Remaining budget for a category is the budget minus what you have spent in it so far: =B2-C2, where C2 is a SUMIFS total from your expense log. Wrap it in MAX(0, ...) if you want a floor at zero, and add a status column so each row says OK, Close or Over without you reading the numbers.
The columns you need
Assume a sheet with headings in row 3 and categories from row 4:
- A: Category
- B: Budget for the month, typed in
- C: Spent, from the log with SUMIFS
- D: Remaining, which can go negative
- E: Left to spend, floored at zero
- F: Status
Your expense log, on a sheet called Log, has dates in A, categories in B and amounts in C, rows 2 to 500. Put the first day of the month in B1.
How do I calculate spent and remaining?
Spent, in C4:
=SUMIFS(Log!$C$2:$C$500,Log!$B$2:$B$500,$A4,Log!$A$2:$A$500,">="&$B$1,Log!$A$2:$A$500,"<"&EDATE($B$1,1))
Remaining, in D4: =B4-C4. This keeps the true sign: a negative number is the overspend. Left to spend, in E4: =MAX(0,B4-C4). Use E when you want a clean display that never shows a minus sign, and keep D because it tells you by how much you went over. An optional column G can show the overspend alone with =MAX(0,C4-B4).
What formula gives an OK, Close or Over status?
In F4:
=IF(B4="","",IF(D4<0,"Over",IF(D4<=0.1*B4,"Close","OK")))
Read it from the inside. If there is no budget, leave the cell blank. If remaining is below zero, it says Over. If the remaining amount is no more than ten percent of the budget, it says Close. Otherwise OK. Change 0.1 to 0.2 for an earlier warning. Hypothetical example:
| Category | Budget | Spent | Remaining | Left to spend | Status |
|---|---|---|---|---|---|
| Food | ₹6,000 | ₹5,700 | ₹300 | ₹300 | Close |
| Fuel | ₹3,000 | ₹3,350 | -₹350 | ₹0 | Over |
| Subscriptions | ₹1,000 | ₹640 | ₹360 | ₹360 | OK |
| Shopping | ₹4,000 | ₹3,700 | ₹300 | ₹300 | Close |
Check the logic: Food has 300 left and ten percent of 6,000 is 600, so 300 is within the band and the status is Close. Subscriptions has 360 left against a band of 100, so it is OK. Fuel is 350 below zero, which is Over, and the floored column shows ₹0 while column D still records the minus 350.
Can I see how many days are left alongside the remaining amount?
Yes, and it makes the number much more useful. Remaining of ₹3,000 on the 5th is a different story from ₹3,000 on the 25th. Add a cell with =EOMONTH($B$1,0)-TODAY() for days left after today, and divide each Left to spend by it to get a rough daily figure per category. Keep it as a guide only; bills that fall due late in the month will not follow a daily pattern.
What should the total row show?
Sum the Budget column and the Spent column, then subtract. Do not add up the floored column for the total remaining, because that ignores overspends and makes the month look better than it is. For the overall status, apply the same IF to the totals. A category that is over while the total is fine is a sign to move money between categories, which is a perfectly reasonable thing to do in a household budget.
What if I carry unspent money into next month?
Add a Carried forward column and change Remaining to =B4+carry-C4. Set the carry yourself each month, copying last month's positive remaining only where you really mean to roll it over. Rolling everything automatically makes the sheet drift away from what your bank balance says, so it suits sinking funds such as annual insurance more than groceries.
A short check before you rely on it
- Pick one category and add its log rows by hand; compare with the Spent cell.
- Type a spend above budget to see the Over status appear.
- Confirm blank budget rows show blank status, not Over.
- Format Remaining as a number with a minus sign for negatives.
SpendixAI has budgets on Pro, with statements you import feeding the spent figures; a sheet like this one is still a good way to understand exactly what the number means.
Useful ideas start with a clearer picture of your own spending.
Explore your reports


