What to Include in a Wedding Budget Spreadsheet

Wedding budgets rarely blow up on the venue. The venue is the number everyone stares at for months — it gets negotiated, compared, and agonised over. Budgets blow up on the twenty things nobody wrote down: the cake cutting fee, the second shoot, the alterations, the postage, the cash you need in envelopes on the morning.

A good spreadsheet doesn't make anything cheaper. What it does is stop the slow leak of unlisted costs, and tell you not just what things cost but when the money leaves your account. Here's everything that belongs in one.

The five columns every line needs

Start with the skeleton. Every single row — whether it's a $12,000 venue or a $40 guest book — gets these five fields.

Keep estimated and actual in separate columns permanently. The temptation is to overwrite the estimate once you book — resist it. The gap between the two is the single most useful piece of information in the file, because it tells you how wrong your guesses tend to be, which tells you how wrong the rows you haven't booked yet probably are.

The four columns most people forget

A total is only half a budget. These four turn it into something you can actually manage.

• Who's paying. Us, her parents, his parents, a specific relative. Tag every row. It makes contributions concrete instead of vague, and it means nobody discovers in month eight that two people both assumed the other was covering the bar.
• Deposit paid. How much you've already handed over, and the date you paid it. Deposit sizes vary widely between vendors and contracts, so take the figure from the contract in front of you rather than assuming a standard percentage.
• Balance due. Actual cost minus deposit paid, as a formula. Sum this column and you have the number that matters most in the final month.
• Balance due date. The date in the contract, not "before the wedding". This is the column that becomes your payment timeline.

The full category checklist

Work through this list and create a row for anything that applies. It's faster to delete rows you don't need than to remember a category at 11pm four months in.

The events either side of the wedding

