Wedding Planning Financial Model Template

Start with the Assumptions sheet — everything else flows from it. Enter your current service packages and their prices, your approximate number of weddings per year broken down by package type, and your booking conversion rate (the percentage of consultations that turn into signed contracts). If you're not sure about some numbers, use industry benchmarks as a starting point: a well-established planner typically books 1 in 3 consultations, charges $3,500–$7,000 for full-service, and $1,200–$2,500 for day-of coordination. The model will be rough on day one and get more accurate as you replace estimates with your actual figures.

The Booking Pipeline sheet is where the model earns its value for cash flow planning. Review the deposit timing logic — the default assumes a 30% retainer at booking and the balance due two weeks before the wedding date. Adjust these percentages and the average lead time (how many months in advance clients typically book) to match your actual contract terms. Once that's set, the Cash Flow sheet will show you when cash is actually coming in versus when events are happening — that January–February spike from holiday-engaged bookings, the pre-event cash investment in March–April, and the May–June collection of final balances. Wedding planners who understand this timing gap manage their operating cash reserves far better than those who only track revenue.

After you've worked through the income side, fill in the Expense Budget with your actual costs. Be thorough with the variable costs — mileage and transportation add up faster than most planners expect, and day-of supplies (printing, emergency kits, coordination tools) are consistently underestimated. Review the P&L Summary to check your gross margin against the 55–70% benchmark for the industry. If you're running lower, the expense detail will show you which cost categories are the culprit. Come back each quarter, enter your actuals, and use the variance to adjust the remaining months of the forecast.

Wedding planning businesses have a cash flow structure that's genuinely unusual: revenue is earned at the event, but cash comes in months — sometimes over a year — before and after. A planner who books a September wedding in January collects a retainer immediately, pays nothing back to the client if they deliver, and collects the final balance in August. On paper, the business looks seasonal and lumpy. In cash, January is often a great month even though no events are happening. Getting this timing right is the core financial challenge, and a spreadsheet that only shows accrual revenue completely misses it.

The two metrics that define a healthy wedding planning business are revenue per wedding and gross margin per event. Revenue per wedding is a function of your package structure and client segment — full-service planners in major markets often reach $6,000–$10,000+ per event, while day-of coordinators in smaller markets may average $1,200–$1,800. Gross margin per event is what's left after you subtract assistant wages, contractor fees, and direct event costs from your fee. For most planners, this runs 55–70%. If it's lower, either your pricing isn't covering your direct costs or you're spending more assistant hours than your packages account for. Both problems are solvable, but only if you're measuring them.

Capacity is the strategic constraint that most solo planners hit and don't plan around. At 20 weddings per year, a solo planner at $5,000 average fee is doing $100,000 in revenue. At 30 weddings, the math looks great on paper — $150,000 — but the operational reality is you can't do 30 weddings alone without burning out or degrading quality. The decision to hire a junior coordinator or associate planner is the first major financial inflection point: you add cost immediately, but it unlocks the capacity for another 10–15 events per year. The Capacity & Growth sheet in this model lets you run those numbers before you commit — you'll see exactly what booking volume you need at your price points to cover the hire and what it does to your net margin in years one through three.