Quick answer: An Indian wedding budget planner in Excel lists every expense by function (Roka, Sagan, Mehndi, Haldi, Wedding, Reception) and by category (venue, catering, decor, photography, clothing, jewellery and so on). For each item it tracks the estimate, the final quote, the advance paid and the balance due, so you always know how much of the budget is committed and which vendor needs paying next. The free Xplorexcel Wedding Planner adds a guest list with headcount for each function, a shagun register and a countdown checklist, all in one workbook.
Key takeaways
- A countdown dashboard with days to go, budget used, balance still to pay vendors, guests expected and shagun received.
- A vendor payment tracker with advance paid, balance and next due date, overdue alerts, and a “next payments” list.
- A guest list for up to 300 families with RSVP. It works out the headcount for each function, which is the number your caterer needs.
- A shagun register to record every gift and shagun envelope, with a thank-you tracker.
- A 28-task checklist dated automatically from your wedding date.
How to plan an Indian wedding budget
- Fix one total figure first. Agree it with both families before you book anything.
- List every function separately. Roka, sagan, mehndi and reception add up fast, and they are often left out of the first plan.
- Estimate before you meet vendors, then replace each estimate with the final quote as you book. The gap between the two is where budgets get away from you.
- Track advances and due dates, not just totals. Most vendors take 30–50% in advance and the rest in the week of the wedding, so the cash crunch comes all at once.
- Keep 5–10% for contingency. Extra guests, last-minute decor changes and tips always come up.
Typical share of an Indian wedding budget
| Category | Typical share | Notes |
|---|---|---|
| Catering | 25–30% | Per-plate rate × headcount, for each function |
| Venue | 15–25% | Often bundled with catering at banquet halls |
| Clothing & jewellery | 15–25% | Bridal lehenga, sherwani, family outfits, bridal set |
| Decor & flowers | 7–10% | Stage, mandap, entry and mehndi decor |
| Photography & video | 5–8% | Pre-wedding shoot, drone and album add to the cost |
| Music, makeup, invitations, travel, gifts | 10–15% | Small items that add up |
| Contingency | 5–10% | Keep it, and don’t spend it early |
These are rough guides. Your own split depends on the city, the number of guests and which functions you hold.
Wedding guest list with RSVP and headcount
Enter one row per family or group: the side (bride or groom), the group (family, relatives, friends, office, neighbours), the city and phone number. Mark Y under each function they are invited to, enter the number of adults and kids, and track the RSVP, whether the card has been sent and whether they need a place to stay.
The headcount table then shows, for each function, how many people are invited, how many have confirmed, how many are expected (everyone who hasn’t said no), and how many replies are pending. Give your caterer the expected number plus a 5–10% buffer.
Shagun register (gift list)
Many families keep a notebook of shagun and gifts received, so they can say thank you and return the gesture at the giver’s own family functions. This sheet records the date, the giver, the relation, the function, the type (cash, UPI, gold or silver, gift item) and the amount or value. It totals everything by function and by type, and highlights anyone who hasn’t been thanked yet.
Wedding checklist (countdown)
The checklist starts six months before the wedding and runs until the marriage registration afterwards. Each task has a number of days before the wedding, and its due date is worked out from your wedding date. Change the date and every deadline moves with it. Tasks show as Done, Overdue, Next 2 weeks or Upcoming.
How to use the wedding planner (5 steps)
- Setup: Enter the bride’s and groom’s names, the wedding date, the city and the total budget.
- Budget: List every expense with its estimate. As you book vendors, add the final cost, the amount paid and the next due date.
- Guest List: Add each family, mark the functions they’re invited to, and update the RSVPs.
- Shagun Register: Note gifts and shagun as they come in.
- Checklist: Follow the countdown. The dashboard shows everything at a glance.
Download the Wedding Planner in Excel (Free)
File: Indian Wedding Planner and Budget Tracker 1.0 · Format: .xlsx · Macros: none · Price: free.
Get updates and new free templates
Your download below doesn’t need this. Leave your WhatsApp number or email and I’ll send you fixes for this file and new free templates. No spam, unsubscribe anytime.
Tip: save the file to Google Drive and share it with family members, so the whole family can update the guest list and payments from their phones in Google Sheets.
Frequently asked questions
How do I make a wedding budget in Excel?
Make one row per expense with columns for function, category, vendor, estimated cost, final cost, amount paid and balance. Total the final costs and compare them with your budget. This template also summarises spending by category and function and lists the next payments due.
What is the biggest expense in an Indian wedding?
Catering is usually the biggest single expense, because it is the per-plate rate multiplied by the guest count for every function. The venue and the bride’s clothing and jewellery come next. Cutting the guest list is the most effective way to cut the budget.
How many guests should I tell the caterer?
Give the number of guests expected at that function (everyone invited except those who have said no), plus a 5–10% buffer. The Guest List sheet calculates this for each function.
What is a shagun register?
A record of the shagun (cash in envelopes) and gifts received at the wedding functions, with who gave what. Families use it to send thank-yous and to give a similar shagun at the giver’s own family functions.
Can both families use the same file?
Yes. Upload it to Google Drive and open it in Google Sheets, then share it with edit access. It has no macros, so everything works there.
Can I use it for an engagement or a smaller function?
Yes. Leave out the functions you don’t need and change the checklist tasks. The function and category lists are on a hidden Lists sheet that you can unhide and edit.
More free personal finance templates from Xplorexcel
Budget shares are rough guides only. Last reviewed: October 2026.
