Knowledge Base

The “Revenue and occupancy” report displays the analytics on the revenue and occupancy.

The report is updated at 5 am every day. The report displays data in the hotel’s default currency at the currency rate of a guest’s check-in date.

How to generate the report

1. To change the default reporting period, select two dates in the calendars. Then, click on the “Apply filter” button.

2. To generate the report on one or several specific room types, use the “Room type” filter.

3. To see data for each day separately, tick the “Enable detalization by days” check-box.

4. If you want data to be divided into groups according to room types, tick the “Enable detalization by room types” check-box.

5. To set the column in the report to your liking, click the “View” button and tick the options you need.

6. To download the report to your computer, click the “Export to XLS” button.

What data is displayed in the report

• Room revenue — the revenue you get from each booking that does not include service fees and taxes but includes the early check-in/check-out fees.

• Discount amount — a total discount given to all the bookings.

• Room nights sold — the number of room nights booked within the selected period. It is calculated by the formula: Room nights sold = rooms sold * number of occupied nights in the sold rooms.

• Beds sold — the number of beds sold within the selected period. For each day, the number of room nights is multiplied by the total number of people staying in the rooms. It also comprises extra beds.

• Guests check-in — the number of guests that were supposed to check in within the selected period.

• Rooms check-in — the number of rooms that were supposed to be checked in within the selected period.

• Reservation window — the average number of days between the booking and the specific dates or months of stay.

• Average room cost per night (ADR) — the average cost of a room during the selected period. It is calculated by dividing the net revenue from the inventory sales (after taking away discounts, indirect taxes, and the cost of meals) by the number of room nights sold. It is calculated by the formula: ADR = Room revenue / Room nights sold.

• Average revenue per room (RevPar) — it is calculated by dividing the revenue from the sold rooms by the number of rooms available. The formula: Room revenue / Hotel’s inventory.

• Average revenue per client (RevPAC) — it is calculated by dividing the room revenue (taking away the service fees) by the number of beds sold within the selected period.

• Average length of stay (ALS) — it is calculated by dividing the total number of nights spent at the hotel by the number of bookings. All the bookings for a specific date or a month are taken into account.

• Total rooms — the total number of room night at the hotel for the selected date.

• Total beds — the total number of bed nights at the hotel for the selected date.

• Under repair — the number of room nights that are under repair.

• Total rooms available — the number of rooms available at the hotel for on the selected date taking away rooms under repair.

• Total beds available — the number of beds available at the hotel for on the selected date taking away rooms under repair.

• Total % of room occupancy — it is calculated by dividing the number of occupied rooms by the total number of rooms at the hotel.

• Total % of occupancy — it is calculated by dividing the number of occupied beds by the total number of beds at the hotel.