A useful wedding budget spreadsheet for 200 guests lists each cost, a planned amount, vendor commitments, and the balance against your budget. Here is an illustrative Excel 365 example totaling $58,000, or $290 per guest; it is a planning model, not a promised local price, and you can replace every amount with real quotes.
Example budget for 200 guests
This sample assumes a $60,000 spending target and reserves $4,500 for contingencies. The figures are deliberately illustrative: venue, catering, bar service, taxes, staffing, season, location, and what a package includes can change the total substantially. Treat the table as a starting allocation to edit, not as a quote or an industry average.
| Category | Illustrative plan |
|---|---|
| Venue | $6,000 |
| Catering | $18,000 |
| Bar | $6,000 |
| Photography and video | $5,000 |
| Music | $2,500 |
| Attire and beauty | $3,500 |
| Flowers and decor | $4,000 |
| Planning | $3,000 |
| Stationery | $1,000 |
| Cake and dessert | $1,200 |
| Transportation | $1,000 |
| Ceremony and officiant | $800 |
| Other fees | $1,500 |
| Contingency reserve | $4,500 |
| Total planned | $58,000 |
The arithmetic is straightforward: the listed categories add to $58,000, leaving $2,000 between the example plan and its $60,000 target. Dividing $58,000 by 200 gives $290 per invited guest as a rough all-category planning ratio. That does not mean every guest costs $290: venue, photography, attire, and other costs are fixed or only partly tied to attendance. Catering and some bar or rental charges are more likely to rise with the final headcount.
What the spreadsheet should track
A workable workbook distinguishes a target from estimates and commitments. A quote is not necessarily the final bill, and a deposit is a payment toward a contract rather than a separate expense to add on top of its full price. Keeping those concepts separate helps prevent a budget from looking smaller or larger than it really is.
- Target: the maximum amount you intend to spend, including any reserve you want to protect.
- Planned amount: your allowance for each category before all vendors are selected.
- Committed amount: the full contracted price once you have accepted a vendor’s terms. Update it when the scope or contract changes.
- Paid to date: deposits and later payments already made. Track this separately from the full commitment.
- Remaining: the difference between the planned allowance and the committed amount. A negative number signals that a category is over its allowance.
For a simple sheet, use columns for category, planned, committed, remaining, paid to date, due date, and notes. Use one row per cost, not one row per vendor if a vendor covers unrelated categories. If a caterer’s proposal includes food, staff, rentals, and service charges, either record the full bundled contract in one category or split it consistently; do not enter the same bundled amount in several rows.
Set up the workbook in Excel
In Excel for Microsoft 365 on Windows, open a blank workbook and enter a small summary at the top: put Budget target in A2 and 60000 in B2; put Guest count in A3 and 200 in B3. Set row 4 as column headings: Category in A4, Planned in B4, Committed in C4, Remaining in D4, Paid to date in E4, and Notes in F4. Enter the 15 example categories in A5:A19 and their planned figures in B5:B19.
Use row 20 for totals. Put Total in A20, then add the total formula described below in B20. You can use the same pattern in C20 and E20 to total commitments and payments once figures are entered. In D5, calculate the remaining allowance for the first category, then copy that formula down through D19. Leave unknown amounts blank rather than treating a vendor’s preliminary estimate as a firm contract. Add due dates or payment milestones in a separate column if they need to be tracked.
Format money cells by selecting the relevant range and choosing Home > Number Format, then selecting Currency or Accounting. For a quick visual warning, select D5:D19 and use Home > Conditional Formatting > Highlight Cells Rules > Less Than, entering 0. This flags negative remaining amounts. On Mac, Excel has the same core formulas and conditional-formatting feature, though ribbon layout can vary by release; Excel for the web also supports these basic steps, with some interface differences.
Useful formulas and what they tell you
With the planned category figures in B5:B19 and the total cell in B20, enter =SUM(B5:B19) in B20. In the example it returns $58,000. SUM adds the planned values, so changing a category automatically updates the total. If you add categories, expand the formula range to include the new rows.
With a $60,000 target in B2 and the planned total in B20, enter =B2-B20 in B21 to show unallocated room. The example result is $2,000 ($60,000 minus $58,000). A positive result means some target remains unassigned; a negative result means planned costs exceed the target. This is not the same as cash in a bank account.
With the guest count in B3 and the planned total in B20, enter =B20/B3 in B22 to calculate the planned cost per guest. The example returns $290 ($58,000 divided by 200). This ratio is useful for comparing scenarios, but it is not a prediction of the additional cost of inviting one more person.
With the planned amount in B5 and the full contracted amount in C5, enter =B5-C5 in D5, then copy it down through D19. If the venue allowance is $6,000 and its contract is $6,400, the result is -$400, meaning that category exceeds its plan by $400. If the contract is $5,700, the result is $300 still available. Enter the full contract in C, not only the deposit. These formulas use standard Excel syntax and do not require newer functions.
How guest count changes the numbers
Two hundred guests affects more than the meal bill. The venue must allow for the expected attendance and layout, while table count can influence linens, centerpieces, place settings, and staffing. Invitations, favors, transport, and bar quantities may also change with headcount. However, a larger guest list does not automatically multiply every cost: the same photographer, planner, ceremony, or attire may serve the event at either headcount.
Build a low, expected, and high attendance scenario before finalizing per-person contracts. For instance, compare the budget at 180, 200, and 210 attendees, while keeping fixed costs unchanged and adjusting only costs that actually vary by guest. Confirm whether vendor pricing uses invited guests, confirmed RSVPs, a guaranteed minimum, or a final count deadline. The contract controls; the spreadsheet should reflect its actual pricing method.
Also distinguish invited guests from the number billed. Couples, children, vendors receiving meals, and late RSVP changes may be handled differently by a venue or caterer. Ask the vendor which people count toward food, seating, bar, and rental totals. A guest-count cell is a useful planning reference, but it cannot substitute for the vendor’s specific guarantee rules.
Choosing realistic category allowances
Start with the total amount you can afford to allocate, then reserve money for uncertain or easily overlooked costs before distributing the rest. The example sets aside $4,500, but the right reserve depends on your circumstances and risk tolerance; it is not a universal percentage. If you use a reserve, label it clearly and do not also include the same reserve inside multiple vendor categories.
Request itemized proposals where possible. For each quote, check whether the number includes taxes, service charges, delivery, setup and teardown, overtime, equipment, travel, and gratuity. A low headline quote may omit required additions, while a higher package may include items that would otherwise be separate line items. Compare the scope as well as the total.
- Prioritize categories that matter most to you and decide which features can be reduced if quotes exceed the plan.
- Use written estimates for early planning and mark them as estimates; replace them with contracted totals when booked.
- Ask vendors how extra guests, schedule extensions, substitutions, or changes affect the price.
- Record quote dates and payment deadlines in notes or separate columns so old prices and upcoming obligations are visible.
Common spreadsheet mistakes
A frequent error is counting deposits twice: once as a deposit and again as part of the full vendor price. Keep the contract amount in Committed and record the deposit in Paid to date. Another is entering a package total in the venue row and then entering its included tables, chairs, or staffing as new costs. Only list an item separately when it is genuinely outside the package.
Do not assume a per-guest figure covers all costs. A $290 average based on the illustrative total includes fixed expenses and a contingency reserve, so it should not be used as a caterer’s meal price. Conversely, a food quote per person may exclude service, taxes, rentals, or bar costs. Compare like with like before drawing conclusions.
Finally, keep the original plan visible when you update estimates. If you overwrite the planned amount every time a quote changes, you lose the ability to see whether the decision is within the original allocation. A separate committed column makes overspending visible without hiding what you first intended to spend. Save a dated copy before making major revisions, and consider keeping the workbook in a shared location with clear editing permissions if more than one person updates it.
Frequently Asked Questions
How much should a wedding for 200 guests cost? There is no single reliable price without a location, date, venue, service level, and clear list of inclusions. The $58,000 total here is a sample budget only. Gather local quotes, check what they include, and replace the sample numbers with your own.
What is the cost per guest for a 200-person wedding? Divide the total budget by 200 for a broad planning ratio. In this example, $58,000 divided by 200 is $290 per guest. Because that total includes fixed costs and a reserve, it is not the amount each guest adds to the bill.
What should a wedding budget spreadsheet include? Include the target, categories, planned amounts, contracted totals, payments made, remaining allowances, due dates, and notes. Track deposits as payments toward a contract, not as extra expenses beyond the full contracted cost.
How much extra should I leave for unexpected wedding costs? There is no fixed reserve that fits every event. Put a contingency amount in its own row based on your budget and uncertainty, then identify what it covers. Avoid counting that reserve twice or spending it as if it were already committed.
Can I use this spreadsheet in Google Sheets? Yes. The basic formulas shown, such as SUM and subtraction, also work in Google Sheets. You can copy the layout and values, then adjust menu steps and formatting to match the Sheets interface; the Excel-specific instructions above refer to Microsoft Excel.
Related
- Office Inventory Spreadsheet: Setup, Tracking, and Tips
- Retirement Savings Tracker Spreadsheet: Build Yours
- PowerPoint Slideshow Loop: How to Repeat It Continuously
Try it: the Date Difference Calculator: days, months, years and weekdays between two dates, with the DATEDIF formulas.
More in How-to basics
- Does iPad Have Excel? App, Features, and Costs ExplainedYes. Microsoft Excel is available as an app for iPad, and you can use it to open, create,…
- Excel Table Not Adding New Rows? Causes and SolutionsExcel tables usually add rows when you type directly in the first row beneath them, or press Tab…
- How to Enable the Text Import Wizard in Excel for CSV FilesTo enable the legacy Text Import Wizard in Excel for Microsoft 365 on Windows, open File > Options…
- Excel Keyboard Shortcuts: Options for Every TaskExcel keyboard shortcut options include built-in key combinations, ribbon Key Tips, the Search box, and commands added to…
- Import a Color Palette in Excel: Step-by-Step GuideTo import a color palette in Excel for Microsoft 365 on Windows, load an Office theme file (.thmx)…
- How to Add Page Numbers in Word: Step-by-Step GuideTo add page numbers in a Word document, open the file, select Insert > Page Number, choose a…
Sources: Function behaviour and menu paths: Microsoft Support documentation for Excel. Method & sources
Spotted an error in this guide? Let us know.