Wedding planning has exactly two failure modes: forgetting something, and quietly blowing the budget. A spreadsheet fixes both — if it’s organized by month.
Here’s the checklist professional planners actually use, compressed into a spreadsheet-friendly format.
Why a spreadsheet beats a wedding-planning app
Wedding apps are pretty, but they charge a subscription, lock your data behind their columns, and can’t do the one thing that actually keeps a wedding on budget: compare plan vs. actual per category. A spreadsheet does all of it, costs nothing, and your partner can edit it at the same time.
The columns that make it work
Before the checklist, build the table it lives in. Seven columns is all you need:
| Column | What goes in it |
|---|---|
| Task | One action per row (“Book florist”) |
| Month | The target month — this is your grouping column |
| Owner | You, partner, or a parent — removes the “I thought you were doing that” fight |
| Due date | Real date, not “sometime in June” |
| Status | Not started / In progress / Done (dropdown) |
| Cost category | Which budget line it hits (venue, attire, flowers…) |
| Notes | Contact names, confirmation numbers, contract links |
Filter by Month to see what’s next; filter by Owner to see what’s yours.
12–10 months out
- Set the total budget and split it by category (venue, food, photo, attire, flowers, music, stationery, contingency)
- Draft the guest list with plus-ones
- Book venue and photographer (these sell out first)
- Pick the date
9–7 months out
- Book catering, music, and florist
- Choose attire; start alterations early
- Send save-the-dates
- Create a vendor tracker: contact, deposit paid, balance due, due date
6–4 months out
- Order invitations and stationery
- Plan the ceremony and reception layout
- Book transport and accommodation for out-of-town guests
- First dress fitting
3–2 months out
- Send invitations; set an RSVP deadline
- Finalize the menu and tasting
- Build the seating chart
- Write vows; apply for the marriage license
1 month out
- Confirm every vendor by phone (not email)
- Final headcount to caterer
- Break in the shoes; final fitting
- Prepare an emergency kit and a day-of timeline
The week of
- Rehearsal, then rehearse the timeline one more time
- Distribute the day-of timeline to the wedding party
- Pack: rings, vows, documents, emergency kit
- Hand the timeline to someone who isn’t you
The budget split that survives contact with reality
A starting allocation that works for most weddings (adjust to your priorities):
| Category | Share of budget |
|---|---|
| Venue + catering | 45–50% |
| Photography + video | 12–15% |
| Attire + beauty | 10–12% |
| Flowers + décor | 8–10% |
| Music + entertainment | 8–10% |
| Stationery + rings | 5% |
| Contingency | 5–10% |
The contingency line isn’t optional. Every wedding has at least one “we didn’t see that coming” cost — the couples who budget for it don’t have to cut something they love.
Three formulas that keep the year honest
- Vendor balance —
=Total - DepositPaidso you always know what’s still owed. - RSVP counter —
=COUNTIF(GuestList!E:E,"Attending")(plus one for “Invited” and “No response”) gives you a live headcount for the caterer. - Budget vs. actual —
=SUMIF(Transactions!Category, A2, Transactions!Amount)against each planned line. This is the number that tells you the truth in week six, not month ten.
If you want the formulas pre-built plus the guest list, seating chart and vendor payment schedules wired together, that’s exactly what our Wedding & Event Planner contains. And if you want the budget math in depth, read how to build a wedding budget spreadsheet that survives every edit.
The spreadsheet that holds it all
Each line above becomes a row with three columns: task, month, done. That single habit — one list, checked weekly — is why planners never forget things.
The couples who enjoy planning aren’t more organized — they just track things in one place instead of five.