A shagun ledger in Excel is a simple list with a row for every gift given or received: the family, the occasion, the date, the amount or the gift, and a note. A lookup formula then shows what you gave that family the last time, so the amount you pick next is a choice, not a guess. The sheet makes no claim about what is customary.
What columns should the ledger have?
| Column | Heading | Example |
|---|---|---|
| A | Family | Mehta family |
| B | Occasion | Wedding, engagement, naming ceremony |
| C | Date | 12-Feb-2023 |
| D | Gave (₹) | 2,100; blank when you received |
| E | Received (₹) | 1,100; blank when you gave |
| F | Gift in kind | Silver coin, saree, utensil set |
| G | Estimated value (₹) | Only if you want totals to include it |
| H | Notes | Who attended, where the event was |
One row per event per direction. If you gave and also received on the same occasion, make two rows. Writing names consistently matters: pick Mehta family or Mehta, and do not switch, because the lookup matches text exactly.
How do I look up what we gave last time?
Add a small lookup area at the top right. Type a family name in J1. Then:
- Date of the last gift to them: =MAXIFS($C$2:$C$500, $A$2:$A$500, J1, $D$2:$D$500, ">0")
- Amount on that date: =SUMIFS($D$2:$D$500, $A$2:$A$500, J1, $C$2:$C$500, J2), where J2 holds the date from the line above
- Total ever given to them: =SUMIFS($D$2:$D$500, $A$2:$A$500, J1)
- Total ever received from them: =SUMIFS($E$2:$E$500, $A$2:$A$500, J1)
MAXIFS works in Excel 2019 and later, Excel 365 and Google Sheets. In an older Excel version, sort the sheet by date and read the last row for that family instead.
What does a worked example look like?
Say you gave the Mehta family ₹2,100 at a wedding in March 2023 and received ₹1,100 from them at your cousin's engagement in 2024. A new wedding invitation arrives from them. You type Mehta family in J1.
| Lookup | Result |
|---|---|
| Last gift date | March 2023 |
| Amount on that date | ₹2,100 |
| Total ever given | ₹2,100 |
| Total ever received | ₹1,100 |
This does not tell you what to give. It tells you what happened, and the decision stays yours, informed by your budget that month and your relationship with the family.
How do I handle gifts that are not cash?
Write the item in column F and, if you want totals to include it, an estimated value in G. Keep the estimate honest: what you paid, not what it might be worth. Then your total can use =SUMIFS(D)+SUMIFS(G) if you like, or you can keep money and gifts separate. Whichever you choose, say so in a note at the top.
Which extra tabs are useful before a season of weddings?
- A budget tab: a total you are comfortable with for the season, and the running sum of what you have already given.
- A calendar tab: date, event, travel needed, outfit sorted or not.
- A return gifts tab: what you gave in return at your own events, with the guest list so no family is missed.
Sum your season's gifts with =SUMIFS($D$2:$D$500, $C$2:$C$500, ">="&DATE(2026,10,1), $C$2:$C$500, "<="&DATE(2027,3,31)). Change the dates to your own season.
Can an app help with the money side?
UPI shagun and card payments for gifts already appear in your statement. SpendixAI can import it, and cash given at the event can be added by hand in a batch, so the season's total is one report. The family and occasion detail stays in this sheet.
Before the next invitation
- Type the family name in the lookup cell and read the result
- Check the season budget cell
- Enter the gift the same day it is given
- Note any gift in kind with a rough value
Useful ideas start with a clearer picture of your own spending.
Explore your reports


