A Diwali gift tracker is a sheet with one row per recipient and columns for relationship, tier, gift idea, cap, amount spent and what you received in return. Group recipients into three tiers with a fixed cap each, and the total is known before you shop. The received column lets you keep gifting even from year to year without keeping score in your head.
What columns does the tracker need?
- A: Name
- B: Relationship, such as cousin, manager, neighbour or the person who helps at home
- C: Tier, written as A, B or C
- D: Gift idea, such as sweets box, dry fruit pack or a plant
- E: Cap in rupees
- F: Amount spent
- G: Gift received this year, with a rough value if you know it
- H: Note for next year
The sheet is plain: headings in row 1, twenty recipients in rows 2 to 21. For a flag on overspend in column I, use =IF(F2>E2,"Over","OK") and copy it down.
How do the three tiers work?
Say you gift 20 people. Tier A is six close relatives, with a cap of ₹1,500 each. Tier B is eight colleagues and neighbours, with a cap of ₹500 each. Tier C is six people you want to thank with a small token, such as those who help through the year, at ₹200 each. The workplace tier should follow your office's gifting norms, so check those before buying.
| Tier | People | Cap each | Tier total |
|---|---|---|---|
| A: close relatives | 6 | ₹1,500 | ₹9,000 |
| B: colleagues and neighbours | 8 | ₹500 | ₹4,000 |
| C: small tokens | 6 | ₹200 | ₹1,200 |
| Total | 20 | - | ₹14,200 |
Check: 6 + 8 + 6 = 20 people, and 9,000 + 4,000 + 1,200 = ₹14,200. To pull the tier totals from the sheet, use =SUMIF($C$2:$C$21,"A",$F$2:$F$21) for the amount spent on tier A. Change the letter for B and C. =COUNTIF($C$2:$C$21,"A") returns how many recipients sit in that tier.
How do you use the received column without keeping score?
The point is not to match every rupee. It is to notice patterns: a relative who sent a large hamper for three years running, or a neighbour you have never gifted but who gifts you each time. Write what came and roughly what it was worth. Next year, before you set caps, scan that column and decide whether to move anyone up or down a tier. Move people on purpose, not because you felt awkward at the door.
Who should be on the list at all?
Write the full list first, then cross out anyone you only list from habit. A list built from real relationships is shorter and each gift can be better. Include people who help at home or in your society if you wish to thank them, but keep that decision separate from the money you give as wages or bonus.
Can you buy in bulk without it looking impersonal?
- Order sweets boxes or dry fruit packs for a tier in one go, so you can ask for a combined bill and one delivery.
- Keep a small stock of gift wrapping and cards so the finish is personal even when the gift is the same.
- For relatives in other cities, check delivery charges and dates early, and count them in the cap.
- Pay in as few transactions as possible, so the record is short.
Recording it in your expense tracker
Create a Diwali gifts category and add one entry per purchase, noting the tier in your sheet. SpendixAI supports custom categories and several expenses added in one go, so a day's gift shopping can be entered together and the total checked against ₹14,200 or whatever your own number is. Keep the recipient-level detail in the sheet, where the columns already exist.
Before you place the orders
- List finalised and tiers assigned
- Caps multiplied by headcount and compared with your gift budget
- Office gifting norms checked for colleagues
- Delivery dates for faraway relatives confirmed
- Received column from last year read before deciding tiers
Useful ideas start with a clearer picture of your own spending.
Explore your reports


