ShaadiBudget Pro — an Indian wedding budget dashboard showing category totals, committed amounts and a planned-versus-committed chart
Digitalaikart Original · Spreadsheet System

ShaadiBudget Pro

The Indian wedding budget, vendor and payment tracker — planned, committed and paid, kept apart

One Excel workbook, nine linked sheets, no macros and nothing to install. You plan the wedding by function and by category, log every vendor you speak to with their quote and GST, record every advance and instalment against its due date, count plates from your guest list, keep a shagun register and work a checklist whose dates are calculated backwards from the wedding day. The Dashboard adds it up: what you planned, what you have committed, what has actually been paid, what is still owed, what is due in the next fortnight and what is already late — plus six health checks that tell you when a number is missing instead of quietly showing zero. It runs in Microsoft Excel and in Google Sheets, on a laptop or in the phone app, and it is one payment with no subscription. Every formula is a plain SUMIFS, COUNTIFS or EDATE, so you can open it, read it, change it and keep it.

9
Linked sheets
15
Expense categories
₹0
Per month
Excel
+ Google Sheets
Get ShaadiBudget Pro — ₹249 →

The Problem It Solves

A wedding is forty vendors, six functions, three opinions and one number everybody is quietly guessing at

📒

The budget lives in five places at once

A notebook for the caterer, a WhatsApp forward for the decorator, a diary for the venue, one Excel sheet someone's cousin started, and a number in everybody's head. Nobody can answer "how much have we spent" without an hour of phone calls.

🧾

The quote and the bill are never the same number

The caterer quotes ₹1,150 a plate, then adds GST. The decorator's quote excludes lighting. The photographer's travel is "extra". By the time you compare two vendors you are comparing two different sums, and the cheaper one is not always cheaper.

📅

Advances get paid twice, balances get forgotten

Forty thousand by UPI in April, fifty thousand by cheque in July, and nobody remembers which instalment that was. The vendor calls in November for a balance you thought was settled in September.

🍽️

The plate count is a guess made twice

250 invited, 180 "definitely coming", 60 maybe, and a caterer who needs a number nine days before the function. Then the Jain and non-veg counts get worked out on the back of an envelope, at the counter, on the day.

What It Does

Three numbers kept apart on purpose: planned, committed and paid

🧮 Planned, committed and paid are separate

Planned is what the Budget Plan sheet says you intend to spend. Committed is what a vendor has actually quoted and you have booked. Paid is what has left your bank. The Dashboard shows all three, plus what is still owed — so an "on budget" wedding that is short of cash this month is visible before it happens.

🎪 Budget by function, not just by category

Roka, engagement, haldi, mehendi, sangeet, wedding, reception — up to ten functions, each with its own date, venue, expected guests and plate rates. Every expense line and every vendor sits against a function, so the Dashboard shows what each function actually costs.

🧾 Quotes compared with GST and extras

Type the quote, the GST percentage and any other charges; the workbook shows the tax-inclusive quote and the true total cost beside it. Two vendors quoted differently finally become two comparable numbers, and the booked amount is what feeds every total.

💰 Every instalment with its due date

One row per advance or balance, with the mode and a reference. Mark Paid = Yes when the money goes out. Unpaid rows past their date turn red, rows due within fourteen days turn amber, and "paid so far" per vendor is calculated from that flag alone — not typed twice.

🍽️ Plates counted from your RSVP

One row per family with veg, Jain and non-veg headcounts. The Dashboard takes the smaller of the function's expected guests and the confirmed people, splits it in your confirmed guest mix, and prices it at that function's plate rates. You are not catering for 250 when 84 have confirmed.

🎁 Shagun register, both sides

Who gave what, on which function, cash or UPI, and whether the thank-you went out. Totals split by bride side and groom side, so the "who gave what" conversation has a number behind it instead of a memory.

✅ Checklist dated from the wedding

Forty tasks with "months before" — book the venue at nine months, print the cards at four, confirm the rooming list at one. The do-by date is calculated from the wedding date on Setup, so changing the date moves every task with it, and anything past its date and not done is flagged LATE.

🚨 Six health checks, not silent zeros

The Dashboard tells you when the budget is empty, when a vendor is booked in a category with nothing planned, when a function has guests but no plate rate, and when a booked vendor has no payment logged. A spreadsheet that says "check this" is worth more than one that says ₹0.

📊 One chart the family can read

Planned against committed, category by category, on the Dashboard. It prints with everything else on one A4 page for the meeting where the budget gets decided.

What's Inside the Download

Five files, one ZIP — the blank workbook, a filled example, the guide, a quick start and the licence

