Review occupancy, revenue, channel performance, and operations KPIs from the Reporting menu.
Overview
The Hotel → Reporting menu brings together operational and financial views: booking lists, room status snapshots, occupancy and revenue pivots, RevPAR/ADR calculations, channel mix, housekeeping turnaround times, and maintenance resolution metrics.
Most reports use confirmed bookings and completed operational records. Filter by property and date range using the search panel at the top of each screen.
How It Works
Reports fall into three groups:
- Reservations & inventory – Booking Summary, Room Status Report, Occupancy pivot.
- Revenue – Revenue (basic) pivot, RevPAR / ADR wizard.
- Operations – Channel mix, Housekeeping SLA, Maintenance KPIs.
The RevPAR / ADR wizard is interactive: pick a date range and property, click Compute, and see ADR (average daily rate), RevPAR (revenue per available room), sold room-nights, and attributed revenue per property.
Pivot reports let you drag dimensions (property, channel, month) and measures (estimated total, room-nights, completion hours) to explore data without exporting to Excel.
Step-by-Step Guide
- Open Hotel → Reporting → Booking Summary for a filterable list of all bookings.
- Use Room Status Report to see current ops_status across rooms.
- Open Occupancy pivot – group by property and check-in month; measure room-nights.
- Open Revenue (basic) – analyze estimated room revenue by property and period.
- Open RevPAR / ADR, set From and To dates, optionally pick a property, and click Compute.
- Review ADR and RevPAR on the results lines – one row per property when computing all properties.
- Open Channel mix to compare estimated revenue and room-nights by source channel.
- Open Housekeeping SLA for average turnaround hours on completed cleaning tasks.
- Open Maintenance KPIs for resolution hours on completed work orders.
Fields Table
| Field Name | Description | Example |
|---|---|---|
Booking Summary |
List report of bookings with status, dates, guest, revenue |
Filter: Confirmed, this month |
Room Status Report |
Rooms with current operational status |
12 Dirty, 45 Clean |
Occupancy – Room-nights |
Nights × rooms sold on confirmed bookings |
840 room-nights |
Revenue – Estimated total |
Booking estimated room revenue measure |
$126,400 |
Wizard – From / To |
Check-in based date range for KPI calculation |
1 Jun – 1 Jul 2026 |
Wizard – Property |
Optional filter; empty = all properties in company |
Grand Plaza Hotel |
Active rooms |
Count of sellable rooms on the property |
60 |
Available room-nights |
Rooms × nights in the period |
1,800 |
Sold room-nights |
Overlapping confirmed booking room-nights |
1,120 |
Attributed revenue |
Room revenue attributed to the date window |
$168,000 |
ADR |
Attributed revenue ÷ sold room-nights |
$150.00 |
RevPAR |
Attributed revenue ÷ available room-nights |
$93.33 |
Channel mix – Channel |
Source channel dimension on pivot |
Booking.com |
HK SLA – Turnaround (hours) |
Hours from task start to finish on done tasks |
1.2 hrs avg |
Maintenance – Resolution (hours) |
Hours from work start to finish on done orders |
3.5 hrs avg |
Field Explanations
Booking Summary
Standard list of hotel.booking records – use filters for draft/confirmed/cancelled, property, and date ranges.
Room Status Report
Shows each room’s ops_status – useful for end-of-day inventory meetings alongside the front-desk rack.
Occupancy – Room-nights
Primary occupancy measure: number of rooms sold multiplied by nights on confirmed bookings.
Revenue – Estimated total
Uses booking estimated room revenue (rooms + extras). Based on booking prices, not posted invoices.
Wizard – From / To
Defines the analysis window using booking check-in/check-out overlap. To date is exclusive (same as bookings).
Wizard – Property
Limit KPIs to one hotel or leave blank to compute rows for every property in the current company.
Active rooms
Count of active hotel.room records on the property – denominator base for RevPAR capacity.
Available room-nights
Total inventory capacity in the period: active rooms multiplied by number of nights in the range.
Sold room-nights
Portion of confirmed booking room-nights that fall inside the wizard date window.
Attributed revenue
Share of each booking’s estimated total proportional to overlapping nights in the window.
ADR
Average Daily Rate – revenue per sold room-night. Higher ADR means stronger pricing on occupied rooms.
RevPAR
Revenue Per Available Room – revenue spread across all available room-nights, sold or not. Key hotel industry KPI.
Channel mix – Channel
Groups bookings by Source channel. Requires channels to be set on bookings – see Distribution guide.
HK SLA – Turnaround (hours)
From housekeeping tasks in Done state with start and finish timestamps. Lower is faster cleaning.
Maintenance – Resolution (hours)
From maintenance orders in Done state. Tracks how long rooms stay out of service.
Tips
- Tag every booking with a source channel before month-end so channel mix reflects true OTA vs. direct mix.
- Run RevPAR / ADR weekly with the same date range length (e.g. always 30 nights) for comparable trends.
- Housekeeping and maintenance KPIs only include completed work with start and finish times – train staff to use Start/Done buttons.
Common Mistakes
- Comparing wizard dates incorrectly The wizard uses booking overlap logic – a long stay crossing your To date only counts nights inside the range.
- Expecting invoice-based revenue on basic reports Estimated total comes from booking prices; use Accounting for posted invoice totals.
- Empty SLA reports If housekeeping skips Start, completion hours stay zero and SLA pivot looks empty.