Hotel Sales Forecast Template

Start with the Assumptions sheet. Enter your total available rooms, your ADR targets by guest segment (transient, corporate, group), and your expected occupancy rates by month. If you have historical PMS data, use last year's actuals as your baseline — even rough estimates get you 80% of the way there on the first pass. Then fill in your F&B, meeting, and ancillary assumptions using revenue-per-occupied-room benchmarks. For a full-service hotel, F&B revenue typically runs $25–$60 per occupied room per night depending on your outlet mix. Most properties complete the Assumptions sheet in 30–45 minutes.

Once your assumptions are set, review the Monthly Forecast to sanity-check the numbers. Compare your projected RevPAR to your competitive set or last year's performance — if something looks off, trace it back to the assumption driving it. Apply seasonal adjustment factors for months where you know demand shifts significantly: summer leisure peaks, December holidays, the January valley. Fill out the Scenario Comparison sheet with a conservative downside (occupancy 10–15 points below base) and an optimistic upside, then check whether the range brackets your realistic expectations. This step adds 20 minutes but makes the forecast far more defensible.

The ongoing value is in the Actual vs Forecast sheet. After each month closes, pull your PMS rooms revenue, POS F&B totals, and event revenue from your sales system and enter them alongside the forecast. The variance calculations immediately show which departments are tracking to plan and which aren't. If rooms revenue is consistently coming in 8% below forecast, your ADR assumption may be too aggressive, or your OTA channel mix may be running higher than planned. Reviewing this sheet monthly takes 20–30 minutes and gives your revenue manager concrete data to adjust pricing and channel strategy going forward.

Hotel revenue forecasting is different from most industries because a single property generates revenue across multiple departments simultaneously, and those departments behave differently. Rooms revenue is driven by occupancy and ADR — two variables that move in opposite directions when you discount to drive volume, creating a leverage dynamic that isn't obvious without modeling it explicitly. F&B revenue scales with occupied rooms but is also influenced by outlet mix and events on the books. Meeting and event revenue can spike your ADR-equivalent for group blocks while filling your restaurant and bar on shoulder nights. Without a forecast that captures all of these interactions, you're managing each department in isolation.

The highest-leverage metric in hotel forecasting is RevPAR — Revenue per Available Room — because it captures both the rate and the volume dimension simultaneously. A property running 90% occupancy at $120 ADR (RevPAR: $108) is generating more revenue than one running 70% occupancy at $150 ADR (RevPAR: $105), even though the second has a better rate. Segmentation matters too: transient leisure guests book through OTAs with 15–25% commission, eroding your net ADR; corporate negotiated accounts book at a fixed rate with no commission; group blocks lock in room revenue early but require F&B minimums. A well-built forecast models these segments separately so you can see what your channel mix is actually doing to your effective revenue.

The forecast becomes an operational management tool when you compare actuals against it monthly and use the variances to guide decisions for the months ahead. If January rooms revenue came in $18K below forecast, the question is whether that was an occupancy problem (fewer rooms sold than projected) or an ADR problem (more discounting than planned). Each has a different response: an occupancy shortfall might mean adjusting distribution strategy or promotional packages; an ADR shortfall might mean reviewing your rate parity or shifting your channel mix toward direct bookings. This template is built to surface those distinctions by department and by driver so your revenue manager has data to act on rather than a single total number.