A weekly spending limit with rollover is a table where each week's available amount is the allowance plus last week's leftover, which may be negative if you overshot. It suits variable spending like vegetables, eating out and petrol, where a monthly figure hides the week you went wrong. The only real design decision is how to get week-start dates, and a simple "add seven days" step does that more safely than WEEKNUM.
How do you generate the week-start dates?
Type the first Monday you want to track in A2, say 5-Oct-2026. Then in A3 enter =A2+7 and fill down. Every row now holds a Monday and the next row starts exactly seven days later.
WEEKNUM(A2,2) gives a week number with Monday as the first day, which is handy as a label. But it restarts in January, so a table spanning two calendar years will repeat numbers. The date column is the safe key.
What columns does the table need?
- A: week starts (Monday date)
- B: weekly allowance, for example ₹3,500 for food and fuel together
- C: carry-in: 0 in the first row, then the previous row's F
- D: available = B2+C2
- E: spent that week
- F: left = D2-E2 (negative when you overshoot)
Pull spent from your transactions tab, with dates in A, categories in B and amounts in C:
=SUMIFS(Txn!$C$2:$C$500, Txn!$B$2:$B$500, "Food", Txn!$A$2:$A$500, ">="&A2, Txn!$A$2:$A$500, "<"&A2+7) + SUMIFS(Txn!$C$2:$C$500, Txn!$B$2:$B$500, "Fuel", Txn!$A$2:$A$500, ">="&A2, Txn!$A$2:$A$500, "<"&A2+7)
Adding two SUMIFS keeps the formula readable when two categories share one allowance.
How do you choose the allowance? Look at your own last eight weeks of food and fuel spending, add them up and divide by eight. Round that to a figure you can live with, then trim it slightly if you want the sheet to push you. A limit copied from someone else's household will either be ignored or make you give up by week three.
What does a month of weeks look like?
With a ₹3,500 allowance and made-up spending:
| Week | Allowance | Carry-in | Available | Spent | Left |
|---|---|---|---|---|---|
| Week 1 | 3,500 | 0 | 3,500 | 3,900 | -400 |
| Week 2 | 3,500 | -400 | 3,100 | 2,600 | 500 |
| Week 3 | 3,500 | 500 | 4,000 | 3,200 | 800 |
| Week 4 | 3,500 | 800 | 4,300 | 4,600 | -300 |
Week 1 overshoots by ₹400, so week 2 has only ₹3,100 to work with. Two good weeks then build a cushion of ₹800, which week 4 partly spends. Four weeks of allowance is ₹14,000 and total spending is ₹14,300, which matches the final left figure of -₹300.
How much can you spend per day this week?
In a spare column, divide what is left by the days remaining, counting today:
=IF(AND(TODAY()>=A2, A2+7>TODAY()), (D2-E2)/(A2+7-TODAY()), "")
On Monday it shows available divided by seven; on Sunday it shows whatever is left for that one day. If the figure is negative, you have already used the week's money and the sheet is telling you to pause, not to panic.
Should leftover always roll over?
If you find yourself saving a pile in good weeks and burning it in one weekend, add a ceiling with MIN, as in =MIN(F2, 2000) in the next row's carry-in. Or absorb overshoots with =MAX(F2,0) so a bad week is forgiven. Try each for a month and keep the one you actually follow.
Keep it low effort
The sheet only works if cash spends reach it. Jot cash purchases into the transactions tab the same evening, or add them in a batch on Sunday. SpendixAI lets you add several expenses by hand at once and import card or bank statements for the rest, which can save retyping if the sheet starts to feel heavy.
Useful ideas start with a clearer picture of your own spending.
Explore your reports


