How to Make a Wedding Budget Spreadsheet That Keeps You on Track
A wedding budget spreadsheet works when it does three things: holds your total number, splits it into categories that match how weddings really spend, and tracks what you've paid vs. what you still owe on every vendor. Do those three and you'll never be blindsided by a balance. Here's how to build it in Google Sheets — free, editable, and yours.
Step 1: Start from your total, not the categories
Decide the all-in number first and let the categories fit inside it. If you start by pricing a dress, a venue, and a florist, you'll add your way to a total that's already too high. Put the total in one cell at the top; every category below is a slice of it.
Step 2: Use category percentages that match real weddings
These planning benchmarks get you a realistic starting split — adjust to your priorities:
| Category | Typical share |
|---|---|
| Venue & catering | ~40–50% |
| Photography & video | ~10–12% |
| Attire & beauty | ~8–10% |
| Flowers & décor | ~8–10% |
| Music / entertainment | ~7–10% |
| Stationery, rings, favors, misc. | the rest |
Add a contingency line of 5–10%. Something always comes up, and an unfunded surprise is what turns a budget from a plan into a source of stress.
Step 3: Track deposit, balance, and due date per vendor
This is the column set that actually prevents overspending. For each vendor: Estimated, Actual, Deposit paid, Balance due, and Due date. A wedding is paid in installments over months — a total-only budget hides the balances stacking up behind the deposits.
- Remaining budget:
=Total - SUM(Actual column)at the top, so it's the first thing you see. - Still owed:
=SUM(Balance due column)— the number that matters in the final month.
Step 4: Make overspending impossible to miss
Add conditional formatting so any category where Actual > Estimated turns red. Your eye catches the problem the moment it happens, while you can still trade a splurge in one category for a cut in another.
The budget that works is the one you update the day you book a vendor — not the one you reconstruct the week of the wedding.
Want budget, guest list, vendor payments and the day-of timeline in one file? That's the Wedding & Event Planner Toolkit. And before you build your list, read the wedding guest list spreadsheet guide.