To review your gifting by person, list every gift of the year with its recipient, occasion and amount, then total by recipient with a pivot table or SUMIFS. Sorting the totals shows who received most, which occasions drive the spend and where your giving is uneven. The family list below is made up.
What columns does the sheet need?
- Date.
- Recipient: use one consistent spelling for each person, such as Mother or Sister, not Amma in one row and Mom in another.
- Occasion: Birthday, Wedding, Diwali, Rakhi, Other.
- Amount in rupees.
- Optional: what you gave, and a mark for cash or item.
Fill it from your statements and your memory of cash gifts. Spelling consistency matters more than anything else, since a pivot treats Mom and Mother as two people.
How do you total by recipient?
Say recipients are in column B, occasions in column C and amounts in column D, rows 2 to 200.
- One person's total: =SUMIFS($D$2:$D$200, $B$2:$B$200, "Mother")
- One person at one occasion: =SUMIFS($D$2:$D$200, $B$2:$B$200, "Mother", $C$2:$C$200, "Diwali")
- Count of gifts to a person: =COUNTIFS($B$2:$B$200, "Mother")
Or use a pivot table: select the data, insert a pivot table in Excel or Google Sheets, put Recipient in rows, Occasion in columns and Sum of Amount in values. It gives the whole grid in one go.
What does a made-up family list show?
| Recipient | Total (₹) | Share of year |
|---|---|---|
| Spouse's parents | 9,500 | 25% |
| Sister | 7,800 | 21% |
| Mother | 6,200 | 17% |
| Niece | 5,400 | 14% |
| Father | 3,100 | 8% |
| Colleagues (group gifts) | 3,000 | 8% |
| Friend | 2,500 | 7% |
| Total | 37,500 | 100% |
The total is 9,500 + 7,800 + 6,200 + 5,400 + 3,100 + 3,000 + 2,500 = ₹37,500. Shares are rounded, so they may not add exactly. In this family, the spouse's parents take about a quarter of gifting, and the mother receives double what the father does.
What can the imbalances tell you?
Not much on their own, since love is not measured in rupees. But the grid can start useful conversations with yourself. Is the gap between mother and father a decision or an accident? Does the niece get a lot because of three occasions in a year? Are you matching what someone gave you, or giving more to those you see less of? You may find a gift you thought was small, repeated six times, is your largest line.
Look at the occasion view too. Suppose the same year splits into ₹14,200 on festivals, ₹12,600 on birthdays and ₹10,700 on weddings and other events. That is about 38 per cent, 34 per cent and 29 per cent. If festivals are the largest block, a festival pot started in the summer will help more than a monthly birthday fund.
What do you change after the review?
- Choose a rough annual figure per person or group for next year, written next to this year's.
- Decide the occasions you will mark for each person, so decisions are not made at the shop.
- Set a cap for group gifts, so colleague collections do not creep.
- Move big seasonal items, such as Diwali, into a monthly pot.
When does a sheet stop being enough?
If you keep up the list for several years, copying rows from statements gets tiresome. SpendixAI can import statements and hand-added cash expenses into one workspace; its Report builder filters and groups transactions and lets you download CSV, and a sub-category per recipient can work for a small circle of people. Check that the grouping you want fits before moving.
Year-end checklist
- All gifts entered with consistent recipient names.
- Pivot or SUMIFS totals ready.
- One sentence per person on what you want next year.
- The total as a share of your take-home, for context.
Useful ideas start with a clearer picture of your own spending.
Explore your reports

