Your total was never the problem. The deposit calendar was.
Almost every wedding budget spreadsheet you can download has the same shape: a list of categories, an estimated cost for each, and a grand total at the bottom.
That tells you whether the wedding is affordable in aggregate. It tells you nothing about whether you can afford April, which is the question that actually causes couples to reach for a credit card.
Weddings do not bill you once. They bill you in deposits at booking, progress payments at intervals, and a cluster of final balances in the last eight weeks. A couple can be perfectly on budget overall and still be unable to make a specific month, because three vendors happened to want their balance in the same fortnight.
So the spreadsheet worth building is a cash-flow tool, not a cost list. Same categories, completely different structure.
Estimated, contracted, deposited, paid: four columns, not one
The single biggest improvement is splitting the cost column into four. Every line item gets:
- Estimated — your guess before you have quotes. This is the number you plan with early and should stop looking at once you have a contract.
- Contracted — the actual all-in figure from a signed agreement, including service charge, gratuity and tax.
- Deposited — what you have already handed over.
- Outstanding — contracted minus deposited, which is the number that actually matters.
The gap between estimated and contracted is where wedding budgets die, and having both visible side by side is what makes the drift obvious while you can still do something about it.
Total the outstanding column. That figure — not your grand total — is what you still have to find, and it is the only number worth checking weekly.
The all-in trap
Put the all-in figure in the contracted column, never the headline quote. Catering quoted at $95 a head is frequently $125 once service charge, gratuity and tax are applied, and that difference across 110 guests is over three thousand dollars.
Ask every vendor the same question before you sign: what is the total I will actually pay, including everything. Then put that number in the sheet. Vendors will tell you honestly; they simply do not volunteer it.
Laying vendor payments against your actual paydays
This is the tab that makes the whole thing worth building.
One row per payment — not per vendor. If the photographer takes a deposit in March and a balance in September, that is two rows. Each row has the vendor, the amount, and the due date.
Then a monthly summary underneath: for each month between now and the wedding, total payments due, money you will have saved by then, and the running balance.
The moment you build this, one or two months will light up as impossible. That is the entire point, and it is far better to discover it eleven months out — when you can move a payment, renegotiate a schedule, or increase saving — than six weeks out when the only remaining lever is credit.
What to do about a month that does not work
Three options, in order of preference. Ask the vendor to split the payment; most will, and almost nobody asks. Move a discretionary booking later. Or increase the monthly saving figure now, while there are still enough months for a small increase to matter.
All three are available in month three. None of them is available in month eleven.
The tracker for who promised to contribute what
A separate small table, and it prevents a specific and unpleasant surprise.
Columns: who, how much, when it is available, and whether it has actually arrived. Nothing enters your available funds until the last column says yes.
Family contributions are frequently sincere and vague. "We'll cover the flowers" turns out to mean a figure someone had in mind that is not the figure you are now looking at. Recording the specific amount and the specific date converts a warm sentiment into a line you can plan with, and it surfaces the mismatch early enough to be a conversation rather than a crisis.
If a contribution has conditions attached — a guest list, a venue preference, a religious element — note that here too. It is the most useful column in the table and the one nobody writes down.
The categories worth having, and the ones that just create work
Wedding spreadsheets suffer from the same disease as household budgets: too much granularity, entered enthusiastically in month one and abandoned by month four.
Twelve line items is plenty. Venue. Catering. Bar. Photography. Video, if you are having it. Flowers. Music. Attire, both of you. Stationery. Rings. Transport. Everything else.
The temptation is to break flowers into bouquets, boutonnieres, centrepieces, ceremony arch and installations. Resist it, because your florist will quote you one number for the package and you will spend an hour allocating it across five rows for no benefit.
The exception is anything with a separate contract and a separate payment schedule. Those need their own row, because the payment tab depends on it.
The "everything else" row is not optional
Give it a real figure, not a placeholder. Ten percent of your working budget is a reasonable starting point, and it will be spent — on the shuttle you did not know you needed, the extra hour of hair and makeup, the corkage, the cake-cutting fee, the vendor meals.
An "everything else" row of $200 is a fiction that makes your total look better and helps with nothing.
Tips, service charges, and the tax nobody quotes you
Give these their own section rather than burying them inside each vendor line, because they are large, they are easy to forget, and they mostly fall due in the final week when your attention is elsewhere.
A separate block covering: service charges where not already contracted, gratuities for the vendors you intend to tip, sales tax where it is applied separately, delivery and setup fees, overtime rates if the evening runs long, and the cost of the marriage licence itself.
That last one is trivially small and universally forgotten, which is a decent summary of this whole category. Individually minor, collectively several thousand dollars.
Build an overtime line before you need it
Put an hour of venue overtime, an hour of photography and an hour of the band or DJ into the sheet as a contingency line from day one. Most weddings run long, the decision is made at 10pm by people who have been drinking, and the invoice arrives afterwards.
Budgeting for it in advance means the decision on the night is genuinely free. Not budgeting for it means it is still made, just worse.
The running variance number to check weekly
One cell, at the top, in a larger font: contracted total minus your ceiling.
That is the number. Not the estimate total, not the amount spent, not the percentage of budget used. Just how far above or below your agreed ceiling your actual signed commitments now sit.
Check it once a week, together, for ninety seconds. The reason a single number works better than a dashboard is that it is impossible to interpret creatively. A dashboard invites you to find the chart that looks encouraging. One cell showing +$4,200 does not.
And it makes the conversation about a decision rather than an inventory. If you are at plus four thousand, you either find four thousand or you take four thousand out. Both are fine. Not knowing is not.
Two people, one sheet
The wedding budget is frequently the first document a couple genuinely co-owns, and it is worth setting it up as one rather than as something one person maintains.
In practice that means both of you have real edit access, both of you enter the quotes from the vendors you personally dealt with, and both of you know where the variance cell is.
The pattern to avoid is the one where one person becomes the budget and the other becomes the person who is told about it. It produces exactly the dynamic where every spending question turns into a request for approval, which is corrosive during planning and considerably worse afterwards, when the same shape gets carried into the marriage. Splitting the jobs rather than the bills matters here more than anywhere, because the stakes are visible and the timeline is short.
A practical division: one person owns the payment schedule tab, the other owns the contracted column, and you look at the variance cell together once a week. Ten minutes, both informed.
Keeping the estimate column honest early on
In the first months, before you have contracts, the entire sheet is guesses — and guesses drift upward silently as you learn what things cost.
Two habits that help. Never overwrite an estimate without noting it; add a small column for the original figure so you can see how much the plan has moved from where it started. And once a month, total the estimates and compare to the ceiling, exactly as you will later with contracted figures.
Most couples discover their estimates have grown by twenty or thirty percent before they have signed anything at all. That is a very recoverable problem in month two and a very expensive one in month nine.
Closing the sheet out after the wedding
Worth ten minutes about a fortnight afterwards, and almost nobody does it.
Fill in the final actual paid for every line. Note which categories ran over and by how much. Record the true all-in total, including the licence, the tips, the overtime and the things you forgot.
Two reasons. Practically, you will be asked — by friends, by siblings — what a wedding actually costs, and a real number is a genuine kindness. And personally, it is the first large project you have budgeted as a couple, and knowing where your estimates were wrong is directly useful for the next one, which will probably be a car or a house.
Then archive it and start something smaller for the marriage. An eight-row monthly template is a completely different tool from a wedding tracker, and the wedding one should not become your household budget by inertia.
Building it, in order
Set the ceiling first — before any venue tours, because every number after that will be set warm. Then list categories with estimates. Add the four-column structure. Build the payment schedule tab with one row per payment. Add the contributions table. Add a tips and extras block, including an overtime contingency. Put the variance cell at the top.
Share it properly so both of you can edit, and check the variance cell weekly. The same four-tab discipline that works for a household budget applies here, with the payment schedule doing the job the irregular-costs tab does in normal life.
One last thing, and it is the thing the spreadsheet is really for. Both of you should be able to state the variance number without opening it. If only one of you knows where you stand, you do not have a shared budget — you have one person quietly carrying it, which is a bad way to start a marriage and an easily avoidable one.