Wedding Budget Spreadsheet for 50 Guests: Costs & Formulas

Formulas & functions · Updated November 21, 2026

A practical wedding budget spreadsheet for 50 guests should list each cost, its planned amount, the latest expected total, and what has been paid. The sample below totals $9,823 including a 10% contingency; it is an illustrative planning example, not a typical-price guarantee or a quote.

What a 50-guest wedding budget needs to track

A guest count is a useful starting point, but it does not determine the whole wedding cost. Some expenses rise with each guest, such as meals, drinks, favors, and possibly chairs or place settings. Others, including photography, music, attire, and many venue fees, may be similar whether 50 or more people attend. Your location, date, service level, and what is included in a vendor package can change the numbers substantially.

Use the spreadsheet to answer three different questions: how much you plan to allocate, what you currently expect to spend, and how much you still owe. These are not interchangeable. A deposit is a payment, not necessarily the full cost; an unpaid balance is not the same as an amount over budget. Keeping separate columns helps prevent those figures from being confused.

Before filling in vendor estimates, decide whether the budget covers only the event or also related costs such as rings, a rehearsal meal, travel, or a post-wedding brunch. Write down what is excluded. Otherwise, a spreadsheet can look balanced while important costs sit outside it.

Illustrative budget for 50 guests

The following example uses made-up planning figures to demonstrate a workable layout. The amounts are not a price survey. Replace each line with written quotes and your own priorities, and check whether a quote includes tax, service charges, delivery, setup, and other add-ons.

Category Planned amount
Venue $1,200
Catering and beverages $2,750
Attire $900
Photography $1,100
Flowers $450
Rentals and decor $500
Music $650
Cake $250
Stationery $180
Transport $200
Ceremony and legal fees $150
Gratuities and service charges $300
Miscellaneous $300
Category subtotal $8,930
10% contingency $893
Illustrative total $9,823

The subtotal is the sum of the 13 listed categories. Ten percent of $8,930 is $893, so the example’s total is $9,823. A contingency is a reserve for changes or forgotten costs, not a promise that every wedding needs exactly that amount. Choose a reserve that fits your uncertainty and the amount you can afford to set aside.

Set up the worksheet in Excel

In Excel for Microsoft 365 on Windows, create a blank worksheet and use these headers in row 1: A, Category; B, Planned; C, Current total; D, Paid; E, Left to pay; F, Over or under. Enter the 13 categories in rows 2 through 14. Put your own estimates in column B and the latest expected full cost in column C. When you have a vendor quote, update the current total rather than treating a deposit as the full cost.

Column D records payments made. Column E calculates the remaining amount due, while column F compares the plan with the current expected cost. For example, if the venue plan is $1,200, the current venue total is $1,200, and you have paid $400, you still owe $800. A positive over-or-under figure means the current cost exceeds its planned allocation if you use the variance formula below.

Leave row 15 blank for readability. In row 16, label the category subtotal. In row 17, label the contingency. In row 18, label the total budget including contingency. Keep guest count in B20 and enter 50 there. This layout gives the formulas below consistent cells; if you change the layout, adjust their references.

Formulas for totals, balances, and cost per guest

With category planned amounts in B2:B14, current totals in C2:C14, and payments in D2:D14, enter the following formulas in row 2 and copy them down through row 14:

  • With the current full cost in C2 and payments made in D2, enter =C2-D2 in E2. If C2 is $1,200 and D2 is $400, the result is $800 left to pay.
  • With the planned amount in B2 and current full cost in C2, enter =B2-C2 in F2. If B2 is $1,200 and C2 is $1,350, the result is -$150, meaning the item is $150 over plan.

With the category figures in rows 2:14 and row 16 reserved for subtotals, enter =SUM(B2:B14) in B16. The example returns $8,930. Enter =SUM(C2:C14) in C16 to total current costs and =SUM(D2:D14) in D16 to total payments. In E16, use =C16-D16 to show the amount still due across those categories; in F16, use =B16-C16 to show the subtotal’s remaining budget or overspend.

With B16 holding the planned subtotal and row 17 reserved for a 10% contingency, enter =B16*10% in B17. It returns $893 for the example. With C16 holding the current-cost subtotal, enter =C16*10% in C17 to calculate a reserve using current costs instead. Then, with the subtotal in row 16 and reserve in row 17, enter =B16+B17 in B18 for the planned total, and =C16+C17 in C18 for the current total including reserve. If the current subtotal is also $8,930, C18 returns $9,823.

With the all-in planned total in B18 and the guest count of 50 in B20, enter =B18/B20 in B21. The result is $196.46 per guest. This is an average allocation, not a meal price: it includes fixed and non-guest expenses too. Format the money columns as Currency or Accounting using Excel’s number-format controls, and display B21 as currency with two decimal places.

How to estimate costs without misleading yourself

