Important to know:
The room type report provides a breakdown of your revenue based on your room types. This report can be used to see which room types are more popular than others.
You can also use this report as a guide to decide the best room pricing strategy to earn maximum profits and keep your occupancy steady.
Run this report by going to Reports > Revenue > Room type
How do I run a room type revenue report?
To run a room type revenue report:
Go to the Reports page. This will take you straight to the Revenue reports section.
Click on the Room type tab.
Select the date type for the report by clicking on Search by:
Stay date: date range your guests stayed at your property.
Booked on: date range your guests booked their reservations.Enter a date range (mandatory): select a Date from and a Date to, to indicate the first and last day of the range dates you want to include in this report.
Leave the Revenue includes tax option unticked if you wish to exclude tax in the report. If you tick this option, the tax from any taxable service charge will be included in the calculation.
Click on Run report.
The report will display the revenue details per room type for the selected date range.
How do I export the room type revenue report?
Click on Export at the bottom right. The report will be downloaded as a .csv file you can open in Microsoft Excel, Apple’s Numbers, or any other spreadsheet application.
.csv stands for "comma-separated values".
Are you having trouble importing the .csv file into .xlsx (Excel format)? You can always search online for "How do I import a .csv file into a .xlsx file?".
How are the room type revenue report items calculated?
Find below a list of the items you will see after running this report and how Little Hotelier calculates them.
Some terms are only available when the Stay date is selected under Search by, and they are indicated as such.
The total amount is not provided for the average metrics (ADR, lead time, LoS) that are explained in detail below.
Room type: name of the room type.
Revenue: total revenue from the room type and any extra person (adult, child, infant) charges.
Extra items and credit card surcharges are excluded from the calculation.
If the report is based on the Stay date, it includes the revenue of the room nights for your room types that falls within the specified date range. For example, a report on your double room for the month of December includes the revenue of reservations from guests that stayed between the 1st and 31st only.
If based on the Booked-on date, it includes the revenue from reservations for this room type booked on the specified date range, which, in this example includes reservations booked from the 1st to the 31st of December.
When Revenue includes tax option is ticked:
The tax from any taxable service charge will be included in the calculation.
Fixed amount taxes won’t be included in this calculation.
Reservations: total number of reservations that meets the report criteria.
If a report is based on the Stay date, it counts reservations for this room type that have at least a one night stay that falls within the chosen date range.
If the report is based on the Booked-on date, it will count all reservations for this room type that have been booked within the selected date range.
Nights: total number of room nights for this room type that is sold/occupied within the selected date range.
If the report is based on the Stay date, it includes the number of occupied room nights for this room type that falls within the chosen date range.
If based on the Booked-on date, it includes the number of room nights that were booked for this room type during the chosen date range.
Occupancy: the percentage of available rooms occupied for the specified period. Term only available when the Stay date is selected under Search by.
Calculation: occupied room nights ÷ total available room nights. Total available room nights = total room nights (number of rooms x number of days) - closed room nights (number of nights with a room closure).
ADR (average daily rate): average revenue earned for an occupied room type per day. In other words, ADR will tell you how much you make per room on average in a given day. The higher the ADR, the better.
Calculation: rooms revenue ÷ number of rooms sold (or occupied) for each room type.
The number of rooms sold will be in the formula if you searched by Booked-on.
The number of rooms occupied will be in the formula if you searched by Stay date.
Lead time: on average, how many days in advance are your rooms booked before the check-in date.
Calculation: total lead time ÷ total number of bookings.
If a report is based on the Stay date, it averages the number of days between the booking date and the check-in date for all the reservations that have at least a one night stay within the chosen date range.
If the report is based on the Booked-on date, it averages the number of days between the booking date and the check-in date for all the reservations made during the specified date range.
LoS (length of stay): average length of time that guests stay at your property for the selected date range.
Calculation: total length of stay ÷ total number of bookings.
If a report is based on the Stay date, it calculates the average length of stay of all reservations that have at least a one night stay that falls within the chosen date range.
If a report is based on the Booked-on date, it calculates the average length of stay of all reservations booked during the specified date range.
RevPAR (revenue per available room): daily room revenue generated per available room. RevPAR measures your property’s ability to fill its available rooms at the average rate. Term only available when the Stay date is selected under Search by.
Calculation: ADR ÷ total available rooms. Total available rooms = total rooms - closed rooms (number of nights with a room closure).
If the RevPAR of your property is increasing, it must mean either your average room rate or your occupancy rate are increasing (or both!).