The usual wedding budget spreadsheet has two money columns, estimated and actual, and nothing for the months a number spends as a quote in between. That gap is where budgets fail: decisions get made against stale guesses while the real prices sit in an inbox. Nine columns, eight category rows and three formulas close the gap, and the build takes about 30 minutes.
Before you build
You need a spreadsheet app both of you can edit at once, so a shared cloud sheet beats a file on one laptop; every formula below works identically in Google Sheets and Excel. You also need the all-in total you are willing to spend, agreed before any vendor conversation, because the sheet's whole job is to defend it. Budget 30 minutes for the build.
Step 1: Put the total above the table
Write the all-in number in a cell of its own above the table and label it. Every formula that matters refers back to this cell, and seeing it while you scroll is half the discipline. If contributions come from more than one household, list them and sum them here, so the total is a fact rather than an assumption.
Step 2: Build the nine columns
- Item: the specific purchase, one row each. The florist and the flower crown are different rows.
- Category: which of the eight budget lines the row belongs to, so category totals can be checked against their shares.
- Estimated: your planned number, written before any vendor contact. It never changes; it is the record of the plan.
- Quoted: the number a vendor gave you in writing. Update only from written quotes, and ask whether service charge and tax are inside before entering it.
- Actual: the signed number, contract plus any change orders. Once this cell is filled, the row stops being an opinion.
- Paid to date: deposits and payments already made against the row.
- Due date: when the next payment on the row is owed. Weddings are paid in deposits and balances, and the dates cluster in the final weeks.
- Vendor and payment method: who is being paid and how, because how you paid decides what you can recover if a vendor fails.
- Notes: the quote reference, what the price includes, and the name of the person who confirmed it.
Step 3: Add rows from the standard categories
Rows come from the standard category shares rather than from memory, because memory forgets transport and remembers flowers. Give every category a header row, then list its real purchases underneath as separate items.
| Category | Share of the total |
|---|---|
| Venue | 25–30% |
| Catering | 20–25% |
| Photography | 8–12% |
| Flowers | 7–10% |
| Attire | 3–5% |
| Music | 3–5% |
| Planner | 3–15% |
| Everything else | 5–8% |
The last category is a container: cake, stationery, transport, hair and makeup, officiant, favors, tips. Give each its own row under the header. A purchase that never got a row is the usual reason a sheet says there is money left when there is not.
Step 4: Seed the estimated column with real numbers
Multiply each share by your total and write the results into the estimated column. If you have no total yet, start from the 2025 median wedding spend of $18,231: at the median, the venue rows seed at $4,600 to $5,500 combined and catering at $3,600 to $4,600.
Do not seed from headline averages. The 2025 average of $32,899 is pulled up by the market's expensive tail, and estimates built on it inflate every row at once. What weddings actually cost, per guest and by state, is the honest seed.
The planner row cannot be seeded from a share, because its 3 to 15% span covers four different products: month-of coordination at $800 to $2,500, partial planning at $2,000 to $6,000, full-service at $3,500 to $15,000 and up. Decide the tier, then seed the row, and if the number will not sit inside the table, the planner row can be made to fit before anything is signed.
Better than seeding that row from a national range is seeding it from a published price. Planners in Austin publish starting prices by tier, which turns the row from an estimate into a shortlist.
Step 5: Move each number right, never back
A row's life runs left to right. It is born as an estimate, becomes a quote when a vendor answers in writing, and becomes an actual when a contract is signed. Never edit leftward: the estimate stays as written even when the quote embarrasses it, because the gap between those two columns is the sheet's most useful information.
Enter a quote the day it arrives. A sheet that lags its inbox by two weeks is a sheet being used to confirm decisions instead of make them.
The quoted column has one trap: a quote that excludes service charge and tax is not the same number as one that includes them. Ask, then enter the all-in figure, so the column stays comparable across vendors.
Step 6: Add the three formulas
Formula 1: best-known cost
Add a tenth column that always shows the truest number a row has. With estimated in column C, quoted in D and actual in E, the formula for row 2 is =IF(E2<>"",E2,IF(D2<>"",D2,C2)). It reads: use the contract if one exists, otherwise the quote, otherwise the plan. Fill it down the whole table.
Formula 2: remaining budget
Subtract the sum of best-known costs from the total: =B1-SUM(J4:J60), where B1 holds the total from step 1, column J is best-known cost, and the range covers your rows. This is the sheet's headline number. While it is positive the plan closes; the moment it goes negative, you are choosing which line pays for it.
Formula 3: cash due by month
Add an eleventh column for what is still owed per row: =J4-F4, best-known cost minus paid to date. Then =SUMIFS(K4:K60,G4:G60,">="&DATE(2026,10,1),G4:G60,"<"&DATE(2026,11,1)) totals everything falling due in October 2026 from the due-date column. Point it at the wedding month and the weeks either side, because that is where the balances stack up.
Those three formulas are the whole engine. Everything else in the sheet is data entry.
Step 7: Keep it alive
Fifteen minutes once a week, on the same day, is enough: enter anything new, update paid-to-date, and read the remaining number together. A budget only one person looks at is a budget only one person believes.
The budget sheet is one document in a larger set, alongside the guest list and the vendor contacts, and where the sheet sits in the wider planning system decides whether it gets opened weekly or rediscovered in a panic.
When the remaining number goes negative while quotes are still arriving, the sheet has done its job early, while the response is still cheap. Which lines to cut when the sheet says cut is a ranked decision, and the gap between the estimated and quoted columns already shows where the drift came from.
Key takeaways
- Build nine columns; the three money columns, estimated, quoted and actual, are the point.
- Rows come from the eight standard categories, split into real purchases, so nothing spends without a row.
- Seed estimates from the $18,231 median or your state's median, never from headline averages.
- Three formulas run everything: best-known cost, remaining budget, and cash due by month.
- Numbers move right, never back, and 15 minutes a week keeps the sheet ahead of the inbox.
Frequently asked questions
What should a wedding budget spreadsheet include?
Nine columns (item, category, estimated, quoted, actual, paid to date, due date, vendor and payment method, notes), rows for each real purchase grouped under the eight standard categories, and three formulas: best-known cost, remaining budget, and cash due by month. The total you are defending sits in its own labeled cell above the table.
Is Google Sheets or Excel better for a wedding budget?
Either. The formulas here run identically in both. The deciding factor is shared editing: a cloud sheet both partners can open on a phone gets maintained, while a file emailed back and forth does not. Pick whichever one you will both actually open weekly.
What is the difference between estimated, quoted and actual cost?
Estimated is your plan, written before contacting any vendor and never edited afterward. Quoted is a price a vendor gave you in writing, entered with service charge and tax included. Actual is the signed contract plus change orders. A number moves right through those columns and never back.
How do you track wedding vendor payments in a spreadsheet?
Give every row a paid-to-date column and a due-date column, then compute what is still owed as best-known cost minus paid to date. A SUMIFS over the due-date column shows the cash leaving in any given month. Most balances fall due in the final weeks, so that month deserves its own check.
How do you make a wedding budget spreadsheet from scratch?
Put the total in a labeled cell, build the nine columns, add rows for every real purchase under the eight standard categories, seed estimates by multiplying each category's share by your total, then add the three formulas. The build takes about 30 minutes, and no downloaded template is required.
What formulas does a wedding budget need?
Three. Best-known cost per row: =IF(actual is filled, actual, otherwise quoted, otherwise estimated), written as a nested IF. Remaining budget: the total minus the sum of best-known costs. Cash due by month: a SUMIFS of outstanding balances against the due-date column.
How do you seed a wedding budget with realistic numbers?
Multiply each category's typical share by your total: venue 25 to 30%, catering 20 to 25%, photography 8 to 12%, on down. If you have no total yet, the 2025 national median of $18,231 is the honest starting point, adjusted by your state's median. Replace estimates with published local fees as soon as you have them.
Should a wedding budget spreadsheet have a contingency row?
It can, but the cleaner discipline is seeding lines at the top of their ranges and treating the remaining-budget number as the buffer. A named contingency row tends to get spent like any other line. Whichever you choose, never let the contingency and the remaining number count the same dollars twice.
How often should you update a wedding budget spreadsheet?
Quotes go in the day they arrive; everything else gets a fixed 15-minute session once a week. The sheet only steers decisions while it is ahead of the inbox. A sheet updated monthly records the budget; it does not defend it.
Are downloadable wedding budget templates worth it?
A template is fine if it separates estimated, quoted and actual; many track only estimated and actual, which hides drift for the months a price spends as a quote. Building your own takes about 30 minutes, and you understand every formula in it. The structure above is the template.