📊 Report Summary
1️⃣ General Information
This report is designed to support financial decision-making by analyzing the property’s key performance indicators.
- The data is based on Folio items and does not include payments or invoices related to specific reservations.
- The report considers the following room type statuses:
- 🏨 Room
- 🏢 Conference Room
- 🚗 Garage
- ⚙️ Technical
2️⃣ Filtering Options
📅 Datepicker
- Choose from predefined options or select a custom date range (past or future).
- Maximum selectable interval: 32 days.
🔲 Exclude Blocked Dates (Only Occupancy)
- Blocked dates are always displayed in the report (Table / Total Room Nights / Blocked Room Nights row).
- If this checkbox is not ticked, blocked room nights are included in the occupancy calculation.
Example:
- Property has 10 rooms, but 1 room is under refurbishment on March 30, 2024.
- 5 rooms are booked for that night.
| Scenario | Calculation | Occupancy % |
|---|---|---|
| Checkbox ticked (default) | 5 ÷ 10 × 100 | 50% |
| Checkbox not ticked | 5 ÷ 9 × 100 | 55.56% |
⚖️ ADR Settings
Filter using two options:
- 🏠 Accommodation Revenue Only (default)
- 🛎️ Service Revenue Included
- Selecting this option enables an additional Service Categories filter to specify which service revenue should be included in ADR calculations.
- Note: The Service Category filter affects only the ADR metric.
📌 Reservation Status
Filter by one or more of the following:
- ✅ Confirmed
- ⏳ Option
- ❌ Cancelled
- 🚫 No-Show
(All options are selected by default, but not all metrics include Cancelled and No-Show reservations. Check individual metric descriptions for details.)
🏢 Room Filter
View performance data for:
- The entire property
- Individual room types
3️⃣ Key Performance Indicators (KPIs)
The report includes four key widgets that provide a quick performance overview:
💰 Total Revenue
- Includes room revenue and ancillary service revenue for the selected period.
📈 Occupancy (%)
Formula:
(Total booked room nights ÷ Available room nights) × 100
Included in the calculation:
-
Only Confirmed and Option room nights
-
Cancelled and No-Show reservations are excluded
Note on Calendar View vs. Daily Occupancy Report Values:
The occupancy percentage shown in the calendar should generally match the daily occupancy values. However, there may be slight differences due to rounding, as the calendar rounds occupancy to one decimal place.
In some cases, discrepancies may occur—particularly when viewing a period that overlaps with the creation date of one or more rooms. Here's why:
-
The calendar calculates occupancy based on the current total number of rooms, regardless of whether a room existed on a particular date.
-
As a result, on days before a newly created room existed, the calendar still includes it in the "available rooms" count, leading to a lower occupancy percentage.
-
On the other hand, the daily occupancy report correctly considers the room creation date and excludes rooms that weren’t yet available, giving a more accurate figure for those dates.
➡️ Therefore, if a room was created mid-period, the calendar may show a lower occupancy percentage than the report for earlier days, due to the inclusion of rooms that didn't yet exist.
📊 Average Daily Rate (ADR)
- 🏠 Accommodation Revenue Only:
- Formula: Accommodation Revenue ÷ Confirmed + Option Room Nights
- Example:
- Period: March 1–8, 2024
- Accommodation Revenue: €2,874
- Confirmed & Option Room Nights: 54
- ADR = €2,874 ÷ 54 = €53.22
- 🛎️ Service Revenue Included:
-
Formula: Total Revenue ÷ Confirmed + Option Room Nights
-
Example:
- Period: March 1–8, 2024
- Total Revenue: €5,718
- Confirmed & Option Room Nights: 54
- ADR = €5,718 ÷ 54 = €105.89
(Note: For Cancelled and No-Show reservations, the ADR metric considers cancellation and no-show fees, if applied. If cancellation and no-show fees are enabled in Settings → Property Policies → Cancellation and Payment Policies, they are automatically applied based on the policy. If not, manually adding a no-show fee as a service will count as service revenue in the summary.
-
📉 Revenue per Available Room (RevPAR)
- Formula: Accommodation Revenue ÷ Total Room Nights
- Example:
- Period: March 1–8, 2024
- Accommodation Revenue: €2,874
- Total Room Nights: 128
- RevPAR = €2,874 ÷ 128 = €22.45
4️⃣ Report Table Breakdown
A "Double Arrow" feature has been added to the date row, allowing users to expand all categories at once.
📋 Key Metrics in the Table
🛏️ Number of Guest Nights
- Displays Confirmed and Option guest nights, including adults, children, and infants.
- Cancelled and No-Show guest nights are not included.
📊 Total Revenue per Available Room (TRevPAR)
- Formula: (Accommodation + Service Revenue) ÷ Total Room Nights
- Example:
- Date: March 1, 2024
- Accommodation Revenue: €500
- Service Revenue: €217
- Total Room Nights: 16
- TRevPAR = (€500 + €217) ÷ 16 = €44.81
🛏️ Total Room Nights (6 Subcategories)
- ✅ Confirmed Nights
- ⏳ Option Room Nights
- 🏠 Available Room Nights
- 🔲 Blocked Room Nights
- ❌ Cancelled Room Nights
- 🚫 No-Show Room Nights
(Note: The report considers the room creation date when calculating available rooms.)
💰 Total Revenue Breakdown
Two main categories with subcategories:
- 🏠 Accommodation Revenue
- Confirmed Room Price
- Cancelled Room Price
- No-Show Room Price
- Option Room Price
- 🛎️ All Services Revenue
- Custom (e.g., Breakfast, Minibar, etc.)
🔻 Discounts
- Summarizes negative service values in the Folio table.
- Affected by the status filter (e.g., if "Option" is unchecked, option-related discounts won’t be included).
🏷️ Coupons
- Summarizes negative coupon values in the Folio table.
- Affected by the status filter, similar to Discounts.
💳 Commission
- Displays commission amounts related to bookings.
- Affected by the status filter.
📌 Summary Calculation
Formula:
Total Revenue - Discounts - Coupons - Commission
📂 Additional Information
⚖️ Gross vs. Net Values
All numbers displayed in the report are either Gross (tax included) or Net (tax excluded) based on your settings:
- Path: Settings → General Settings → Other Settings → "Amounts displayed in Reports"
📄 Export & Print Options
The report can be:
- 🖨️ Printed
- 📥 Exported to Excel