Decide the total festive pot first, split it into four caps (electronics, clothes, home and gifts), and keep a running total beside each cap so that the overspend shows in one category before it spreads. With a made-up pot of ₹40,000 the whole planner fits in a five-row table and takes about ten minutes to set up before the first sale email arrives.
How do I divide the pot across the four categories?
Start from what you already know you must buy, not from what the offers look like. Gifts and clothes for a festival tend to be fixed by the calendar, electronics and home items are often optional and can be pushed to another sale. Say the pot is ₹40,000 and the split is:
- Electronics: ₹16,000, because a new phone cover and a replacement mixer are on the list.
- Clothes: ₹10,000, mostly for the family's festival outfits.
- Home: ₹8,000, for lights, a curtain set and kitchen items.
- Gifts: ₹6,000, for relatives and the people who help through the year.
The caps add up to ₹40,000 (16,000 plus 10,000 plus 8,000 plus 6,000). If your figures do not add up to the pot, the planner is already lying to you.
What does the running table look like?
Four columns are enough: cap, spent so far, left, and a flag. Here is a made-up snapshot taken in the middle of the sale week.
| Category | Cap | Spent so far | Left |
|---|---|---|---|
| Electronics | ₹16,000 | ₹9,500 | ₹6,500 |
| Clothes | ₹10,000 | ₹7,800 | ₹2,200 |
| Home | ₹8,000 | ₹8,600 | -₹600 |
| Gifts | ₹6,000 | ₹2,400 | ₹3,600 |
| Total | ₹40,000 | ₹28,300 | ₹11,700 |
The pot as a whole still has ₹11,700 left, but the Home row is already ₹600 over. That is the reason for category caps: a healthy total can hide a category that has already gone past its limit.
How do I catch overspend in one category early?
In Excel or Google Sheets, put the cap in B2 to B5, spent in C2 to C5 and use D2 as =B2-C2 filled down. Then add the leftover line with =SUM($B$2:$B$5)-SUM($C$2:$C$5). To highlight a negative balance, add a conditional formatting rule on D2 to D5 with the custom formula =D2<0 and choose a red fill.
Decide in advance what you will do when a row goes red. A good default is: stop buying in that category and, if you must continue, move money from another category by writing one line in the sheet that says from where to where and why. Moving money by editing the cap silently is how pots disappear.
What if a gift costs more than I planned?
Gifts are where feelings get involved, so the cap is usually the first to be stretched. Two things help. Fix the gift budget per person before the sale (say ₹600 for each of ten people, which makes ₹6,000), and wrap anything shared, such as a family sweet box, into one line instead of ten.
Can I do this inside a tracker?
Yes. In SpendixAI you can create custom categories and sub-categories, so Electronics, Clothes, Home and Gifts can sit under a Festive heading, and a statement import puts each card line into the right one after you review it. Budgets are part of Pro. If you want to keep it light, the five-row table above is enough.
Decide early whether a small buffer line, say ₹1,000, comes out of one of the caps (making electronics effectively ₹15,000), so that delivery fees, a size exchange or a forgotten gift do not have to come out of a category that is already tight. If the buffer is untouched on the last day, it moves to the leftover line.
After the festival
- Fill in the final Spent column from the statement, not from memory.
- Write the leftover amount, and decide where it goes: back to savings, or into next year's festive pot.
- Mark which category overran and note why in one line.
- Use that note to set next year's caps.
Useful ideas start with a clearer picture of your own spending.
Explore your reports


