Free Hotel Occupancy Forecast Excel Template for 2026

How to use the template

1. Review the property assumptions

Start on the Assumptions sheet. Enter the property name, default total rooms, target occupancy, high- and low-occupancy thresholds, default forecast ADR, and attention thresholds. Adjust the Monday-through-Sunday baseline occupancy percentages to reflect the property's normal demand pattern.

Check the four assumption review messages. They test whether the occupancy thresholds are in the correct order, percentage settings are within 0% to 100%, and default room inventory is greater than zero.

2. Enter one row for each forecast date

Use the Daily Forecast sheet for daily operating inputs. Each row can include:

• Forecast date, demand notes, and source reference
• Total rooms and out-of-order rooms
• Transient and group rooms on the books
• Expected pickup rooms and event demand adjustment
• On-the-books ADR or a forecast ADR override

Expected pickup may be positive or negative, allowing the team to reflect anticipated booking growth, wash, or cancellations. Out-of-order rooms reduce sellable inventory before occupancy is calculated.

3. Review the calculated forecast

The model combines rooms on the books with the day-of-week baseline, expected pickup, and event adjustment. The result is capped at sellable rooms. Review model forecast occupied rooms, final forecast occupied rooms, pickup still needed, forecast occupancy, occupancy to target, forecast ADR, room revenue, and RevPAR.

If management has a documented reason to replace the model result, enter a management occupied rooms override. That override becomes the final forecast while remaining capped at sellable inventory. A separate ADR override can replace the on-the-books or default ADR used in the revenue forecast.

4. Set the Dashboard reporting period

Enter a report start date and report end date on the Dashboard. A date-range check confirms whether the period is ready or whether the dates need correction. The sheet summarizes period KPIs and operational alerts, then lists daily sellable rooms, rooms on the books, final forecast, occupancy, target occupancy, ADR, room revenue, and on-the-books occupancy.

5. Add actual results after each business date

Enter actual occupied rooms and actual ADR on the Daily Forecast sheet. The workbook calculates actual occupancy, actual room revenue, occupied-room variance, occupancy forecast error, and revenue variance. This creates a consistent record for reviewing forecast performance over time.

What does the hotel occupancy forecast calculate?

The Daily Forecast sheet first subtracts out-of-order rooms from total rooms to determine sellable rooms. It adds transient and group reservations to calculate rooms on the books and on-the-books occupancy.

The model then considers the relevant day-of-week baseline, expected pickup, and event demand adjustment. It prevents the model result from falling below zero or exceeding sellable rooms. The final result supports calculations for forecast occupancy, ADR, RevPAR, and room revenue.

Pickup still needed shows the difference between final forecast occupied rooms and rooms already on the books. Occupancy to target compares forecast occupancy with the default target entered on the Assumptions sheet.

How can hotel departments use the daily outlook?

Revenue and sales teams can review transient and group pace, pickup expectations, event adjustments, and ADR. Front office and housekeeping can focus on dates approaching the high-occupancy threshold, while engineering can review days affected by out-of-order inventory.

The Dashboard counts dates above the high-occupancy threshold, below the low-occupancy threshold, and containing out-of-order rooms. It also identifies dates forecast above sellable inventory and past dates missing actual results. These exception-based checks help the team direct attention to dates that need discussion.

How should forecast assumptions be maintained?

Assumptions should reflect current property conditions rather than remaining static. Review the default room count whenever available inventory changes, and revise weekday baselines when booking patterns materially shift. Thresholds should represent the occupancy levels that prompt action at the property.

The default forecast ADR is used when neither a daily on-the-books ADR nor a forecast ADR override is entered. The high-occupancy threshold must be greater than the low-occupancy threshold, while occupancy and forecast-error settings must remain between 0% and 100%.

How does the workbook support forecast accuracy reviews?

After a business date, enter actual occupied rooms and actual ADR. The workbook derives actual occupancy and room revenue, then compares them with the final forecast. Available measures include occupied rooms variance, absolute occupancy forecast error, and revenue variance.

The Dashboard reports average forecast variance for dates with actual occupied-room entries. The Daily Forecast sheet also includes an operational check that identifies a missing actual result for a past date. Regular entry of actual operating results gives managers a clearer basis for reviewing assumptions and pickup estimates.