ShaadiBudget-Pro-Template.xlsx

The blank workbook, ready for your wedding. Nine visible sheets plus a hidden list sheet that feeds the dropdowns. 160 budget lines, 70 vendors, 160 payments, 220 guest families, 120 shagun entries, 80 checklist rows, 10 functions.

ShaadiBudget-Pro-Worked-Example.xlsx

The same workbook filled with a complete fictional wedding — Meera and Aarav, Jaipur, 12 December 2026, ₹45 lakh, 40 tasks, 18 vendors, 30 payments, 22 guest families. Every name and amount is invented; it exists so you can see what "finished" looks like before you type anything.

GUIDE.pdf — five pages

Sheet by sheet, the rules the workbook follows, the exact catering arithmetic, Excel and Google Sheets steps, printing, sharing, seven common "is this a bug?" cases with fixes, and the India notes on GST, TDS and the cash limit.

START-HERE.txt — one page

The two-minute version: what to fill first, in what order, and the three habits that keep the totals correct.

LICENSE.txt — plain terms

One wedding, unlimited edits, unlimited family members on the shared sheet, unlimited printing. No resale, no republishing, no running other people's weddings on one copy.

Preview

Real screenshots of the worked example — nothing staged

The ShaadiBudget Pro dashboard: wedding date, days to go, total budget, committed and paid amounts, a category table with planned, committed, variance and status, a by-function table, guest and catering totals, payments due, shagun and checklist counts, health checks and a planned-versus-committed bar chart
The Dashboard, printed from the worked example — every figure on it is calculated from the other sheets.
The Setup sheet: wedding date, city, total budget, three contribution lines, a functions table with per-plate rates for veg, Jain and non-veg, and fifteen expense categories with a suggested percentage split and the planned amount beside it
Setup — the wedding date, the money, the functions and the plate rates. Everything else reads from here.

File Format & Compatibility

One workbook, two ecosystems, no macros and no password

ItemFormatOpens in
The template and the example.xlsx (Office Open XML), formulas only — no macros, no add-ins, no protected sheetsMicrosoft Excel 2016 and later, Microsoft 365, Google Sheets, LibreOffice Calc
Google SheetsUpload the .xlsx to Drive, then File → Save as Google SheetsEvery formula is SUM, SUMIF, SUMIFS, COUNTIF, COUNTIFS, SUMPRODUCT, MIN, MAX, ROUND, EDATE or TEXT — all present in Sheets under the same names
PhoneThe Google Sheets app, or the Excel appEvery sheet is editable; the layout stacks and the tables scroll sideways
PrintingA4, portrait for the Dashboard and Checklist, landscape for the long tables, each sheet already set to fit to widthAny printer, or File → Download → PDF in Google Sheets
The guidePDF, five pages, A4Any PDF reader
Apple NumbersNumbers can open .xlsx filesMost formulas survive; the chart and some number formats may not. We have not tested Numbers, so treat Excel, Google Sheets or LibreOffice as the supported route

Internet is needed once, to download the ZIP. After that the file is yours — nothing is uploaded, there is no account, and no one can see your vendors or your guest list.

How to Use It

Six steps, about fifteen minutes to a working budget

  1. Open the template in Excel, or upload it to Google Drive and open it with Google Sheets. There is nothing to install and nothing is locked.
  2. Fill Setup. Wedding date, city, total budget, what each side is contributing, then your functions with a per-plate rate for veg, Jain and non-veg. Fifteen expense categories come with a suggested split you can move.
  3. Build the Budget Plan. One row per expense line — function, category, item, planned amount. The header total and the Dashboard update as you type.
  4. Add your vendors. Quote, GST %, other charges, and the amount you finally booked. The status column keeps track of who is an enquiry, who has quoted and who is booked.
  5. Log the payments. Every advance and instalment with its due date and mode. Change Paid? to Yes when the money leaves — that single flag drives paid-so-far, balance due and the overdue list.
  6. Keep the guests, shagun and checklist current, then open the Dashboard. If the six health checks say OK, the workbook is wired correctly and you can stop maintaining it and start booking things.

Type in the pale gold cells; the blue-grey cells are formulas. Use the dropdown values for category, function, side and status — free text is allowed, but a near-match will not be added to the right total.

Who It's For

Written for the person who ends up holding the spreadsheet

👰

The couple planning it themselves

You have a number, a date and a hundred decisions. This keeps every quote and every payment in one place so the number stops moving without you knowing.

👨‍👩‍👧

Two families splitting the cost

Contribution lines on Setup, a bride-side and groom-side split in the shagun register, and a committed-versus-budget figure that both sides can read off the same page.

