Spreadsheets

Diwali budget planner sheet: gifts, sweets, clothes and decor

A Diwali budget planner for Google Sheets: planned and actual spend by category, a gift list with bought status, and a comparison with last year's column.

Editorial illustration for Diwali budget planner sheet: gifts, sweets, clothes and decor

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:

CategoryLast year (₹)Planned (₹)Actual (₹)
Gifts12,00014,00015,200
Sweets and dry fruits4,0004,5004,300
Clothes15,00016,00016,800
Decor3,5003,0002,700
Puja items2,5002,5002,500
Total37,00040,00041,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.

NameRelationshipPlanned (₹)Bought
SisterFamily3,000Yes
BrotherFamily2,500No
Maternal auntFamily1,500No
NeighboursNeighbour800Yes
Domestic helpHousehold2,000No
Colleagues, four boxesWork2,000No
  • 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?

  1. Enter the final actuals within a week, from your UPI history and card statement, not memory.
  2. Look at the F column: which category grew most? Decide if that was a choice or a drift.
  3. Write a one-line note on the tab for next year, such as "start gifts list earlier".
  4. 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.

SPENDIXAI JOURNAL

Useful ideas start with a clearer picture of your own spending.

Explore your reports