Saltar al contenido principal

Guide

Event budget vs actuals: how to track a live show

Track budget vs actuals line by line, from the approved budget to what the show really spent, with the source of every actual. The variance per line is what tells you where the next estimate was wrong.

By Pedro van Tol, founder of ShowOps.AI and an executive producer for 15 years

To track event budget vs actuals, keep one budget per show with a budgeted and an actual amount on every line, record actuals as they become known rather than after the show, and note where each actual came from. The variance on each line, and its cause, is what tells you where the plan was wrong and what to change in the next estimate.

A budget that only gets compared with reality at wrap is a report on the past. One that fills in during the build is a tool you can still act on.

The columns that matter

ColumnWhat goes in it
CategoryLabor, equipment, venue, travel, production and so on. Keep the same categories from estimate to wrap.
Line descriptionSpecific enough to match an invoice: "LED wall, 3 days," not "video."
BudgetedThe approved number. It does not change when spending does.
ActualWhat the line cost or will cost, updated as soon as it is known.
VarianceActual minus budgeted. Positive is over budget.
SourceWhere the actual came from: a crew booking, a vendor contract, a shipment, a manual entry.
ReasonFor any line over a threshold you set, one line on why.

Five habits that keep actuals current

  1. Lock the budget you approved. Save it as a version and compare against it. A budget you keep editing cannot tell you what changed.
  2. Record change orders separately. A client-requested addition is not an overrun. Keep it as its own record so the variance shows the difference.
  3. Take crew actuals from the roster. Confirmed bookings already know days, rates and per diem. Retyping them invites a second number.
  4. Note the source on every actual. "From the vendor contract" and "estimated by Jo" are different levels of certainty.
  5. Write the reason while it is fresh. At wrap nobody remembers why lighting ran over on day two.

A worked example (illustrative)

The figures below are made up for the example and do not come from any customer.

LineBudgetedActualVarianceSource and reason
Crew labor$18,400$20,200+$1,800Roster. Rehearsal added a day for two crew.
LED wall$12,000$12,000$0Vendor contract.
Freight$3,500$4,150+$650Shipment. Late-change truck.
Catering$2,800$2,450-$350Manual entry. Smaller crew meal count.

Two of the four variances trace back to one schedule change. That is the pattern to look for: a date change that nobody priced before it was confirmed.

How ShowOps.AI handles it

  • Each budget line carries a budgeted and an actual amount, and the actuals view shows the variance per line, filterable by category and by source.
  • Sync actuals pulls the latest figures from the modules that hold them: work orders, shipments and any crew cost lines already posted to the roster. Anything else is entered by hand, and every actual shows its source.
  • Budgets are versioned, change orders are their own records, and the actuals view exports to CSV.
  • When a producer confirms a timeline change, ShowOps.AI reports the staffing cost change and the budget lines linked to the crew bookings that move, before anyone approves it. An approved change updates those lines, and it can be undone. This step is switched on for each organization during setup.
  • At close-out, the debrief asks for a reason on each flagged variance, so the next estimate starts from what actually happened.

What it does not do: it does not import invoices or purchase orders, and it does not invoice the client.

For budgets, versions and change orders, see Budget. If the budget lives in a spreadsheet today, read When does an event production spreadsheet stop working?.

Frequently asked questions

What is budget vs actuals for an event?
It is the comparison, line by line, between what you planned to spend on a show and what you actually spent. The difference on each line is the variance. A variance report tells you where the plan was wrong, which is the most useful input to the next estimate.
When should actuals be recorded?
As they become known, not after the show. Crew cost is known when bookings are confirmed, a vendor cost when the contract is signed, a shipment when it is booked. Waiting for invoices means the budget is a week late every time.
Should change orders go into the budget?
Yes, as their own record against the budget rather than as a silent edit to a line. Then the variance shows whether the overrun came from a client change or from your own estimate.
How does ShowOps.AI track actuals?
Each budget line has a budgeted and an actual amount and shows the variance. Actuals can be pulled in from the modules that know them, such as work orders, shipments and crew cost lines posted to the roster, or entered by hand, and each actual shows where it came from. The view exports to CSV.
Can I model a what-if on the budget in ShowOps.AI?
Yes. A budget scenario applies assumptions, such as a different contingency, and shows the projected totals and margin as you change them. Budget scenarios are switched on for each organization during setup.

See it in your production

Talk to the team

We are happy to walk through how ShowOps.AI fits your productions, your tools, and your data requirements.