Wedding Budget Spreadsheet: 80 Rows That Cover the Whole Day

Quick answer. A working wedding budget spreadsheet has 80 plus rows covering venue, catering, attire, photography, music, florals, stationery, transportation, accommodations, decor, ceremony items, gifts, taxes, gratuities, and a contingency reserve. Each row tracks budget, deposit paid, balance due, and final cost. Our Wedding Budget Excel template ships with the rows pre-populated and a dashboard that updates as you fill in actuals.

The average US wedding cost in 2026 is around $33,000 (based on aggregated industry surveys, with significant regional variation). Whether your wedding costs $8,000 or $80,000, the trick is the same: 80 plus discrete items, each with its own deposit timing and final invoice. A spreadsheet that catches all of them prevents the surprise items that blow budgets.

What a wedding budget spreadsheet needs to do

Three jobs.

1. List every category and item before you book anything. Forgetting alterations or gratuities at planning time means absorbing them later as overage.
2. Track deposits separately from final cost. Most vendors take 25 to 50 percent at booking, with the balance due 1 to 4 weeks before the event. Cash flow planning matters.
3. Show real-time variance against the total budget. As you book vendors, the dashboard tells you whether you’re on track or whether something has to give.

A spreadsheet does these three jobs better than a wedding-planning app for one reason: you can see the entire budget on one screen.

The 80 rows, by category

Here’s the standard category breakdown. Counts are typical; some weddings will have more or fewer items per category.

That’s 85 rows; most weddings end up with 70 to 100 line items.

Add a contingency line at the bottom: 5 to 10 percent of total budget. Things will come up. Budget for them up front so they don’t feel like overruns.

The columns each row needs

Eight columns covers the work.

Eight columns scaled across 80 rows is a lot of cells, but the data is light per cell and updates infrequently.

A worked example

Couple budget: $28,000 wedding, 130 guests, October 2026.

Major line items:

The dashboard immediately shows the budget is over by $7,000. The conversation that follows: cut catering ($90/person to $70/person = $2,600), cut photographer hours (8 to 6 = $800), cut florals ($1,800 to $1,000 = $800), cut bar ($2,400 to $1,500 = $900), absorb $1,900 with the contingency. New total: $30,000. Still $2,000 over but workable.

That’s the value of laying it all out before booking anything.

Deposit and balance timing

Most vendors take a deposit at booking and the balance 1 to 4 weeks before the wedding. The spreadsheet’s deposit and balance-due-date columns help you forecast cash flow.

For an October wedding, typical timing:

• Deposits: January through March (when bookings happen).
• Balances: August through early October.

If you have $9,000 in deposits to pay across January and February, that’s a real cash flow event for most couples. Knowing it 4 months ahead lets you budget cash reserves accordingly.

Where the spreadsheet helps that an app doesn’t

Wedding planning apps (Zola, The Knot, Wedding Wire) all offer budget tools. The spreadsheet has three advantages.

You can see all 80 line items on one screen. Most apps require navigation between categories. The spreadsheet shows the whole thing at once, which is necessary for the trade-off conversations.

You own the data. No platform lock-in. If Zola changes their pricing or shuts down a feature, the spreadsheet doesn’t care.

Custom categories without limits. Apps have fixed category lists. A friend recently spent $400 on custom rubber stamps for the bar napkins; that doesn’t fit in any app’s pre-set categories. In a spreadsheet, it’s just another row.

The apps have advantages too: vendor directories, RSVP integration, public website builder. Use both if it helps; the spreadsheet handles the budget specifically.

What I’d add after a year of using one

Three small additions that turned out to matter.

A who-pays-what column. When parents are contributing to specific items (catering covered by bride’s parents, photographer covered by groom’s parents), tracking it row-by-row prevents end-of-night reconciliation surprises.

A rehearsal-dinner section. Often forgotten in the main wedding budget; can run $1,000 to $5,000 separately. Add as its own mini-section so it doesn’t sneak in as an overage.

A “what we cut” log. As budget conversations happen and you decide to cut things, log them. Useful for two reasons: avoid re-adding accidentally, and post-wedding reflection on what mattered vs what didn’t.

How to use the template

The Wedding Budget Excel template is $12 and includes:

• 85 pre-populated rows across the 12 standard categories
• Budget, quote, deposit, balance, final cost columns
• Dashboard with category totals, budget vs actual, deposit calendar
• Contingency calculator
• Per-guest cost calculation (helpful for catering negotiation)
• Excel format that opens in Google Sheets, Numbers, LibreOffice

If you’d rather build it, the structure above is reproducible from scratch. The template saves a few hours and ensures you don’t forget categories.

Get the template

• Monthly Budget Template — Planned-vs-actual monthly budget with a dashboard and category targets.
• Annual Budget Template — 12-month grid with seasonal expense planning and category rollups.
• Annual Budget Template — 12-month grid with seasonal expense planning and category rollups.
• Wedding Budget Ultimate ($19) — 150+ pre-built line items, deposit/balance calendar, guest-count cost splits, and vendor tracker.

Related

• Free Monthly Budget Template for Google Sheets
• How to Plan a Yearly Budget in Google Sheets