Use Google Sheets for a wedding budget tracker, not Google Docs. A tracker has to add up vendor quotes, subtract what you have paid and show what is still due. Sheets does that with formulas. Docs is a word processor, so every total would be typed by hand and wrong by the second week.
Excel works just as well. If you already live in Google Drive, Sheets is the easier pick because the whole family can open the same link on their phones.
Where Docs still helps
Docs is fine for the parts of a wedding that are not numbers. The muhurat timeline, the day-of schedule, the list of who calls which relative, the pandit’s samagri list. Keep those in a Doc and share it with the family WhatsApp group.
The mistake is putting the budget in the same Doc. A table inside a Doc looks like a spreadsheet and behaves like a printout. Change one vendor quote and nothing else updates. Three weeks later nobody trusts the total.
What a wedding tracker needs
Four tabs, and not much more.
Function-wise budget. Indian weddings are several events, not one. Engagement or roka, haldi, mehendi, sangeet, the wedding day, reception, and travel and stay for family. Each gets its own budget line so you see which function is eating the money.
Vendor tracker. Every vendor with the total quote, the amount paid so far, the balance and the next due date. This is the tab that saves you. The venue, the caterer and the decorator each take an advance, and the balance is usually due a few days before the event.
Guest list. Bride side and groom side, people invited per family, RSVP status and a confirmed headcount. Catering is charged per plate, so headcount is money.
Shagun received. Who gave what, and whether the thank-you has gone out. Keep this tab private and do not share the whole file with it visible.
Example: a ₹15.3 lakh wedding
Take Divya and Karan in Jaipur, planning a wedding with seven functions. Their function budgets add up to ₹15.3 lakh: ₹1 lakh for the engagement, ₹80,000 each for haldi and mehendi, ₹2 lakh for sangeet, ₹7 lakh for the wedding day, ₹2.5 lakh for the reception and ₹1.2 lakh for family travel and stay.
They fund it with ₹8 lakh from savings, ₹5 lakh from the families and a ₹3 lakh personal loan. That is ₹16 lakh in total, so on paper there is a ₹70,000 cushion.
The loan is where people get surprised. At 11% over 36 months, ₹3 lakh is a ₹9,822 monthly EMI and about ₹53,578 of interest. The tracker works this out in the Wedding Budget tab, and you can check any other rate or tenure with the EMI calculator or the personal loan calculator. The 11% rate is an example. Use your bank’s quote.
Now the venue. Say the wedding-day banquet quote is ₹2.5 lakh and they paid ₹75,000 as an advance. The tracker shows ₹1.75 lakh still due, and when the due date is within a week the row turns red. Nobody is chasing a WhatsApp message from two months ago.
Pay attention to the “committed” column, not the “paid” column. A wedding budget that only tracks paid money looks fine until the balances land together in the last fortnight.
Free template
The file is a free .xlsx with the four wedding tabs and a Start Here sheet. It has example rows so you can see how it fills in. Overwrite them.
Getting it into Google Sheets
Go to Google Drive, choose New, then File upload, and pick the downloaded file. Right-click it and open with Google Sheets. Or open a blank sheet, go to File, Import, and upload.
Formulas, the dropdowns and the EMI calculation come across. Check the conditional formatting (the red due dates) after import, since Sheets sometimes handles those differently. Then use Share and give your partner and one parent edit access. Give everyone else view only, and keep the shagun tab to yourselves.
Mistakes that break the budget
Budgeting the wedding day and forgetting the functions around it. Haldi, mehendi and sangeet are where costs creep, because each has its own decor, food and outfits.
Counting the loan amount as free money and ignoring the EMI. If your income is ₹85,000 a month, a ₹9,822 EMI is about 11.6% of it for three years. Check that against everything else you already pay with the FOIR calculator before you borrow.
Using shagun to plan spending. It arrives after the event, so treat it as a repayment buffer, not part of the budget you spend from.
Monthly budget as well
A wedding sits on top of a normal household budget. The paid version of this planner adds a monthly income and expenses tracker, annual view, savings goals and an EMI tracker in the same file, with the wedding tabs included. It is a separate product and not required for the free tracker above.
This is a budgeting tool, not financial advice. All figures are examples. Replace them with your own quotes and rates.