Wedding Planning 101: The Complete 12-Month Spreadsheet System

Twelve months out from your wedding, every couple has the same thought: where do we even start?

You've got a date. Maybe a venue. A growing list of decisions about flowers, photographers, food, and seating. A few Pinterest boards. Three group texts. A Notes app entry that started as a guest list and is now... whatever it is now.

The problem isn't motivation. It's that wedding planning has too many moving parts to live in your head — and the free PDFs floating around online are checklists in disguise. They tell you what to do (book a photographer at 9 months) but not how to track the 14 vendors you're choosing between, the 165 guests with RSVPs in different states, or the day-of schedule the coordinator needs at the rehearsal.

This guide walks you through the system we built for our wedding planner spreadsheet — a system you can replicate yourself, or just buy as a finished workbook.

The five-system framework

Every wedding workbook needs five interconnected systems. Most planners stop after one or two.

1. Master timeline — 100+ tasks, scaffolded across 12 months down to day-of and the month after.
2. Vendor tracker — every contract, deposit, balance, due date, and contact in one place.
3. Guest list + RSVPs — drives meal counts and the seating chart automatically.
4. Seating chart — pulls table assignments from the guest list. Over-capacity flags red.
5. Day-of schedule — minute-by-minute, hand to your coordinator at rehearsal.

If you're missing any of these, you're going to lose hours re-entering data across three apps.

System 1 — The 12-month timeline

Most "wedding checklists" you find online are alphabetized lists. That's useless. You need tasks bucketed by phase, with status, owner, target date, and a "days remaining" formula that flags what's slipping.

The 11 phases

Every wedding fits into roughly the same arc:

• 12+ Months Out — venue, photographer, videographer, save-the-date list
• 9 Months — save-the-dates sent, caterer, DJ/band, bridal party
• 6 Months — invitations ordered, hair/makeup booked, officiant chosen
• 4 Months — menu finalized, cake, florist, rentals
• 2 Months — final fittings, vows drafted, marriage license research
• 1 Month — final headcount to caterer, seating chart final, vendor tips ready
• 2 Weeks — RSVP follow-ups, hair/makeup trial, dress alterations done
• Week of — rehearsal walkthrough, marriage license, welcome bags
• Day Before — rehearsal dinner, lay out outfit, sleep early
• Wedding Day — the minute-by-minute (more on this below)
• After — thank-you cards, dress preservation, change names

Why "days remaining" matters more than dates

Anyone can write down "send save-the-dates by Dec 14." The discipline is knowing you're 47 days out and the task is still Not Started. A =Target_Date - TODAY() formula plus conditional formatting (red when negative, amber when ≤14 days) is the difference between a pretty PDF and a working system.

System 2 — The vendor tracker

You're going to evaluate 30+ vendors over 12 months. You'll book 12-18 of them. Each booking has a contract, a deposit, a balance due, and a final due date. Most couples track this in their email inbox. Don't.

A vendor row should capture:

• Vendor name + category (Photography, Catering, DJ, Florist, etc.)
• Primary contact name + phone + email
• Contract signed? (Yes / No dropdown)
• Total cost
• Deposit paid (auto-computes balance due)
• Final due date (formula tells you days remaining)
• Deliverables in plain English ("8 hours coverage + 2 albums + 200 prints")

The two automation rules that matter:

• If contract not signed AND days until due ≤ 30: flag amber (start chasing)
• If contract not signed AND days until due ≤ 7: flag red (this is now an emergency)

That single conditional rule has saved more weddings than any planner.

System 3 — Guest list + RSVPs (the hub)

The guest list is where every other system pulls from. Get this right and seating, meal counts, and final headcount become formulas. Get it wrong and you'll be triple-entering data across three apps.

Required columns

• First name, last name, side (Partner 1 / Partner 2 / Both)
• RSVP status (Pending / Yes / No / Maybe)
• Plus-one count (0/1/2)
• Plus-one name + meal
• Dietary / allergies
• Address (mailing)
• Save-the-Date sent? Invitation sent?
• RSVP date received
• Table number
• Notes ("college roommate," "Mom's family")

