Health and family

Lena-dena ledger: the family's two-way record of wedding money

A two-way lena-dena register for what your family gave at others' weddings and received at its own, with sample rows and formulas to see who is open.

Editorial illustration for Lena-dena ledger: the family's two-way record of wedding money

A lena-dena register is a two-way record: what your family gave at other people's functions, and what it received at its own. Kept in one place, it lets you see at a glance what a household gave you before you choose what to give back, so reciprocity is a matter of looking at the page rather than relying on an elder's memory. Treat it as a reminder, not a scoreboard.

What goes into each row

One row per gift, whichever way it travelled. The columns that earn their place are listed below.

  • Date and function, for example Cousin's wedding or Griha pravesh.
  • Family or person, written the same way every time, because the totals depend on it.
  • Direction: Given or Received.
  • Amount in rupees, entered exactly as it was, including the extra rupee.
  • Mode: cash, UPI, or kind such as sweets, a saree or a utensil set.
  • Note: who handed it over, what was said, anything to remember.

Sample rows for three families across two weddings

Hypothetical figures. The first wedding is your own son's, in February 2025; the second is the Verma family's daughter's, in November 2026.

DateFunctionFamilyDirectionAmountNote
Feb 2025Our son's weddingVerma familyReceived₹5,100Cash envelope
Feb 2025Our son's weddingRao familyReceived₹2,100UPI, name in remark
Feb 2025Our son's weddingKhan familyReceived₹1,100Cash, with a sweets box
Nov 2026Verma daughter's weddingVerma familyGiven₹5,100Handed to the father
Nov 2026Rao nephew's engagementRao familyGiven₹2,100Sent by UPI

Read down by family. The Vermas gave ₹5,100 and received ₹5,100, so that account is even. The Raos are also even at ₹2,100 each way. The Khans gave ₹1,100 and nothing has gone back yet, which is a prompt for their next function and not a debt.

How do I see who is open in a sheet?

Put the columns in a sheet as A Date, B Function, C Family, D Direction, E Amount, and keep a list of family names down column H starting at H2. Then, in I2, take what you received from that family and subtract what you gave. This works in Excel and Google Sheets.

  • Net for the family in H2: =SUMIFS($E$2:$E$500,$C$2:$C$500,H2,$D$2:$D$500,"Received")-SUMIFS($E$2:$E$500,$C$2:$C$500,H2,$D$2:$D$500,"Given")
  • Total you have received overall: =SUMIFS($E$2:$E$500,$D$2:$D$500,"Received")
  • Total you have given overall: =SUMIFS($E$2:$E$500,$D$2:$D$500,"Given")

A positive net means the family has given you more than you have returned; a negative net means the opposite. With the sample above, the Khans show 1,100 and the other two show 0.

Should I match every amount exactly?

No. Matching is a starting point. Closeness, the circumstances of the host, and how recently you were in touch all properly change the figure. Many families give a little more when returning, or the same in a different form. The register only stops you from giving noticeably less by accident, or from forgetting a family altogether.

Keeping it going

  • Fill the Received rows within a day or two of your own function, while the envelopes and names are fresh.
  • Add the Given row on the day you attend, not at the end of the season.
  • Record the same family name the same way each time, including the spelling.
  • Back the sheet up where a second family member can open it.

Money you give is spending and can also sit with your other expenses, for example in SpendixAI, while money received is not an expense and belongs only in this register.

SPENDIXAI JOURNAL

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

Explore your reports