Wedding Budget Spreadsheet Example and How to Use It

How-to basics · Updated November 21, 2026

A wedding budget spreadsheet helps you compare your spending plan with vendor estimates, actual charges, and payments already made. Here is an illustrative $30,000 Excel example, followed by formulas and setup steps you can adapt to your own guest count, location, and priorities.

Example wedding budget spreadsheet

The sample below uses one row per expense. Planned amounts add up to $30,000; current estimates total $29,800. Actual costs are left blank because a budget should distinguish a quote from a final bill. Paid amounts show deposits or payments already made, and the estimate variance compares each quote with its original plan.

Category Item Planned Estimate Actual Paid Estimate unpaid Variance
Venue Venue and rental $7,500 $7,600 — $1,500 $6,100 $100
Food and drink Catering and bar $8,000 $8,200 — $0 $8,200 $200
Photography Photographer $3,000 $2,800 — $600 $2,200 -$200
Attire Clothing and beauty $1,800 $1,900 — $0 $1,900 $100
Flowers and decor Florals and decorations $1,800 $1,700 — $0 $1,700 -$100
Entertainment Music $1,500 $1,400 — $500 $900 -$100
Stationery Invitations and printing $600 $550 — $0 $550 -$50
Transport Transportation $500 $450 — $0 $450 -$50
Dessert Cake $500 $450 — $0 $450 -$50
Ceremony License and ceremony costs $300 $250 — $0 $250 -$50
Reserve Contingency fund $4,500 $4,500 — $0 $4,500 $0
Total $30,000 $29,800 — $2,600 $27,200 -$200

These figures are an example, not a typical price list or a spending recommendation. Vendor prices, taxes, service charges, and what is included in a package vary by place and contract. The contingency line is part of the planned total here; if it is not spent, it remains unspent rather than becoming an assumed vendor cost.

What each spreadsheet column should track

Keep the meanings of the money columns separate. Planned is the amount you have allocated before booking. Estimate is the latest expected total based on a quote or contract. Actual is the final amount charged once known. Paid records money already sent, not the whole cost. Estimate unpaid is the estimated balance remaining, while variance shows how the current estimate compares with the plan.

  • Category and item: Use categories for summaries and item names for specific vendors or purchases. A category can contain several rows, such as separate ceremony and reception rentals.
  • Planned: Set this amount when deciding how to distribute the overall budget. Keep the original plan visible so later changes are understandable.
  • Estimate and actual: Update the estimate when a vendor quote changes. Enter the final actual cost when the bill is settled; do not replace the estimate with the final amount if you want to preserve the comparison.
  • Paid: Record each payment and its date in a separate payment log or notes field. If multiple installments are involved, do not treat one deposit as the full paid amount.

Consider adding columns for vendor name, contract status, due date, payment method, and notes. Those fields make the sheet useful for organizing obligations, not just adding costs. Do not put sensitive payment-card numbers or account credentials in a shared workbook.

Useful Excel formulas for the example

In this layout, the headers are in row 1, expenses occupy rows 2 through 12, and the total is row 13. Enter formulas in row 2 and fill them down through row 12. In Excel for Microsoft 365 on Windows, select the formula cell and drag its fill handle down, or copy and paste it into the remaining cells.

With estimate in D2 and paid-to-date in F2, put this in G2 for the estimated unpaid balance. For the venue row, it returns $6,100 because $7,600 minus $1,500 equals $6,100: =D2-F2.

With planned amount in C2 and estimate in D2, put this in H2 for the estimate variance. The venue returns $100, meaning its estimate is $100 over plan: =D2-C2. A negative result means the estimate is below plan. This sign convention is useful if you label the column clearly.

With planned amounts in C2:C12 and the total row at 13, put this in C13. It returns $30,000: =SUM(C2:C12). With estimates in D2:D12 and the same total row, this formula in D13 returns $29,800: =SUM(D2:D12).

With paid amounts in F2:F12, enter this in F13 to total the payments. It returns $2,600: =SUM(F2:F12). With estimated unpaid amounts in G2:G12, this formula in G13 returns $27,200: =SUM(G2:G12). This agrees with the estimate total of $29,800 minus $2,600 paid.

With variance values in H2:H12, use this in H13 to total the variance. It returns -$200, since the estimates are $200 below the $30,000 plan: =SUM(H2:H12). You can also verify that total by subtracting the planned total from the estimate total. Avoid typing a number into a total cell that should contain a formula, since manual totals will not update when line items change.

Build and format the workbook in Excel

  1. Open a blank workbook and add the column headers shown in the example to row 1. Enter one expense per row, leaving actual amounts empty until you have a final charge.
  2. Enter planned values, estimates, and payments as numbers, not text with a manually typed currency symbol. Select the money cells and choose Home > Number Format > Currency, then set the decimal places you want. Currency formatting changes how a number displays, not the value used in calculations.
  3. Enter the formulas in the first expense row and the total row. Check the sample results above before copying formulas down. Use Home > Format as Table to apply a table style and filterable headers; confirm that the selected range includes the header row.
  4. Save the workbook with a clear name and update it after quotes, contract changes, and payments. If using Excel for the web, the basic formulas and table tools are available there too, although ribbon layout can differ. The steps above describe Excel for Microsoft 365 on Windows.

