A hotel forecast is the estimate of how each date or month will close: how many rooms you will sell, at what price and with what revenue. It is not guesswork: it combines what you already have on the books with what usually comes in from today until arrival.
The basic formula
A simple forecast is built like this: current books (OTB) + expected pickup until the arrival date. Expected pickup is estimated from previous years: how much came in, at the same distance from arrival, for comparable dates.
The references you need
- Today’s OTB by stay date.
- SDLY: what was on the books on the same day last year.
- Last year’s close: how those dates actually ended.
- Budget, to measure the distance to target.
If this year you are ahead of SDLY and last year the period closed at 85% occupancy, it is reasonable to expect an equal or higher close, unless something has changed in the market.
Common mistakes
- Ignoring moving periods. Easter or an event that changes dates distorts month-on-month comparisons.
- Not netting out cancellations: useful pickup is net.
- Forecasting by month and never by day: problems usually sit on specific dates.
- Not reviewing it: a forecast is updated every week with the new books.
What it is for
A reliable forecast helps set prices, decide when to open or close rates and channels, and also supports operations: staffing, purchasing and maintenance are easier to plan when you know what occupancy is coming.
Frequently asked questions
What is the difference between forecast and budget?
The budget is the target set before the year starts; the forecast is the updated estimate of how it will actually close.
How often should the forecast be updated?
Weekly is recommended, and daily for the nearest or highest-demand dates.
Can it be done without history?
It is harder. Without daily snapshots of previous years’ books, SDLY and expected pickup cannot be calculated.
How Keymets does it
In Keymets Hotels, Booking Pace compares the books every day with SDLY, last year’s close and budget, and Special Periods avoids the mistakes caused by moving periods. It is the basis for a hotel forecast without spreadsheets. See also booking pace.
Free guide: the 10 KPIs every hotel manager should check every morning.