These get planned separately and paid for out of the same money, which is exactly how they end up untracked. Give each one its own category in the same file: engagement party, bridal shower or bachelor/bachelorette weekend (at least the portion you're covering), rehearsal dinner, next-day brunch, and the honeymoon.

The honeymoon in particular deserves a subtotal of its own. Flights and hotels usually want deposits on a completely different schedule from your vendors, and you want to be able to see the wedding-day total on its own without it.

The line items that ambush people

These are the costs that get left out, and the reason is structural: none of them appear on the headline figure you compared vendors on, so they never make it into the version of the budget you built while choosing. Add a row for each one that applies before you get a single quote.

• Service charge and administration fees. Often quoted separately from the per-head price, and often a percentage of the whole food-and-drink bill. On a large catering line this can be one of the biggest single "surprises" in the file.
• Corkage, cake cutting, and plating fees. Charged per bottle or per guest. Bringing your own wine is only cheaper after corkage is subtracted — do that maths before you commit.
• Overtime. Photography, band, venue, and bar all have end times. Budget one extra hour of the ones you'd most regret losing, and treat it as spent.
• Delivery, setup, and collection. Rentals, flowers, and cake almost always have a delivery charge, and sometimes a next-morning collection charge too.
• Taxes. Whether they're already inside a quoted figure varies by vendor and by where you are. Ask, and note the answer in the row — never assume a quote is tax-inclusive.
• Gratuities. Some are contractual, some are customary, and they add up across a dozen vendors. Work them out as a real line rather than a vague "we'll sort it on the day" with our Wedding Vendor Tip Calculator, and note which ones need cash in envelopes.
• Postage. Square or oversized invitations often cost more to send, and you're paying twice if you include RSVP envelopes.
• Alterations and trials. Multiple fittings, plus hair and makeup trials — often charged on top of the wedding-day price rather than included in it. Ask which it is when you book, and put the answer in the row.
• Insurance. Wedding insurance, and any liability cover your venue requires you to hold.
• The marriage licence. Small, and forgotten with impressive consistency.

Estimating the bar line properly

Drinks are the line people guess hardest at, because it's the only major category where the quantity depends on human behaviour rather than a headcount multiplied by a price.

Estimate the volume before you estimate the cost. Work out roughly how many bottles of wine, beer, and spirits a group your size drinks over the hours you're serving — the Wedding Alcohol Calculator does this from guest count, event length, and drink mix — and then price that list at what you'd actually pay. Then add mixers, ice, glass hire, and bartender time as separate rows, because they're separate invoices.

One honest trade-off worth understanding: a venue's per-head open bar package is more expensive per drink than supplying your own, but it's a fixed number you can put in the spreadsheet in January and never revisit. Supplying your own is usually cheaper and always more work, and it moves the risk onto you — over-order and you've spent money on wine nobody drank, under-order and someone is driving to a store during the reception. Neither answer is wrong; just make sure the row reflects the one you chose, including corkage.

Setting the totals

Once the rows exist, you need starting numbers for them. Percentage allocations are the fastest way to get there. Our Wedding Budget Calculator splits a total using one common set of planning conventions — venue 35%, catering 20%, photography 11%, attire 6%, rings 6%, videography 5%, music 4%, flowers 3.5%, décor 3%, transport 2%, hair and beauty 1.75%, stationery 1.25%, gifts and favours 1%, and a half-percent buffer. Venue and catering together take a little over half; everything else divides what's left.

Treat those percentages as a way to fill a blank page, not as a finding about what weddings cost. They're a convention, not a measurement of your wedding, and plenty of perfectly normal weddings sit nowhere near them. If you're marrying somewhere the venue is free but every table, glass and toilet has to be trucked in, your rentals line will dwarf the allocation and your venue line will be near zero. If photography is the thing you'll care about in twenty years, move money into it deliberately and take it from a category you've decided matters less. The split's only job is to give you a starting number for every row — the moment you hold three real quotes, your own numbers beat any benchmark, and you should overwrite the percentages without hesitation.

Build in a contingency and protect it

Add a contingency row of 5–10% of your total. Use the lower end if most of your big costs are already contracted at fixed prices; use the higher end if you're early in planning, your guest list is still moving, or your plans depend on weather.

Overruns don't usually come from one disaster. They come from a guest count that creeps up by eleven, an upgrade you agreed to in a tasting, an extra hour of photography, and a delivery charge nobody mentioned. Each is small; together they're the contingency.

Two rules make it work. First, it's a real line with real money behind it, not the gap between your budget and what you could theoretically afford. Second, when you spend from it, record it — reduce the contingency row explicitly rather than quietly raising an estimate. A contingency you can't see shrinking isn't doing its job.

A payment timeline, not just a total

The question that wakes people up isn't "what does this cost?" — it's "what do we owe in March?" Your balance-due-date column answers it.

1. Add a "month due" formula next to the due date so every balance is stamped with a month.
2. Build a small table listing each month from now until a month after the wedding.
3. Sum the balances due in each month.
4. Put your expected savings contributions and any contributions from family in a second column beside it.
5. Add a running cumulative balance across the months.

What you're looking for is any month where the running balance goes negative. That's the month you can't pay for, and you've found it while you still have options — shift a payment date with a vendor, move a discretionary purchase later, or save harder in the months before it. Vendors commonly set final balances somewhere in the last month or two before the date, so that's where a crunch tends to land, but don't assume it: read the due date out of each contract and let the table tell you where the pressure actually is.

Keeping it accurate

A wedding budget doesn't fail because the structure was wrong. It fails because nobody opened it for six weeks.

Book fifteen minutes a week, same slot, both of you. Enter anything paid since last time, update any estimate where you've received a real quote, check the variance column for rows drifting in the wrong direction, and look at the next two months on the payment timeline. Fifteen minutes is genuinely enough once the structure exists.

When a quote changes — and they do, because guest counts move and packages get adjusted — update the estimate, don't paper over it. If the new number is higher, decide immediately where it comes from: the contingency, or a reduction somewhere else. Writing "+$450, from contingency" in a notes column takes five seconds and is the difference between a budget that reflects reality and one you stop trusting in month four.