The channel report provides a breakdown of your revenue based on your connected channels, including your direct booking engine and reservations created on your Little Hotelier front desk manually.
You can run this report by going to Reports > Revenue > Channel.
How do I run a channel revenue report?
To run a channel revenue report:
Go to the Reports page. This will take you straight to the Revenue reports section.
Click on the Channel 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. 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 channel for the selected date range.
How do I export a channel revenue 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.
.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 channel revenue report items calculated?
Find below a list of the items you will see after running this report and how Little Hotelier calculates them.
Total amount is not provided for the average metrics (ADR, lead time, LoS) that are explained in detail below.
Channel: name of the channel where reservations were made. You might see as well:
Direct is for online bookings made from your direct booking engine.
Extranet is for bookings created by you or your staff in the Little Hotelier front desk.
BookingButton is for reservations made through this booking engine.
If you have imported reservations in the past, they might appear when running the Channel revenue report. Before the name of the channel, imported reservations show " Import/ " for you to remember that these reservations were manually integrated to Little Hotelier.
Revenue : total revenue from the channel 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 your rooms for each channel they were booked through that fall within the specified date range.For example, a report on your direct online bookings for the month of December includes the revenue between the 1st and 31st only.
If based on the Booked-on date , it will include the revenue of your reservations that have been booked through each channel within the selected date range, which, in this example is 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 running a report based on the Stay date , it will count all reservations made through each channel that have, between their check-in and check-out dates, at least one stay date that falls within the specified date range.
If the report is based on the Booked-on date , it will count all reservations that have been booked through each channel within the selected date range.
Cancelled reservations: number of reservations that were cancelled for each channel within the selected date range.
If running a report based on the Stay date, it will include the number of cancelled reservations that had, between their check-in and check-out dates, at least one stay date that falls within the specified date range.
If the report is based on the Booked-on date, it will include the number of cancelled reservations that were booked on the specified date range.
Nights: total number of room nights for each channel that are sold/occupied within the selected date range.
Room nights of cancelled reservations are not included in this total.
If the report is based on the Stay date , it includes the number of occupied room nights for this channel 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 channel.
ADR (average daily rate): average revenue earned for an occupied room per day for each channel. In other words, ADR tells you how much you make per room (for each channel) on average in a given day. The higher the ADR, the better.
Calculation: rooms revenue ÷ number of rooms sold (or occupied) for each channel.
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 your rooms are 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.