Free guide - Northbench

The household budget spreadsheet: the five tabs that matter

A budget fails in one of two ways: it is so detailed that maintaining it becomes a second job, or so vague that it produces no information. The five-tab design below is the middle path - enough structure to tell the truth, little enough that you keep it for years.

Tab 1: The month

Income in, fixed costs out (rent, utilities, insurance, subscriptions - the things that arrive whether you believe in them or not), then the flexible spend, then what remains. The only number that matters on this tab is the remainder, and it should be visibly positive by design, not by accident.

Tab 2: The running net worth

One row per month: every account's balance, every debt's balance, one total. This is the tab nobody builds and everybody should - it is the scoreboard of the whole household, and it moves slower than the budget but tells the truth about direction. Up over twelve months means the system works, whatever the individual months felt like.

Tab 3: The yearly bills calendar

The insurance premium, the car service, school fees, the holiday that arrives every December like a bill because it is one. The budget that dies usually dies in the month an annual expense landed on a monthly plan that forgot it existed.

Tab 4: The sinking funds

A sinking fund is a named savings goal with a monthly contribution: "car replacement, $150/month." It converts scary future lumps into boring monthly lines. Three to five funds is plenty; more is a hobby.

Tab 5: The honest discretionary

One category, one number, no itemized guilt. Budgets that track every coffee train people to lie to their own spreadsheet. Give the fun money a number, spend it on anything, and let the rest of the system stay clean.

What to leave out

Daily transaction logging (your bank already does it), per-category alarms, and any tab you would be embarrassed to show your partner. The budget is a steering wheel, not a dashboard of judgement.