Couples Budget Spreadsheet: Track Who Earns and Spends What

A couples budget spreadsheet puts both partners’ income and spending in one file, tagged by person, so you can see who earned what, who paid for what, and whether shared costs are split the way you agreed. Our budget spreadsheet does this with a person on every transaction and a distribution tab that totals each person’s income and spending for any period you choose. It works for couples with joint accounts, separate accounts or a mix of both.

What the couples budget spreadsheet tracks

The couples features sit inside the full budget spreadsheet for Google Sheets and Excel, so you get a complete household budget rather than a separate split sheet:

• People on the setup tab. Add each spender and earner once. Every other tab uses the same list.
• A person on every transaction. Paychecks, bills, groceries and one-off purchases are each tagged with the person who earned or spent the money.
• The distribution tab. It shows who earned and who spent what over a period you choose, such as one month, or custom dates, such as since you moved in together.
• One shared file. Share your Google Sheets copy with your partner and you both edit the same budget, so there is no emailing versions back and forth.

Everything else works for the household as a whole: the monthly tabs, the dashboard, the bill calendar, and your choice of a zero-based or carry-over budget.

Worked example: one month for two people

Alex and Sam take home $4,500 and $3,000 a month. They split shared costs by income, and each pays for their own car, gas, clothes and hobbies. These are example numbers for one month. The earned and spent totals in the first table are what the distribution tab reports; the percentages are simple division.

Person	Take-home pay	Share of income	Spent	Share of spending
Alex	$4,500	60%	$2,425	67%
Sam	$3,000	40%	$1,210	33%
Total	$7,500	100%	$3,635	100%

Alex spent 67% of the household total while earning 60%. That looks unfair at first glance, but it mostly reflects who paid the rent. To check the agreed split, look at shared costs only:

Shared cost	Paid by Alex	Paid by Sam
Rent	$1,800	$0
Groceries	$260	$390
Utilities	$0	$185
Internet	$0	$70
Dining out together	$140	$60
Total paid	$2,200	$705
Fair share at 60/40 of $2,905	$1,743	$1,162
Difference	+$457	-$457

Sam transfers $457 to Alex, and each has then put 38.7% of take-home pay toward shared costs. A 50/50 split of the same $2,905 would be about $1,453 each, which is 48% of Sam’s pay and only 32% of Alex’s. Personal spending stays separate: $225 for Alex (gas and clothing) and $505 for Sam (car payment, gas and hobbies).

If both of your accounts are set up in the spreadsheet, record that $457 as a transfer between accounts rather than as spending. Otherwise the same money shows up twice: once when it was spent on groceries and again when it moved between you.

How to set it up for two

1. On the setup tab, add both names as spenders and earners, along with your currency and start month.
2. Add each person’s income sources and your categories, grouped as bills, expenses, savings, subscriptions and debts.
3. Enter recurring bills once on the recurring transactions tab and tag each one with the person who pays it.
4. As you spend, log each purchase in the variable transactions tab with the person who paid.
5. Make your Google Sheets copy, then click Share, add your partner’s email and set the role to Editor.
6. Once a month, open the distribution tab, pick the month, and compare what each of you earned and spent with the split you agreed.

The method: agree on a split, then track it

There are three common setups: everything joint, separate accounts plus a joint account for shared bills, or fully separate accounts with a monthly settle-up like the one above. None is right for everyone. What matters is that you pick one on purpose and write down which costs count as shared. A common starting point is to share housing, utilities, groceries, household supplies, joint subscriptions and outings you take together, and to keep debts from before the relationship, hobbies, clothing and gifts for each other personal.

Our guide on how to budget as a couple compares those three setups and gives an agenda for a monthly money meeting. How to split bills by income works through the proportional formula at three different income gaps. If you want every dollar assigned together, zero-based budgeting is a good fit for two, and a family budget covers what changes once kids arrive. To see which bills fall on which paycheck, the bill tracker spreadsheet in the same file shows every due date on a calendar.

Build your own couples budget in Google Sheets or Excel

If you would rather start with a basic version, two tabs will do. On a Tx tab, use six columns: A date, B description, C category, D amount, E person and F shared (Yes or No). Make E and F dropdowns: Insert > Dropdown in Google Sheets, or Data > Data Validation > List in Excel.

On a Summary tab, put each name in column A (A2 and A3) and each person’s take-home pay in column B. These formulas work the same in Google Sheets and Excel:

Cell	Result	Formula
C2	Share of income	=B2/SUM($B$2:$B$3)
D2	Total spent	=SUMIFS(Tx!D:D,Tx!E:E,A2)
E2	Shared costs paid	=SUMIFS(Tx!D:D,Tx!E:E,A2,Tx!F:F,"Yes")
F2	Fair share of shared costs	=SUMIFS(Tx!D:D,Tx!F:F,"Yes")*C2
G2	Settle-up (positive means owed money)	=E2-F2

Fill row 2 down to row 3. To limit everything to one month, put the start and end dates in J1 and J2 and add ,Tx!A:A,">="&$J$1,Tx!A:A,"<="&$J$2 inside each SUMIFS, just before its closing parenthesis.

For a quick total by person, the apps differ:

• Google Sheets: =QUERY(Tx!A1:F500,"select E, sum(D) where F = 'Yes' and E is not null group by E",1) lists shared spending per person in one formula.
• Excel: choose Insert > PivotTable, drag Person to Rows, Amount to Values and Shared to Filters, then set the filter to Yes.

For both of you to edit at once, share the Google Sheets file as described above. In Excel, simultaneous editing needs the file saved in OneDrive or SharePoint and shared from there.

Who it suits and who it does not

This setup suits couples moving in together, partners with different incomes who want a split that feels fair, and households where one person pays most bills but both want to see where the money goes.

It works less well if one partner will not record spending at all, because the distribution tab can only show what is in the file. It also does not connect to your banks, so you enter transactions yourselves. That extra step is also what makes both of you see each purchase.

Before your first month, agree in one sentence which costs are shared and how you split them, and write it down where you will both see it, so every monthly review starts from the same rule.