A budget for couples spreadsheet puts both partners' bank statements in one table, marks each row as shared or personal, and splits the shared total by an agreed rule, either half each or in proportion to income. A settle-up row at month end shows who owes whom. It works whether you have a joint account, separate accounts or both.
Joint, separate or both: which account setup the couples spreadsheet follows
The couples spreadsheet follows whatever accounts you already have, rather than asking you to change banks. With one joint account, the sheet is a normal budget. With separate accounts, it needs both statements and a shared column. With a joint account plus personal ones, it tracks how much each person paid in to the joint account.
One joint account for everything
If both pay checks land in one joint account and every bill leaves from it, there is only one statement. The spreadsheet is the same as a single person's budget: rows, categories and monthly totals. The only couples-specific part is agreeing on the categories and on personal spending money, which the next section covers.
Two separate accounts
If each of you keeps your own account and pays some shared bills from it, the shared spending is scattered across two statements. One partner pays rent, the other pays groceries and utilities. The sheet has to pull both statements together and work out whether each person paid their share. This is where a spreadsheet earns its keep, because no single bank view shows it.
A joint account fed by two personal accounts
Many couples keep personal accounts and a joint account for shared bills, with each person transferring a set amount into the joint one every month. Here the spreadsheet needs the joint statement for the spending, plus the transfer rows from each personal statement to confirm what each person put in. Personal spending stays private if you want it to, because it never has to enter the sheet.
Which shared categories does a couples budget need?
Shared categories are the kinds of spending you both treat as household costs: rent or mortgage, utilities, groceries, insurance, shared transport and anything for children or pets. Personal categories are each person's own choices. The line between them is a decision you make together, once, so the spreadsheet does not have to settle an argument every month.
Write the list down on its own sheet, with two columns: Category and Type, where Type is either Shared or Personal. Here is an example. Your own list will differ.
| Category | Type |
|---|---|
| Housing | Shared |
| Utilities | Shared |
| Groceries | Shared |
| Home insurance | Shared |
| Childcare | Shared |
| Eating out together | Shared |
| Eating out alone | Personal |
| Clothes | Personal |
| Hobbies | Personal |
| Gifts for family | Discuss |
The grey areas
Some categories do not sort neatly. A gym membership might be personal for one person and a shared health cost for another. Gifts to one partner's family are a common sticking point. Mark those as Discuss at first and decide them case by case for a month or two. Once a pattern is clear, move them to Shared or Personal.
Personal money with no questions asked
A fixed amount of personal money each month, for each person, removes a lot of friction. Neither partner reports what it buys. In the spreadsheet, that money is simply one row per person, and the purchases behind it stay off the sheet entirely.
How should a couple split shared bills fairly?
A couple can split shared bills in half, or in proportion to each person's income. A half split is simple and suits partners who earn about the same. An income-share split asks each person to pay the same percentage of their take-home pay, which feels fairer when one earns much more. Pick one rule and write it in the sheet.
A worked income-share split
Here is an example with made-up numbers. Partner A takes home 4,200 a month and Partner B takes home 2,800, for a combined 7,000. Shared bills total 3,500.
| Partner A | Partner B | Total | |
|---|---|---|---|
| Take-home pay | 4,200 | 2,800 | 7,000 |
| Share of income | 60% | 40% | 100% |
| Share of 3,500 shared bills | 2,100 | 1,400 | 3,500 |
| Left after shared bills | 2,100 | 1,400 | 3,500 |
Each person pays 50% of their take-home pay toward shared bills. With a half split, each would pay 1,750: Partner A would keep 2,450 and Partner B only 1,050. Neither rule is wrong. The table just makes the difference visible, so you choose with the numbers in front of you.
In the sheet, put each person's monthly take-home pay in a cell and calculate the share with =A_pay/(A_pay+B_pay). Multiply the month's shared total by that share to get what each person should have paid.
Where the take-home pay figure comes from
Use net pay, the amount that lands in the bank, not the salary in a contract. It is the figure both of you can see on your statements. If pay varies from month to month, use the last three months of payslips or deposits. If your payslips arrive as PDFs and you want them next to the budget, turning a payslip into an Excel sheet covers the options and what each costs.
Combining both partners' statements into one couples sheet
Combining the statements means pasting both partners' transaction rows into one table, with a column that says whose account each row came from. Then each row gets a category, and a lookup against your category list marks it Shared or Personal. Totals by person and by type follow from SUMIFS.
The columns
Use one table, called Tx, with these columns:
- Date, Description, Amount from the statement.
- Paid by, A or B, typed once for the whole block of rows you paste.
- Category, from a payee rule or typed by hand.
- Type, filled by
=XLOOKUP([@Category], Cats[Category], Cats[Type], "Discuss").
Each partner can download their own statement and hand over only the shared rows if you prefer to keep personal spending private. Delete the personal rows before pasting. The settle-up only needs the shared ones.
Getting both statements into rows
The CSV export from online banking is the quickest route, when both banks offer one. If one of you only gets PDF statements, a converter avoids typing. CheapBankConvert, once it opens, converts a PDF statement into CSV or Excel for a one-time price per document, and statements of two pages or fewer convert free.
Totals that the sheet should show
Three totals cover most couples: shared spending this month, shared spending paid by A, and shared spending paid by B. With the Tx table above, A's share is =-SUMIFS(Tx[Amount], Tx[Type], "Shared", Tx[Paid by], "A"), and B's uses "B". The settle-up in the next section compares these with what each person should have paid.
The monthly settle-up row for a couples budget
The settle-up row compares what each partner actually paid toward shared costs with what they should have paid under your split rule. The difference is the amount one person transfers to the other. One transfer at month end replaces dozens of small "I'll get you back" moments and keeps both people even.
A worked settle-up
Continuing the example, with shared bills of 3,500 and a 60/40 split:
| Partner A | Partner B | |
|---|---|---|
| Should pay (60/40) | 2,100 | 1,400 |
| Actually paid | 1,850 | 1,650 |
| Difference | -250 | +250 |
Partner A paid 250 less than their share and Partner B paid 250 more, so A transfers 250 to B. The two differences always add to zero. If they do not, a shared row has the wrong Paid by value, or a personal row slipped in.
In the sheet, the difference is =Actually_paid - Should_pay. A negative number means that person owes the other.
When a joint account is involved
If the shared bills come out of a joint account, the settle-up compares contributions instead of payments. Each person's "actually paid" is the total of their transfers into the joint account that month. The rest of the arithmetic is the same.
Reviewing the month together
The settle-up is a natural moment to look at the whole month side by side. A short monthly budget review checklist keeps that conversation to the useful questions: what ran over, what is coming next month, and whether the split still feels fair. Ten minutes once a month is usually enough.
When a couples spreadsheet causes more arguments than it solves
A couples spreadsheet causes arguments when it tracks too much detail or turns into a record of who spent what on themselves. Personal spending in a shared sheet invites comments. A split rule one partner never really agreed to breeds resentment. In those cases, track less: only the shared total and the settle-up.
Some signs the sheet needs trimming:
- Personal rows keep coming up. Take them out of the sheet and use a fixed personal allowance instead.
- The settle-up feels like an invoice. Round to the nearest 10 or 50, or settle quarterly rather than monthly.
- One person does all the work. Swap who downloads and categorizes each month, so both know what the sheet says.
- Every review ends in a debate about one category. Move it to Discuss and agree a cap for it, then stop tracking it in detail.
A shared savings goal can help the sheet feel less like bookkeeping. Many couples start with a joint safety net. How big an emergency fund needs to be works out a target from your own monthly costs, and the shared spending total from this sheet is a good starting figure for it.