Wedding Budget Spreadsheet for 100 Guests: A Simple Plan

How-to basics · Updated November 21, 2026

For 100 guests, start with a spreadsheet that lists each expense, its planned cost, its actual cost, and the difference; the sample budget below totals $27,000, or $270 per guest, as an illustration rather than a typical price or a quote. In Excel for Microsoft 365 on Windows, you can track the plan with simple SUM formulas and adjust it to your own budget, location, priorities, and vendor quotes.

What a 100-Guest Wedding Budget Spreadsheet Should Include

A useful wedding budget is more than a list of vendor names. It should show the amount you intend to spend, what you have committed to spend, what has actually been paid, and what remains. Keeping those figures distinct helps prevent a quote, a signed contract, and a payment from being mistaken for the same thing.

Set up these columns in Excel: category, planned amount, actual or committed amount, difference, and notes. You can use the notes column for a vendor name, quote date, payment deadline, deposit, or a reminder about what the price includes. The sample categories below add up to $27,000:

Category Illustrative plan
Venue and site fees $5,000
Food and catering $8,000
Drinks and bar $2,500
Photography $3,000
Attire and alterations $1,800
Flowers and decor $1,500
Music $1,200
Stationery $400
Cake or dessert $500
Transport $400
Hair and makeup $500
Rentals $1,200
Contingency $1,000
Total $27,000

These are round-number planning entries, not estimates of what vendors charge. Some venues include tables, chairs, or catering; others bill those separately. If a service is included in another line, do not budget it twice. Rename, remove, or add rows to match the actual arrangements.

How to Set Up the Workbook in Excel

In a blank workbook, put Guest count in A2 and enter 100 in B2. Put Total budget in A3 and enter your chosen limit in B3; for the example, use $27,000. In row 5, add the headings Category, Planned, Actual, Difference, and Notes in columns A through E. Enter the categories in A6:A18 and the sample plan amounts in B6:B18. Leave actual costs blank until you have quotes or payments to record.

To make a range easier to read, select the headings and category rows, then choose Insert > Table. In the Create Table window, confirm the range and select My table has headers. Format the planned, actual, and difference columns as currency from Home > Number. The menu paths are available in Excel for Microsoft 365 on Windows; the Mac ribbon labels can vary slightly by release, and the same table and number-format options are available there. A table is optional: ordinary cells and formulas work too.

Use consistent definitions for Actual. One practical choice is to record the full contracted amount once you sign, then update it if the contract changes. Record payment dates and amounts in Notes or a separate payment log. Another choice is to keep Actual strictly for money paid and add a separate Committed column. Do not mix unpaid balances with payments without labeling them, or the remaining-budget figure can look larger than the money still available.

Formulas for Totals, Variance, and Cost Per Guest

With category amounts in B6:B18 and the total row in row 19, enter this in B19 to add the planned amounts. The sample entries return $27,000.

=SUM(B6:B18)

With actual costs in C6:C18 and the total row in C19, enter this formula to total the recorded actual amounts. If those entries add up to $26,400, the result is $26,400; blank cells are treated as zero.

=SUM(C6:C18)

With planned amounts in column B and actual amounts in column C, enter this in D6 and fill it down through D18 to show actual minus planned for each category. For example, if catering is planned at $8,000 in B7 and the actual amount in C7 is $8,200, the result in D7 is $200, meaning $200 over the plan.

=C6-B6

With category totals in row 19, enter this in D19 to calculate the total variance. If the planned total is $27,000 and the actual total is $26,400, it returns -$600, meaning the recorded actual total is $600 below the plan.

=C19-B19

With the total budget in B3 and actual total in C19, enter this in B23 to show the budget remaining. If B3 is $27,000 and C19 is $26,400, the result is $600. This number is only as complete as the costs entered: a blank actual-cost cell does not mean the related service will be free.

=B3-C19

With the guest count in B2 and the planned total in B19, enter this in B22 to calculate the planned cost per guest. With 100 guests and a $27,000 plan, it returns $270. This is a planning ratio, not a vendor’s per-person price: it spreads fixed costs such as photography across the guest count as well as food and drink.

=B19/B2

How to Adapt the Sample for Your Guest Count

One hundred guests is a planning assumption, not necessarily the final number who will attend. Separate guest-dependent expenses from mostly fixed expenses. Meals, beverages, favors, and some rental charges may change with attendance or the final count supplied to a vendor. A photographer’s fee or a venue rental may not change in direct proportion to the number of guests, though packages and venue capacity can affect the quote.

For a useful comparison, keep the total-budget cell fixed while you change the guest count. The per-guest figure will then rise or fall, but it will not predict an exact saving from inviting fewer people. Ask each vendor what changes when the count changes, and record the deadline for submitting the final head count. Track invited, confirmed, and final counts separately if you need to compare them; do not silently replace the planning count with the RSVP count.

As an example, suppose the invitation list grows from 100 to 110. Do not simply add ten times the average budget per guest to every category. Instead, get updated food, drink, seating, and rental figures, then check whether the venue can accommodate the change. Fixed costs may remain unchanged, while per-person items may increase. Enter revised quotes in the relevant rows and retain the earlier quote in Notes if you want a record of the change.

