Wedding Budget Breakdown: What Each Category Costs, in Percent

"How much should a wedding cost" has no useful answer. "How much of our budget should go to each category" does. Below is a full breakdown on the sample wedding from a budget tracker: 30,000 for 120 guests, 60 cost lines in 12 categories, the default percentage for each one, what the couple actually planned, and the three formulas that turn a list of quotes into a split you can steer.

The default split, turned into money

The template keeps the percentages on its Lists tab, so you can change them; they must add up to 100%. On a 30,000 budget they give these targets, next to what the sample couple planned from their estimates, quotes and final invoices:

Two things stand out. The venue and the food together are 14,050, 47% of the budget, and they are the two lines the couple got right or better. And the overage is not one bad decision: it is five categories that each drifted by a few hundred.

Where the 754 came from

It started before any quote arrived. The 60 estimates on the Budget tab already add up to 30,500, so the plan was 500 over on day one. Quotes and final invoices then moved 24 lines, some up and some down, for another +254: venue rental 5,800 → 6,000, dinner for 120 guests 3,840 → 3,960, photographer 2,100 → 2,200, and in the other direction tables and linens 500 → 400, videographer 1,000 → 900.

The category that surprises people is Other: 10 small lines, 1,860 in total, 6.2% of the budget against a 4% default. Rehearsal dinner 500, officiant 400, vendor tips in cash 400, wedding insurance 150, dance lessons 100, guest book and signage 90, getting-ready snacks 80, marriage license 60, emergency kit 50, website domain 30. None of them is big; all of them are real, and most couples do not write them down until the week they are due.

Formula 1: planned cost per category

Every cost line has a category from a dropdown and a Planned cost that takes the final invoice if there is one, else the quote, else the estimate. One SUMIF per category adds them up, and the target is just the percentage times the budget:

Planned cost:  =SUMIF(Budget!$B$6:$B$125, B8, Budget!$H$6:$H$125)
Target:        =C8 * $C$5                 (default % × total budget)
Difference:    =E8 - D8                   (planned minus target)

For Photo & Video that is 2,200 + 900 + 400 + 300 = 3,800 planned against 10% × 30,000 = 3,000, a difference of +800.

Formula 2: a flag that ignores noise

A category 50 over its target is not a problem; one 800 over is. The flag uses a tolerance of 5% of the target, but never less than 0.5% of the whole budget (150 here), so small categories do not turn red over a few dollars:

=IF(ABS(G8) <= MAX(0.05*D8, 0.005*$C$5), "On track", IF(G8 > 0, "Over", "Under"))

That is why Transportation, 120 over a 600 target, is still On track, and Favors & Gifts, 154 over the same 600 target, is Over: the line is at 150. Flowers at +50 and Cake at +90 stay green too.

Formula 3: how many guests the budget covers

Only some costs grow with the guest count. On the Lists tab three categories are marked as per guest: Catering & Bar (6,600), Cake & Desserts (690) and Favors & Gifts (754). Together that is 8,044, or 67.03 per guest at 120 guests. Everything else, 22,710, is fixed: the venue, the photographer and the dress cost the same for 100 guests or 140.

Per-guest costs:   =SUMIF(D8:D27, "Yes", C8:C27)               → 8,044
Cost per guest:    =J8 / C5                                     → 67.03
Guests it covers:  =ROUNDDOWN((J12 - J9) / J10, 0)              → 108

(30,000 - 22,710) / 67.03 = 108.75, so the budget covers 108 guests with the current plan. The what-if table shows the same from the other side:

This is the useful part of the breakdown: every 10 guests move the total by 670.33. Cutting the guest list is one lever; cutting 754 of fixed costs (for example, the 800 Photo & Video overage) is another, and it keeps all 120 people.

Reading the split without panicking

The couple in the sample has paid 9,372 so far, 30% of the plan, and has 21,382 still to pay. Their families pledged 30,000 in total (15,000 from the couple's savings, 10,000 and 5,000 from the two sets of parents), so the funding gap is the same 754. That is a decision, not a crisis, and the split tells them where to make it:

• Accept a category that is over if another one is under. The venue freed 1,550; that is why a 2,314 overage in five categories only shows up as 754 in total.
• Look at Other first. Small lines are the easiest to trim, and the easiest to forget to add in the first place.
• Change the percentages if they do not fit your wedding. The defaults are a starting point; a backyard wedding moves venue money into rentals and flowers.

If you are also saving toward the date month by month, an annual budget for 2027 is where the wedding savings line lives next to everything else.

Skip the build

The three formulas above are the core of the Budget Split and Per Guest tabs. The tracker also logs payments against each line, flags deposits due in the next 30 days and tracks who pays what.

Wedding Budget Spreadsheet for Google Sheets and Excel

Type each cost once with its estimate, quote and final invoice, then log payments as you make them. Planned, paid, balance due and status per line, the split by category with Over / Under flags, cost per guest with a what-if, deposit due dates and contributions are calculated. Two files: Lite (4 tabs) and Full (12 tabs), sample data and blank copies.

Get the Wedding Budget Spreadsheet on Etsy →

See it work

FAQ