Revenue by Room Type Report

The Revenue by Room Type Report allows users to track the total revenue generated from each room type in the property.

Perform the following steps to generate the report:

Navigate to Reports à Dynamic Reports à Revenue/Forecasting à Revenue by Room Type Report

Refer to the following table and fill in the fields.

Field	Description
Report Name	Revenue by Room Type.
Property	This is a mandatory multi-select drop-down list that displays a list of all properties under the tenant. The current property is selected by default.
Start Date	This is a mandatory field that displays the current property date by default. Users can select any date in the past or future.
End Date	This field displays the current property date by default. Users can select any date in the past or future. The maximum range between the start and end date is 365 days.
Group By	Users can generate the report grouped by the following options: Property Market Segment Guest Type This is a mandatory field.
Include Room Type with No Activity checkbox	When selected, the room types for which no activities (arrivals, departures, room move, and so on) occurred are included in the revenue calculation for the selected date range. When this checkbox is not selected, the room types for which no activities occurred are not included in the revenue calculation.

Click Run to generate the report.

Click Save to save the report under User Favorites section.

Sample Report

Report Fields

This report displays the following fields:

Field	Description
Category	Displays the name of the property or market segment or guest type based on the Group By option selected by the user. Users can search and filter records using this column. This column can be sorted.
Date	Displays the dates for the selected date range. An accordion is provided that is in expanded state by default. A subtotal for the other columns is calculated and displayed at the date level. Users can search and filter records using this column. This column can be sorted.
Room Type	Displays the name of the room type that has revenue for the selected date. Users can search and filter records using this column. This column can be sorted.
Room Revenue	Displays the sum of room revenue for reservations for a particular room type for the selected date excluding tax. The Room Revenue is calculated as follows: Room Revenue = Room Rate + Charges Flagged as Room Revenue - Credits Flagged as Room Revenue. This column can be sorted.
Room Revenue Tax	Displays the sum of room revenue tax accrued for the reservations for a particular room type for the selected date. This column can be sorted.
Room Revenue Total	Displays the Room Revenue Total calculated as the sum of Room Revenue and Room Revenue Tax. This column can be sorted.
Non-Room Revenue	Displays the sum of non-room revenue accrued for the reservations for a particular room type for the selected date excluding tax. The Non-Room Revenue is calculated as follows: Non-Room Revenue = Charges not flagged as room revenue - Credits not flagged as room revenue. This column can be sorted.
Rooms Available	Displays the total number of rooms available for a room type that can be assigned to reservations. This column can be sorted.
Non-Room Revenue Tax	Displays the sum of non-room revenue tax accrued for the reservations for a particular room type for the selected date. This column can be sorted.
Non-Room Revenue Total	Displays the Non-Room Revenue Total calculated as the sum of Non-Room Revenue and Non-Room Revenue Tax. This column can be sorted.
Rooms Occupied	Displays the number of rooms with reservations in In-House status for a particular room type for the selected date. This column can be sorted.
Rooms Vacant	Displays the total number of rooms that are vacant for a room type.
Out of Order	Displays the total number of rooms for which an Out of Order inventory block is created.
Off the Market	Displays the total number of rooms for which an Off the Market inventory block is created.
Occupancy %	Displays the Occupancy % for a particular room type for the selected date calculated as follows: Rooms Occupied /Rooms Available on the property for that date. This column can be sorted.
ADR	Displays the Average Daily Rate (ADR) for a particular room type for the selected date calculated as follows: Average Daily Rate (ADR) = Room Revenue for the day/Total Occupied Rooms on the property for that date. This column can be sorted.
RevPAR	Displays the Revenue Per Available Room (RevPAR) for a particular room type for the selected date calculated as follows: Revenue Per Available Room (RevPAR) = Potential Room Revenue for the day/Rooms Available on the property for that date. This column can be sorted.
Owner’s RevPAR	Displays the Owner’s Revenue Per Available Room (Owner’s RevPAR) for a particular room type for the selected date calculated as follows: Owner’s RevPAR = Room Revenue Total for the day/Rooms Available on the property for that date. This column can be sorted. This column is displayed only when the Owner feature setting is enabled, and the property is integrated with Residence Management.
Group Blocks Total	Displays the total number of group blocks for a particular room type for the selected date. This column can be sorted.
Group Pick-Ups	Displays the total number of group blocks picked-up for a particular room type for the selected date. This column can be sorted.
Group Remaining	Displays the total number of group blocks remaining to be picked-up for a particular room type for the selected date. This column can be sorted.
Arrivals	Displays the total number of arriving reservations for a particular room type for the selected date. This column can be sorted.
Departure	Displays the total number of departing reservations for a particular room type for the selected date. This column can be sorted.
Stay Overs	Displays the total number of reservations with stay overs for a particular room type for the selected date. This column can be sorted.
No Shows	Displays the total number of No-Show reservations for a particular room type for the selected date. This column can be sorted.
Adults	Displays the number of guests who fall under the adults age category for a particular room type for the selected date. This column can be sorted.
Children	Displays the number of guests who fall under the children age category for a particular room type for the selected date. This column can be sorted.
Day Use	Displays the total number of day use reservations for a particular room type for the selected date. This column can be sorted.
Comp	Displays the total number of comp reservations for a particular room type for the selected date. The reservations with zero-dollar rate or rate lesser than comp threshold with the type as Comp are included. This column can be sorted.