Revenue by Room Type .ng | HotelKey Knowledge Base

Revenue by Room Type Report Overview

Parent Hub: 📈 Revenue & Analytics

Category: 📊 Performance Summaries

Target Roles: Directors of Revenue Management, General Managers, Directors of Finance & Controllers, Asset Managers, Inventory Managers

Key Value: Maximize room category yield, evaluate room product line profitability, track transient versus group revenue contributions per room category, and analyze Average Daily Rate (ADR) and RevPAR yield across room types.

Executive Summary

The Revenue by Room Type Report is a primary room product line performance and category yield document within the 📊 Performance Summaries category of the 📈 Revenue & Analytics hub. Designed to deliver granular financial intelligence by physical room category, it aggregates room night production, occupant headcounts, and revenue realizations for every room type configured at the property.

By pairing stay parameters (Date, Day Of Week) with inventory attributes (Room Type Name, Room Type Code, Total Rooms, Out of Order, Total Sold Rooms) and monetary performance metrics (Transient Room Revenue, Group Room Revenue, Other Room Revenue, Total Revenue, ADR, RevPAR), this report enables revenue managers, controllers, and hotel leadership to evaluate premium suite upsell performance, audit group block revenue contributions, prevent rate dilution, and optimize room category pricing structures.

Key Capabilities

Categorical Revenue & Production Analysis: Itemizes room nights sold (Total Sold Rooms), occupant headcounts (Adults, Children), and gross earnings across individual room categories.
Multi-Stream Revenue Unbundling: Differentiates transient room earnings (Transient Room Revenue) from contracted group block earnings (Group Room Revenue) and incidental room-adjacent fees (Other Room Revenue).
Category Yield Benchmarking: Calculates key yield metrics—including Average Daily Rate (ADR) and Revenue Per Available Room (RevPAR)—for each room type.
Inventory Capacity Auditing: Tracks total room type physical counts (Total Rooms) alongside maintenance holds (Out of Order) to measure true operational yield.

Report Views & Functional Breakdown

The Revenue by Room Type Report presents room category performance in a unified single-table matrix that supports three key analytical perspectives:

┌────────────────────────────────────────────────────────────────────────┐
│                   REVENUE BY ROOM TYPE REPORT                          │
├────────────────────────────────────────────────────────────────────────┤
│                         Unified Matrix View                            │
├──────────────────────────┬──────────────────────────┬──────────────────┤
│ 1. Category Revenue &    │ 2. Inventory Production  │ 3. Rate Yield &  │
│    Departmental Mix      │    & Capacity Controls   │    RevPAR Performance│
└──────────────────────────┴──────────────────────────┴──────────────────┘

1. Category Revenue & Departmental Mix

Monitors gross revenue generation and unbundles earnings across transient, group, and incidental room revenue streams per room category.

Primary Use: Evaluating which room categories generate the highest total revenue (Total Revenue), auditing group block revenue contributions (Group Room Revenue), and tracking incidental fee add-ons (Other Room Revenue).
Key Metrics: Date, Day Of Week, Room Type Name, Room Type Code, Transient Room Revenue, Group Room Revenue, Other Room Revenue, Total Revenue.

2. Inventory Production & Capacity Controls

Tracks room night sales volume, occupant density, physical capacity, and out-of-order holds for each room type.

Primary Use: Measuring room category demand (Total Sold Rooms), auditing guest occupant headcounts (Adults, Children), and tracking maintenance displacement (Out of Order).
Key Metrics: Date, Room Type Name, Room Type Code, Total Rooms, Out of Order, Total Sold Rooms, Adults, Children.

3. Rate Yield & RevPAR Performance

Measures pricing realization and RevPAR efficiency across standard versus premium room types.

Primary Use: Comparing ADR premiums realized across suite and standard categories (ADR) and assessing overall room type yield efficiency (RevPAR).
Key Metrics: Date, Room Type Code, Total Sold Rooms, Total Revenue, ADR, RevPAR.

Image 10-6-26 at 7.56 PM.png — Revenue by Room Type Report

Data Dictionary (Dynamic View Columns)

Customize your default view using the Configure (⚙️) icon on the report page. Below is the full data dictionary representing every column available in this report:

💡 Monetary & Rate Calculation Note: Transient Room Revenue, Group Room Revenue, Other Room Revenue, and Total Revenue represent Gross Base Room Revenue (Excludes Taxes & Fees). Total Revenue is calculated as Total Revenue = Transient Room Revenue + Group Room Revenue + Other Room Revenue

