Event budget vs actual: how to see the gap before it surprises you

Budget vs actual for an event isn't the same problem as budget vs actual for a project. A project's costs mostly come from one place, on a rough schedule you control. An event's costs arrive from four or five different people — the person who booked flights, the one who paid the stand deposit, whoever expensed the hotel — over the two or three months around the event, in whatever currency each invoice happened to be in. The gap doesn't show up as one big miss. It shows up as several small ones that nobody adds together.

The four numbers to track, per event

Planned cost. What the budget said before the event happened, line by line — registration, travel, accommodation, stand or sponsorship.

Actual cost. What was actually invoiced, updated as each cost comes in rather than reconstructed afterward.

Variance. Actual minus planned, per line and in total — the number that tells you whether next year's budget needs to change, not just whether this year went over.

Cost per attendee. Actual cost divided by people who attended, not people who were invited. It's the number that makes two differently-sized events comparable.

A simple method, with the free template

This doesn't need a system before it needs a habit: record the planned cost before the event, and update the actual column the day each invoice lands — not in a batch three weeks later, when the source of a cost is easy to forget. The Trade Show Budget & Attendance Tracker is built around exactly this rhythm, with the variance calculated automatically once both columns are filled in.

Not ready for software? Take the spreadsheet.

The Trade Show Budget & Attendance Tracker is the file we would build if we had to do this in Excel: budget vs actual per event, an attendee list, a pre-show checklist and a cost-per-attendee calculation. It is free, it works, and it is yours whether or not you ever open Convenio.

Free trade show budget template and conference attendance tracker, downloadable as an Excel spreadsheet. Track expected versus actual event budget, attendee lists and no-shows, and cost per attendee for any trade show or conference.

We'll email you the file. No sequence, no calls.

Reading the trend across more than one event

One event's variance tells you what happened. It's only useful going forward once you can see it next to last quarter's and last year's — the same line item running consistently 10% over, one event type that always comes in under budget, a team whose events cost more per attendee than everyone else's. That comparison is where a spreadsheet per event stops being enough: it means opening several files and lining up rows by hand, and it's exactly the report a tool like Convenio builds automatically once the same numbers are entered event by event — budget vs actual per event, per team or per quarter, without rebuilding a pivot table each time. Once the trend is visible, the next question is usually whether the events were worth it at all.

Not ready for software? Take the spreadsheet.

The Trade Show Budget & Attendance Tracker is the file we would build if we had to do this in Excel: budget vs actual per event, an attendee list, a pre-show checklist and a cost-per-attendee calculation. It is free, it works, and it is yours whether or not you ever open Convenio.

Free trade show budget template and conference attendance tracker, downloadable as an Excel spreadsheet. Track expected versus actual event budget, attendee lists and no-shows, and cost per attendee for any trade show or conference.

We'll email you the file. No sequence, no calls.

Questions