The room report provides a breakdown of your revenue based on your actual physical rooms occupied or sold for a specific date range. You can run this report by going to Reports > Revenue > Room
How do I run a room revenue report?
Go to the Reports page. This will take you straight to the Revenue reports section.
Click on the Room 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 date range you want to include in this report.
Leave the Revenue includes tax option unticked if you wish to exclude tax in the report.
Note: If you tick this option, the tax from any taxable service charge will be included in the calculation.Click Run report. The report will display the revenue details per room for the selected date range.
How do I export this report?
Click on Export at the bottom right. The report will be downloaded as a .csv file that you can open in Microsoft Excel, Apple’s Numbers, or any other spreadsheet application.
Note:
.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 report items calculated?
Find below a list of the items you will see after running this report and how Little Hotelier calculates them.
Note:
Some terms are only available when the Stay date is selected under Search by, and they are indicated as such.
Total amount is not provided for the average metrics (ADR, lead time, LoS) that are explained in detail below.
Room: name or number of the actual physical room.
Revenue: total revenue from the room 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 will include the revenue of the room nights for your rooms that fall within the specified date range.
For example, a report on your double room corporate for the month of December includes the revenue of reservations from guests staying between the 1st and 31st only.If based on the Booked-on date, it will include the revenue from reservations for each room booked on the specified date range, which, in this example is from the 1st to the 31st of December.
Note:
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 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 that have been booked within the selected date range.
Nights: total number of room nights for this room 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 that fall within the chosen date range.
If based on the Booked-on date, it includes the number of room nights that were booked during the chosen date range for this room.
Occupancy: 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 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 number.
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.
Note:
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 your average room rate or occupancy rate is increasing (or both!)