🧑‍💼

The cousin running all of it

You are the coordinator, you have forty tabs open, and you need one screen you can send to a relative who asks "kitna kharcha hua". That is the Dashboard.

🏛️

Small venues and wedding planners

Useful as a per-wedding cost sheet — one file per wedding, as the licence asks. Not a booking system, not a CRM, and it does not pretend to be one.

Get Instant Access

One-time payment · Lifetime access · No subscription, no per-wedding fee, no expiry

Buy With Confidence

The same terms as every Digitalaikart tool

🔐

Secure payment

Razorpay handles the payment. Card and UPI details are never seen by this site.

⬇️

Instant download

The ZIP is on the thank-you page the moment the payment succeeds, and the link is yours to keep.

🔁

Replaced free

If a file is missing or will not open, email within 7 days and a working copy is sent.

📄

Licence in plain English

One wedding, unlimited edits and printing, everyone in the family on the same sheet. LICENSE.txt is inside the ZIP, not buried on a web page.

Frequently Asked Questions

Is this an ebook?

No. You get two working spreadsheets — a blank one and a filled example — plus a guide, a quick start and a licence. Nothing to read before you can use it: open the workbook and start typing.

Do I need Excel, or does Google Sheets work?

Both work, and so does LibreOffice Calc. In Google Sheets, upload the file to Drive and use File → Save as Google Sheets. Every formula in the workbook exists in Sheets with the same name, so nothing needs rewriting. There are no macros, so nothing gets blocked either.

What exactly is the difference between planned, committed and paid?

Planned is your intention, from the Budget Plan sheet. Committed is what a vendor has quoted and you have booked, from the Vendors sheet. Paid is money that has actually left, from the Payments sheet where Paid = Yes. The Dashboard shows all three and the gaps between them, which is how you see an overspend before the bill arrives.

Does it handle GST on vendor quotes?

It multiplies the quote by whatever GST percentage you type, and adds any other charges, so you can compare two vendors on the same basis. It does not know the correct rate for a given service, and it does not calculate your GST liability or file anything — that is between you, the vendor and your CA.

How does the plate estimate work?

For each function it takes the expected guests from Setup and the confirmed people from the Guests sheet and uses the smaller of the two. It splits those plates in your confirmed veg / Jain / non-veg mix and prices them at that function's plate rates. It is a sanity check against a caterer's quotation, not a replacement for it.

Can my family edit it too?

Yes. In Google Sheets, share the file with them as Editors — the licence covers everyone working on the same wedding. On a phone, the Google Sheets app can edit any cell, so a payment status can be updated at the vendor's counter.

How many functions, vendors and guests can it hold?

Ten functions, 160 budget lines, 70 vendors, 160 payments, 220 guest families, 120 shagun entries and 80 checklist rows. That covers a large Indian wedding comfortably; if you genuinely need more rows, insert them above the total row and the formulas follow.

Does it calculate TDS or file my taxes?

No. It is a planning aid. TDS under sections 194C and 194J, the ₹2 lakh cash-receipt restriction under 269ST, and anything you need to file are yours to confirm with a chartered accountant. The guide explains where each of these shows up in a wedding budget.

Will it tell me what my wedding should cost?

No, and be careful of anything that claims to. Costs depend on your city, the season, the guest count and the menu. Every amount in the worked example is fictional and labelled as such. What the workbook does is hold the numbers you bring back from real quotations.

Can I use it for more than one wedding?

The licence covers one wedding, with unlimited edits and printing. If you are a planner running several weddings, buy one copy per wedding you run — that keeps the terms simple and the file honest.

What if a formula does not behave?

Page 4 of the guide lists the seven things that usually look like a bug — a category typed instead of picked, a vendor name spelled two ways, a date typed as text — with the fix for each. If it is genuinely broken, email within 7 days and a working copy or a fix comes back.

How do I get the files after payment?

After a successful payment you land on a thank-you page with a download button for the ZIP. The ZIP holds both workbooks, the guide, the quick start and the licence.

Can I get a refund?

Digital products are non-refundable once downloaded. If a file is missing, corrupted or will not open, email lonefaisal977@gmail.com within 7 days and it will be replaced.

Pairs Well With

CashFlow Compass — 13-Week Cash Flow Forecast

If the wedding is being paid for out of a business, see which month the vendor instalments collide with salaries. ₹249.

BizCalc Pro — Indian Loan & EMI Calculator

Work out what a wedding loan actually costs per month before you sign for one. ₹199.

SocialKit India — 48 Ready-to-Post Social Graphics

Save-the-date and function cards, made offline in your browser. ₹249.