Spreadsheets

Wedding budget template in Excel with vendor advance and balance

A wedding budget template in Excel for India with vendor quote, advance, balance due, due date, who paid and a total-versus-budget check with contingency.

Editorial illustration for Wedding budget template in Excel with vendor advance and balance

A wedding budget sheet should list every vendor with the quote, the advance paid, the balance still due, the due date and the family member who paid. Add a contingency line and one cell that compares the total with the overall budget. Then you can see on any day what is committed, what is paid and what falls due next.

What columns should the vendor table have?

  • A Item: venue, catering, decor, photography, clothes, jewellery, gifts, ritual items.
  • B Vendor name, C Quote, D Advance paid.
  • E Balance due: =C2-D2
  • F Due date of the next payment, G Paid by (which family member), H Status.
  • H2: =IF(E2<=0,"Settled",IF(F2<TODAY(),"Overdue","Pending"))

Add a column for the quote reference or invoice number, and keep a folder with each vendor's written quote and receipts. Notes about verbal promises belong in the sheet too, with the date.

Can you show an example with numbers?

Say a family sets an overall budget of ₹20,00,000 and has these hypothetical vendor quotes:

ItemQuote (₹)Advance paid (₹)Balance due (₹)
Venue4,50,0001,50,0003,00,000
Catering5,20,0002,00,0003,20,000
Decor1,80,00050,0001,30,000
Photography1,20,00040,00080,000
Clothes2,00,0002,00,0000
Jewellery3,00,0003,00,0000
Gifts80,000080,000
Ritual items40,00020,00020,000
Total18,90,0009,60,0009,30,000

The totals are =SUM(C2:C9), =SUM(D2:D9) and =SUM(E2:E9) for quote, advance and balance, once the vendor table sits in rows 2 to 9 with the vendor name in column B. Check: 18,90,000 minus 9,60,000 leaves ₹9,30,000 still to pay.

How do I add a contingency and compare with the budget?

Put the overall budget in a cell, say K1, and a contingency percentage in K2. Choose a percentage you are comfortable with; 10 percent is only an example. Then:

  • K3, contingency amount: =K2*SUM(C2:C9). At 10 percent of 18,90,000, that is ₹1,89,000.
  • K4, planned total: =SUM(C2:C9)+K3, which gives ₹20,79,000.
  • K5, verdict: =IF(K4>K1,"Over by ₹"&TEXT(K4-K1,"#,##0"),"Within budget"). Here 20,79,000 minus 20,00,000 is ₹79,000 over.

For a quick visual, add a bar: =REPT("|",MIN(30,ROUND(K4/K1*30,0))). A longer bar than 30 characters is capped, so a bar at full length means you have reached or passed the budget. Alternatively, use Conditional Formatting, Data Bars on the total cell. TEXT with "#,##0" shows western commas in the message; format the cells themselves with the English (India) locale to see lakh-style grouping.

How do I know who paid and what is due next?

Use SUMIFS to total advances by payer, for example =SUMIFS($D$2:$D$9,$G$2:$G$9,"Father"). Do this for each person who contributes. For the next payment date, use =MINIFS($F$2:$F$9,$E$2:$E$9,">0"). It returns the earliest due date among vendors that still have a balance. MINIFS needs Excel 2019, Excel 365 or Google Sheets.

Which costs do families forget?

The vendor list covers the big names, but small items add up. Add rows for the ones your family's customs need, for example:

  • Tailoring alterations and last-minute stitching.
  • Travel and stay for relatives and for the vendors' teams.
  • Return gifts, sweets boxes and invitation printing.
  • Tips and thank-you envelopes for helpers on the day.
  • Extra hours charged by decor or sound if a ceremony runs late.

You will not need every row. The point is to decide once, early, so the contingency is for surprises rather than for things you knew about.

A last checklist

  1. Every vendor has a written quote and a receipt for each payment.
  2. Cash payments are noted with date, person and amount.
  3. Balance due is matched against the vendor's own statement before the final payment.
  4. Gifts received are recorded separately from spending.

After the wedding, SpendixAI can bring in the bank and card statements, attach receipts to the matching transactions and show spending by category, a handy cross-check on this sheet.

SPENDIXAI JOURNAL

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

Explore your reports