How to forecast the budget for an event portfolio
Each event has its own budget, and the finance committee wants to know what the whole year will cost and when the money moves.
The short answer
A portfolio forecast stacks every event's budget into one table with three columns of certainty: committed, expected and open. Add the month cash is likely to leave or arrive, and keep the forecast live by updating it when a quote, a deposit or a date changes.
The forecast is only as good as the status of each line. Tax treatment, accounting policy and approvals belong to your finance team, so put those as questions for them rather than assumptions in the sheet.
Classify every line by certainty
| Level | Meaning | Example |
|---|---|---|
| Committed | Signed or paid. Cancelling would still cost money under the agreement. | Venue deposit paid, signed AV contract. |
| Expected | Quoted or planned, with a named source, but not yet binding. | Catering quote received, registration income based on last year's range. |
| Open | An estimate with no quote or an unresolved decision. | Printing, speaker travel, a venue not yet chosen. |
Build the portfolio view
- Put each event's budget lines into one sheet with columns for event, line, amount, level, and expected month of payment or receipt.
- Ask finance how tax and service charges should be shown, and apply the same treatment to every event. Note it at the top of the sheet.
- Total by month and by level to see committed spend, expected spend and what is still open.
- Add a column for income lines with the same levels. Treat income as expected or open until it is received.
- Compare the monthly cash total with the bank position the finance committee works from.
Keep it live
- Update when a quote arrives, a deposit is paid, a date moves or an event is dropped.
- Record the date and reason of each change so the committee can see how the forecast moved.
- Review monthly with finance, and after each event compare forecast with actual for each line to improve the next one.
- Keep one version. Copies kept by each event owner drift apart quickly.
Where forecasts mislead
- Income counted as certain before it arrives, such as registrations that are still open.
- Costs shared across events, such as a website or a member system, counted in none or counted in all.
- Contingency hidden inside lines so nobody can see it. Show it as its own line and name who can release it.
- A date change that moves a payment into a different financial year, with nobody telling finance.
Worked example · Fictional example
Three events, one table
Fictional organisation and figures in ringgit, for illustration only.
Persatuan Fiktif Jurutera Bangunan has an annual conference, a regional briefing and an awards evening. Finance asked for the cash view by quarter.
The table shows that committed costs in the third quarter are RM 38,000, expected costs RM 52,000 and open costs RM 20,000. The committee sees that a decision on the briefing venue moves RM 12,000 of open costs into expected, so it schedules that decision first.
| Event | Q3 committed (RM) | Q3 expected (RM) | Q3 open (RM) | Q3 income expected (RM) | Biggest open decision |
|---|---|---|---|---|---|
| Annual conference | 30,000 | 35,000 | 8,000 | 20,000 | Final venue layout |
| Regional briefing | 5,000 | 10,000 | 12,000 | 6,000 | Venue choice |
| Awards evening | 3,000 | 7,000 | 0 | 4,000 | None |
| Total | 38,000 | 52,000 | 20,000 | 30,000 |
Use this yourself
Portfolio budget forecast worksheet
One row per budget line. Use the same level definitions across events and review with your finance team.
| Event | Line | Cost or income | Amount | Level (committed / expected / open) | Expected month | Source (quote, contract, estimate) | Last updated and by whom |
|---|---|---|---|---|---|---|---|
Handle it in-house, or bring in help?
Your team can usually handle this when
- Finance already uses a simple monthly cash view.
- Each event owner can state which lines are committed.
- Two or three events have budgets of similar structure.
Outside planning help earns its fee when
- Events keep separate budgets with different treatments of tax and charges.
- Committee decisions keep changing the numbers and nobody can say what moved.
- A recurring programme needs forecast and actual compared across years.
Want one forecast the committee can read?
A recurring programme manager can keep the portfolio forecast current alongside finance, flag lines whose status has changed and prepare the monthly view for the committee. Accounting treatment, tax questions and spending approval stay with your finance team and committee. The event recurring calendar capacity planner shows when the work behind the money falls.
Questions organisers ask
Should income be in the same forecast as costs?
Yes, with the same three levels. Treat income as expected or open until it arrives, so the cash view does not look better than it is.
How do I handle tax in the forecast?
Ask your finance team or accountant how amounts should be shown and apply it consistently. Do not decide tax treatment in the event sheet.
How often should the forecast be updated?
Whenever a status changes, and reviewed monthly with finance. During a heavy quarter, a weekly check against open quotes is useful.
Where does contingency go?
Show it as its own line, with the name of the person who can release it. Hiding it inside other lines makes the portfolio total hard to read.
Related resources
Content record: Draft. Written from the cited sources and checked by automated rules; not yet independently reviewed.