Comparing event budget with actual spend
The event is under way or over, and the committee wants to know where the money has gone against plan.
The short answer
Put approved budget, committed spend and paid spend in separate columns for each category, then calculate variance as actual minus budget. Show percentage variance only where the budget is not zero.
Commitments are orders you have placed and not yet paid. Paid is money that has left. Adding them together double counts anything you have paid, so keep them apart and add a forecast column for the final figure.
Decide what counts as actual
Before comparing, agree one definition and use it every time. Otherwise two people read the same report and reach different conclusions.
Event budget versus committed spend covers the earlier question of tracking commitments. This page is about the comparison once costs are being paid or have been paid.
- Paid: invoices settled, with the date.
- Committed: confirmed orders or signed quotes not yet invoiced or paid.
- Accrued: work delivered but not yet invoiced, if your finance team tracks it.
- Forecast: your best view of the final cost of the line.
Worksheet columns and formulas
The Event budget variance calculator applies this logic, including a clear not applicable result where the budget is zero. Enter your categories from the Event budget builder so the categories match.
| Column | What goes in | Formula |
|---|---|---|
| A. Approved budget | The figure the committee approved for the line | Entered |
| B. Paid to date | Invoices settled | Entered |
| C. Committed, not yet paid | Confirmed orders not yet settled | Entered |
| D. Actual and committed | What the line has taken so far | B + C |
| E. Forecast final cost | Your best view of the final figure | Entered, with a note |
| F. Variance on forecast | How far the line will finish from plan | E - A |
| G. Variance percentage | Only if A is not zero | F / A |
A sequence for each review
- Update paid and committed values from finance records, with the date of the extract.
- Calculate variance on every line, and sort the lines by size of variance, not by order in the budget.
- For each line off plan, write the cause in one sentence: price, quantity, scope change or timing.
- Decide which variances need a decision: absorb, reduce elsewhere, release reserve or ask for more budget.
- Record the decisions and update the forecast column so the next review starts from them.
Common mistakes
- Adding committed and paid values for the same invoice.
- Comparing actual spend to an original budget that has since been formally revised, without noting which version.
- Reporting a percentage on a line that had no budget.
- Treating a favourable variance as savings when the invoice has not arrived.
- Reviewing only at the end, when decisions are no longer possible. See Event forecast to completion for the forward view.
Worked example · Fictional example
A fictional mid-point review
Fictional organisation and figures, illustrative only.
A fictional professional body reviews its two-day seminar budget five weeks before the date. Catering shows approved RM 40,000, paid RM 5,000, committed RM 30,000, forecast RM 44,000. Variance on forecast is RM 4,000, or 10 percent.
A line for printing shows approved RM 0 because the committee assumed digital programmes, but RM 1,200 is committed after members asked for printed copies. The percentage is shown as not applicable. The committee sees both points, decides to release RM 1,200 from reserve under its release rule, and asks the catering lead to confirm the final confirmed number with the caterer before the forecast is changed again.
Use this yourself
Budget versus actual worksheet
Copy this into a spreadsheet. Enter values in A, B, C and E; the other columns follow the formulas.
- Keep one row per budget category and one total row that sums each column.
- Note the extract date at the top of the sheet.
- Add a comment column for the cause and the decision.
| Category | A Budget | B Paid | C Committed | D = B + C | E Forecast | F = E - A | G = F / A |
|---|---|---|---|---|---|---|---|
| Venue | |||||||
| Catering | |||||||
| Audio-visual | |||||||
| Printing and signage | |||||||
| Speakers and travel | |||||||
| Total |
Handle it in-house, or bring in help?
Your team can usually handle this when
- One finance contact supplies up-to-date paid figures on request.
- The budget has a manageable number of categories.
- The committee reads a one-page variance report without needing the workings.
Outside planning help earns its fee when
- Costs are spread across departments or cost centres with different reporting dates.
- No one is sure which budget version the committee approved.
- A decision on scope or reserve is needed now and the figures are not trusted.
Want the variance review run for you?
A project lead working from an Event Blueprint can maintain the budget, commitments and forecast alongside the plan, and prepare the variance summary and decisions list for each committee review. Send your current budget and the latest paid figures.
Questions organisers ask
How often should budget and actual be compared?
Monthly is usual in the months before the event, then more often in the last weeks when commitments move quickly. Link each review to a committee or finance date so it is not skipped.
Is a favourable variance always good?
Not always. It may mean an invoice has not arrived, a scope item was dropped or a quantity has not been confirmed. Ask what caused it before treating it as a saving.
What if the budget changed after approval?
Keep the approved original and the revised version as separate columns or sheets, and say which one each report uses.
Related resources
Content record: Draft. Written from the cited sources and checked by automated rules; not yet independently reviewed.