Occupancy Reports

Three views of the same question — how full were you — at three levels of detail: by day, by room type, and by individual room. All take the standard Period filter and download as CSV or PDF.

Occupancy rate here means rooms occupied divided by rooms available, so a room blocked for maintenance still counts as unavailable and does not quietly flatter the percentage.

• Occupancy Overview:
  • One row per day for the period, so you can see the shape of demand rather than a single average. An Occupancy trend chart plots it. Columns: date, total available rooms, rooms occupied, occupancy rate, RevPAR, total revenue, upcoming reservations, cancellations and no-shows. The last three columns are what make this more than an occupancy chart: a day with good occupancy and a run of cancellations behind it was not really a good day, and upcoming reservations show what is already on the books for the days ahead rather than what has already happened.
• Occupancy by Room Type:
  • The same period broken down by room type, and — uniquely in this family — compared with the same period last year. A RevPAR by room type chart sits above the table. Columns: room type, available room nights, quantity sold, quantity comparison, average daily rate, average daily revenue, RevPAR and RevPAR comparison, with a total row. The two comparison columns are the report: they say whether a room type is genuinely growing or just riding a good year, and a type whose quantity is up while its RevPAR is down is being discounted harder than it needs to be. Summary cards add Top booking source, Total commissions and the percentage of bookings that carried no commission — the direct business, in other words.
• Room Usage:
  • One row per physical room, for facilities planning rather than revenue management. Summary cards give Average occupancy and Total revenue, and an Occupancy and revenue by room type chart groups them. Columns: room, type, current status, occupied days, available days, maintenance days, occupancy rate, revenue, turnovers and last cleaning. Turnovers counts how many separate stays the room handled — a room with high turnovers and low occupied days is doing a lot of short stays, which is more housekeeping work for the same money. Maintenance days is the column to read when a room’s revenue looks poor: it may have been perfectly sellable and simply unavailable. Blocked rooms and their reasons are listed in full under Reservation Reports.