Spreadsheets

Couple shared expenses in Google Sheets: a proportional split sheet

A Google Sheets template for couples with a Joint tab, personal tabs and a settle-up cell that splits shared bills by each partner's take-home pay.

Editorial illustration for Couple shared expenses in Google Sheets: a proportional split sheet

To split shared expenses between partners in proportion to income, give each person a share percentage equal to their take-home divided by the combined take-home, then compare what each paid with what each should have paid. The gap is the settle-up amount. The sheet below does this with a Joint tab, a personal tab each and one cell that says who pays whom.

How should I set up the tabs?

  • Joint: every shared bill, with date, item, amount and who paid.
  • Asha and Ravi (one personal tab each): each person's own spending, never counted in the split.
  • Settle-up block: kept at the right of the Joint tab, columns F and G.

Keeping personal spending on separate tabs avoids awkward debates. Both can see the Joint tab; each personal tab can be shared with only its owner if you want privacy.

What is the share-percentage formula?

Put each person's monthly take-home, meaning the amount that actually reaches their account, in G1 and G2. Say Asha's is ₹70,000 and Ravi's is ₹50,000.

CellFormulaValue
G3: Asha's share=G1/(G1+G2)58.33%
G4: Ravi's share=G2/(G1+G2)41.67%
G5: Joint total=SUM(C2:C200)₹60,000
G6: Asha paid=SUMIFS($C$2:$C$200,$D$2:$D$200,"Asha")₹40,000
G7: Ravi paid=SUMIFS($C$2:$C$200,$D$2:$D$200,"Ravi")₹20,000
G8: Asha's fair share=G5*G3₹35,000
G9: Settle-up=G6-G8₹5,000

The percentages are 70 out of 120 and 50 out of 120. Joint bills of ₹60,000 mean Asha's share is 35,000 and Ravi's is 25,000. Asha actually paid 40,000, which is 5,000 more than her share, so Ravi owes her ₹5,000. Ravi's side checks out: he paid 20,000 against 25,000.

A positive G9 means Asha is owed money, and a negative one means she owes. To turn this into a sentence, use:

=IF(G9>=0,"Ravi pays Asha ₹"&TEXT(G9,"#,##0"),"Asha pays Ravi ₹"&TEXT(-G9,"#,##0"))

What if one partner pays more in a month?

The formula already allows for it, because it compares what each paid against what each should have paid. If Asha pays the ₹30,000 rent and a ₹10,000 grocery bill while Ravi pays a few small bills, the settle-up simply grows. Nothing needs adjusting. What does need care is a bill paid from a joint account, if you have one. Record it as paid by "Joint" and make sure the Joint paid total is also compared with what each person transferred in.

If one person pays a large annual bill, such as an insurance premium, put it on the Joint tab in the month it was paid, and decide beforehand whether to settle immediately or spread it. The sheet gives the number; you choose the timing.

What if our incomes change?

Take-home changes with a raise, a bonus month or a break. Do not overwrite the old figures; keep a small table with a column per month and point G1 and G2 at the current month with a lookup. Or copy the Joint tab for each month so past settlements stay as they were. Agree as a couple whether bonuses count: this is a conversation, not a formula.

A monthly routine that keeps it light

  1. Enter shared bills as they happen, or once a week from the statement.
  2. On a fixed day, such as the 1st, read the settle-up message.
  3. Pay by UPI or bank transfer, then type the settlement as a line on the next month's Joint tab so the sheet shows it was cleared.
  4. Copy the tab, rename it with the month, and clear the amounts for the next one.

SpendixAI is not a bill-splitting app, so keep the settle-up in this sheet. It is still useful for each person's own side: each of you can import your own statements and see personal spending by category without exposing it to the other.

SPENDIXAI JOURNAL

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

Explore your reports