Spreadsheets

Salary day split sheet: divide your paycheque in Google Sheets

Divide your salary on payday with a Google Sheets plan that allocates rent, EMI, bills, SIP and savings, flags over-allocation and adds a second salary.

Editorial illustration for Salary day split sheet: divide your paycheque in Google Sheets

A salary day split sheet in Google Sheets takes the amount credited and allocates it line by line to rent, EMI, bills, SIP, savings and spending money. A check cell flags when your allocations are more than the salary, so the plan is settled within minutes of the credit. A second column handles a dual-income household.

How do I lay out the sheet?

Put the labels in column A and set it up like this:

  • B2: salary credited for Person 1, typed on payday
  • C2: salary credited for Person 2, left empty for a single-income home
  • Row 4 headers: Item, Person 1, Person 2, Total, Share of income
  • Rows 5 to 11: rent, household and groceries, EMI, bills, SIP, savings, spending money
  • Row 13: Total allocated; row 14: Left to allocate

Each line gets an amount typed under Person 1 or Person 2, so a rent paid by one partner and groceries paid by the other stay visible in their own column.

Which formulas do I need?

  • D5, line total: =B5+C5
  • E5, share of income: =IF($B$2+$C$2=0, 0, D5/($B$2+$C$2))
  • B13, Person 1 total: =SUM(B5:B11), with the same formula in C13 for Person 2
  • B14, Person 1 left: =B2-B13, with C14 for Person 2 using =C2-C13
  • Status in B15: =IF(B14<0, "Over by "&TEXT(-B14,"#,##0"), IF(B14=0, "Fully allocated", "Unallocated: "&TEXT(B14,"#,##0")))

Copy B15 across to C15. The status tells you plainly: over, balanced or something left. Add a red fill with a custom formula =B$14<0 on the Left to allocate row.

A single salary with pretend figures

Say ₹70,000 is credited. A plan could look like this:

ItemAmountShare
Rent₹22,00031.4%
EMI₹9,50013.6%
Bills₹6,0008.6%
SIP₹8,00011.4%
Savings₹10,00014.3%
Spending money₹14,50020.7%

The lines add to 22,000 + 9,500 + 6,000 + 8,000 + 10,000 + 14,500 = ₹70,000, so Left to allocate is zero and the status reads Fully allocated. Shares are rounded to one decimal place and add to 100 percent.

How does a second salary work?

Say Person 2 earns ₹45,000 and handles household costs. Their column might read: household and groceries ₹15,000, bills ₹5,000, SIP ₹6,000, savings ₹9,000 and spending ₹10,000, which is 15,000 + 5,000 + 6,000 + 9,000 + 10,000 = ₹45,000. Combined income is ₹1,15,000, and the total column shows the household's full picture: rent ₹22,000, bills ₹11,000, SIP ₹14,000, savings ₹19,000 and so on.

How do I make the plan happen on payday?

  1. Move the savings and SIP amounts first, as soon as the salary lands, using a standing instruction or scheduled transfer in your bank app.
  2. Set aside the rent and EMI amounts in the account they are paid from.
  3. Put the bills line into the account that handles auto-debits.
  4. Spend only from the spending money line for the rest of the month.

What if the salary credit is not the full amount I plan with?

Some people receive part of their pay as a variable component or reimbursements on a different date. Enter only the amount that has actually been credited in B2, and add a second small block below for extra credits as they arrive, with their own allocation lines. That way the check cell always compares allocations to money you really hold, and a delayed payment never makes the plan look healthier than it is.

When to revisit the split

  • After a raise, a new EMI or a change in rent.
  • When Spending money runs out before the month does, which means one of the lines above it is too low.
  • Before festival months, when you may want a temporary line.

After the month, SpendixAI can import your statements so you can compare what you planned to spend with what actually left your accounts, by category.

SPENDIXAI JOURNAL

Useful ideas start with a clearer picture of your own spending.

Explore your reports