The average wedding budget gets revised 20+ times between booking the venue and the final headcount. Most couples track it in a notes app, three spreadsheets and an increasingly anxious group chat — then discover in month nine that they’ve overspent photography by $1,800.
A single well-built spreadsheet fixes this. Here’s the structure professional planners use, and how to build it in Google Sheets or Excel.
Why wedding budgets break
Three failure modes, all fixable with structure:
- Budget and actuals live in different places — nobody knows the real number.
- Vendor payments are tracked in email — deposits get forgotten and charged twice.
- Guest count changes silently — catering costs move but the budget doesn’t.
The fix: one workbook where vendors feed the budget, and the budget feeds the dashboard.
The five tabs
1. Budget — 16 categories, actuals included
List your categories with a budget column and an actual column that pulls from the Vendors tab automatically:
=SUMIFS(Vendors!$E:$E,Vendors!$B:$B,A2)Categories: Venue, Catering, Photography, Videography, Music/DJ, Flowers, Attire, Rings, Invitations, Cake, Transportation, Accommodation, Hair & Makeup, Favors, Honeymoon, Contingency.
Add the three columns that make it useful:
- Difference:
=B2-C2(positive = under budget) - % used:
=IFERROR(C2/B2,0) - Status:
=IF(C2>B2,"Over budget",IF(E2>0.9,"Watch","On track"))
Conditional formatting on the status column (red / amber / green) and you can see the whole wedding’s health in one glance.
Always keep a Contingency line. 10% of total budget. Every wedding finds a use for it.
2. Vendors — the payment schedule
One row per vendor:
| Vendor | Category | Total cost | Deposit paid | Final paid | Balance | Status |
|---|
- Balance:
=E2-F2-G2 - Status:
=IF(H2<=0,"Paid in full",IF(F2+G2>0,"Partially paid","Unpaid"))
This is the tab that prevents double-charging: the balance column is the single source of truth for what’s still owed, and it feeds the Budget tab’s actuals. Deposit due dates and final due dates as separate columns keep the cash-flow calendar honest.
3. Guest List — RSVP tracking
Columns: Guest name, Side, Email, Phone, RSVP, Plus-one, Meal, Table, Notes.
Dropdowns on RSVP (Invited / Attending / Declined / No response), Plus-one (Yes/No) and Meal (Chicken / Fish / Vegetarian / Kids meal). Then the counts that matter, anywhere on the sheet:
=COUNTIF(E:E,"Attending")
=COUNTIF(E:E,"Invited")+COUNTIF(E:E,"No response")Conditional formatting: attending green, invited amber, declined red. When your caterer asks for the headcount, you read two numbers instead of counting rows.
4. Seating Plan — automatic table grouping
List tables 1–12 in column A with seat capacity in column C. In column B, one array formula pulls every guest assigned to that table:
=TEXTJOIN(", ",TRUE,IF(Guests!$H:$H=A2,Guests!$A:$A,""))Assign table numbers on the Guest List tab; the seating plan writes itself. A status formula flags the problem before it becomes a problem:
=IF(B2="","Empty",IF(LEN(B2)-LEN(SUBSTITUTE(B2,",",""))+1>C2,"Over capacity","OK"))(Works automatically in Google Sheets and Excel 365 — in older Excel, click the cell and press Ctrl+Shift+Enter.)
5. Dashboard — the one page you check weekly
- Days to go:
=wedding_date - TODAY() - Guests invited / attending / awaiting RSVP: the COUNTIFs above
- Budget used:
=Budget!C_total/Budget!B_total - Outstanding vendor payments:
=Vendors!H_total - Next checklist items: the first five unchecked rows from the countdown list
One glance answers “are we on track?” — the question both partners ask, and the one that starts arguments when neither can answer it.
The 12-month countdown
Budget and guests are the math; the checklist is the calendar. The standard sequence, from 12 months out:
- 12 months: set date and budget, book venue
- 10 months: photographer, videographer, caterer, DJ
- 8 months: save-the-dates
- 6 months: invitations, guest accommodation
- 3 months: formal invitations, rings
- 6 weeks: chase RSVPs, finalize seating
- 4 weeks: final headcount to caterer
- 1 week: vendor tips, honeymoon packing
- Wedding day: get married
Tick each off with a status column — same dropdown discipline as everything else.
Three rules that keep it accurate
- One number, one home. Vendor totals live only in Vendors; the Budget tab references them. Never type the same number twice.
- Log payments the day they happen. A deposit “you’ll add later” is a double-charge waiting to happen.
- Re-baseline monthly. Compare actuals to budget, move the contingency if needed, and note what changed. The budget is a living document, not a contract.
Skip the build
All five tabs — budget with auto-actuals, vendor payment tracker, 80-row guest list with dropdowns, self-writing seating plan, countdown dashboard and the 12-month checklist — ship pre-built in our Wedding & Event Planner, with a sample wedding filled in so you can see it working. It also adapts to any milestone event: engagements, birthdays, reunions, corporate events.
The spreadsheet isn’t the plan — it’s the mirror. Update it honestly and it will tell you the truth while there’s still time to act.
Related reading: