The short answer
A wedding budget spreadsheet is a table with a row for each vendor or cost and columns for the estimated, contracted, paid and remaining amounts, built from your own quotes and contracts. To make one, start with the total you can spend, list your categories, put service charges, tax and fees on their own rows, add payment dates and a contingency row, and update it from each invoice.
How do you make a wedding budget from your own numbers?
Start with the total you can spend and where it comes from: your savings, what you expect to set aside each month until the wedding, and any contributions that have been promised to you. Write each source on its own line with the date the money will be available. That total is the ceiling for the spreadsheet, not a figure borrowed from an average.
Then list your categories, such as venue, catering, bar, photography, music, flowers, attire, rentals, stationery, transportation, officiant, tips and a contingency. Fill each one from the quotes and contracts you have. Where you do not yet have a quote, enter your own estimate and mark it as an estimate, so you can see at a glance which numbers are still guesses.
What columns should a wedding budget spreadsheet have?
Four money columns keep a budget honest. Estimated is what you expect before you have a quote. Contracted is what a signed agreement says you owe. Paid is what has actually left your account. Remaining is what is still to pay, calculated as Contracted minus Paid, or Estimated minus Paid where there is no contract yet.
Add columns for the next payment date and amount, and for the source: the document and page each number came from. When a vendor sends a revised quote, update the contracted figure and note the new document in the source column, so you can trace any number back to paper.
- Category and vendor
- Estimated
- Contracted
- Paid to date
- Remaining (Contracted or Estimated minus Paid)
- Next payment date and amount
- Source document and page
Why put fees, service charges and tax on separate rows?
A percentage hidden inside a vendor total is easy to miss when the base changes. Give each service charge, administrative fee, sales tax, card fee or delivery charge its own row, with its rate and the base it applies to written in a note, such as "service charge, 20% of food and beverage". Then write the row as a formula that points to the base, so it updates when the base does.
This matters when the guest count moves. If the food and beverage line rises, the service charge and tax rows should rise with it, and a formula does that for you. Check your contract for the order of calculation, since the tax base may include or exclude the service charge; ask the vendor to confirm it in writing.
How do you track wedding payment dates in the budget?
For each contract, list each payment with its amount and its due date or trigger, such as "balance due 14 days before the event". Convert each trigger into a calendar date. Then sort by date to see how much is due in each month, and compare that with when your money is available from the first section.
If two large payments fall in the same week, you will see it early enough to plan for it. Put the dates in a calendar with reminders, and when a payment is made, move the amount from Remaining to Paid and record the date and method.
How big should the contingency row be?
Size the contingency from your own open items rather than a rule of thumb. List what is not settled: a guest count that may rise, possible overtime, a weather backup you may need, a price increase clause, delivery charges not yet quoted. Put a rough cost on each, using the rates in your contracts where they exist, and add them up.
That sum is your contingency row. As each item is settled, either move the money into the category it belongs to or release it. A contingency built this way tells you what it is for, which makes it easier to protect when something new comes up.
Wedding budget spreadsheet example: a worked budget
For example, a hypothetical couple has $30,000 available. Their rows: venue rental contracted at $6,000; catering food and beverage for 100 guests at $85 each, $8,500; a 20% service charge on food and beverage, $1,700; 8% sales tax on food, beverage and service charge, 0.08 x $10,200 = $816; photography contracted at $3,800; flowers estimated at $2,500. The total is $23,316, leaving $6,684.
Their open items: ten more guests would add $850, plus $170 of service charge and 0.08 x $1,020 = $81.60 of tax, or $1,101.60; one hour of photography overtime at a contracted $350. The contingency row is $1,451.60, leaving $5,232.40 for unbooked categories. They have paid $3,000 to the venue and $1,000 to the photographer, so $20,816 - $4,000 = $16,816 remains on contracted rows.
How do you update the budget when invoices arrive?
When an invoice arrives, compare each line with the contract row before you pay. Check the quantities, rates, percentages and base, and look for lines that are not in the contract. If something differs, ask the vendor to explain it in writing before you update the spreadsheet.
Once the invoice matches, update the contracted figure if it has legitimately changed, record the payment in the Paid column with the date, and add the invoice to the source column. Keep a short note of why any number changed, so you and anyone helping you can follow the history later.
- Compare each invoice line with the contract row
- Check quantities, rates and percentage bases
- Ask in writing about any line that differs
- Update Contracted only for agreed changes
- Record the payment date and method
- Note the invoice in the source column
Wedding budget spreadsheet
Use one row for a decision or deliverable. Keep unanswered items visible. Download the blank worksheet to open in Excel, Numbers or Google Sheets.
On a small screen, swipe the worksheet sideways to see the remaining columns.
| Category | Estimated | Contracted | Paid | Remaining |
|---|---|---|---|---|
| Venue rental | — | — | — | — |
| Catering food and beverage | — | — | — | — |
| Service charge (rate and base) | — | — | — | — |
| Sales tax (rate and base) | — | — | — | — |
| Photography | — | — | — | — |
| Music | — | — | — | — |
| Flowers | — | — | — | — |
| Attire | — | — | — | — |
| Tips | — | — | — | — |
| Contingency (open items) | — | — | — | — |
A message you can make your own
Add your document reference and the questions that apply. You decide what to send and send it yourself.
We are building our wedding budget and want our numbers to match your contract exactly. Could you confirm, in writing, the full amount we will owe, broken out by each charge, including any service charge, administrative fee and sales tax, with the rate and the base each one is calculated on? Could you also list each remaining payment with its amount and due date, and tell us which lines would change if our guest count or hours change?
Common questions
What should be included in a wedding budget spreadsheet?
A wedding budget spreadsheet should include the categories that match your own plans, such as venue, catering, bar, photography, music, flowers, attire, rentals, stationery, transportation, officiant, tips and contingency, plus separate rows for service charges, tax and fees. Add or remove rows to match what you are actually booking.
What percentage of the wedding budget should go to the venue?
The share of a wedding budget that goes to the venue has no percentage you can rely on, because it depends on what the venue includes and what you book elsewhere. Work it out from your own spreadsheet instead. For example, a hypothetical $6,000 venue in a $30,000 budget is $6,000 / $30,000 = 20%.
What is a realistic wedding budget?
A realistic wedding budget is the total you can actually spend, from savings, what you can set aside before the wedding and contributions that have been promised, each with the date it will be available. Start the spreadsheet from that figure, then fill the rows from quotes and see whether the plan fits inside it.
Should you use average wedding costs to fill your budget?
Average wedding costs are a weaker source for your budget than your own quotes and contracts, which reflect your date, location, guest count and choices. Where you have no quote yet, enter your own estimate and mark it as an estimate until a written quote replaces it.
How do you handle a deposit in the budget?
A deposit in a wedding budget goes in the Paid column, with the full contracted amount in Contracted, so Remaining is the difference. Do not count the deposit again as a separate cost, and check the contract for whether it is applied to the balance or held separately and returned.
When should you update a wedding budget spreadsheet?
A wedding budget spreadsheet is worth updating whenever a document arrives or a payment is made: a new quote, a signed contract, an invoice or a receipt. A regular check-in on a date you choose, such as once a month, helps you catch anything that did not get entered.