Event budget template with a forecast column

An event budget template lists every cost and revenue line of the event in rows and tracks each line in 5 columns: Planned, Committed, Actual, Forecast, and Variance.

The template below is free, needs no email, and comes as a CSV file that opens in Excel and Google Sheets. Of the five, Forecast is the column that shows an overspend while the contract behind it can still be changed.

Download the event budget template

Download event-budget-template.csv (plain CSV, no sign-up). In Excel, open the file directly. In Google Sheets, use File, then Import, then Upload. The rows and columns match the table below, and the values are blank for you to fill in.

What goes in each column

Planned is the budget your board or CFO approved. Freeze it at approval. Later changes belong in Forecast, where they show up as variance against the approved number.

Committed is what you have signed for: deposits, contract minimums, room block obligations, and guarantees, whether or not the invoice has arrived. Actual is what has been invoiced or paid to date. Before the event, Actual trails Committed; after reconciliation the two should meet.

Forecast is your current estimate of where each line will end. Calculate it like this:

For a variable line such as food and beverage, the spend you still expect is the forecast attendance times the unit cost. For a fixed line that is fully signed, Forecast equals Committed. For revenue lines, Forecast is signed revenue plus open deals weighted by the chance they close.

Variance compares the forecast with the plan:

On a cost line, a positive variance means you expect to overspend. On a revenue line, a positive variance means extra income. With that convention, the variance on the Net row equals the revenue variance minus the cost variance.

What does an event budget look like?

An event budget has a cost section, a revenue section, and a net row that subtracts one from the other. A budget with a single amount per line records the plan and nothing after it. With Committed, Actual, and Forecast next to Planned, the same sheet shows how far each line has moved since approval.

Mark each cost line as fixed (venue, AV, speakers, insurance) or variable (food and beverage, print and badges, anything priced per head). Fixed costs stay the same when attendance drops, so they are the ones that decide your break-even point:

Costs are rising faster than budgets. A corporate planner quoted by Skift Meetings in April 2026 put it this way: "Labor, F&B, and AV costs are up 20–30% compared to pre-2020. Budgets aren't." That is one planner's experience, not a measured average. (Skift Meetings) In the 32nd Convene Meetings Market Survey, two in 5 planners expect a flat events budget next year and nearly one quarter expect a smaller one (PCMA Convene). If you copy last year's actuals into Planned, the cost lines start out low.

How do I create a budget for an event?

Start from zero. Every line has to justify its amount for this event, instead of inheriting last year's actual plus an inflation guess. At the SISO Leadership Conference 2026, the cost containment session recommended zero-basing the budget and sorting spend each year into protect, optimize, and eliminate, based on event outcomes (Trade Show Executive). A B2B event strategy applies the same three buckets to whole events.

1. List the cost lines from the template and delete the ones that do not apply. Add a line when a cost has its own contract, invoice, or owner, including internal staff time.
2. Classify each line. Protect the lines that drive registrations or sponsor renewals, such as keynotes and the sponsor reception. Optimize the lines you need but can resize: menus, AV scope, print runs, staff hours. Eliminate what survives only by habit. Planners are already cutting there: in the same Convene survey, 48% trimmed entertainment and 41% trimmed food and beverage.
3. Tag each line fixed or variable, and price variable lines per attendee.
4. Build revenue from its sources. Registration fees are attendance times average net price. Sponsorship is signed contracts plus the open pipeline weighted by stage.
5. Set contingency as its own line. Keep contract penalties on a separate row, so a penalty never disappears into contingency.
6. Calculate break-even attendance and put it on page one, next to the planned attendance.
7. Freeze Planned at approval and fill the other four columns as contracts are signed.

If your meeting is not expected to earn money, keep the revenue section anyway. Break-even then tells you the attendance below which the meeting stops covering its own direct costs, which is the number to bring to a scope conversation.

What should a conference budget include?

A conference budget includes every line in the template. Food and beverage, the room block, and staff time need the most care, because each can cost more than the plan shows.

Food and beverage is usually the largest line. In the Convene survey, 65% of respondents named food and beverage and 58% named audiovisual among the largest items in next year's budgets. Hotel contracts often carry an F&B minimum, so the Committed amount can be higher than what your attendance would consume.

Room block attrition belongs in the budget as its own row, even when the Planned value is zero. If attendees book fewer room nights than the contract requires, the shortfall is billed to you:

Staff time is easy to leave out, because internal hours never arrive as an invoice. Enter internal hours at a loaded hourly rate next to temporary labor, so the sheet shows what it takes your own team to run the event. Travel and lodging for staff and speakers sits on its own row for the same reason.

Once the event is over, carry the Actual column into your post-event report template, where cost sits next to attendance, pipeline, and revenue.

How do you keep an event within budget?

You keep an event within budget by updating the Forecast column before each contract deadline, while the quantity in that contract can still change. Meal guarantees, room blocks, AV sets, and temporary staff are all sized before the final headcount is known, and each has a date after which the number is locked.

The commitment calendar

The deadlines below are typical ranges. Your venue and supplier contracts set the real dates, so check each contract before you rely on them.

