Free template · Excel & Google Sheets
Free couples budget template: split bills by income
When one partner earns more, a 50/50 split can feel unfair. This template splits shared bills in proportion to take-home pay and shows who owes whom each month.
Download free template (.xlsx) Split bills by income calculator →
No sign-up, no email. Works in Excel, Google Sheets, Numbers and LibreOffice.
What’s inside
- Income sheet: Each partner’s monthly take-home pay. Each share is worked out for you, for example 60/40.
- Expenses sheet: Shared bills and who paid them: rent, groceries, utilities, nights out.
- Split sheet: Each partner’s fair share by income, what they paid, and the balance between you.
Preview, with sample data
| Partner | Share | Paid | Fair share | Balance |
|---|---|---|---|---|
| Partner A | 60% | 31,899 | 27,059.40 | +4,839.60 |
| Partner B | 40% | 13,200 | 18,039.60 | −4,839.60 |
Where a spreadsheet falls short
- Personal and shared spending end up mixed in one file.
- Both of you need to keep it up to date, which rarely lasts.
- There is no shared budget or alert before you overspend.
In Traxpend, everyone adds expenses from their own phone, budgets warn you at 80%, recurring bills log themselves, and settle-up shows the fewest payments with a UPI QR or a PayPal or Venmo link. Free for up to five people. Traxpend for couples.
Questions
Is splitting bills by income fairer than 50/50?
It depends on what you agree. With a 50/50 split, the lower earner spends a bigger part of their pay on the same home. An income-based split keeps each partner’s share of pay the same.
Does it work in Google Sheets?
Download the file, open Google Sheets, choose File → Import → Upload, pick the file and select “Create new spreadsheet”. The formulas carry over.
Should I use gross or take-home income?
Most couples use take-home pay, because that is the money actually available for bills.
Can we keep personal spending separate?
Yes. Only log shared bills in this sheet. Personal spending stays out of it.