A zero based budget spreadsheet assigns every dollar of a month's income to a named line, such as rent, groceries or savings, until the amount left to assign is exactly zero. Your bank statement supplies both halves: the deposits tell you what to assign, and the spending rows show whether each dollar did the job you gave it.
What makes a budget spreadsheet zero based?
A budget is zero based when income minus everything you assign equals zero. The zero is not your bank balance. It is the unassigned remainder on the plan. Savings, debt payments and a small buffer all count as assignments, so a zero based plan can still leave money sitting in the account.
The idea answers a specific weakness of a plain spending limit. A limit tells you how much groceries may cost, but it says nothing about the $300 that was never planned at all. Unplanned money tends to disappear into small purchases. Giving it a line, even a line called "Extra savings", makes the choice visible.
Three rules define the method:
- Start from money you actually received, not from salary on paper.
- Assign until the remainder is zero. A positive remainder means unplanned money. A negative one means you planned more than you have.
- Reassign, never overspend. If a line runs out, money moves from another line, and the total stays at zero.
A spreadsheet suits this well because the arithmetic is simple and you can see every line at once. The cost question is covered in how much budgeting apps cost per year, which compares paid zero based apps with a free sheet.
Finding the income figure for a zero based budget in your statement
The income figure for a zero based budget is the total of deposits that are genuinely yours to spend in the month: paychecks, freelance payments, benefits. Your bank statement lists every deposit with a date and a description, so you add up the qualifying rows rather than estimating from a payslip or a contract.
Using deposits instead of gross pay matters because taxes, retirement contributions and insurance come out before the money reaches the account. A $4,200 gross salary might arrive as two deposits of $1,700. Only the $3,400 that landed can be assigned.
Leave out deposits that are not new money:
- Transfers from your own savings. Moving $500 into checking does not make you $500 richer.
- Refunds. A returned jacket puts money back into the clothing line, not into income.
- Repayments from friends. If you covered a dinner and were paid back, that offsets the dinner.
One timing choice keeps the plan stable. Many people budget each month with the income received in the previous month. That way the full amount is known before the month starts, and a paycheck that arrives on the 31st does not land in a plan you already closed.
Zero based budget spreadsheet layout: the assign column and the left-to-assign cell
The sheet needs one row per budget line and four columns: line name, assigned, spent and remaining. Above the table sit two cells: the month's income and a "left to assign" cell that subtracts the assigned column from income. Your planning is done when that cell reads 0.00.
A practical layout:
| Cell or column | Contents | Formula |
|---|---|---|
| B1 | Income for the month | Typed from the statement deposits |
| B2 | Left to assign | =B1-SUM(B5:B30) |
| A5:A30 | Budget lines | Typed |
| B5:B30 | Assigned | Typed |
| C5:C30 | Spent | SUMIFS over the statement rows |
| D5:D30 | Remaining | =B5-C5 |
Format B2 so it turns red when it is not zero. Conditional formatting with the rule "cell value not equal to 0" does it. That one red cell is the whole discipline of the method in a single place.
Group the lines into fixed bills, variable spending, savings and debt, with a subtotal for each. The groups do not change the arithmetic, but they show at a glance how much of your income is committed before the month even starts.
Keep a separate tab for statement rows, with date, description, amount and a category column you fill in. The "Spent" column then reads from that tab with a formula like =-SUMIFS(Rows!C:C, Rows!D:D, A5), where column C holds amounts and column D holds the category. The minus sign turns negative spending rows into positive totals.
Worked example: assigning a $3,400 month to zero
This example takes a made-up household with $3,400 of deposits in September and assigns all of it before October starts. The figures are illustrations, not recommendations. The point is the shape of a finished zero based plan: every line named, savings included, and a left-to-assign cell of exactly zero.
| Line | Group | Assigned |
|---|---|---|
| Rent | Fixed | 1,250.00 |
| Electricity and gas | Fixed | 110.00 |
| Phone and internet | Fixed | 95.00 |
| Car insurance | Fixed | 88.00 |
| Groceries | Variable | 420.00 |
| Fuel | Variable | 140.00 |
| Eating out | Variable | 120.00 |
| Personal and household | Variable | 90.00 |
| Car repairs fund | Savings | 75.00 |
| Holiday gifts fund | Savings | 60.00 |
| Emergency savings | Savings | 300.00 |
| Credit card payoff | Debt | 552.00 |
| Buffer | Variable | 100.00 |
| Total assigned | 3,400.00 | |
| Left to assign | 0.00 |
Two lines here deserve a note. The buffer gives small surprises a home without breaking another line. The credit card payoff absorbed whatever was left after everything else, which is a common way to reach zero: decide your essentials first, then send the remainder to a goal.
At the end of October, the statement rows fill the "Spent" column. Suppose groceries came to $455.20, eating out to $96.40 and fuel to $131.75. Groceries is $35.20 over, eating out is $23.60 under, and fuel is $8.25 under. The buffer covers the grocery gap, and November's plan raises groceries to $450 while trimming eating out.
Matching statement rows to each zero based budget line
Each spending row on the statement gets one budget line as its category, and the sheet adds up the rows per line. When the spent total for a line passes its assigned amount, that line is overspent. The match is only as good as the categories, so set a short rule for anything ambiguous.
Most rows are easy. A supermarket is groceries, a fuel station is fuel. A few need a decision you apply every month:
- A big-box store that sells both food and household goods. Pick one line for it, or split the receipt if the amounts are large.
- Savings transfers. These are assignments being carried out, not spending. Mark the transfer row with the savings line, so the line shows as funded.
- Card payments. If you budget the purchases on the card, the payment from checking is not new spending. Tag it as a transfer and leave it out of the totals.
Getting rows into the sheet in the first place is the slow part. Typing 120 rows from a PDF statement takes a while and invites mistakes. The trade-off between typing and automated reading is costed in manual data entry vs OCR cost per page. A CSV download from online banking, or a converted statement, saves most of that time.
Check the totals once a month. The sum of every "Spent" cell plus uncategorized rows should equal the total of outgoing rows on the statement, minus the card payments you tagged as transfers. If it does not, a row is missing a category.
What happens when a zero based budget line runs out mid-month?
When a zero based budget line runs out, you move money into it from another line, and the total assigned stays the same. Groceries goes up by $40 and eating out goes down by $40. The left-to-assign cell still reads zero, and the overspend becomes a decision instead of a surprise.
In the spreadsheet, record moves rather than overwriting numbers. Add a "Moved" column between Assigned and Spent, and change Remaining to =B5+C5-D5 with the new column in C. A move of $40 is +40 on one line and -40 on another. The column should sum to zero, and a check cell with =SUM(C5:C30) confirms it.
Keeping the original assignment visible shows patterns over time. If groceries receives a transfer every month, the plan is wrong, not your shopping. Raise the line in next month's plan and lower whatever kept donating to it.
Sometimes there is nothing left to move. Every line is already near its limit, and a $250 car repair arrives. That is what the savings lines are for. Move money out of the car repairs fund first. If that fund is empty, the emergency line covers it, and the next month's plan rebuilds both. Spending more than income, with nothing to move, means the month ends with a negative left-to-assign figure. Write that number at the top of next month's plan as a deduction from income, so the gap is paid back rather than forgotten.
When a zero based budget is the wrong tool
A zero based budget asks for a plan every month and a check against the statement every month. That suits people who like detail or who are paying down debt on a deadline. It suits people with very uneven income, or who will not open the sheet weekly, less well, and a simpler method may last longer.
Signs the method is costing more than it returns:
- You rebuild the plan every month from scratch and never compare it with the statement. The checking half is where the method earns its keep.
- Your income swings by hundreds of dollars between months. Assigning money you have not received yet breaks rule one. Budgeting last month's income helps, but very uneven earnings fit a base-budget approach better.
- You have 30 or more lines. Each extra line is one more place for a small overspend and one more move to record.
Two lighter options keep part of the idea. An envelope budgeting spreadsheet without cash envelopes keeps the "money has a place" principle with fewer lines and refills. A plain spending-limit budget with a single savings line asks for even less.
If your bank only gives you PDF statements, CheapBankConvert converts each one to CSV or Excel rows for a one-time price, with no subscription to remember. It is in early access, so join from the homepage to hear when it opens.