Wedding Planning KPI Dashboard Template

Getting started takes about 20 minutes. Download the .xlsx file and open it in Excel or Google Sheets. Begin with the Bookings & Revenue sheet: enter each of your active contracts with the event date, package type, total contract value, and payment milestones. Then open the Accounts Receivable sheet and log which milestones have been collected and which are outstanding. Once those two sheets are populated, the KPI Overview dashboard will display your current average contract value, gross margin, and AR position automatically — giving you a useful baseline before you've touched anything else.

For ongoing use, update the dashboard in two rhythms. First, update the Accounts Receivable sheet every week or two as milestone payments come in — this is your most time-sensitive tracker and keeps you from losing track of what's overdue. Second, update the Booking Funnel sheet whenever you receive a new inquiry or sign a new contract, logging the source and outcome. Monthly, enter your profitability data for any events that completed during the period: total hours worked, direct costs incurred, and any add-on revenue. The Profitability per Event sheet is most useful when updated within a week of each event while your recollection of the work involved is fresh.

Before your slow-season planning review or your annual pricing evaluation, open the Monthly Trends sheet alongside the Profitability per Event sheet. The trend charts will show whether your average contract value is growing, whether your conversion rate has changed as you've moved up-market or shifted your marketing focus, and whether your gross margin is holding steady as your business grows. The profitability data by event is the single most useful input for deciding whether to raise your pricing, narrow your package offerings, or stop taking certain types of bookings — and it's the data that most wedding planners never systematically capture.

Wedding planning is a service business where the financials are structurally deceptive. Revenue looks strong when you have a full calendar, but the number that actually determines profitability is gross margin per event — contract value minus direct costs — and most planners don't calculate it rigorously until they realize they've had a six-figure year and very little to show for it. The industry's typical gross margins of 55–70% are achievable, but they require tracking what you actually spend on each event: assistant wages, sub-planner fees, vendor pass-throughs, and the hours you personally put in. Without a dashboard, the instinct is to focus on bookings, not on which bookings actually make money.

The KPIs that distinguish thriving wedding planning businesses from chronically overworked ones fall into three categories. Revenue quality — average contract value, gross margin per event, and effective hourly rate — tells you whether your pricing and scope are aligned with the work involved. Pipeline health — inquiry volume, booking conversion rate by source, and referral percentage — tells you whether your business development is working and which channels deserve more investment. Financial stability — accounts receivable as a percentage of booked revenue and milestone collection timeliness — tells you whether your cash position is as strong as your calendar looks. Referral rate deserves particular attention: planners who generate 50–70% of new bookings from past client referrals and vendor relationships operate with dramatically lower marketing costs and higher conversion rates than those dependent on directory listings.

The practical value of tracking these metrics monthly is that you make better decisions about pricing, capacity, and marketing before the decisions become urgent. A booking conversion rate that drops from 35% to 20% over two quarters is a signal worth investigating before you attribute it to market conditions — it might be your response time, your pricing relative to the market, or a change in the client profile coming through a particular lead source. An effective hourly rate below $50 on full-service weddings is a clear signal that your pricing, your scope management, or both need to change. This dashboard surfaces those signals while there's still time to act on them.