Schedule a forecast review one week before each deadline. The rows run in the order the decisions usually arrive, from the room block review to meal guarantees in the final week.

The attendance forecast behind the Forecast column

A budget built on today's registration count runs low because many people register late. The Maritz Registration Insights Report, which analysed 360,000 registrations across 30 trade shows over three years, found that in 2023 45% registered in the final 4 weeks, more than a quarter in the final two, and 9% on site (PCMA Convene). Those are trade shows, so treat the shape as a warning rather than as your own curve. Use your own history to project the final number:

Rebuild it every week from 6 weeks out, and every month before that. Conference registration forecasting turns the same formula into a range you can sign contracts against.

Event budget example: a 1,200-attendee conference

The numbers in this example are invented to show the method. An association plans a conference for 1,200 paid registrations at an average net price of $520, with $180,000 in sponsorship. Fixed costs are $360,000. Variable costs are $200 per attendee ($180 food and beverage, $20 print and badges), so $240,000 at plan. Planned costs total $600,000, planned revenue $804,000, planned net $204,000. Break-even attendance is ($360,000 − $180,000) ÷ ($520 − $200) = 562.5, so 563 attendees.

Past events had 45% of final registrations in at 6 weeks, 57% at 4 weeks, and 75% at two weeks, close to the Maritz pattern above.

Six weeks out. Registrations stand at 486. Forecast: 486 ÷ 0.45 = 1,080, which is 120 below plan. Sponsorship is $140,000 signed plus $80,000 in two open deals at 50%, so the forecast stays at $180,000. At the AV deadline the team drops one breakout room, and AV goes from $95,000 to $86,000.

Four weeks out. Registrations are 621. Forecast: 621 ÷ 0.57 = 1,089, rounded to 1,090. The team makes 3 decisions.

• Room block. The contract holds 1,200 nights at $249 with an 80% pickup threshold, so the association must pick up 960 nights. Forecast pickup is 850, a shortfall of 110 nights, or $27,390 of exposure. The contract allows releasing up to 110 nights at the 30-day review, and the team releases all 110. The block becomes 1,090 nights and the threshold 872 (1,090 × 0.80). Pickup of 850 still falls 22 nights short: 22 × $249 = $5,478 in attrition. Releasing a night lowers the obligation by only 0.8 of a night, so clearing the shortfall would have taken 138 released nights, a release allowance to ask for in the next contract.
• F&B minimum. The contract carries a $200,000 food and beverage minimum. At 1,090 attendees, F&B is 1,090 × $180 = $196,200, which leaves $3,800 the hotel would bill anyway. A sponsor who wanted a reception gets one: it costs $12,000 and the sponsor pays $15,000. F&B forecast becomes $208,200, above the minimum. Compared with paying the minimum for nothing, net improves by $15,000 − $8,200 = $6,800.
• Print. The print run is set at forecast plus 5%: 1,145 × $20 = $22,900, instead of $24,000.

Two weeks out. Registrations are 818. Forecast: 818 ÷ 0.75 = 1,090.7, so 1,090 holds. Temporary staff are locked at 14 instead of 16, saving 2 × $1,200 = $2,400. One open sponsorship deal signs at $40,000 and the other is lost. With the $15,000 reception, sponsorship is $140,000 + $40,000 + $15,000 = $195,000.

Here is the budget the CFO sees 2 weeks before the event:

Registration fees are 818 × $520 = $425,360 signed and paid, with a forecast of 1,090 × $520 = $566,800. The contingency stays in the forecast until the event is over; the attrition charge sits on its own row, where the board can see it. The forecast net is $176,622 against a planned $204,000. The rows account for the whole $27,378 gap: $57,200 less registration revenue, offset by $15,000 more sponsorship and $14,822 lower costs. The room block and F&B decisions behind those rows were made at the four-week review, before either contract date passed.

To test what the same event returns once pipeline and closed revenue are in, run the inputs through the event ROI calculator, and read the event ROI guide for the cost and attribution choices behind that figure.

Where EventIQ fits

EventIQ replaces nothing. It connects on top of the platforms you already run: registration and ticketing (Cvent, Zoom, Swapcard, StubHub), CRM (Salesforce, HubSpot, GoHighLevel), and marketing (Google Ads, Meta Ads, LinkedIn Ads, Mailchimp, Google Analytics). Platforms with an API outside that list are connected on request.

Registrations and attendance stay separate records. Contacts are matched by exact email, and every record keeps its result: matched, unmatched, or no email. Salesforce deals, stages, and close dates link to an event through a campaign relationship you confirm. Marketing spend sits by event and channel, with the author of every change. Records sync on a schedule: Swapcard every 15 minutes, Cvent every 30, Zoom every 2 hours, Salesforce every 4. The Event Dashboard and the Portfolio Dashboard show them in one view, and a forecast is visible before the event.

EventIQ holds marketing spend by event and channel. Venue, food and beverage, audiovisual, travel, and staff time stay in your budget file; the template on this page is where they meet the spend EventIQ already records.