Column Name	Description	Data Source / System Mapping	Includes Taxes & Fees?
Date	Official business date for which room type revenues are reported.	System Business Date	N/A
Day Of Week	Calendar day of the week corresponding to the business date (e.g., Monday, Tuesday).	System Calendar Engine	N/A
Room Type Name	Full human-readable description of the room category (e.g., 2 Queen Standard, 1 King Suite, Standard Room).	Room Type Master Setup	N/A
Room Type Code	Unique alphanumeric code assigned to the room category (e.g., `TQNN`, `XKLN`, `TWAN`, `TWYN`, `CSTN`).	Room Type Master Setup	N/A
Total Rooms	Total physical room count configured for the specific room type.	Physical Inventory Engine	N/A
Out of Order	Physical rooms in the category removed from service due to maintenance or repairs.	OOO/OOS Inventory Logs	N/A
Total Sold Rooms	Total physical rooms sold and occupied in the category on the business date.	`SUM(Category Occupied Rooms)`	N/A
Adults	Total registered adult guests occupying rooms in the category.	`Reservation > Occupancy`	N/A
Children	Total registered child guests occupying rooms in the category.	`Reservation > Occupancy`	N/A
Transient Room Revenue	Gross base room revenue generated by transient guest stays in the category.	`SUM(Transient Room Charges)`	❌ No
Group Room Revenue	Gross base room revenue generated by contracted group block stays in the category.	`SUM(Group Room Charges)`	❌ No
Other Room Revenue	Additional room-adjacent revenue charges posted to folios in the category.	`SUM(Other Room Charges)`	❌ No
Total Revenue	Consolidated gross room revenue (`Transient + Group + Other Room Revenue`).	`SUM(Category Room Revenues)`	❌ No
ADR	Average Daily Rate earned per sold room in the category (`Total Revenue / Total Sold Rooms`).	`Total Revenue / Total Sold Rooms`	❌ No
RevPAR	Revenue Per Available Room generated by the category (`Total Revenue / Total Rooms`).	`Total Revenue / Total Rooms`	❌ No

Customization & Platform Features

User & Property Preferences

Personal Preference: Tailor your individual view by hiding or dragging columns. Your preferences save automatically for future sessions.
Property Defaults: System Admins can configure standard default layouts across all property users to streamline operational reporting. To maximize audit efficiency, group the columns into 6 logical blocks:
- Timeline & Category Anchors (Cols 1–4): Date | Day Of Week | Room Type Code / Name | Room Type Category
- Market Segment Context (Col 5): Market Segment
- Volume & Accommodation Revenue (Cols 6–7): Stays | Revenue
- Rate Yield & Contribution Metrics (Cols 8–10): ADR | Occupancy Contribution | RevPAR Contribution

Use the top-right toolbar icons on the report page to manage and export your data view:

Icon	Action / Feature	Description
	Knowledge Article	Opens the knowledge base article to learn how to interpret this report.
	Saved Views	Saves your column filtering, sorting, and highlight preferences so you can easily reload your custom view later without reconfiguring the report.
	Bar Chart	Displays report data in a visual bar chart format.
	Filter	Opens filter controls to isolate specific data within a column based on your selected criteria.
	Highlight	Highlights column values in a designated color based on selected conditions.
	Export	Exports and downloads the report in various formats (Excel, PDF, CSV) for offline analysis or printing.
	Configure	Opens column selection controls to toggle visibility, reorder columns, or hide rows with all zeros.
	Additional Configuration	Provides advanced report configuration and display formatting options to customize data presentation.
	Group By	Summarize and group report data dynamically in real time.

Interactive Visualizations & Grouping Controls

Group By & Pie Chart Visualization: The Revenue By Room Type report features an interactive pie chart to help analyze financial distribution across market segments and inventory categories. Users can group category records on the fly by Room Type, Market Segment, or Date to evaluate category performance trends over time. By selecting a metric from the Select Base Column dropdown menu—such as Revenue, Stays, ADR, or RevPAR Contribution—the chart dynamically renders percentage share breakdowns alongside an interactive color-coded legend.

Image 10-6-26 at 7.57 PM.png — *Group By & Pie Chart Visualization*

Bar Chart Visualizer: The Revenue By Room Type report features an interactive bar chart to help visualize daily financial and stay trends across a chosen timeframe. By adjusting the Select Column (Y-Axis) dropdown menu, users can dynamically switch the chart to plot either total Revenue or overall Stays alongside the detailed data grid below.

Image 10-6-26 at 7.58 PM.png — *Bar Chart Visualizer*

Advanced Controls

Exporting & Yield Analysis: Download in Excel or PDF format to support weekly yield meetings, room type pricing adjustments, and product line profitability reviews.
Filtering: Filter data by specific date ranges or room type codes (e.g., isolate premium suite categories vs. standard inventory).
Highlighting (Conditional Formatting): Apply custom rules to automatically highlight high-performing room categories or room types experiencing rate dilution.

Within 📈 Revenue & Analytics & 📊 Performance Summaries:

Occupancy by Room Type – Deep dive into room category physical capacity, availability, out-of-order holds, and dual RevPAR calculations.
General Manager Report – Review property-wide macro statistics, total room revenues, ADR, and RevPAR performance.
Hotel Statistics – Complete 360-degree operational overview including room counts, occupancy, taxes, payments, and booking activity.

Cross-Pillar Deep Dives:

⚖️ Ledgers & Trial Balance: Reconcile room revenue realizations against General Ledger control accounts in Trial Balance or Day End Summary.
💳 Payments & Transactions: To inspect specific guest payments and folio transactions driving room revenue, review All Transactions.