Income minus all allocations equals zero, and that does not mean spending everything; savings and debt payments are categories too. In the Excel sheet below you start with the month's income, give every rupee a category, and watch one cell, Left to assign, which must end at zero. The sheet shows the formula and what to do with unspent money at month end.
How should the sheet be laid out?
Use a single tab. Put income sources in rows 2 to 4 with the total in B5. Below them, the Left to assign cell in B7 and a header row at row 9. Categories run from row 10. Type the first day of the month in B1, since the Spent formula below reads it:
- A: Category - rent, groceries, utilities, transport, EMIs, insurance fund, savings, eating out, fun, buffer
- B: Allocated this month
- C: Spent so far
- D: Left in category
The rule is simple: every rupee of income lands in a category before the month starts. If you get paid on the 1st, do this on the 1st, with real numbers from last month beside you.
What is the formula for Left to assign?
In B7: =B5-SUM(B10:B40). When it shows zero, every rupee has a job. A positive number is money still waiting to be assigned; a negative number means you have promised more than you earn. Add a conditional format on B7 with a custom formula =ROUND($B$7,2)<>0 and a red fill, so only an exact zero stays calm.
In C10, if you track expenses on a second tab with Date in A, Category in B and Amount in C, use =SUMIFS(Expenses!$C$2:$C$2000, Expenses!$B$2:$B$2000, A10, Expenses!$A$2:$A$2000, ">="&$B$1, Expenses!$A$2:$A$2000, "<"&EDATE($B$1,1)), where B1 holds the first day of the month. In D10 use =B10-C10.
A worked example with pretend numbers
Say a household has ₹75,000 of income this month. The allocations:
| Category | Allocated |
|---|---|
| Rent | ₹25,000 |
| Groceries | ₹9,000 |
| Utilities | ₹4,000 |
| Transport | ₹5,000 |
| EMIs | ₹8,000 |
| Insurance fund | ₹3,000 |
| Savings | ₹12,000 |
| Eating out | ₹4,000 |
| Fun | ₹3,000 |
These add to ₹73,000, so Left to assign shows ₹2,000. Rather than leave it floating, give it a job, say Buffer, ₹2,000. Now 75,000 - 75,000 = 0, and the sheet is balanced.
What happens to unspent money at month end?
Zero-based budgeting is strict about this, and the rules matter more than the maths:
- Flexible categories, such as eating out: move the leftover to savings or carry it into next month's income pool.
- Sinking categories, such as the insurance fund: carry the balance forward; it was meant to build up.
- Overspent categories: cover the shortfall by moving allocation from another category, and write down which one.
Say eating out ends with ₹900 left and groceries ends ₹400 over. Reduce eating out's allocation to ₹3,600 and raise groceries to ₹9,400. Eating out then has ₹500 left, groceries is at zero, and total allocations are unchanged at ₹75,000. The budget still balances, and you can see exactly what flexed.
What are the common slips?
- Forgetting irregular costs such as school fees, festival gifts and vehicle service; give them a monthly line.
- Adding income during the month without assigning it, so Left to assign quietly stays above zero.
- Treating zero as a target to spend, when savings and the buffer are categories like any other.
- Skipping a weekly look at the Left in category column.
When tracking becomes the bottleneck
The sheet only works if the Spent column is current. SpendixAI can import bank and card statements and categorise them, which can feed that figure. It is not built as a zero-based budgeting system; it has budgets, bills and savings goals on Pro, so think of it as a way to fill in the actuals while the zero-based planning stays in your sheet.
Useful ideas start with a clearer picture of your own spending.
Explore your reports


