Guides › Budgeting with a spreadsheet › Zero-Based Budget Spreadsheet (Excel & Google Sheets): How It Works · Updated 26-10-2026
Zero-based budget spreadsheet: give every pound a job
A zero-based budget means income minus everything you plan to spend, save or repay equals exactly zero. It does not mean spending everything; savings and extra debt payments are jobs too. A spreadsheet makes it easy because one cell shows how much is still unassigned.
Buy now — $12$17 See what’s inside →
- Secure checkout by Stripe
- Instant download
- 30-day money-back guarantee
- Excel + Google Sheets
The one formula you need
Put your expected income for the period in one cell, say B2, and all your planned amounts in a column, say D5:D40. The amount left to assign is:
=B2-SUM(D5:D40)
Your goal is to get that cell to 0. If it is positive, give the rest a job (savings, a debt, a sinking fund). If it is negative, cut something until it is zero.
Categories that make it work
- Fixed bills: housing, utilities, insurance, phone, minimum debt payments.
- Variable essentials: groceries, fuel, household items.
- Irregular costs: a monthly slice of car repairs, gifts and annual bills, kept as sinking funds.
- Goals: emergency fund and extra debt payments.
- Personal money: a small, guilt-free amount per person. Budgets without it tend to be abandoned.
Zero-based budgeting per paycheck
Monthly zero-based budgets can still run short if most bills fall before your second payday. The fix is to do it per paycheck: each paycheck is zeroed out against the bills it has to cover. Our paycheck to paycheck guide and biweekly budget guide explain how to assign bills to paychecks.
Irregular income
If you are self-employed or work variable hours, budget from your lowest normal month, not your average. When a good month comes, the extra gets its job afterwards: buffer first, then goals.
Common mistakes
- Forgetting annual costs, then calling the budget a failure when the car insurance arrives.
- Making categories so tight there is no room for real life.
- Never checking against the bank. Ten minutes a week keeps the plan honest.
Zero-based budgeting is one of the methods in our step-by-step budgeting guide.
Ready-made
The Paycheck Budget & Debt Payoff Planner shows what is left on each paycheck after bills, so you can zero it out paycheck by paycheck, with sinking funds and a snowball vs. avalanche debt plan in the same file.
FAQ
Does zero-based mean I spend everything?
No. Savings, sinking funds and extra debt payments count as jobs. Zero means nothing is left unplanned.
Does the formula work in Google Sheets?
Yes, the same formula works in Excel and Google Sheets.
Can I do it with two incomes?
Yes. Add both incomes in the income cell; the planner supports two incomes with different pay schedules.
Related guides
- Start here: How to budget with a spreadsheet: a step-by-step guide
- Paycheck to paycheck budget spreadsheet: plan by payday, not by month
- Sinking funds spreadsheet: stop irregular bills breaking your budget
- Biweekly budget template: make every second-Friday paycheck work
- All guides
Get instant access — $12$17 See what’s inside