A Diwali budget sheet has two tables: one for categories, with last year's spend, this year's plan and the actual, and one gift list with the person, planned value and a bought yes-or-no. Put last year beside this year, and the sheet tells you straight away where the festival costs are growing.
What goes in the category table?
Rows for gifts, sweets and dry fruits, clothes, decor, and puja items. Columns: A category, B last year, C this year planned, D actual, E difference from plan, F change from last year. Say the figures look like this, all hypothetical:
| Category | Last year (₹) | Planned (₹) | Actual (₹) |
|---|---|---|---|
| Gifts | 12,000 | 14,000 | 15,200 |
| Sweets and dry fruits | 4,000 | 4,500 | 4,300 |
| Clothes | 15,000 | 16,000 | 16,800 |
| Decor | 3,500 | 3,000 | 2,700 |
| Puja items | 2,500 | 2,500 | 2,500 |
| Total | 37,000 | 40,000 | 41,500 |
Formulas: E2 is =C2-D2 (negative means over plan), F2 is =IF(B2=0,"",D2/B2-1), formatted as a percentage. Totals use =SUM(B2:B6). Overall, actual 41,500 is ₹1,500 above the plan of 40,000, and ₹4,500 above last year's 37,000, which is 12.2 percent: 4,500 divided by 37,000 is 0.1216.
How do I build the gifting list?
On a second tab, Gifts: A name, B relationship, C planned value, D bought (Yes or No), E actual price. Say it holds a sister at ₹3,000, a brother at 2,500, a maternal aunt at 1,500, the neighbours' box at 800, the domestic help at 2,000 and four colleagues' boxes at 2,000 in all.
| Name | Relationship | Planned (₹) | Bought |
|---|---|---|---|
| Sister | Family | 3,000 | Yes |
| Brother | Family | 2,500 | No |
| Maternal aunt | Family | 1,500 | No |
| Neighbours | Neighbour | 800 | Yes |
| Domestic help | Household | 2,000 | No |
| Colleagues, four boxes | Work | 2,000 | No |
- Planned total: =SUM(C2:C30). Here 3,000 plus 2,500 plus 1,500 plus 800 plus 2,000 plus 2,000 is ₹11,800.
- Still to buy: =SUMIFS($C$2:$C$30,$D$2:$D$30,"No")
- Progress: =COUNTIF(D2:D30,"Yes")&" of "&COUNTA(A2:A30)&" bought"
- Headroom in the gifts category: =C2-SUM(Gifts!C2:C30) on the category tab, where C2 is the planned gifts figure. With a 14,000 plan, that leaves ₹2,200 for anything unplanned.
Rather than one big list in your head, the gift tab shows who has been covered and who has not, which is what saves last-minute spending.
How do I compare with last year?
Keep one tab per year, named Diwali 2025 and Diwali 2026. In this year's tab, make column B pull last year's actuals: ='Diwali 2025'!D2. The link means you never retype old figures, and next year you can copy this tab, rename it and repoint column B. Because sheet names contain spaces, the quotation marks in the formula are required.
What should I add to the checklist?
- A shopping checklist column on the category table, with Done or Not yet beside each item, such as lights, rangoli colours, diyas, sweets, new clothes.
- A column for the payment mode, so you can match cash and UPI payments with your statements.
- A note for advance orders, such as sweets or tailoring, with the amount already paid.
- A line for the house cleaning or minor repair work done before the festival, if you spend on that.
What should I do after the festival?
- Enter the final actuals within a week, from your UPI history and card statement, not memory.
- Look at the F column: which category grew most? Decide if that was a choice or a drift.
- Write a one-line note on the tab for next year, such as "start gifts list earlier".
- Copy the tab for next year.
If many Diwali payments go through your card and UPI, SpendixAI can import the statement and let you put them in a custom category such as Festival, so the actual column comes straight from your records.
Useful ideas start with a clearer picture of your own spending.
Explore your reports

