Stackrows
Wedding Planning Invoice Template
A
B
C
D
E
F
G
1
Category
Budget
Actual
2
3
4
5
6
7
8
Client Invoice
Invoice Log
Payment Schedule
Vendor Pass-Throughs
Client & Wedding Directory

Wedding Planning Invoice Template

Invoice clients by milestone, track payment schedules across all active weddings, and reconcile vendor pass-throughs — in one Excel template built around how wedding planning businesses actually bill.

$29Save 4+ hours vs. building a wedding planning billing tracker from scratch
Instant download after purchase
Works in Excel & Google Sheets
30-day money-back guarantee
.xlsx240 KB5 sheetsUpdated 2026-03-22

What's Inside This Wedding Planning Invoice Template

This template includes 5 worksheets, each designed for a specific part of your wedding planning financial workflow:

1

Client Invoice

The client-facing invoice sheet you'll customize and send for each billing milestone. Header fields cover your business name, your client's names and mailing address, the wedding date, and the venue. Line items are pre-organized to match how wedding planners actually bill: a planning and coordination fee (with fields for flat fee, percentage of budget, or hourly), assistant coordinator charges, add-on services (rehearsal dinner coordination, extra planning hours, travel fees), vendor pass-throughs, and a deposit deduction line that reduces the balance due automatically. The balance due calculates from total charges minus any retainer or prior payments on file. Formatted for PDF export with payment instructions and due date fields at the bottom.

2

Invoice Log

A running record of every invoice you've issued across all clients and weddings. Each row captures the invoice number, couple names, wedding date, invoice date, due date, invoice total, amount collected, and outstanding balance. Payment status (Retainer Received, Second Payment Received, Paid in Full, Overdue) uses a dropdown so you can update it in seconds after each payment. Summary rows at the top show total revenue booked for the year, total collected, and total outstanding — giving you an instant read on your accounts receivable without pulling individual invoices.

3

Payment Schedule

A milestone-by-milestone payment tracker for every active wedding. Each wedding gets three rows — Retainer (typically 25-33% of total fee, due at signing), Second Payment (typically 33-40%, due 60-90 days before the wedding), and Final Balance (remaining amount, due 14-30 days before the wedding). Enter the couple's names, wedding date, total contract value, and each milestone due date, and the amounts calculate automatically based on the percentage splits you set. Overdue milestones are flagged in red so you can follow up immediately. Planners managing 15-25 weddings per year use this sheet as their cash flow planner — you can see at a glance which payments are due in the next 30 days.

4

Vendor Pass-Throughs

A per-event tracker for all vendor costs that flow through your business to the client. For each vendor — venue, catering, florals, photography, DJ, hair and makeup, transportation, cake, officiant, rentals — log the vendor's invoice amount, your markup percentage, and the amount billed to the client. The client billing amount and your gross margin on pass-throughs calculate automatically. A payment status column lets you track whether you've paid the vendor and whether the client has paid you for that item. Use this sheet to ensure your vendor billing reconciles to your client invoices and to see your total pass-through margin per wedding.

5

Client & Wedding Directory

A master list of all clients, active and past, with one row per wedding. Fields include couple names, wedding date, venue, city, package tier (Day-Of Coordinator, Partial Planning, Full-Service), agreed total fee, fee structure (flat fee, percentage of budget, or hourly rate), total wedding budget managed, and booking date. This sheet serves as your business CRM and auto-fills client dropdown lists on the Invoice and Payment Schedule sheets so you're not retyping names across worksheets. At year-end, this directory gives you a complete record of revenue, package mix, and average contract value — the data you need to set rates for the following season.

Wedding Planning Invoice Template Features

  • Client invoice with milestone payment deduction and automatic balance-due calculation
  • Invoice log with payment status tracking and total outstanding AR summary
  • Payment schedule with three-milestone structure (retainer, second payment, final balance) and overdue flags
  • Vendor pass-through tracker with markup percentage and client billing amount calculations
  • Client and wedding directory with package tier and fee structure fields for annual business review
  • Built around Day-Of, Partial Planning, and Full-Service fee structures — flat fee, % of budget, or hourly

How to Use This Wedding Planning Invoice Spreadsheet

