To see what Diwali really cost, put your plan and your tracked actuals side by side in one sheet: one row per line, planned amount, actual amount, the difference and a percentage. Then write one short note for each large gap, saying why it happened and what you will do differently. Those notes, not the totals, are what improve next year's plan.
What does the review sheet look like?
Here is a hypothetical plan with ten lines. Say the family planned ₹78,950 and tracked ₹84,800.
| Line | Planned | Actual | Difference |
|---|---|---|---|
| Crackers | ₹3,000 | ₹3,400 | +₹400 |
| Clothes | ₹16,000 | ₹15,000 | -₹1,000 |
| Puja items | ₹2,500 | ₹2,500 | ₹0 |
| Gifts | ₹14,200 | ₹16,700 | +₹2,500 |
| Sweets and snacks | ₹3,500 | ₹4,300 | +₹800 |
| Decor | ₹2,750 | ₹2,400 | -₹350 |
| Dhanteras purchase | ₹20,000 | ₹22,000 | +₹2,000 |
| Hosting dinner | ₹9,000 | ₹10,200 | +₹1,200 |
| Travel home | ₹6,000 | ₹5,500 | -₹500 |
| Tips, helpers and extras | ₹2,000 | ₹2,800 | +₹800 |
| Total | ₹78,950 | ₹84,800 | +₹5,850 |
Check the totals. Planned: 3,000 + 16,000 + 2,500 + 14,200 + 3,500 + 2,750 + 20,000 + 9,000 + 6,000 + 2,000 = 78,950. Actual: 3,400 + 15,000 + 2,500 + 16,700 + 4,300 + 2,400 + 22,000 + 10,200 + 5,500 + 2,800 = 84,800. The differences add to +400 - 1,000 + 0 + 2,500 + 800 - 350 + 2,000 + 1,200 - 500 + 800 = 5,850, which equals 84,800 - 78,950.
Which formulas give you the variance?
- Difference: =C2-B2, where B is planned and C is actual, copied down
- Percentage gap: =IF(B2=0,"",D2/B2), formatted as a percentage
- Flag for a big gap: =IF(ABS(E2)>=0.15,"Explain",""), where 0.15 is the gap you choose to notice
- Totals row: =SUM(B2:B11) and =SUM(C2:C11), then =C12-B12 for the overall difference
Overall, 5,850 / 78,950 is about 7.4 percent over. Gifts are 2,500 / 14,200, about 17.6 percent over. Sweets and snacks are 800 / 3,500, about 22.9 percent over. Extras are 800 / 2,000, 40 percent over. With a 15 percent trigger, those three lines get a note.
Which gaps deserve a note?
Not every gap does. A ₹350 saving on decor is not a lesson. Look for gaps that are large in rupees, large in percentage, or repeated across years. In the example, the Dhanteras line is ₹2,000 over but only 10 percent, so a short note is enough. The gifts line is both large and over the trigger, so it earns a proper sentence.
What does a good note say?
- What happened: 'Two extra relatives added after the cap was set.'
- Why: 'The list was made in September and not revisited.'
- What to change: 'Freeze the gift list on 1 October and add anyone later from a small spare amount.'
Three short lines are better than a paragraph. They are also easier to find next year.
Did the plan fail, or did the festival change?
Be fair to the plan. A line can run over because the plan was too low, because the spending was undisciplined, or because something genuinely new came up, such as an extra guest or a wedding invitation in the same week. Mark each big gap as one of the three. If most gaps are 'plan too low', raise those lines next year and expect the total to rise. If most are 'undisciplined', the fix is a cap and a list, not a bigger plan. If they are 'something new', leave a small spare line for surprises instead of padding every row.
How do you get the actuals without retyping everything?
Pull them from your tracker. If you keep Diwali spending in categories, a report filtered to the festival dates and grouped by category gives the actual column in one go. SpendixAI has a report builder where you filter and group, and you can download the result as a CSV and paste it into the review sheet. Cash spends you added by hand appear alongside imported statement rows.
When the review is done
- Totals checked against bank and card statements
- One note written for each flagged line
- Next year's plan started as a copy of this sheet with the actuals as the baseline
- Sheet saved with the year in its name
Useful ideas start with a clearer picture of your own spending.
Explore your reports


