Hotel RevPAR / ADR / Occupancy Reconciliation Calculator

How this calculator works

The three numbers every hotel general manager, revenue manager, asset manager, and lender reads first on a daily, weekly, or monthly performance report are Average Daily Rate (ADR), occupancy, and Revenue Per Available Room (RevPAR). These are the canonical "rooms KPIs" tracked by Smith Travel Research (STR, now part of CoStar), the American Hotel and Lodging Association (AHLA), and every hotel franchise reporting system in operation. The math is deceptively simple, but the reconciliation matters because GMs and revenue managers frequently miscompute one of the three and read the wrong story off a daily flash report.

The definitions are fixed industry conventions:

• ADR = total rooms revenue divided by room-nights sold. The price axis of the rooms business.
• Occupancy = room-nights sold divided by room-nights available. The fill axis.
• RevPAR = total rooms revenue divided by room-nights available. Equivalent to ADR × Occupancy. The single productivity metric that combines both axes into one number.

Room-nights available equals the rooms physically available to sell times the days in the reporting period — a 40-room property running 30 days has 1,200 room-nights available.

The ADR × Occupancy = RevPAR identity

The identity is algebraic, not empirical. ADR is roomRevenue divided by roomNightsSold; occupancy is roomNightsSold divided by roomNightsAvailable. Multiplying them: (roomRevenue ÷ roomNightsSold) × (roomNightsSold ÷ roomNightsAvailable) = roomRevenue ÷ roomNightsAvailable = RevPAR.

The calculator computes RevPAR two ways — directly from total revenue and via the ADR × Occupancy identity — and reports the gap as a reconciliation check. A non-zero gap signals a data-quality issue in the property management system (PMS) feed: rounding artifacts, comp-room accounting, or house-use mishandling are the typical causes. STR convention is that comp rooms (free for guests, usually for service recovery) and house-use rooms (occupied by staff for hotel business, such as a sales tour) are excluded from both the numerator and denominator. A PMS that includes comp rooms in occupancy but not in revenue will produce a reconciliation gap.

Revenue Generation Index (RGI)

RGI is the STR-standard benchmark of a property's RevPAR against the RevPAR of its competitive set:

RGI = (myRevPAR ÷ compSetRevPAR) × 100

RGI of 100 means the property is capturing its fair share of RevPAR. Above 100 means outperforming the comp set; below 100 means underperforming. The STR-convention thresholds are: 110 and above is strong share, 90 and below is weak share, 90 to 110 is parity.

STR also reports two sibling indices: the Market Penetration Index (MPI, occupancy vs comp set) and the Average Rate Index (ARI, ADR vs comp set). RGI is the combined index. Operators use the three together to diagnose whether outperformance comes from rate, fill, or both — a property with high ARI and low MPI is overcharging into a soft comp set; a property with high MPI and low ARI is overfilling at the wrong rate.

Operators use RGI to separate market-wide tailwinds (a strong city week lifts every property in the comp set) from property-specific outperformance (the property is gaining share even in a flat market). A property with rising RevPAR but falling RGI is benefiting from market drift, not management execution. A property with stable RevPAR but rising RGI is taking share from competitors — the better story for an asset manager.

This calculator approximates RGI from a supplied comp-set ADR under the simplifying assumption that the comp set runs at the property's own occupancy. The exact STR figure requires the comp set's actual occupancy, which is what hoteliers pay for in the STR subscription. Operators with a real STR subscription should use the STR figure directly; this calculator surfaces the math so non-STR subscribers can sanity-check their own performance against rate-shopped comp-set data from OTA Insight (now Lighthouse), Rate Insight, or manual rate-shopping.

Comp-set selection

The comp set is a hand-selected basket of 4 to 6 hotels that directly compete for the same guests as the property. STR allows operators to designate the comp set in the STAR report subscription. The selection criteria are:

• Same submarket. A 5 to 10 minute drive for most urban properties. A property on the north side of a city does not compete with a property on the south side for most demand.
• Same chain scale or close adjacent scale. An upper-midscale select-service hotel competes with other upper-midscale select-service. A full-service luxury property competes with other full-service luxury.
• Similar room count. A 60-room boutique inn does not compete with a 400-room convention hotel. The convention property is fishing in a different demand pool.
• Similar amenity package. A property with a full-service spa does not compete with a select-service property even at the same chain scale.

The temptation to put weaker hotels in the comp set to make RGI look better is real and counterproductive. STR auditors review comp-set selections and asset managers see through it. The right comp set produces an RGI that fluctuates around 100 over a multi-year window — outperformance and underperformance both visible in the same series.

RevPAR vs Total RevPAR vs GOPPAR

RevPAR is rooms-only. Total RevPAR (TRevPAR) includes all revenue centers: rooms, food and beverage, spa, parking, resort fees, telephone, laundry, golf, retail, and ancillary. TRevPAR is the more comprehensive total-property productivity metric and is particularly useful for full-service and resort properties where rooms revenue is less than half of total revenue. RevPAR remains the industry headline because it isolates the rooms business cleanly and because most hotels are select-service or limited-service properties where rooms revenue dominates.

GOPPAR (Gross Operating Profit Per Available Room) is a P&L line, not a top-line productivity metric. It is gross operating profit — revenue minus all operating expenses except management fees, property tax, insurance, debt service, and depreciation — divided by available room-nights. GOPPAR captures cost efficiency. A property with the same RevPAR as its comp set but better GOPPAR is running a tighter expense structure. GOPPAR requires the full Uniform System of Accounts for the Lodging Industry (USALI 11th revised edition) cost stack and is computed in the property accounting close, not in the daily flash report. This calculator surfaces the top-line KPIs that feed into GOPPAR.