For a visual warning, select the variance cells and use Home > Conditional Formatting > Highlight Cells Rules to highlight positive values. Choose a rule that makes over-plan estimates noticeable without treating a negative value as a problem. Check the rule after adding rows so it covers the full variance column.

Set a realistic total and allocate it thoughtfully

Start with the amount the couple and any contributing family members have actually agreed can be spent. Record who is contributing, when funds will be available, and whether a contribution is committed or only tentative. The spreadsheet can track a funding plan, but it cannot make an uncertain contribution reliable; avoid booking costs based only on money that has not been confirmed.

Next, identify costs that apply to the event you are planning. Guest count affects many catering and stationery quotes, while venue, photography, and music may be priced mainly as packages or hours. Ask vendors what a quote includes and whether taxes, service charges, delivery, setup, overtime, or rentals are separate. Do not assume every vendor uses the same definition of a package price.

The example allocates $4,500 to a reserve, but the right reserve depends on how complete the plan is and how much uncertainty remains. It is useful to keep a reserve visible rather than distributing every available dollar to named purchases. If a new expense appears, record it and decide explicitly whether to use the reserve, revise another category, or change the overall spending limit.

Track deposits, deadlines, and changing estimates

A total paid column cannot show when the next payment is due. Add a separate payment schedule with one row per installment and fields for vendor, amount, due date, date paid, and confirmation. A vendor with a deposit and two later installments should have three payment rows. The total of those payments should reconcile with the paid amount in the main budget.

Keep a record of the date and source of each estimate, such as a proposal or signed agreement. When an estimate changes, update the current estimate and add a brief note explaining why. If your household wants to preserve the original quote as well, add an Original quote column rather than relying on memory. This makes it easier to distinguish a genuine price increase from an estimate that was incomplete.

Review upcoming due dates regularly, especially after signing a contract. A payment that is planned but not yet paid is still an obligation, so compare the schedule with available funds rather than looking only at the total budget. For contract terms, cancellation conditions, or local license requirements, read the relevant documents and check the responsible local authority; spreadsheet categories are not a substitute for those details.

Common spreadsheet mistakes to avoid

  • Mixing estimates and actuals: Replacing a quote with a final bill erases the comparison. Keep both fields and enter the bill in Actual when it is known.
  • Counting a payment twice: A deposit is part of the vendor’s total cost, not an extra cost on top of it. Record it under Paid and subtract paid from the estimate to show an unpaid balance.
  • Forgetting small or conditional costs: Delivery, setup, alterations, postage, overtime, and extra guest charges may matter depending on the contract. Ask what is included rather than assuming these apply universally.
  • Leaving formula ranges too short: If you add new rows below the original range, check whether totals and conditional formatting include them. An Excel table can make expanding a list easier, but verify formulas and totals after structural changes.
  • Treating a category limit as a bill: A planned amount is a limit or allocation, not evidence of the final cost. A favorable estimate in one category does not automatically mean that funds are available elsewhere unless you decide to reallocate them.

Spreadsheet, template, or planning app?

A custom Excel workbook suits people who want control over categories, formulas, and privacy settings. A downloadable spreadsheet template can save setup time, but inspect its formulas, categories, and sharing permissions before entering personal details. Templates may include assumptions that do not fit your event, and their totals should be checked rather than trusted automatically.

A dedicated planning app may combine a budget with guest lists, seating, vendor contacts, and reminders. That convenience can be worthwhile if you will use those features, but check whether collaboration, export, or premium tools require an account or payment. A spreadsheet is often easier to modify and print, while an app may offer more integrated planning tools. Either approach works if it clearly separates the planned amount, current estimate, final cost, and payments made.

Frequently Asked Questions

What should a wedding budget spreadsheet include?
At minimum, include categories, individual expense items, planned amounts, current estimates, final actual costs, payments made, and a total. Adding vendor names, due dates, contract status, and notes helps manage the work behind the numbers.

How do I calculate the remaining wedding budget in Excel?
For an unpaid vendor balance, subtract the amount paid from the current estimate. In the sample, the venue has a $7,600 estimate and $1,500 paid, leaving $6,100 estimated unpaid. For the overall amount left under the plan, compare the planned total with the costs you expect to incur, and be clear about whether the reserve is included.

Should the contingency fund be included in the wedding budget total?
It can be included as a reserved portion of the total spending limit, as in this example. Track actual contingency spending as separate line items or notes so the reserve does not appear to be a vendor bill when it has not been used.

How often should I update the spreadsheet?
Update it whenever a quote changes, a contract is signed, a payment is made, or a final bill arrives. A regular review of upcoming due dates also helps catch obligations that a simple total would not reveal.

Can I use this example in Google Sheets?
Yes. The basic formulas shown, including SUM and subtraction, are also supported in Google Sheets. Menu labels and formatting controls differ, so follow the Google Sheets interface rather than the Excel ribbon paths described above.

Related

Try it: the Date Difference Calculator: days, months, years and weekdays between two dates, with the DATEDIF formulas.

More in How-to basics

Sources: Function behaviour and menu paths: Microsoft Support documentation for Excel. Method & sources

Spotted an error in this guide? Let us know.