Household budget spreadsheet template: free, 3 tabs
You found a template, filled in the first month properly, and by week three the Spending tab stopped on the 9th. The formulas were never the problem.
11 October 2026
You found a household budget spreadsheet template, filled in the first month properly, and by week three the Spending tab stopped on the 9th.
The formulas were fine. What broke was the typing: every purchase happened on a phone, the sheet lived on one laptop, and only one of you ever opened it.
Most of the templates that come up for this search are one tab with forty categories and a pie chart. Here is a better one, free, with the three tabs a household actually needs and the one formula that joins them. And, because the sheet will stall eventually, what to do the day it does.
The household budget spreadsheet template: three tabs, one formula
Download the template (CSV). It opens in Excel, Google Sheets or Numbers. The file is the Spending tab, with three example rows to delete. Add two more tabs, Bills and Budget, and set them up as the next two sections describe.
The Spending tab has six columns, in this order:
| Column | What goes in it |
|---|---|
| Date | Written 2026-10-03, so no program confuses 3 October with 10 March |
| Description | The shop, in a word or two |
| Category | One of the dozen below, spelled the same every time |
| Amount | A plain positive number, no currency sign |
| Paid by | Whose card, if you split anything later |
| Notes | Optional. “Birthday present for Mum” and so on |
That is deliberately boring. Boring columns are what make the file portable, and portable is what saves the year of history when the sheet stops getting filled in.
Or the same three tabs, already joined up
Before you build it, here is what the finished thing looks like without the spreadsheet. In Chirpy, open Money. The Bills tab is Repeats: add rent, 1,800, Every month, the 1st, and it posts itself to the ledger on the day and sits on the household calendar beforehand. The Budget tab is Budgets: give Groceries a limit of 760 and the card shows what has gone and what is left as the month goes on, plus a line for anything spent outside a budget.
The Spending tab is the part that changes most. Your partner pays for the shop, adds 84.20 at the till on their own phone, and your budget moves before they are back at the car. Nobody wrote a SUMIFS. Chirpy Basic is free for the whole household, up to six people, no card, and all of this is on it.
If you like the sheet, keep reading and build it. The tabs are the same either way, which matters later.
Tab one, Bills: a year of bills, divided by twelve
Four columns: Bill, Amount, Times a year (12 for monthly, 4 for quarterly, 1 for yearly, 52 for weekly) and Monthly. The Monthly column is one formula, filled down:
=B2*C2/12
Car insurance at 960, once a year, becomes 80 a month. Water at 150 a quarter becomes 50. This is the tab that stops the budget being wrong in March, because a sheet that only lists this month’s bills has no line for the ones that arrive once a year.
The total of the Monthly column is your fixed cost. If those yearly bills keep catching you out, our guide to sinking funds for annual bills sets money aside for each one. If the two of you pay bills from a shared pot, the same total answers how much to put in joint account for bills.
Tab two, Budget: the SUMIFS that does the adding
One row per category, four columns: Category, Limit, Spent and Left. Spent adds up every Spending row with that category in this month:
Keep the category list short. These thirteen cover a household:
- Fixed-ish: Rent, Utilities, Insurance, Subscriptions, Fees
- The ones that move: Groceries, Eating out, Transport, Shopping, Health
- Lumpy: Travel, Gifts, and Other
Set the fixed limits from the Bills tab. Set the moving ones from your last three months of statements, never from a guess; guesses are always low on food. Our guide to the household budget couples actually keep using goes through that, and the grocery budget for family of 4 guide gives you a starting figure for the biggest moving line.
Those are Chirpy’s own thirteen categories, which is not an accident. A sheet built on them moves across later without renaming a thing. And once it has, Ask works on every plan: type how much is left for eating out this month? and it answers from your budgets, including whatever you spent outside them.
Tab three, Spending: where every spreadsheet dies
Bills and Budget take an evening to set up and then barely change. The Spending tab needs a row every time anyone buys anything. That is ten or fifteen rows a week in a family, typed later from memory, by whoever has the laptop.
So the receipts pile up by the kettle. On Sunday someone types in whatever they can remember, the totals come out low, and the budget says you are doing brilliantly right up until the bank says you are not.
A budget spreadsheet is accurate on the day its owner last caught up, and on no other day.
A spreadsheet does one thing better than any app, ours included: you can model anything in it, the what-if of a pay rise or a bigger mortgage, in a formula of your own. Chirpy answers that by never locking your numbers in. Settings, Your data, Download CSV gives you the whole ledger as a spreadsheet, so the what-ifs stay in a sheet and the daily logging happens on both phones, where the spending actually is.
Logging in Chirpy is amount, shop and category, with the date set to today and the person adding it marked as who paid. Our guide to the fastest way to track expenses shows how few entries that really comes to once the bills post themselves.
Sharing a budget spreadsheet with your partner
Sharing the file is easy. In Google Sheets it is the Share button and edit access; in Excel it is saving to OneDrive and sharing from there. Then the file sits in your partner’s inbox and they open it about as often as you open theirs.
The problem is not permission. It is that a spreadsheet on a phone is a miserable place to add a row while somebody waits behind you at the till. So one person becomes the budget person, the other becomes the person the budget is about, and that is a conversation nobody enjoys in month three.
In Chirpy nobody shares anything, because you are both in the household already. Each of you logs your own spends, each entry knows who paid, and the Budgets card is the same card on both phones. If a bill is due, it is on the calendar you already both look at for the dentist and football.
When the spreadsheet stalls, bring it with you
If you have months of rows in the template, they are not wasted. In Chirpy:
- Save the Spending tab on its own as a CSV (File, Download, CSV in Google Sheets; Save As, CSV in Excel).
- Open Money, scroll to Import from another app and choose the file.
- Check the columns. With this template’s headings, Date, Description, Category, Amount and Notes are matched for you. Paid by is not carried across.
- Approve. If anything looks wrong, Past imports lets you remove the whole batch in one tap and try again.
Then the Bills tab becomes Repeats and the Budget tab becomes limits, which takes about as long as typing them did the first time. The difference is that you never type them again.