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

A 60-room city hotel in Prague spent eight months in 2024 chasing a forecasting tool because the GM was certain occupancy forecasts were drifting. By the end of the year the same property had abandoned the tool and gone back to a weekly spreadsheet review by the revenue manager. The reason was not that the tool failed. The reason was that the revenue manager had not previously been doing the spreadsheet review at all. The discipline, not the software, was what was missing. After the tool was abandoned the spreadsheet review continued, and forecast accuracy improved materially, consistent with Cornell SHA research on the role of disciplined operator review in forecast quality.

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. According to Cornell SHA revenue-management research, OTB is the input every forecast starts from; everything else is modelling around it.

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.

Dedicated revenue management resource. Properties without a dedicated revenue manager will not extract RMS value. The RMS makes recommendations; someone has to accept, override, or recalibrate them. According to Hotel Tech Report’s 2025 RMS adoption data, properties without a named revenue manager see RMS deployments underperform vendor benchmarks by 40-60%.

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.

Duetto: the enterprise standard for mid-scale independents and chains. According to Duetto’s customer base, the platform serves 7,000+ properties. Pricing starts USD 1,200 per month and scales by room count and feature tier.

IDeaS G3: SAS-owned, enterprise-grade RMS used at major chains. According to IDeaS’ customer page, serves more than 30,000 properties globally. Pricing is enterprise-tier, typically USD 1,500-3,500 per month for independent groups.

RateGain: RateGain Revenue Manager (RG Optix) targets independents and chains needing distribution-aware rate optimisation. Pricing is quote-based, typically falling in the USD 600-1,500 per month range for mid-scale independents.

Atomize: Swedish-built, focused on independent and small-chain hotels. According to Atomize’s product page, the platform is positioned as a more accessible RMS for boutique-scale properties. Pricing is quote-based, typically USD 400-900 per month.

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

For an 80-room independent doing roughly EUR 3M in annual room revenue, RMS investment of USD 6,000-15,000 per year typically delivers meaningful first-year RevPAR lift per vendor-published case studies at Duetto and IDeaS, declining in subsequent years as the property’s pricing approaches optimal.

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.

Ignoring channel-mix shifts. A property whose OTA share has shifted 10 percentage points in 12 months cannot use last-year-same-date OTB as a clean comparison; the booking-curve shape changed when the channel mix changed. Adjust for this or your pace comparison misleads.

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 separating segments. Total OTB obscures whether the lift is coming from group bookings, OTA leisure, direct corporate or walk-ins. Each segment has its own pickup curve and each responds differently to rate changes. According to STR 2025 segmentation analysis, properties forecasting by segment produce materially more accurate final forecasts than total-only forecasting.

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.

AI-driven event detection. Per Lighthouse’s 2024 rate-intelligence report, AI-augmented event scrapers now detect city-level events (conferences, concerts, sports) with higher recall than manual calendar maintenance. Properties using Lighthouse or similar tools see event-date occupancy lifts roughly 40-60% more reliably than properties relying on manually-maintained event calendars.

Real-time competitive pricing intelligence. Rate-scraping tools (Lighthouse, OTA Insight, Rate Tiger) push competitor-rate data in real time. According to Hotel Tech Report’s 2025 rate-intelligence benchmarks, independents using real-time rate intelligence see 6-10% RevPAR lift over properties relying on weekly manual rate checks.

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

The independent hotels with the most accurate forecasts share four habits: they pull OTB and rate data twice weekly (not daily, not monthly), they segment forecasts by 4-6 booking categories, they reconcile forecast-versus-actual every Tuesday for the closed week, and they maintain a property-specific pickup curve from at least 18 months of historical data. The discipline is what produces accuracy; the tooling supports it.

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.