Distribution and channel accounting

STR convention is to record rooms revenue at the rate the guest paid, gross of OTA commission. A $200 room booked direct and a $200 room booked through Expedia both contribute $200 to rooms revenue, even though the property nets $200 from the direct booking and roughly $170 from the Expedia booking at a typical 15% merchant-model commission. The OTA commission is recorded separately as a distribution cost line on the P&L.

This convention keeps ADR consistent across channels and is the standard every branded hotel uses. Confusing the two — recording net-of-commission revenue in rooms revenue — produces an artificially low ADR that does not reconcile against the rate sheet and breaks every benchmark comparison.

For channel-mix economics and the net-per-channel comparison, the OTA vs direct bookings calculator handles the per-booking arithmetic. The two calculators are complementary: this one captures the top-line rooms KPIs; the channel calculator captures the per-booking distribution math.

Common reconciliation issues

A non-zero reconciliation gap between the direct RevPAR computation and the ADR × Occupancy identity signals one or more of the following:

Comp-room accounting. STR excludes comp rooms from both numerator and denominator. A PMS that includes comp rooms in occupied room-nights but not in revenue produces a small under-statement of ADR and over-statement of occupancy, with a corresponding RevPAR gap.

House-use accounting. Same issue as comp rooms — STR excludes house-use rooms (rooms occupied by staff for hotel business, such as a sales site visit or a renovation crew). A PMS that includes house-use rooms in occupancy but not in revenue produces a similar artifact.

Day-stayed vs day-booked accounting. STR reports on the day stayed; some PMS systems report on the day booked or the day paid. A multi-night reservation that bridges a month-end splits differently in the two systems.

Business-day vs calendar-day cutoff. STR uses calendar days. Most PMS systems report on the hotel's business day — usually a 24-hour window from the day-audit cutoff (typically 2 to 3 AM). A late check-in after the calendar midnight but before the business-day cutoff posts on different dates in the two systems.

Package allocation. A guest paying an inclusive package — $500 for the night including breakfast and parking — has a portion allocated to rooms revenue and a portion allocated to F&B and parking revenue. STR expects a consistent allocation methodology; operators sometimes shift the allocation between periods to manage reported ADR or to optimize tax exposure on F&B vs rooms revenue (the rates differ in some jurisdictions).

The reconciliation gap output is small in dollars but useful as an early warning. A gap of more than a few dollars per available room-night warrants an audit of the PMS configuration.

ADR and occupancy benchmarks

AHLA State of the Hotel Industry data puts U.S. industry occupancy around 63% on a national annual basis, with primary markets at 70 to 75% and secondary or resort markets at 55 to 65%. Small hotels and B&Bs typically run somewhat below the brand-hotel average because they lack the loyalty-program distribution and group sales capability of branded properties.

PAII (Professional Association of Innkeepers International) industry survey data puts B&B annual occupancy in the 35 to 50% band for owner-operated properties, with top-quartile properties reaching 55 to 65% through aggressive direct-booking marketing and review-driven SEO.

STR data buckets hotels into six chain scales: Luxury (Ritz-Carlton, Four Seasons, Aman), Upper Upscale (Hyatt Regency, Westin, Le Meridien), Upscale (Hilton Garden Inn, Courtyard by Marriott), Upper Midscale (Holiday Inn Express, Hampton), Midscale (Quality Inn, Sleep Inn), and Economy (Super 8, Motel 6). Independent small hotels and boutique inns are usually classified by quality tier into one of the scales. A 30-room downtown boutique inn often runs at upper upscale or luxury ADR — roughly the $200 to $400 band in most secondary markets, $400 to $1,000 in primary markets and resort destinations. A roadside independent runs at midscale or economy ADR. Comp-set ADR rate-shopping is the right anchor; do not benchmark a downtown boutique against a Hampton Inn on the interstate.

Reporting cadence

Hotel revenue management is a real-time discipline. The reporting cadence the calculator supports:

• Daily flash report — yesterday's ADR, occupancy, RevPAR. Five minutes for the GM over coffee.
• Weekly forecast pickup — last 7 days vs prior 7, vs same week last year. Run on Monday morning.
• Monthly operating review — the full STAR-equivalent comparison including RGI vs comp set. Run within 10 days of month-end.
• Quarterly asset-management review — RGI / MPI / ARI trend, GOPPAR, capex pacing. Run within 30 days of quarter-end.
• Annual budget — the rooms KPI inputs that feed the next year's budget.

Properties that read the numbers monthly are systematically behind properties that read them daily. A small hotel without a dedicated revenue manager should still produce a daily flash report — the math runs in seconds and the discipline matters.

What this calculator does NOT model

The calculator is rooms-only. It does not compute:

• TRevPAR — requires summing all revenue centers (F&B, spa, parking, ancillary). Available to the operator from the PMS or accounting close.
• GOPPAR — requires the full USALI cost stack and is computed in the accounting close, not the flash report.
• Group vs transient mix — STR reports these separately. For properties with material group business, segment-level KPI tracking is worth the additional reporting overhead.
• Forward-looking pickup — booking-on-the-books for future stay dates. Requires the PMS forward pace file.
• Channel mix economics — the per-booking math for OTA vs direct. Use the OTA vs direct bookings calculator in this cluster.

The calculator is a planning and reporting tool. It surfaces the canonical rooms KPIs in the STR-convention format that every lender, asset manager, and franchise reporting system expects. It is not a substitute for an STR subscription, a revenue management system, or professional financial advice.