Skip to main content

How to run a statistics report

Updated over 3 months ago

Generate statistics reports in Little Hotelier to view and analyse your property's key performance indicators (KPIs) including your occupancy rate, average daily rate and revenue metrics.

Running a statistics report

  1. Navigate to Reports

  2. Click on Strategic > Statistics

  3. Under Search by, select to search by Stay date or Booked-on date

  4. Select date filters (Date from and Date to)

  5. Leave the Revenue includes tax option unchecked if you wish to exclude tax in the report

  6. Click Run report

  7. Click Export to download a CSV file

Unallocated reservations aren’t counted in any room night metrics or occupancy but are included in revenue calculations.

Definitions and calculations

Capacity metrics

Report item

Description

Calculation

Total room nights

Total capacity.

Number of rooms x number of days.

Closed room nights

Number of nights with a room closure.

Sum of closure nights.

Occupied room nights

Total number of room nights that are sold.

Sum of booked nights.

Unoccupied room nights

Number of nights with no reservations and no closures.

Total room nights - (Closed + Occupied room nights).

Performance metrics

Report item

Description

Calculation

ADR

ADR or Average Daily Rate measures the average price paid per room.

Calculation: Rooms Revenue / Total Number of Rooms Sold (or Occupied).

Average revenue per booking

Average revenue generated per booking.

Calculation: total revenue / total number of bookings.

Cancelled reservations

The number of reservations made through this channel that was cancelled within the selected date range.

Stay date: Includes cancelled room rates only for dates within the selected range (e.g., Dec 1-31).

Booked-on date: Includes rates for all cancellations made during the selected booking period (e.g., reservations booked Dec 1-31).

Lead time

It shows on average how many days in advance this room or room type is booked before the check-in date.

Calculation: Total Lead Time / Total Number of Bookings.

Stay date: Averages time between Booked-on and Check-in dates for reservations with at least one night in the selected range.

Booked-on date: Averages time between Booked-on and Check-in dates for all reservations made during the selected range.

LoS

LoS or Length of Stay is the average length of time that the guests stay at your property for a certain period.

Calculation: Total Length of Stay / Total Number of Bookings.

Stay date: Averages length of stay for reservations with at least one night in the selected range.

Booked-on date: Averages length of stay for all reservations booked during the selected range.

Occupancy

The percentage of available rooms occupied for the specified period. Room closure is excluded from the calculation.

Calculation: Occupied Room Nights / Total Available Room Nights.

RevPar

RevPar (Revenue Per Available Room) is the daily room revenue generated per available room. Room Closures are excluded from the calculation.

Calculation: Room Revenue / Total Rooms Available.

RevPar is only displayed when the report is filtered by Stay date.

Did this answer your question?