Room Type Summary .ng | HotelKey Knowledge Base

Room Type Summary 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 incidental revenue contributions per room category, and analyze Average Daily Rate (ADR) and RevPAR yield across room types.

Executive Summary

The Room Type Summary 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, Room Available, Vacant Rooms, Out of Order, Sold) and monetary performance metrics (Room Revenue, Other Room Revenue, Total Revenue, ADR, Occupancy, Revpar With OOO Rooms, Revpar Without OOO Rooms), this report enables revenue managers, controllers, and hotel leadership to evaluate premium suite upsell performance, audit room category revenue contributions, prevent rate dilution, and optimize room category pricing structures.

Key Capabilities

Categorical Revenue & Production Analysis: Itemizes room nights sold (Sold), occupant headcounts (Adults, Children, Total Guests), and gross earnings across individual room categories.
Multi-Stream Revenue Unbundling: Differentiates base room accommodation earnings (Room Revenue) from incidental room-adjacent fees (Other Room Revenue) to calculate combined departmental yield (Total Revenue).
Category Yield Benchmarking: Calculates key yield metrics—including Average Daily Rate (ADR), Occupancy Percentage (Occupancy), and dual RevPAR calculations (Revpar With OOO Rooms, Revpar Without OOO Rooms)—for each room type.
Inventory Capacity Auditing: Tracks total room type physical availability (Room Available) alongside vacant capacity (Vacant Rooms) and maintenance holds (Out of Order) to measure true operational yield.

Report Views & Functional Breakdown

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

┌────────────────────────────────────────────────────────────────────────┐
│                    ROOM TYPE SUMMARY 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 room revenue and incidental revenue streams per room category.

Primary Use: Evaluating which room categories generate the highest total revenue (Total Revenue), auditing base room charges (Room Revenue), and tracking incidental fee add-ons (Other Room Revenue).
Key Metrics: Date, Day Of Week, Room Type Name, Room Type Code, 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 (Sold), auditing guest occupant headcounts (Adults, Children, Total Guests), and tracking maintenance displacement (Out of Order) and vacant capacity (Vacant Rooms).
Key Metrics: Date, Room Type Name, Room Type Code, Room Available, Vacant Rooms, Out of Order, Sold, Adults, Children, Total Guests.

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), monitoring category capacity utilization (Occupancy), and assessing overall room type yield efficiency both including (Revpar With OOO Rooms) and excluding (Revpar Without OOO Rooms) maintenance inventory.
Key Metrics: Date, Room Type Code, Sold, Total Revenue, ADR, Occupancy, Revpar With OOO Rooms, Revpar Without OOO Rooms.

Image 10-7-26 at 7.45 AM.png — Room Type Summary 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: Room Revenue, Other Room Revenue, and Total Revenue represent Gross Base Room Revenue (Excludes Taxes & Fees). Total Revenue is calculated as Total Revenue = Room Revenue + Other Room Revenue. All occupancy percentages are rendered as decimal ratios (e.g., 0.4810 = 48.10%).

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., 1 King Standard, 1 King Premium, 2 Double Standard).	Room Type Master Setup	N/A
Room Type Code	Unique alphanumeric code assigned to the room category (e.g., `DGCN`, `DQAN`, `DRAN`, `KABN`, `KBSN`, `KQJN`, `KQQN`, `KTPN`, `KWPN`, `KZCN`, `SQAN`).	Room Type Master Setup	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
Total Guests	Total registered guest occupant headcount (`Adults + Children`).	`SUM(Adults + Children)`	N/A
Room Available	Total physical room count configured and available for the specific room type.	Physical Inventory Engine	N/A
Vacant Rooms	Total rooms in the category remaining unsold on the business date.	Inventory Availability 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
Sold	Total physical room nights sold and occupied in the category on the business date.	`SUM(Category Occupied Rooms)`	N/A
Room Revenue	Gross base room revenue generated by guest stay charges in the category.	`SUM(Category 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 (`Room Revenue + Other Room Revenue`).	`SUM(Category Room Revenues)`	❌ No
ADR	Average Daily Rate earned per sold room in the category (`Total Revenue / Sold`).	`Total Revenue / Sold`	❌ No
Occupancy	Proportion of total category rooms occupied (`Sold / Room Available`).	`Sold / Room Available`	N/A
Revpar With OOO Rooms	Revenue Per Available Room calculated against total physical capacity including OOO rooms (`Total Revenue / Room Available`).	`Total Revenue / Room Available`	❌ No
Revpar Without OOO Rooms	Revenue Per Available Room calculated against net operational capacity excluding OOO rooms (`Total Revenue / (Room Available - Out of Order)`).	`Total Revenue / Net Available`	❌ 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 the below logical blocks:
- Timeline & Category Anchors (Cols 1–4): Date | Day Of Week | Room Type Code | Room Type Name
- Physical Inventory & Sales Volume (Cols 5–8): Room Available | Vacant Rooms | Out of Order | Sold
- Guest Demographics (Cols 9–11): Adults | Children | Total Guests
- Revenue Streams (Cols 12–14): Room Revenue | Other Room Revenue | Total Revenue
- Rate Yield & Utilization Metrics (Cols 15–18): ADR | Occupancy | Revpar Without OOO Rooms | Revpar With OOO Rooms

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 Room Type Summary report features an interactive pie chart to help analyze category performance across your property. Users can group category records on the fly by Room Type Name or Day Of Week to evaluate category performance trends over time. By selecting a metric from the Select Base Column dropdown—such as Total Guests, Sold, Vacant Rooms, or Room Revenue—the chart dynamically displays percentage distributions accompanied by a color-coded legend.

Image 10-7-26 at 7.48 AM.png — *Group By & Pie Chart Visualization*

Bar Chart Visualizer: The Room Type Summary report includes a customizable bar chart to help visualize property metrics and occupancy trends over time. By adjusting the Select Column (Y-Axis) dropdown menu, users can dynamically switch the chart to track guest counts (Adults, Children, Total Guests), inventory status (Room Available, Vacant Rooms, Out of Order, Sold), or financial metrics (Room Revenue) alongside the detailed summary table.

Image 10-7-26 at 7.53 AM.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, group allocations, and dual RevPAR calculations.
Revenue Summary – Review daily property-wide revenue postings, gross vs. net revenue realizations, and itemized tax accruals.
General Manager Report – Review property-wide macro statistics, total room revenues, ADR, and RevPAR performance.

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.