How to Build a Zero-Based Budget in a Spreadsheet (UK Guide)

Most budgets fail quietly. You decide to spend less, save more, and be sensible — then a car repair lands, a birthday appears, and the plan dissolves by the 14th. The problem is rarely discipline. It is that the plan never said which pound was meant to cover what.

A zero-based budget fixes that. Before the month starts, you give every pound of income a job: bills, food, fuel, savings, debt, fun. When the last pound has been assigned, the spreadsheet balance reads zero. It sounds rigid, but it is the opposite. Nothing is left to memory or mood, and you find out about a shortfall on the 1st rather than the 27th.

What "zero" actually means

Zero-based does not mean you spend everything. Money assigned to savings, a holiday fund, an emergency buffer or an overpayment counts as assigned. Zero means zero unassigned.

If you bring in £2,400 and every one of those pounds is allocated — including the ones going into savings — you are at zero. Any money left floating is money that will drift.

You do not need fancy software. A single spreadsheet tab, five columns and about twenty minutes a month will do it.

Step 1: Build the shell of the spreadsheet

Open a blank sheet and set up four columns: category, planned, actual, and difference. Then lay out the rows in three blocks.

• Income at the top — one row per source, with a total.
• Categories in the middle — grouped as fixed bills, flexible spending, and savings or debt.
• Balance at the bottom — a single cell that subtracts the total of your categories from your total income.

That balance cell is the whole point of the exercise. Using letters for columns and numbers for rows, it might look like =B2-SUM(B6:B45), where B2 is total income and B6 to B45 are your category rows. Fill it in as you go, and keep an eye on it.

Step 2: Add only income you can rely on

If you are paid a salary, use your net pay — the amount that actually lands after tax, National Insurance, pension contributions and any student loan repayment. That figure is on your payslip, and it may differ slightly from month to month if you do overtime or have benefits taken through payroll.

If your income varies, do not budget on your best month. Take the lowest of the last three months and build the month on that. Anything above it gets assigned when it arrives, not spent in advance. The same goes for bonuses, tips and cashback: leave them out of the plan, then give them a job the day they hit your account.

Step 3: List every cost, in priority order

Order matters, because when money is tight it tells you what gets funded first. A sensible sequence for most UK households:

1. Rent or mortgage.
2. Council tax, gas and electricity, water, broadband and phone.
3. Insurance, and transport you need for work.
4. Minimum payments on any credit cards, loans or car finance.
5. Food, toiletries and household essentials.
6. Savings, including a starter emergency fund.
7. Extra debt payments.
8. Everything else — subscriptions, takeaways, clothes, hobbies, gifts.

Go through your last two or three bank statements rather than guessing. Annual and one-off costs belong here too: car insurance, MOT, service, Christmas, birthdays, dental check-ups, a new boiler fund. Take the yearly amount, divide by twelve, and give it its own monthly line. A £600 insurance premium becomes a £50 monthly transfer into a separate pot, and it stops being a nasty surprise.

Step 4: Assign pounds until the balance reads zero

Now work down your list, filling in the planned column. After each line, glance at the balance cell. When you get to the bottom, two things can happen.

If the balance goes negative before you reach the fun stuff, that is information, not failure. Either trim a flexible category, or accept that something has to wait this month. If you reach the bottom with money still unassigned, do not shrug and leave it. Send it somewhere deliberate: the emergency fund, an ISA, an overpayment, or next month's buffer.

A quick illustration

Say your net income is £2,300. Housing takes £850, council tax and utilities £280, transport £180, minimum debt payments £120, food and essentials £400. That leaves £470 for savings, overpayments, personal spending and anything else. Assign all of it. If you decide £100 each for you and your partner as no-questions-asked spending, that is a legitimate budget line — not a leak.

Step 5: Plan for the bills that don't arrive monthly

Council tax is often paid over ten months, which means two payment-free months that quietly become overspend months. Divide the annual bill by twelve instead and put the difference aside, so the monthly cost is the same all year. The same trick works for quarterly energy bills, annual subscriptions, and anything else that lands unevenly.

Step 6: Update the actuals once a week

Enter what you really spent in the actual column, using your banking app or statements. Ten minutes on a Sunday is plenty; daily tracking tends to burn people out. Do not chase perfection. A tenner in the wrong category will not change your month, but three weeks of not looking will.

At month end, compare planned with actual. Some lines will be over, some under. Adjust the plan for next month rather than scolding yourself — the spreadsheet is meant to be edited, not admired.

Making it stick

Keep the file somewhere you will actually open it: cloud storage, your phone's spreadsheet app, or pinned on a laptop. Save a fresh copy each month so you can see your own patterns over time. Review your categories every few months, because households change — a child starts school, a commute changes, a subscription you forgot about quietly renews.

Two habits protect the whole system. First, a weekly ten-minute check-in, so surprises are small. Second, a personal spending line for each adult that nobody has to justify. Budgets that forbid everything get abandoned by February.

If debts are making the numbers impossible to balance, or you are choosing between essentials, free and confidential help is available from Citizens Advice and StepChange. This article is general guidance, not regulated financial advice, so speak to a qualified adviser before making significant decisions about debt, pensions or investments.

Photo: Barta4 / Pixabay