Build it yourself and you will still understand it a year from now
There is a good argument for downloading a couples budget spreadsheet: it is faster. There is a better argument for building one, which is that you will know what every cell does.
Kaki and I used downloaded templates for about a year. The problem was never that they were bad. It was that when something did not add up, neither of us could tell whether we had entered something wrong or whether a formula three tabs away was doing something we had not noticed. So we stopped trusting it, and a spreadsheet you do not trust is a spreadsheet you stop opening.
The one we built took an afternoon. It is uglier and I can explain every part of it, which turned out to matter more.
Four tabs, and what belongs on each
Resist the urge to do this in one giant sheet. Four tabs, each with one job.
Tab 1 — Monthly. The one you actually open. Planned and actual for each category, one column per month across the year.
Tab 2 — Income. Both incomes, by month, including irregular payments. Feeds the Monthly tab.
Tab 3 — Irregular. Everything that happens once or twice a year, with its month and amount. This is the tab that stops annual costs ambushing you.
Tab 4 — Goals. Each savings goal with its target, deadline, current balance and required monthly contribution.
That is the whole structure. Anything you are tempted to add — net worth tracking, investment performance, a debt snowball calculator — belongs in a separate file. Every tab you add to this one is a tab that has to stay current.
The income tab when paychecks are irregular
Two stable salaries make this trivial: two rows, twelve columns, done.
Irregular income needs a different approach, and getting it wrong is why freelancers and commission earners find budgeting so frustrating.
Do not budget against what you expect to earn. Budget against your lowest month in the last twelve. Everything above that is treated as a windfall and allocated separately when it arrives.
This feels pessimistic and it is the only version that works. Budgeting against an average means you overspend in the good months and cannot cover the bad ones, and the bad ones are the whole reason you needed a plan.
The buffer row
Add one row called Buffer that holds last month's leftover. Irregular earners should be running one month ahead — this month's bills paid with last month's income — and that row is how you see whether you still are.
Getting a month ahead takes a while. It is the single most stabilising thing an irregular-income household can do, and the buffer row is what stops you accidentally spending your way back out of it.
The formulas worth knowing, and the ones to skip
You need about five. Everything else is showing off.
- SUM for column totals. Obviously.
- SUMIF to pull a category total from a transaction list. This is the one that does the real work if you ever paste raw bank exports in.
- Planned minus actual as its own column. Not a percentage — the dollar figure. Percentages of small categories are misleading.
- A simple IF for the goal tab — whether the current balance is on track for the deadline. One green cell is worth more than a paragraph.
- Division for the irregular tab — annual total divided by twelve, which becomes a single line in your monthly plan.
Skip conditional formatting that turns cells red. It feels rigorous and it produces a document that makes you feel bad, which reduces how often you open it. That is a real cost with no offsetting benefit.
Skip anything that requires entering individual transactions by hand. Manual transaction entry is the single most reliable killer of household spreadsheets. Use monthly category totals pulled from your bank app; four minutes, no decay.
The irregular tab, which is the one that changes everything
If you build only one tab beyond the basics, build this one. It is the difference between a spreadsheet that describes your life and one that predicts it.
List every cost that occurs once or twice a year, with the month it lands and the amount. Car insurance, registration, road tax, the dentist, the annual subscriptions, Christmas, birthdays, the trip you take every summer, the vet, the boiler service, professional memberships.
Total it. Divide by twelve. That figure goes into your monthly plan as a single line, and the money accumulates in savings under its own name.
The first time we did this the annual total was startling — several thousand dollars of entirely predictable spending that had never appeared in any monthly budget we had built. Which explained, retroactively, why our budgets had been mysteriously wrong every year without either of us being able to say where.
Why this is the tab that fixes the emergency fund
A large share of what couples call emergencies are annual costs arriving on schedule. Once those are funded separately, the emergency fund stops being raided four times a year, which is usually the only reason it never grew.
You have not saved any money by doing this. You have just stopped being surprised, and it turns out most of the damage was the surprise.
Two charts that shorten a money conversation
Charts are optional but these two earn their place, because they replace explanation with pointing.
Chart one: savings goal over time. A single line, current balance by month, with a straight target line running to the deadline. Above the line is good. This is the entire progress conversation in one glance and it is the chart that makes saving feel like something rather than nothing.
Chart two: three biggest variable categories, monthly. Usually groceries, eating out and one other. Three lines over twelve months.
The second one is what surfaces drift. A category that has moved from $600 to $780 over four months is invisible in a table and obvious as a line. And crucially, a line going up is a fact rather than an accusation — which changes the tone of the conversation completely.
Sharing it so you are both editing the same file
Google Sheets or Excel on OneDrive. Not a file on one laptop that gets emailed around, and not a screenshot pasted into a message thread.
Three things to set up properly on day one:
Both accounts have genuine edit access. Not view. If one of you can only look, that person is a spectator, and spectators do not develop any sense of what things cost.
Turn on version history. Both of you will overwrite something eventually. Being able to restore it removes the anxiety that stops people editing freely.
Bookmark it on both phones. Sounds trivial. The difference between a spreadsheet you can open at a shop and one you have to be at a desk for is enormous.
Keeping twelve months of history without twelve files
The most common way a couples spreadsheet degrades is version sprawl — Budget_2026.xlsx, Budget_2026_v2, Budget_2026_FINAL.
One file. Months as columns, not as tabs. Twelve columns on one Monthly tab means every comparison is a glance sideways, and it means the annual review is already assembled.
At year end, do not start a new file. Add twelve more columns and hide the previous year. Two years of side-by-side history is the most valuable thing the spreadsheet will ever give you — it is how you find out that December genuinely costs 40% more, that you underestimate groceries every single year, and that your insurance renewal has crept up three years running.
What to do in the first month
Do not plan. Observe.
Build the tabs, enter your income, list your irregular costs, and then just record actuals for one month without any planned figures at all.
Every budget we built from estimates turned out to be fiction. We guessed groceries and were off by about forty percent, which meant our first plan was wrong from the beginning and we spent a month feeling like we were failing at something we had simply mis-measured.
One month of observation gives you a plan built on facts. It also makes the first real month feel achievable, which matters more than accuracy for whether you keep going.
The goals tab, and making progress visible
Four columns per goal: name, target amount, deadline, current balance. Then one calculated column — required monthly contribution, which is simply the gap divided by months remaining.
That calculated column is the whole value of the tab. It converts "we should save for a house" into "$640 a month," which is a number you can either commit to or consciously reject by moving the deadline.
Two rules that keep it useful. Three goals maximum. A list of nine goals is a list of zero goals, and the required monthly contributions will add up to more than you have, which makes the whole tab something you avoid looking at.
And every goal needs a date, even an arbitrary one. Without a deadline there is no required contribution, and without a required contribution there is nothing to be on or off track against.
Update the current balance once a month when you do everything else. Watching the gap close is, genuinely, the thing that keeps people doing this.
When a spreadsheet is the wrong tool
I like spreadsheets and I still think plenty of couples should not use one.
If your problem is visibility, not arithmetic. If the issue is that neither of you knows what the total is, a spreadsheet is a lot of manual work to produce a number your bank could show you. Match the tool to the failure before you build anything.
If one of you will genuinely never open it. A spreadsheet maintained by one person is a report, not a shared system, and it recreates exactly the dynamic where one person becomes the household accountant.
If your spending is scattered across six accounts. Assembling that by hand every month takes long enough that you will stop. Either consolidate the spending or use something that aggregates.
If you have tried three times and abandoned it three times. That is information. Try the eight-row version instead, or a shared note. There is no prize for using the more sophisticated tool.
The afternoon, in order
Create the file and share it. Build four tabs. Enter both incomes by month. List every irregular cost with its month. Set up three or four goals with targets and dates. Add the five formulas. Make two charts. Bookmark it on both phones.
Then leave the planned column empty and record one honest month.
The spreadsheet is not the point and never was. What it buys you is a shared set of facts, so that the fifteen minutes you spend talking about money each month is spent deciding things rather than establishing what happened. That is the entire return, and it is a good one.