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:

  1. What do we earn together, and what does each of us bring in?
  2. Which costs are shared, which are personal, and who pays each one?
  3. Are we making progress toward goals that belong to both of us?
  4. 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

  1. 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.
  2. Splitting by default instead of by decision. 50/50 isn’t wrong, but it should be a choice you made, not an assumption.
  3. Tracking in two places. If each of you keeps your own sheet, you’ve recreated the original problem. One file, both of you.
  4. Skipping the review. A budget that’s never discussed goes stale within two months. The check-in is what makes it work.
  5. 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.

Your set-up checklist

Read next

Once the structure is in place, these four guides cover the decisions couples usually stall on:

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.

Stop Arguing About Money. Put Both Incomes on One Page.

The Couple's Finance & Money Date Planner Spreadsheet — 11 tabs and 329 working formulas built for two people. A Financial Snapshot tab puts both partners' income, accounts, debts and net worth side by side with a combined column. A Joint Budget tab uses a Yours, Mine & Ours approach: every line has a Who Pays dropdown (Partner 1, Partner 2 or Shared) and the sheet totals what each partner owes, with Shared lines split 50/50. A Bill Responsibility Tracker assigns every bill to a person and an account and records whether it has been paid this month. A Savings Goals tab tracks ten shared goals with each partner's contribution and percent complete. A Combined Debt Payoff Plan calculates months to pay off and total interest for each debt and returns a debt-free date. A Purchase Decision matrix scores up to three options against ten weighted criteria and names the winner. A Money Date Agenda gives you a six-part monthly check-in with a twelve-month history, a Financial Values worksheet lines up each partner's priorities, and Anniversary Checkpoints track net worth year over year. Works in Excel and Google Sheets, no macros and no add-ons.

View on Etsy — $14.99