Revenue & Analytics | HotelKey Knowledge Base

📈 Revenue & Analytics Reports

Welcome to the Revenue & Analytics reporting hub. Use this page to quickly find reports for tracking property performance, booking trends, revenue forecasts, market segmentation, and pricing strategy.

Jump to a section: 📊 Performance Summaries | 🥧 Market & Segmentation | 🏷️ Rate Management | 🔭 Yield & Forecasting

👥 Who is this for?

These reports are primarily designed for:

Revenue Managers: For yielding rates, forecasting future occupancy, and analyzing business mix.
General Managers & Ownership: For high-level performance summaries, historical trend analysis, and overall property health metrics.
Directors of Sales & Marketing: For reviewing booking pace, channel performance, and tracking source of business.

📂 What you will find in this section:

To help you seamlessly analyze your property's performance, we have organized our analytical reports into four key strategic areas:

📊 Performance Summaries: Your high-level property metrics. Access the comprehensive General Manager Report, review core hotel statistics, and analyze net revenue summaries.
🥧 Market & Segmentation: Understand your business mix. Find reports detailing your source of business, local market segment breakdowns, and overall segment overviews.
🔭 Yield & Forecasting: Tools for future pacing. Track your booking pace, review occupancy and revenue forecasts, and monitor rate group pacing to stay ahead of the curve.
🏷️ Rate Management: Insights into your pricing strategies. Review rate code configurations, audit manual rate overrides, and track discrepant or zero-rate bookings.

💡 Pro Tip: If you are looking for daily operational tracking, such as expected arrivals, no-shows, or current in-house balances, please navigate to the 🛎️ Front Desk & Guest Services reporting page.

📂 Knowledge Base Articles

📊 Performance Summaries Reports

Report	What it helps you do
Add-On Revenue	Track guest-level amenity fulfillment schedules, verify digital purchase channels and dual-currency postings, and analyze add-on sales totals.
General Manager Report	Track key performance indicators, analyze occupancy, ADR, and RevPAR, and compare daily, MTD, and YTD figures against prior-year baselines.
Historical Arrivals Statistics	Review past check-in ledgers, audit corporate and group account production, analyze ARR, and track outstanding balances.
Historical Departure Statistics	Analyze completed guest departures, audit checkout timestamps, and verify zero-balance folio settlements across historical stay windows.
Historical In House Statistics	Audit historical guest profiles, evaluate length-of-stay trends, and review contact data quality and identification compliance.
Hotel Statistics	Analyze room revenue metrics, track tax and payment collections, compare MTD and YTD figures, and review forward-looking guest forecasts.
Length of Stay Statistics	Analyze stay durations, evaluate occupancy and ADR yields by length of stay, and track MTD and YTD revenue performance.
Net Revenue	Review departmental earnings, separate earned income from deposits and non-revenue postings, and reconcile PMS activity with GL accounts.
Occupancy by Room Type	Analyze room-type sales, track group allocations against inventory, and compare RevPAR with and without out-of-order rooms.
Occupancy Summary	Track daily room states and booking velocity, analyze ADR and RevPAR variations, and evaluate occupancy models for revenue reporting.
Package Revenue Activity	Trace bundled rate plan postings, verify package element revenue splits, and reconcile individual and group package ledgers.
Package Revenue Summary	Review package revenue distribution, audit departmental revenue splits, and reconcile PMS package earnings with GL accounts.
Revenue Activity	Audit line-item revenue postings across reservations, house accounts, and group masters, and consolidate property totals for end-of-day review.
Revenue by Room Type	Analyze category-level performance, assess occupancy and RevPAR contribution, and evaluate market segment bookings across room tiers.
Revenue Summary	Review revenue postings by transaction code, trace gross-to-net calculations, and isolate city, sales, and state tax liabilities.
Room Type Summary	Analyze room availability, track ancillary revenue additions, and compare RevPAR calculations with and without out-of-order rooms.
Sub Charge Type	Audit sub-ledger revenue postings, track adjustments and refunds, and analyze MTD and YTD variance against prior-year benchmarks.
Travel Agent Revenue Details	Analyze agency booking production, audit room versus package revenue splits, and verify commission eligibility across IATA accounts.

