Life events

Wedding budget template with Indian function categories

A wedding budget template for India with function-wise categories and the columns and formulas for quote, advance, balance and owner, in Excel or Sheets.

Editorial illustration for Wedding budget template with Indian function categories

A good Indian wedding budget sheet is organised by function and by cost line, with one row per vendor and columns for quote, advance, amount paid, balance and owner. Build it once with the layout below and every conversation about money becomes a look at one row rather than a hunt through chats.

Which categories belong in an Indian wedding sheet?

Start with the functions your families actually hold, then add cross-cutting lines. A typical set is below; delete what you do not host and add your own, since customs vary widely.

  • Pre-wedding: roka or engagement, ring ceremony, pre-wedding shoot.
  • Mehendi and haldi.
  • Sangeet.
  • Baraat and pheras, including muhurtam timing, pandit and rituals.
  • Reception.
  • Cross-cutting: venue, food, decor, photography and video, outfits, jewellery, invitations, return gifts, travel and stay, music, makeup, transport, miscellaneous.

What columns should each row have?

ColumnHeadingWhat goes in it
AFunctionSangeet, Reception, and so on
BItemDecor, Caterer, Pandit
CVendorName and phone
DQuoteAgreed amount
EAdvanceFirst amount paid
FPaid so farTotal paid including advance
GBalanceFormula
HOwnerWho pays: Bride side, Groom side, Joint
IDue dateWhen the next payment falls

Which formulas do I need?

These work in both Excel and Google Sheets. Put headers in row 1 and data from row 2 to row 200.

  • Balance for each row, in G2: =D2-F2
  • Total quoted: =SUM($D$2:$D$200)
  • Total paid: =SUM($F$2:$F$200)
  • Total outstanding: =SUM($G$2:$G$200)
  • Quoted total for one function, say Sangeet typed in cell L1: =SUMIFS($D$2:$D$200, $A$2:$A$200, $L$1)
  • Paid by one family, say Groom side typed in L2: =SUMIFS($F$2:$F$200, $H$2:$H$200, $L$2)

Argument order in SUMIFS is sum range first, then each criteria range followed by its criterion. Keep the ranges the same size or the result will show an error.

How do I see what is due soon?

Sort by the Due date column, or add a filter and choose the next fortnight. To total what is due by a date typed in L3, use =SUMIFS($G$2:$G$200, $I$2:$I$200, "<="&$L$3). The text in quotes with the ampersand makes the cell value part of the condition, which is how SUMIFS compares dates.

When does a sheet stop being enough?

A sheet is fine while one person types every payment. It gets harder when several relatives pay from different accounts and cash changes hands. At that point, importing the bank and card statements into an expense tracker such as SpendixAI, adding cash entries by hand, and keeping a category for each function can save retyping, while the sheet remains your quote-and-balance reference.

How do I stop the sheet from getting messy?

Three small rules keep it readable. Enter amounts as plain numbers with no rupee sign or commas typed in, and let the cell format display them. Use the same spelling for every function name, because SUMIFS treats Sangeet and Sangeet (with a trailing space) as different. And add a row for each vendor even when no money has moved, so the total quoted always reflects every commitment, not only the ones that have been paid.

If more than one person edits the sheet, agree who may change quotes and who may only add payments. A short Notes column beside each row records why a number moved.

Setting it up in an evening

  1. Create the nine columns above and freeze row 1.
  2. Enter every vendor you have spoken to, even if no payment is made yet.
  3. Add the formulas for balance and totals.
  4. Share the sheet with the people who will edit it and agree who types what.
  5. Review totals together once a week, and update the Due date column as you pay.
SPENDIXAI JOURNAL

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

Explore your reports