Hotel Revenue Forecasting 2026: Pickup, Pace, and the Math Independent Hotels Actually Need

Correction (November 3, 2026): Unsupported statistics, illustrative anecdotes presented as observations, and unverified price estimates have been removed. The remaining guidance describes evaluation steps; it does not promise a measured result.

This is the unglamorous reality of hotel revenue forecasting for independents. The expensive tools matter less than the question “is anyone actually looking at booking pace every week?” For most properties under 100 rooms, the math is simple and the bottleneck is operational discipline rather than algorithmic sophistication.

This guide is for the 30-150 room independent hotel that wants to forecast revenue more rigorously without buying enterprise-grade RMS. It covers the core concepts (pickup, pace, on-the-books versus final forecast), the spreadsheet methodology that works for most independents, when an RMS is actually worth the spend, and the five pitfalls that waste forecasting effort.

The Three Concepts That Matter

Most forecasting jargon distracts from three core ideas.

On-the-books (OTB). What is confirmed for future dates today. The eCornell forecasting and availability-controls course covers booking curves and pickup as the base inputs for hotel revenue forecasts; OTB is the snapshot every forecast starts from.

Pickup. New bookings added during a specific period for future arrivals. Typically measured at 30, 14, and 7 days out. If a Saturday three weeks away has 40 OTB on Monday and 47 on Friday, that week saw 7 pickup for that Saturday.

Pace. Cumulative bookings on the books compared to historical patterns. If your Saturday-three-weeks-out OTB matches last year’s same-date-same-time OTB exactly, you are “on pace.” If meaningfully higher, you are “ahead of pace”; if meaningfully lower, “behind pace.” See Lighthouse rate-intelligence pace methodology for the standard ranges most independents use.

The combination is the forecast: today’s OTB plus expected future pickup based on pace versus historical pickup curves equals the final forecast.

The Spreadsheet Methodology That Works

For independent hotels under 100 rooms with two years of clean PMS data, a weekly spreadsheet forecast outperforms most off-the-shelf RMS tools at zero software cost. The methodology has four columns.

Column one: target date. Each future date you are forecasting. For most independents this is the next 60-90 days.

Column two: current OTB. Pull from your PMS daily or twice-weekly. Cloudbeds, Mews, RoomRaccoon and most cloud PMSes export this directly.

Column three: same-day-same-time prior year OTB. This is the comparison anchor. If today is March 15 and you are forecasting Saturday April 5, the comparison is “what was OTB for the equivalent Saturday in 2024 on the equivalent day-out-from-arrival.” Most PMSes can be queried for this; if not, maintain a parallel spreadsheet that records OTB weekly for future reference.

Column four: variance from pace. Current OTB minus prior-year-same-time OTB, expressed as percentage. Above a few points ahead of pace, you can consider raising rates. Materially behind pace signals a promotion window. The exact thresholds vary by property; see STR pace-analysis methodology for industry guidance.

This is the entire methodology. The work is the discipline of doing it weekly, not the complexity of the math.

When an RMS Actually Pays Back

A Revenue Management System (RMS) earns its cost when three conditions are true at once.

Property scale above 80-100 rooms. Below this, the volume of bookings does not produce enough signal to justify algorithmic decisions; weekly human judgement works. Above this, the volume produces enough signal that automation catches patterns humans miss.

Year-round demand variability. Properties with strong daily and weekly variation in demand (urban hotels with corporate-leisure mix, resort destinations with event-driven peaks) get more from RMS than properties with smooth seasonal patterns.

Below all three thresholds, the spreadsheet method works. Above all three, the RMS investment pays back. In between, the call is judgement. For how forecasting sits inside the wider independent stack alongside the PMS, channel manager, and rate-optimization layers, see the boutique hotel technology guide.

The RMS Market in 2026

For independent hotels above the 80-room threshold considering an RMS, the shortlist is shorter than the marketing materials suggest.

LodgIQ: US-led, with strong machine-learning positioning. Pricing is quote-based.

Five Forecasting Pitfalls

Three patterns waste forecasting effort, regardless of whether you use a spreadsheet or RMS.

Treating yesterday’s OTB as the forecast. OTB is a snapshot; the forecast needs to project remaining pickup. Properties that treat OTB as the forecast consistently underestimate final occupancy on dates more than 30 days out and overestimate on dates inside 7 days.

Forecasting too far out. Beyond 90 days, the booking pace curve flattens and the forecast becomes a guess. Most independent hotels forecast 60-90 days out maximum; beyond that, scenario-plan rather than forecast.

Not reconciling forecast versus actual. A weekly forecast that is never compared to actual final results becomes a guess on rinse-and-repeat. Disciplined revenue managers reconcile every Tuesday, comparing the previous week’s forecast for the now-closed dates against actuals, and adjust pickup-curve assumptions accordingly.

What 2026 Adds

Two new trends are reshaping forecasting for independents.

Both trends mean that even properties below the 80-room RMS threshold can extract more forecasting value than they could three years ago, at lower cost. The 2026 baseline for a 50-room independent is no longer “spreadsheet only;” it is “spreadsheet plus rate intelligence.”

Pattern That Works

Choose a forecast review cadence and segment structure that the team can maintain. Reconcile forecasts against actual stays and record how missing history or changed trading conditions affect the result. This article does not establish a best-performing hotel cohort or a universal minimum history.

For deeper context on revenue management beyond forecasting, see revenue management dynamic pricing for small hotels 2026. For the RevPAR math forecasting feeds, see the RevPAR forecast calculator.