Friday afternoon is forecast afternoon
Every Friday, your events sales manager exports the diary, pastes it into the forecast spreadsheet, removes cancelled bookings that are still in the export, guesses which provisional holds will convert, adds a few enquiries they feel good about, and sends it to the general manager. It takes a couple of hours. On Monday, the owner asks why October looks lower than last week, and nobody can quite say which change caused it.
The forecast is the most important number the sales team produces, and it is rebuilt from scratch each week by hand.
The diary was not built to forecast
Booking systems are good at holding bookings. They are less good at showing revenue by month and status, comparing with last year at the same point, or explaining what changed. Revenue for an event also changes as numbers, packages and extras change, so a snapshot taken at booking stage goes stale.
- Confirmed, provisional and enquiry stages are mixed in exports.
- Revenue per booking changes as numbers change, but the forecast does not follow.
- Last year's position at the same date is not stored, so comparisons are guesses.
- Bedroom revenue for residential events sits in another system.
- Nobody can see what moved between two weekly versions.
Decisions made on a number nobody trusts
Owners use the forecast to plan staffing, marketing and cash. If it is wrong or cannot be explained, they either ignore it or overreact to it. The sales manager spends time producing numbers instead of selling. A forecast that includes provisional holds at full value can make a quiet quarter look healthy until it is too late to do anything.
How we build a live on-the-books forecast
- Bookings, holds and enquiries are read from your booking system on a schedule, with their current value, date and status.
- Each is placed in a stage: confirmed, provisional, pipeline. You choose how much weight provisional and pipeline business carry, and the forecast shows both raw and weighted figures.
- Revenue follows the booking. When numbers or packages change, the forecast changes with them.
- A snapshot is saved each week, so you can compare with last week and with the same point last year.
- A movement report lists what changed: new confirmations, cancellations, value changes and holds released.
- Bedroom revenue linked to events can be included from your property management system if you want a combined view.
| Month | Confirmed | Provisional | Pipeline | Same point last year |
|---|---|---|---|---|
| Next month | From confirmed bookings | From holds | From live enquiries | From last year's snapshot |
| Following month | As above | As above | As above | As above |
| Quarter ahead | As above | As above | As above | As above |
The weights you apply to provisional and pipeline business are your judgement. The system makes that judgement explicit and applies it consistently.
A Monday that starts with answers
The general manager opens the forecast at any time and sees it current. When a month moves, the movement report says why: a conference cancelled, two holds released, one large booking confirmed. The sales manager's Friday is spent on the pipeline rather than on the spreadsheet.
Signs your venue needs this
- The forecast is rebuilt by hand from a diary export.
- You cannot easily compare with the same point last year.
- Nobody can explain why a month moved between weeks.
- Provisional business is counted at full value.
- Event and bedroom revenue are reported separately.