Start by setting up the Client & Wedding Directory with all your active bookings. Enter each couple's names, wedding date, venue, package tier, agreed fee, and fee structure. This takes 10-15 minutes for your current client roster and becomes the data source for the rest of the template — client dropdowns on the Invoice and Payment Schedule sheets auto-populate from this list, so you're not retyping names every time you create a new invoice.

For each billing milestone, open the Client Invoice sheet, select the couple from the dropdown, and fill in the invoice date and due date. The line items are pre-built for the most common wedding planner charges: planning fee (enter your flat fee, percentage, or hourly total), assistant coordinator hours and rate, add-ons like rehearsal dinner coordination or travel fees, and any vendor pass-throughs. Enter any prior deposit received in the deduction line, and the balance due calculates automatically. Export to PDF, send to the client, and log the invoice in the Invoice Log with a status of Outstanding.

Update the Invoice Log every time a payment arrives — change the status to Retainer Received, Second Payment Received, or Paid in Full, and enter the amount collected. Run through the Payment Schedule monthly during busy season to see which milestones are coming due in the next 30 days and which are overdue. Wedding planners who invoice on schedule and follow up on overdue milestones within 3 days of the due date rarely deal with collection problems — clients who fall behind early in the planning process sometimes drop off entirely, and catching that early protects both your cash flow and your calendar.

15 minutes from download to your first client invoice

Download the template, add your active weddings, and start sending milestone invoices with a spreadsheet built for how wedding planners actually bill.

Why Wedding Planners Need a Dedicated Invoice Template

Wedding planning is a service business with a billing structure unlike most other professional services. You're collecting money across a 12-18 month planning window, managing vendor contracts on behalf of clients, and sometimes taking on significant financial exposure between when you pay vendors and when you collect from clients. A generic invoice template doesn't account for milestone billing, vendor pass-throughs, or the payment schedule complexity that comes with coordinating 15-25 weddings per year. Without a structured billing system, it's easy to lose track of which clients owe what and when — and a missed final balance two weeks before the wedding date is a crisis, not an inconvenience.

The standard financial benchmarks for a wedding planning business: gross margins of 55-70% for coordination-only services (your main direct cost is assistant labor at $25-50/hour per assistant on the wedding day); net margins of 15-25% for solo operators after marketing, software, and insurance; a retainer of 25-33% of total fee collected at contract signing; and a booking conversion rate of 25-40% from consultation to signed contract (top planners hit 50%+). Vendor pass-through markups of 10-20% are standard practice and should always be disclosed in your contract. Accounts receivable past 30 days should stay below 5% of annual revenue — wedding clients who haven't paid their final balance two weeks out need a direct conversation, not another invoice email.

The workflow that keeps billing clean: issue each milestone invoice 7-10 days before it's due so clients have time to process payment, log every payment in the Invoice Log the same day it arrives, and review the Payment Schedule weekly during your busy season. If a client misses a payment, follow up within 3 days — most late payments are administrative oversights, not refusals, and a quick message resolves them. For vendor pass-throughs, pay vendors only after you've collected from the client or confirmed the payment is in process. The Vendor Pass-Throughs sheet in this template tracks both sides so you can see at a glance whether you're fronting any vendor costs and how much margin you're earning on pass-through items.

Wedding Planning Industry at a Glance

Financial templates built for wedding planners and coordinators — from day-of coordinators to full-service agencies. Pre-loaded with fee structures, payment milestone tracking, and vendor pass-through categories.

Revenue Drivers

  • Full-service planning fees
  • Day-of coordination packages
  • Vendor referral commissions
  • Vendor pass-through markups
  • Add-on services (rehearsal dinner, elopements)

Key Cost Categories

  • Assistant coordinator wages
  • Contractor/sub-planner fees
  • Vendor pass-through costs
  • Marketing (Knot/WeddingWire listings)
  • Planning software subscriptions
  • Professional liability insurance
  • Transportation and mileage

Typical Margins

Gross: 55-70% · Net: 15-25%

Seasonality

Peak weddings in May-June (spring) and September-October (fall). January-February slowest for events but highest for new bookings from holiday-engaged couples.

Key Performance Indicators

Revenue per weddingBooking conversion rateOutstanding AR as % of revenueGross margin per eventReferral rate (% of bookings from past clients)

Wedding Planning Invoice Template FAQ

Wedding Planning Invoice Template

$29