Quotes, Deposits, Taxes, and Costs People Miss

A quote may not represent the final amount due. Compare proposals on the same basis: confirm which services, delivery, setup, rentals, taxes, service charges, and other fees are included, and ask what could change the price. The exact charges depend on the contract and location, so do not assume a particular tax or fee applies everywhere. Enter the expected full cost in the plan rather than treating a deposit as the total cost.

Deposits affect cash flow, but they are not necessarily an additional expense on top of the contract total. If a $3,000 photography agreement requires a $900 deposit, the plan should normally show $3,000 for photography, while a payment log can show $900 paid and $2,100 still due. Adding both $3,000 and $900 as separate budget expenses would count the deposit twice.

Common omissions include alterations, delivery, setup and breakdown, overtime, postage, tips or gratuities where applicable, marriage-license costs, vendor meals, and charges for late changes. Not all will apply. Use a separate row when a cost is substantial or has its own deadline; otherwise, add it to the appropriate category and explain it in Notes. A contingency row can make uncertainty visible, but it should not be treated as money already spent or as a guarantee that every surprise will fit within it.

Choosing Categories and Priorities

There is no single correct percentage split for every wedding. Venue rules, local prices, cultural or family priorities, season, and what is already included can change the shape of a budget. Start with your real spending limit, list required commitments, and obtain quotes for the categories that could materially affect the plan before assigning precise amounts to everything else.

  • Separate essentials from preferences. Mark which items are required for the event and which are optional upgrades, so reducing spending has a clear starting point.
  • Use categories that support decisions. If decor is a major priority, split flowers, rentals, and other decor into separate rows. If it is a small combined expense, one row may be easier to maintain.
  • Make ownership clear. Note who is paying for each item if contributions are shared, and record whether a contribution is confirmed or only expected.
  • Keep a dated quote trail. Put the quote date, expiry date if stated, and vendor contact in Notes or a vendor sheet. Prices and availability can change, so confirm current terms directly.

Changing a plan is easier when each choice is connected to a consequence. If the catering quote is higher than planned, possible responses might include revising the menu, changing the service format, reducing another optional category, or increasing the overall budget if that is genuinely affordable. The spreadsheet reveals the trade-off; it cannot decide which option suits the couple.

Common Spreadsheet Problems to Avoid

The most common arithmetic problem is inconsistent signs. In this setup, Difference means Actual minus Planned: a positive number is over plan, and a negative number is under plan. Label the column clearly and keep the same convention throughout. If you prefer to display savings as positive, reverse the formula, but explain that choice in the heading.

Another problem is counting a cost twice or leaving a cost out because it is bundled. Read the quote and contract, identify the full amount, and decide which single row owns each expense. Avoid typing a total manually when it can be calculated from the category rows; manual totals can become stale after edits. Also check that the guest count is greater than zero before dividing, and enter numbers as numeric values rather than text with a typed currency symbol if Excel does not recognize them.

Review the workbook after changes: verify that category rows are included in the SUM range, that copied variance formulas point to the matching row, and that the budget cap is not confused with the planned category total. If they differ, decide whether the gap is intentional and label it. For example, a budget cap above the planned spending can leave unassigned room; it is not the same as a contingency line already allocated in the plan.

A Simple Monthly Review Routine

Update the workbook whenever a quote is accepted, a contract changes, a payment is made, or an attendance assumption changes. A brief review at regular intervals can catch overruns earlier than waiting until final invoices arrive. Compare each vendor’s written terms with the spreadsheet, check upcoming payment deadlines, and revise estimates when you have better information.

Keep an untouched copy of the original plan or save dated versions before major revisions. Excel for Windows lets you use File > Save As to create a separate workbook copy; in Excel for Mac, use File > Save As as well. A simple change log with date, old amount, new amount, and reason can explain why the plan moved. Store contracts and receipts securely, and avoid placing sensitive payment-card details in a general budget workbook.

Frequently Asked Questions

How much should a wedding for 100 guests cost?
The cost depends on the location, venue, date, services, and choices, so a guest count alone cannot determine a reliable total. The $27,000 example on this page is an editable illustration, not a market average. Build your own total from current local quotes and the amount you can spend.

What is a reasonable wedding budget per guest?
Divide the planned total by the guest count to get a planning ratio. In the example, $27,000 divided by 100 is $270 per guest. That ratio includes fixed expenses and is not the same as the catering or meal price per person.

Should deposits be listed as wedding expenses?
Track the full contracted cost in the category budget and record deposits as payments toward it in a payment log. That approach shows both the total commitment and the cash already paid without adding the deposit to the total a second time.

What should I do if my wedding budget goes over?
First confirm that the spreadsheet includes full quotes and that no expense is duplicated. Then identify which categories are above plan, ask vendors about available options, and compare reductions or changes against your priorities and spending limit. Update the plan only after deciding how the difference will be handled.

Can I use this wedding budget spreadsheet in Excel on a Mac?
Yes. The basic cells and formulas here work in Excel for Microsoft 365 on Mac as well as Windows. Ribbon arrangement and some menu wording can differ by version, but the formulas use standard Excel functions.

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.