🥧 Market & Segmentation Reports

Report	What it helps you do
Local Market Segment	Analyze booking trends by local market code, assess guest demographics, and track occupancy and RevPAR contribution.
Local Market Segment Details	Audit guest-level reservation profiles, cross-reference rate codes with local market codes, and correct missegmented bookings.
Market Segment Details	Track segment-level yield metrics, analyze occupancy and RevPAR contribution, and audit posting transactions for discrepancies.
Market Segment Details Forecast	Track projected room and F&B revenue by segment, analyze guest demographics, and align staffing and yield strategies.
Market Segment Details Summary	Track room inventory turnover, analyze breakfast package guest counts, and review departmental revenue by market segment.
Market Segment Overview	Analyze daily, MTD, and YTD business mix, track occupancy and RevPAR contribution, and evaluate segment profitability.
Market Segment Summary	Analyze channel-level room and ancillary revenue, assess occupancy and RevPAR contribution, and optimize business mix.
Nationality	Analyze guest origin distribution, identify international feeder markets, and support tourism reporting and regional marketing.
Revenue by Guest Country	Analyze guest origin distribution, evaluate room-night and ADR yield by feeder market, and guide cross-border sales strategy.
Source Summary	Analyze booking origin performance, assess occupancy and RevPAR contribution by channel, and optimize distribution strategy.
Tourism	Analyze domestic versus international guest origin trends, evaluate feeder-market stay duration, and guide regional marketing.
Zip Code	Analyze postal origin distribution, identify regional drive markets, and support local advertising and corporate sales targeting.

🏷️ Rate Management Reports

Report	What it helps you do
Discrepant Rates	Identify rate code shifts, compare quoted versus charged rates, and track user-attributed variances to protect rate integrity.
Rate Code Configuration	Audit active pricing rules, review stay restrictions and tax flags, and cross-reference mappings across room types, packages, and channels.
Rate Group Summary	Analyze rate tier performance, assess occupancy and RevPAR contribution by rate family, and evaluate corporate discounting.
Rate Override	Track manual rate adjustments, compare sold versus new rates, and analyze override reasons for pricing compliance.
Rate Plan Summary	Analyze promotional and negotiated rate plan performance, map rate codes to segments, and evaluate campaign results.
Rate Report	Review itemized room rates, taxes, and fees; audit guest balance allocations; and verify agency or corporate pricing compliance.
Rate Type Tracking	Analyze daily, MTD, and YTD year-over-year performance by rate tier and evaluate revenue growth across rate families.
Zero Rate	Audit zero-value room rate postings, review complimentary and house-use stays, and confirm authorized stay compliance.

🔭 Yield & Forecasting Reports

Report	What it helps you do
Booking Pace	Track future booking velocity, analyze revenue and ADR movement across pickup windows, and optimize rate tiers and restrictions.
Occupancy Forecast & History	Analyze historical and projected stay movement, evaluate ADR and RevPAR variations, and support labor planning and yield forecasting.
Rate Group Forecast	Analyze forward revenue and occupancy projections by rate group, assess contribution metrics, and align pricing strategy.
Rate Plan Forecast	Analyze future occupancy distribution by rate plan and segment, track contribution metrics, and use filters for demand forecasting.
Revenue Forecast by Local Market Segment	Analyze forward demand by local market code, assess projected contribution metrics, and track local corporate contract pickup.
Revenue Forecast by Market Segment	Analyze forward booking trends by market segment, evaluate projected contribution metrics, and optimize rate barriers and sales efforts.
Source Forecast	Analyze projected booking origin performance, track channel contribution metrics, and optimize OTA, GDS, and direct-booking strategy.
Turn Away Reason Code	Analyze unconstrained demand, track denial reasons by booking channel, and identify lost revenue opportunities.