Start with the items that can constrain the rest of the plan: venue, food and drink, and any required rentals or staffing. Ask vendors for an itemized quote and note its date, what it includes, and whether the total is firm or provisional. For a per-person catering quote, multiply the quoted rate by the number of people it applies to, then add any separately quoted fixed fees. Do not assume a per-person rate includes tax, service, or a vendor meal.

Split broad categories when doing so improves decisions. For example, divide stationery into invitations, postage, and day-of materials, or separate attire from alterations and accessories. Avoid creating so many tiny lines that updating the sheet becomes a burden. A useful category is one you can estimate, compare, or make a choice about.

  • Record the source of each estimate in a notes column: quote, online estimate, or your own allowance.
  • Mark uncertain amounts as estimates and revisit them when you receive current vendor information.
  • Include costs paid by family or another contributor, but identify who is responsible for paying each bill.
  • Check whether a vendor’s minimum spend, delivery fee, or required package changes the apparent per-person price.

Use the guest count carefully

Fifty invited guests does not always mean 50 final attendees. Keep the budget’s working guest count visible and update it when your planning assumptions change. For food and drink, clarify whether the quote is based on invited guests, confirmed attendees, children, or a minimum headcount. A small difference in headcount can affect a per-person bill, while it may not change a fixed venue or photography fee.

To see the effect of a guest-count change, adjust B20 and review the cost-per-guest result. You can also make a separate scenario by copying the worksheet and changing the count, rather than overwriting the current plan. Avoid reducing a fixed expense by a percentage just because the guest list shrinks; confirm with the vendor whether the price actually changes.

Do not use the average cost per guest as a shortcut for every decision. In this example, $9,823 divided by 50 is $196.46, but that figure includes items such as attire and photography. If you want the catering cost per person, divide only the catering-and-beverage amount by the relevant headcount, and be clear about whether separately charged fees are included.

Payment tracking and common spreadsheet problems

Update the payment column whenever a deposit or installment clears, and keep the current total equal to the expected full bill. If a vendor changes a quote, update the total and add a note explaining why. This makes the remaining balance useful for cash-flow planning without accidentally shrinking the estimated final cost when a payment is made.

A frequent mistake is entering the amount paid in the current-total column. That makes the sheet suggest that the bill is smaller than it is. Another is counting a service charge twice: once inside an all-inclusive quote and again as a separate budget line. Read the quote and label exactly what each amount represents. If a quote is unclear, ask the vendor to clarify rather than guessing.

Keep a small notes area for due dates, deposit terms, cancellation rules, and contact details, or maintain those details in a separate vendor tracker. The spreadsheet is a planning tool, not a replacement for the signed agreement or invoice. Reconcile its numbers with current documents before making a payment, and keep a backup copy before making major edits.

Make the example fit your priorities

The sample allocation is only a starting structure. You might spend more on a location and simplify decor, host a restaurant meal instead of hiring a caterer, or choose a smaller photography package. Those choices shift costs between categories; they do not make one sample allocation universally right. First identify the parts of the day that matter most to you, then adjust planned amounts and seek quotes that fit the total available budget.

If the total exceeds your limit, compare specific options rather than applying the same cut everywhere. Ask whether a different date, a shorter service period, a simpler menu, fewer rentals, or a smaller stationery run changes the actual quote. Check whether a proposed saving creates another expense, such as needing to rent equipment that a package would have included. The spreadsheet helps reveal trade-offs; it cannot determine which trade-off is right for you.

Frequently Asked Questions

How much should a wedding for 50 guests cost?
There is no single reliable price for every location or style. The $9,823 figure here is an illustrative worksheet example, not a national average. Build your own total from local quotes, what the venue includes, and the costs you choose to include.

What should a 50-guest wedding budget include?
At minimum, consider the venue, food and drink, attire, photography, ceremony costs, music, rentals, flowers or decor, stationery, transport, and a reserve. Add relevant expenses such as alterations, taxes, delivery, tips, or lodging if they apply to your plans.

How do I calculate a wedding budget per person in Excel?
Put the total you want to average in one cell and the guest count in another. With the all-in total in B18 and 50 guests in B20, =B18/B20 returns $196.46 when B18 is $9,823. Use only the catering total instead if you mean food cost per person.

Should deposits count as wedding expenses?
Yes, record deposits as payments made, but keep the full expected vendor bill in the current-total column. This lets the sheet show both total commitment and remaining balance. Confirm the contract and invoice terms for the actual amount due.

How much contingency should I add?
There is no universally correct percentage. The example uses 10% to demonstrate a formula. Choose a reserve based on how uncertain your estimates are and your available funds, and avoid treating that reserve as permission to exceed a limit you cannot meet.

Related

Try it: the Formula Explainer: paste any formula and see each function and reference in plain English.

More in Formulas & functions

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

Spotted an error in this guide? Let us know.