Overview

Little Hotelier offers two report options to help you analyse your hotel's revenue:

Summary report: this report provides a high-level overview of your total revenue for a specific period.
Breakdown revenue report: export a more detailed report that breaks down your revenue on a daily basis. This report provides individual reservation details alongside the daily revenue figures. To access this data, run a summary report and click Export followed by Reservation data.

How do I run a revenue summary report?

This report contains information on all reservations that are allocated (assigned to a specific room) and unallocated (yet to be assigned a room but appear on the Calendar).

Go to Front Desk > Reports
Select the date type for the report by clicking on
Search byStay date: date range your guests stayed at your property
Booked on: date range your guests booked their reservations
Enter a date range: select a Date from and a Date to
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

How do I export a revenue summary report?

Click Export in the bottom right corner
Click the dropdown list next to Export to choose your preferred report format:

Export summary: download a concise report with the same information you see on the screen
Export reservation data: a detailed revenue breakdown report with daily figures

Both reports are downloaded as CSV files, compatible with spreadsheet applications like Microsoft Excel or Apple Numbers.

How are the report items calculated?

Here is a list of the items you will see after running this report and an explanation on how they are calculated.

Room: total room revenue + any additional person charges. Extra items and credit card surcharges are excluded from the calculation.

Stay date: shows revenue earned from rooms occupied during the chosen dates.
Booked-on date: shows revenue generated from reservations booked within the chosen date range.

Extras: total revenue from extra items. Credit card surcharges are excluded from the calculation.

💡 Revenue from Per Booking, Per Room, and Per Person extras is only included if the first night of the reservation falls within the selected date range. Excluded reservations won't contribute to the extras revenue calculation.

Taxes: sum of all percentage and fixed amount taxes. Credit card surcharges are excluded from the calculation.

Reservations: number of reservations that meet the report criteria.

Stay date: shows reservations with stays happening within your chosen dates.
Booked-on date: shows reservations booked within your chosen dates, regardless of the actual stay dates.

Nights: total number of room nights that are sold/occupied within the selected date range.

Stay date: counts nights guests spend within your chosen dates.
Booked-on date: counts nights booked within your chosen dates, regardless of the actual stay.

Occupancy: percentage of available rooms occupied for the specified period. 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 nights) - closed room nights (number of nights with a room closure).

ADR (average daily rate): the average revenue earned for an occupied room per day.

Calculation: rooms revenue ÷ number of rooms sold (or occupied)

Stay date: number of rooms occupied
Booked-on: number of rooms sold

Lead time: how many days in advance your rooms are booked before the check-in date.

Calculation: total lead time ÷ total number of bookings

Stay date: average lead time (number of days between booking and check-in) for reservations with at least one night's stay within the chosen date range.
Booked-on date: average lead time for all reservations booked during the specified date range.

LoS (length of stay): the average length of time guests stay at your property for the selected date range.

Calculation: total length of stay ÷ total number of bookings

Stay date: shows the average number of nights guests stay within your chosen dates.
Booked-on date: shows the average length of reservations booked during your chosen dates, not necessarily reflecting the actual stay.

Revenue per available room (RevPAR): daily room revenue generated per available room. RevPAR measures your property’s ability to fill its available rooms at the average rate. This is only available when Stay date is selected under Search by.