To review the shagun you gave this year, add up every entry, group the total by relationship tier, and compare it with the pot you set in April. The two questions that matter are which tier drove the total and whether any single decision pushed you over. Eleven weddings in a year is a perfectly believable load, and a twenty-minute review will show you where the money went.
What do I need before I start?
- Your shagun log for the financial year, from April to March, with date, name, tier and amount.
- The pot you set at the start, if you set one.
- The tier figures you decided on, to see whether you stuck to them.
If your tiers were never written down, take this review as the chance to write them. Sort each person into immediate family, close friends and cousins, colleagues and neighbours, or distant relatives, and assign the tier retroactively.
A worked example with hypothetical numbers
Say the pot was ₹22,000 and you attended 11 weddings.
| Tier | Weddings | Total given | Share of year |
|---|---|---|---|
| Immediate family | 2 | ₹12,200 | 51.0% |
| Close friends and cousins | 3 | ₹6,300 | 26.4% |
| Colleagues and neighbours | 4 | ₹4,400 | 18.4% |
| Distant relatives | 2 | ₹1,002 | 4.2% |
| All tiers | 11 | ₹23,902 | 100% |
The immediate-family tier is 12,200 of 23,902, a little over half, from only two weddings. The year came in ₹1,902 over the pot. The average per wedding is ₹23,902 divided by 11, about ₹2,173.
What drove the total?
Look at the biggest single lines. In this example one immediate-family wedding was given at ₹7,100, while the usual figure for that tier was ₹5,100, so ₹2,000 more than planned. Without that decision the year would have been ₹21,902, which is ₹98 inside the pot. One conscious choice made the difference, and that is useful to know, because you can plan for it.
It also helps to look at the count by tier. Eleven weddings spread as 2, 3, 4 and 2 tell you that the busiest tier by number, colleagues and neighbours, was only 18.4 percent of the money, while the quietest by number carried half of it. That is worth remembering when someone suggests trimming the small gifts to save money; the savings would be tiny compared with a single decision in the top tier.
Did the pot hold, and what do I change?
- Compare the total with the pot: over or under, and by how much.
- Find the lines that were not in the plan: unexpected invitations, a raised figure, a gift for a wedding you did not attend.
- Decide whether those were one-offs or a pattern. A pattern means the pot or the tier figures were wrong.
- Set next year's pot from this year's actual total, adjusted for what you know is coming.
- Write the new tiers and figures on one page, dated.
How do I get tier totals quickly?
In a sheet with tier in column B and amount in column D, this gives one tier's total in Excel or Google Sheets: =SUMIFS($D$2:$D$200,$B$2:$B$200,"Immediate family"). The count of weddings in that tier is =COUNTIFS($B$2:$B$200,"Immediate family"). Divide the tier total by the grand total, =SUM($D$2:$D$200), for the share.
When a sheet stops being enough, SpendixAI lets you keep a Shagun category with a sub-category for each tier, and its Report builder can filter and group the entries, so the tier totals appear without formulas.
A closing checklist
- Total the year and compare with the pot.
- Group by tier and note the share of each.
- Identify the one or two decisions that moved the total.
- Set the new pot and tier figures within a week of the review.
- Share the plan with your spouse or parents.
Useful ideas start with a clearer picture of your own spending.
Explore your reports