The two formulas that earn this sheet

1. Auto meal counts at the bottom: =COUNTIF(H2:H300,"Beef")+COUNTIF(I2:I300,"Beef") — counts both the guest's meal AND their plus-one's meal in one number you give the caterer.

2. Pending RSVP older than 21 days = red: =AND($E2="Pending",$M2="Yes",TODAY()-$N2>21) — the formula that tells you exactly who to call this week.

System 4 — Seating chart that follows the guest list

This is where most spreadsheets fall apart. People build a separate seating tab, hand-type names from the guest list, then forget to update one when someone changes their RSVP. Two weeks before the wedding, the seating chart and the guest list disagree and you don't know which one is right.

The fix: the seating chart aggregates from the guest list automatically. You only ever update the guest list.

For each table 1-30:

• Capacity (default from Settings)
• Assigned: =COUNTIF('Guest List'!O:O, B2) — counts how many guests have this table number
• Open Seats: =Capacity - Assigned
• Status: =IF(Assigned > Capacity, "Over", IF(Assigned = Capacity, "Full", "Open"))

Conditional formatting paints over-capacity tables red. Now you can experiment with seating arrangements live, watching the colors change as you reassign guests in the guest list.

System 5 — The day-of schedule

The single document your coordinator wants is the minute-by-minute schedule. The single document most couples never finish is the minute-by-minute schedule.

Pre-build it 4-6 weeks out. The pre-seeded version we ship looks like:

• 8:30 AM — Coordinator arrives at bridal suite
• 9:00 AM — Hair and makeup begin
• 11:30 AM — Photographer arrives, detail shots
• 1:30 PM — Partner 1 dress on
• 2:00 PM — First look
• 3:30 PM — Guests arrive
• 4:00 PM — Ceremony begins
• 4:30 PM — Recessional + cocktail hour
• 5:30 PM — Guests invited to reception
• 5:45 PM — Grand entrance + first dance
• 6:10 PM — Dinner served
• 7:00 PM — Toasts
• 7:45 PM — Cake cutting
• 8:00 PM — Open dancing
• 11:30 PM — Last dance
• 11:45 PM — Sparkler send-off

Adjust the times to your venue's actual flow. The structure stays sound across 95% of weddings.

When the spreadsheet stops being useful

There's a point — usually 2-3 weeks out — where you stop adding new data and start running the workbook daily. The Dashboard shows:

• Days to wedding
• Tasks done %
• Guests confirmed (with meal breakdown)
• Vendors booked
• Top 5 overdue tasks
• Vendors with payments due in the next 30 days

That's your morning standup with yourself. Five minutes a day for the final month. Anything red, you act on. Anything amber, you note. Anything green, you trust.

The companion: a separate budget tracker

We deliberately built our Wedding Planner and Wedding Budget Planner as two separate products. The wedding planner handles tasks, vendors, RSVPs, seating, and timing. The wedding budget planner handles categories, estimated vs. actual, payment schedules, and the honeymoon. Buying both gives you the complete system; buying just one gives you that half done well.

Most couples want the planner first (you can budget without it) and add the budget tracker once the bookings start.

Getting started this week

If you're starting from zero:

1. Today: Open a fresh spreadsheet. Type your wedding date in cell C7. Build a 5-row Guest List with your closest people just to feel the system work.
2. This weekend: Add your top 5 vendors you're already considering. Assign target booking dates.
3. Next weekend: Sit down with your partner. Walk through the 11 phases. Argue about timeline.
4. Month 1: Get the timeline 80% populated. Don't worry about perfection.
5. Month 2 onward: Run the Dashboard daily. Act on amber. Sleep through green.

That's the whole system. Twelve months from now, you'll either have built it yourself or used ours. Either way, you'll have made a thousand small decisions in one workbook instead of three group texts.