Spreadsheets

Shagun and gift ledger in Excel for weddings you attend

A shagun and gift ledger for Excel: record what you gave and received by family and occasion, with a lookup of what you gave last time.

Editorial illustration for Shagun and gift ledger in Excel for weddings you attend

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?

ColumnHeadingExample
AFamilyMehta family
BOccasionWedding, engagement, naming ceremony
CDate12-Feb-2023
DGave (₹)2,100; blank when you received
EReceived (₹)1,100; blank when you gave
FGift in kindSilver coin, saree, utensil set
GEstimated value (₹)Only if you want totals to include it
HNotesWho 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.

LookupResult
Last gift dateMarch 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

  1. Type the family name in the lookup cell and read the result
  2. Check the season budget cell
  3. Enter the gift the same day it is given
  4. Note any gift in kind with a rough value
SPENDIXAI JOURNAL

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

Explore your reports