Couples Budget Spreadsheet for Joint Finances: Step-by-Step Setup
You and your partner each know your own numbers. The trouble starts in the gap between them: one of you thought the other paid the electric bill, one of you has been quietly covering groceries for three months, and neither of you can say with confidence how much you’re saving together. A budget for two people has to do something a solo budget never does. It has to make the shared parts of your money visible to both of you.
This guide walks through setting up a couples budget spreadsheet for joint finances in eight steps, using a worked example with clearly labeled assumptions. You can build every part of it in a blank Excel or Google Sheets file. At the end, the Couple’s Finance & Money Date Planner has all of it pre-built if you’d rather skip the setup.
Why couples need a different kind of budget
A single-person budget answers one question: where did my money go? A couples budget has to answer four:
- What do we earn together, and what does each of us bring in?
- Which costs are shared, which are personal, and who pays each one?
- Are we making progress toward goals that belong to both of us?
- How do we talk about all of this without it turning into an argument?
A normal monthly budget template handles question one at best. The other three are where couples get stuck, and they’re the reason a dedicated joint budget layout is worth setting up properly.
Step 1: Put both incomes side by side
Start with a simple snapshot: one column per partner and one combined column. Use take-home pay (after tax and payroll deductions), because that’s the money you can actually spend.
Here’s the example used throughout this guide. These are illustrative numbers, not benchmarks:
| Monthly take-home | Partner 1 | Partner 2 | Combined |
|---|---|---|---|
| Salary / wages | $4,000 | $2,600 | $6,600 |
| Side income | $200 | $200 | $400 |
| Total | $4,200 | $2,800 | $7,000 |
Partner 1 brings in 60 percent of the household’s take-home pay and Partner 2 brings in 40 percent. That ratio comes back in Step 4.
Do the same for account balances and debts on the same page, because the combined picture is what you’ll track over time. Net worth is simply total assets minus total debts, and it’s worth recording at the start so you have a starting point to compare against a year from now.
Step 2: List every shared cost and give it an owner
Open a second tab called Joint Budget. List the costs you share as a household, and add columns for the budgeted amount, the actual amount, the difference, and who pays.
Using the “Yours, Mine & Ours” idea, the Who Pays column takes one of three values: Partner 1, Partner 2, or Shared. That one column is the heart of the sheet. Here’s the example:
| Shared cost | Monthly amount | Who pays |
|---|---|---|
| Rent | $1,800 | Shared |
| Utilities | $320 | Shared |
| Internet | $70 | Shared |
| Groceries | $750 | Shared |
| Car insurance | $180 | Shared |
| Streaming | $40 | Shared |
| Total | $3,160 |
Then add a Partner 1 Share column and a Partner 2 Share column. A formula that does the work for each row, with the amount in column C and Who Pays in column E, looks like this:
Partner 1 share = IF(E5="Partner 1", C5, IF(E5="Shared", C5/2, 0))
Partner 2 share = IF(E5="Partner 2", C5, IF(E5="Shared", C5/2, 0))
Copy it down and sum each column. Note what this version does: a line marked Shared splits 50/50. If you’d rather split by income, there’s a variation in how to split bills fairly when one partner earns more.
Step 3: Assign every bill to a person and an account
A budget tells you how much; a bill tracker tells you who and when. Make a Bill Tracker tab with one row per bill and these columns: amount, due date, who pays, autopay (yes or no), account used, paid this month (yes or no), and payment date.
This tab fixes the most common couples money problem: the bill that nobody paid because each person assumed the other had it. If every row has a name on it, the sentence “I thought you paid that” has nowhere to live. It also makes it easy to see which bills are on autopay and which are manual, which is where late fees tend to come from.
Step 4: Decide how you’ll split shared costs
This is the decision that causes the most friction, so make it on purpose. Using the example, the shared bills are $3,160 a month. Here are the two most common ways to divide them:
| Partner 1 | Partner 2 | |
|---|---|---|
| Take-home pay | $4,200 | $2,800 |
| Equal split (50/50) | $1,580 | $1,580 |
| Left after shared bills | $2,620 | $1,220 |
| Share of own pay used | 37.6% | 56.4% |
| Proportional split (60/40) | $1,896 | $1,264 |
| Left after shared bills | $2,304 | $1,536 |
| Share of own pay used | 45.1% | 45.1% |
Under the equal split, Partner 2 spends 56 percent of their pay on shared costs while Partner 1 spends under 38 percent. Under the proportional split, both spend the same share, roughly 45 percent. Neither is the “correct” answer. Some couples prefer equal because it feels simple; others prefer proportional because it feels fair. The point of putting numbers in a table is that you can see the effect before you agree to it.
Our deeper walkthrough, with the formula to automate it, is in how to split bills fairly when one partner earns more.
Step 5: Decide how your accounts will work
Your split method and your account structure are linked. There are three common setups: everything in joint accounts, everything separate with bills divided between you, or a hybrid where each partner sends a set amount to a joint account for shared costs and keeps a personal account for the rest. The spreadsheet doesn’t care which you choose, because the Who Pays column records the answer either way. If you’re still weighing the options, joint vs separate bank accounts for couples compares them side by side.
Step 6: Set shared savings goals with both contributions visible
Make a Savings Goals tab with columns for the goal, target amount, current saved, percent complete, each partner’s contribution, monthly contribution and target date. Percent complete is just current saved / target, wrapped in IFERROR so empty rows don’t show errors.
Typical goals for couples include an emergency fund, a down payment, a vacation fund, a car fund and a “something fun” fund. Listing each partner’s contribution separately matters more than it seems. It shows both of you that the progress is shared, and it prevents the quiet resentment that builds when one person feels like they’re carrying a goal alone.
For debt, add a combined payoff list: each debt, who owes it, the balance, interest rate, minimum payment and extra payment. Months to pay off for a fixed payment is NPER(rate/12, -payment, balance), and the total interest is payment times months minus the balance. The debt-free date is today plus the longest payoff time.
Step 7: Schedule a monthly money date
A spreadsheet only works if you both look at it. The simplest habit is a monthly check-in with a fixed agenda: celebrate wins, review spending, check goals, look at upcoming expenses, check in on money values, and write down who does what. Forty minutes is plenty. We’ve put the full agenda, with suggested timings, in the monthly money date agenda for couples.
Step 8: Add a way to decide big purchases together
Big purchases are where two sets of priorities collide. A simple scoring table keeps the conversation about the decision rather than about each other: list your criteria, give each a weight from 1 to 5, score each option from 1 to 10, and multiply. The option with the highest total wins, and you’ll have a written reason why. See how to decide on a big purchase with your partner for a worked example.
Common mistakes couples make with a shared budget
- Budgeting only the shared costs. Leave room for personal spending (“mine”) or it becomes a source of friction. Even a small fixed amount each, with no questions asked, removes a lot of tension.
- Splitting by default instead of by decision. 50/50 isn’t wrong, but it should be a choice you made, not an assumption.
- Tracking in two places. If each of you keeps your own sheet, you’ve recreated the original problem. One file, both of you.
- Skipping the review. A budget that’s never discussed goes stale within two months. The check-in is what makes it work.
- Treating the budget as a verdict. The tone matters. The sheet shows numbers; it isn’t grading either of you.
What this looks like in one file
Everything above fits in a handful of tabs: a snapshot, a joint budget, a bill tracker, savings goals, a debt payoff plan, a purchase matrix, an agenda and a history log. You can absolutely build it yourselves in an afternoon. If you’d rather start with a finished version, the Couple’s Finance & Money Date Planner includes all of these as 11 tabs with 329 working formulas, dropdowns, and green and red status highlighting, so the first thing you do is type your numbers in.
Featured on ReadySheetGo
Couple's Finance & Money Date Planner Spreadsheet — $14.99
Includes a combined financial snapshot, a Yours, Mine & Ours joint budget with a Who Pays column, a bill responsibility tracker, shared savings goals, a combined debt payoff plan, a weighted purchase decision matrix and a monthly money date agenda. Works in Excel and Google Sheets.
Your set-up checklist
- Both take-home incomes entered on one page
- Every shared cost listed with an owner
- Every bill assigned to a person and an account
- A split method you both chose on purpose
- At least three shared savings goals with both contributions tracked
- Debts listed together with a payoff estimate
- A recurring money date on the calendar
Read next
Once the structure is in place, these four guides cover the decisions couples usually stall on:
- How to split bills fairly when one partner earns more
- Monthly money date agenda for couples (40-minute template)
- Joint vs separate bank accounts for couples: which works best
- How to decide on a big purchase with your partner (scoring matrix)
If you’re paid on different schedules, how to budget when you and your partner are paid on different schedules covers that, and how to track net worth as a couple picks up where the snapshot leaves off.
Frequently Asked Questions
What should a couples budget spreadsheet include?
At minimum it needs both partners' incomes side by side, a list of shared expenses with a clear owner for each one, shared savings goals with each partner's contribution, and a place to record debts. Better versions also include a bill tracker so nothing is paid twice or missed, a recurring check-in agenda, and a way to score big purchases. The common thread is that everything is visible to both people in one file, so nobody has to ask what the numbers are.
Should couples combine all their money into one account?
There is no single right answer. Some couples merge everything, some keep everything separate and split bills, and many use a hybrid: one joint account for shared costs and a personal account each for spending money. What matters is that the system is agreed on and written down. A budget spreadsheet works with any of the three, because each line simply records who pays it.
How do couples split a budget when one earns more?
Two common approaches are an equal split, where each partner pays half of every shared bill, and a proportional split, where each pays the same percentage of their income. If one partner takes home 60 percent of the combined income, they cover 60 percent of shared costs under the proportional method. Neither is wrong; they reflect different ideas of fairness, so it is worth deciding together and revisiting it when incomes change.
How often should a couple review their budget?
Once a month works well for most couples. A 30 to 45 minute check-in is long enough to look at last month's spending, update goals, and plan for upcoming bills, but short enough that it does not become a chore. Put it on the calendar at the same time every month, and keep a short log of what you decided so you can see progress over time.