Forecasting Event Revenue Across a Hotel Group: Pipeline, Budget, Last Year and Weekly Versions

How to build an event revenue forecast for a hotel group from the sales pipeline, compare it with budget and last year, and track it with weekly versions.

5 October 2026·4 min read·Staybase

Event revenue is hard to forecast. Weddings are booked a year or more ahead, conferences change numbers late, and a single large enquiry can move a month's figures. In a group of hotels, each sales team often keeps its own spreadsheet, and the group view is assembled by hand every week. This guide explains how to build a forecast that is consistent across hotels, comparable with budget and last year, and honest about its own accuracy.

Forecast by event month, not booking month

The first rule is to place revenue in the month the event takes place, not the month the booking was made. A wedding confirmed in March for next August is August revenue. Forecasting by booking date tells you about sales activity; forecasting by event date tells you what the hotel will earn and when.

The building blocks

A useful event forecast shows, for each month of the financial year:

RowWhat it contains
BudgetThe target agreed at the start of the year.
Last yearActual event revenue for the same month last year.
DefiniteConfirmed business, with contract and usually deposit.
Tentative or contractedBusiness that is agreed but not yet fully confirmed.
ProvisionalClients holding dates who have not yet committed.
EnquiryOpen enquiries with an event date and an estimated value.

Showing each stage separately is more useful than a single total. A month with a large enquiry value but little definite business is a risk, not a comfort.

Where it matters, split the figures by segment. Weddings and conference and banqueting behave differently: different lead times, different conversion and different seasonality. Forecasting them together hides both patterns.

Weighted and unweighted views

An unweighted pipeline adds up every enquiry at full value. A weighted pipeline multiplies each lead by the likelihood of winning at its stage.

For example, if August has £40,000 definite, £20,000 provisional and £30,000 in enquiries, and your team uses 60% for provisional and 20% for enquiries, the weighted view is £40,000 + £12,000 + £6,000 = £58,000. The probabilities are your own; review them once a year against what actually converted.

Consistency across a group

A group forecast only works when every hotel feeds it in the same way. Agree:

If one hotel calls a signed contract "Definite" and another calls it "Confirmed", the group totals mix two different things.

Manual adjustments, with reasons

A forecast built from the pipeline is only as good as the data in it. Sometimes the sales team knows more than the system: a client has confirmed verbally, or a large conference is likely to reduce its numbers. Allow adjustments, but require a short reason for each one and make them visible. An adjustment without a reason is impossible to review a month later.

Weekly versions and accuracy

A live forecast changes every day. To see how it is moving, save a version at the same point each week, for example every Monday morning, and name it by week. Comparing this week's version with last week's shows which months improved and which slipped.

Over time, saved versions also show how accurate the forecast was. Comparing what you forecast three months ago with what was actually won tells you whether the team tends to be optimistic or cautious. One common measure is MAPE, the mean absolute percentage error: the average size of the monthly misses as a percentage, regardless of direction.

A weekly forecast routine

  1. Each hotel updates lead values, stages and event dates.
  2. Sales managers review large movements and add adjustments with reasons.
  3. The group view is checked against budget and last year by month and quarter.
  4. A version is saved and shared with the leadership team.
  5. Once a month, past versions are compared with actual results.

Summary

How Staybase handles this

Staybase Sales & Events includes a Group forecast under Reports. It shows the financial-year forecast for each hotel and for the group, built live from lead values by event month and split into Conference and Banqueting and Wedding. Rows include Budget, Definite, Tentative / Contracted, Provisional, Enquiry and last year, with differences and quarter totals. Clicking a live figure shows the leads behind it.

Budgets and last-year figures are entered per hotel; the Group tab is the sum of the hotels. Live rows can be adjusted with a reason, marked with a dot, and reset to live at any time. Save version stores a named snapshot, such as Week 37, and cells that differ from the live forecast are highlighted. The Accuracy tab compares a saved version with what was won, by month, with variance and MAPE. The forecast exports to Excel, and a weekly email can be scheduled, with a version saved automatically before each one.

Stage mapping, the first month of the financial year and the forecast segment for each event type are set in Settings, and permissions separate viewing from editing. Each stage can carry its own win probability for the weighted forecast on dashboards.

To see the group forecast on a real pipeline, book a demo at staybase.co.uk.

See it with your own hotel in mind

An online demo, focused on the modules you choose.

Book a demo