How to Budget for an Event (With an Excel Template)

• Tahir Abbas
• November 06, 2026

An event budget turns a guest count and a list of quotes into one number you can approve. This guide shows the steps in Excel. You can follow along with our free event budget template.

Updated November 2026

Step 1: Fix the guest count and total

Most event costs depend on how many people come, so decide a likely guest count first. The example is an awards dinner for 80 guests with a total budget of $12,000.

Step 2: List every cost

Common categories are venue, catering, entertainment, decor and rentals, marketing, staff and security, travel and other. For each item write a quantity and a unit cost. Estimated cost is =C10*D10. Buffet dinner at $38 for 80 guests is $3,040. Drinks at $14 for 80 guests is $1,120.

Step 3: Add the totals

In the example eight items total $9,640. That leaves $2,360 of the $12,000 budget. Divide by guests for cost per guest: 9,640 / 80 = $120.50. This is the figure to compare against ticket prices or per-head limits.

Step 4: Track actuals and what is paid

When a bill arrives, type it beside the estimate. Variance is =E10-F10. The buffet bill was $3,120, which is $80 over the $3,040 estimate. Use a Yes, Part or No column for payments and count the unpaid items with =COUNTIF(G10:G49,"No"). See the data validation guide for drop-downs.

Step 5: Summarise by category

Use SUMIF to total each category, as described in Microsoft’s SUMIF reference. A bar chart of estimated against actual shows which category is moving.

Ways to keep the budget on track

• Ask for written quotes that include fees and service charges.
• Link per-guest lines to the guest count so changes flow through.
• Hold a buffer for items nobody thought of.
• Review actuals against estimates every week as the date approaches.

These are illustrations to help you plan, not financial, legal or tax advice.

Frequently asked questions