Accommodation Reports
- Introduction
- Opening the Reports
- Room Summary
- Occupancy Report
- Discount Report
- Daily Guest Report
- Accommodation > Occupancy
- Which Report Should I Use?
Introduction
The accommodation reports are for lodge and hotel managers. They answer: how much did each room earn, how full were we, where did our discounts go, and who stayed on which day. Every report is read-only. This chapter also covers the Occupancy tab inside Accommodation, which is a separate report with similar names. For the bookings themselves see Booking a Room and Rooms and Accommodation Settings.
Opening the Reports
- Open Reports > Accommodation Reports.
- The page opens on Room Summary. The other tabs are Occupancy Report, Discount Report and Daily Guest Report.
- Set the dates. The figures refresh by themselves.
Note
You need the See all reports permission. The page has no plan restriction.
Each tab has an Export PDF button at the top right. It opens a PDF preview with the same dates and filters.
The date fields are From Date, From Time, To Date and To Time (the Occupancy tab has dates only). The range starts on the first of the current month. If your business has a day rollover set, the day runs from rollover to rollover and the time boxes are ignored. See How Dates and Business Days Work.
Room Summary
Per-room performance. One row for every room, even a room with no bookings. A booking belongs to the period by the day it was created, not by its stay dates.
| Column | Meaning |
|---|---|
| Room, Floor | The room number and floor. |
| Type, Rate | The room type and its rate. |
| Bookings | Bookings created in the period. |
| Active | Of those, how many are checked in now. |
| Completed | Of those, how many have checked out. |
| Revenue | The stays before discounts: the net total plus the discounts given, less any value written off as complimentary. |
| Discounts | Discounts given on those bookings. |
| Net Revenue | What the stays earned after discounts (and less anything written off as complimentary). |
| Avg Booking | The average stay total. |
| Outstanding | The unpaid room balances. Orange when above zero. |
Cards under the table show Total Rooms, Total Bookings, Net Revenue, Total Discounts and Outstanding Balance.
Cancelled bookings are left out of this report. Rate is the room type's base rate.
Occupancy Report
How full the rooms were. One row per room for stays that fall in the range. Filters: From Date, To Date, Room Number (type part of a number) and Booking Status (Active, Checked Out, Cancelled).
| Column | Meaning |
|---|---|
| Occupied Days | The number of different nights in the range on which this room was occupied (a stay covers the nights from check-in up to the day before check-out; an open stay covers every night to the end of the range). |
| Available Days | Period days minus Occupied Days. |
| Occupancy Rate | Occupied Days ÷ the days in the range, as a percentage. Green from 80, yellow from 50, red below. |
| Bookings, Active, Completed, Cancelled | Booking counts by status. Bookings does not include cancelled ones. |
| Avg Stay | The average length of stay in days. |
| Net Revenue, Discounts | Stay totals after discounts (less complimentary) and the discounts given. Cancelled bookings are left out. |
The top cards show Total Rooms, Avg Occupancy Rate, Total Bookings and Period Days. Two boxes sum up: Revenue Summary (Gross Revenue, Total Discounts, Net Revenue) and Occupancy Statistics (Report Period, Average Occupancy, Total Bookings).
Booking Status narrows the bookings counted in each row; every room still appears. A stay is matched if it overlaps the range, including arrivals during the whole To Date. The Occupancy Rate never goes above 100%.
Discount Report
Where discounts go. Filters: the four date and time boxes, Min Discount Threshold (only rooms whose discounts add up to at least this amount) and Room Filter (part of a room number). It counts bookings created in the period.
Four cards at the top:
- Total Discounts Given, with "% of gross revenue".
- Discounted Bookings, with "% of all bookings".
- Average Discount: the average of the discount over all bookings in the period, including those with none.
- Net Revenue, "After discounts".
Gross revenue here means the room rate plus the package price, before any discount. Discount % compares the discount with that figure.
Discount Analysis by Room columns: Room, Floor, Type, Total Bookings, Discounted Bookings, Discount Rate (share of the room's bookings that had a discount: red above 50%, orange above 25%), Total Discounts, Avg Discount, Max Discount, Min Discount, Discount % (with a small bar) and Net Revenue.
Top 10 Highest Discounted Bookings lists the ten biggest discounts: Booking #, Room, Guest Name, Check In, Check Out, Room Rate, Discount Amount, Discount %, Final Amount and Status.
When discounts exist, a Discount Insights box repeats the totals in sentences. Cancelled bookings are left out of this report. Who may give discounts is set under roles, not in this report.
Daily Guest Report
Who stayed, day by day. Every guest booking is its own row, listed under the day the guest checked in, with the amount for the stay and how it was paid. Cancelled bookings are left out. Each day has its own Day total. Nothing is carried from one day to the next.
Filters: the four date and time boxes. The range is matched on the check-in time.
| Column | Meaning |
|---|---|
| Time | The check-in time. |
| Guest | The guest's name, with the phone number partly hidden. |
| Room | The room number. |
| Package | The package, for example Half Board or Bed Only. |
| Nights | The number of nights. An amber Open badge marks a stay with no check-out date yet. |
| Amount | The stay total as of now, less anything given away as complimentary. |
| Paid | Money received, less complimentary. |
| Balance | Amount − Paid, never below zero. Orange when above zero. |
| Payment Mode | One line per mode used, with its amount, so part-cash part-M-Pesa shows both. A Complimentary line is shown for the record but not counted. |
| Status | Paid, Partial or Unpaid (green, amber, red). |
Under the table: Days with Guests, Guests, Total Amount, Total Paid, Outstanding Balance, and Takings by Payment Mode (the total taken in each mode across the range). With no data you see "No guests checked in during the selected period."
For an open stay, Amount and Nights grow each day, so the same row can show a bigger balance tomorrow.
Deposit Stays
When a guest paid a lump-sum deposit, the row carries a green Deposit tag with "left" and an amount, for example Deposit left 6,500.00. That is the deposit not yet used up: money paid minus the value of the stay so far. The row keeps the full stay total in Amount. It is not reduced as nights are used. The revenue per night from deposits is on Sales & Collections (see Reading the Reconciliation). The same Deposit tag with "left …" appears under Paid on the Accommodation tab of Financial Reports. How deposits are taken is in Payments, Deposits and Checkout.
Accommodation > Occupancy
This is a separate report, the Occupancy tab on the Accommodation page (Accommodation > Occupancy). It shows only to users with the See all reports permission. It counts guest nights, so it is the better measure of how full you were.
Fields: Start Date and End Date (the current month by default) and Room Type. Click Export to Excel for a spreadsheet.
Four cards:
- Occupancy Rate: total nights sold ÷ (rooms that are available × days in the range).
- Total Bookings: bookings checking in during the range, excluding cancelled ones.
- Total Nights: the nights of those bookings.
- Total Revenue: the total of those stays.
Performance Metrics shows Average Rate per Night (revenue ÷ nights), Available Room Nights and Total Rooms. Date Range shows the start, end and total days.
Three tables follow:
- Revenue by Room Type: Room Type, Bookings, Nights Sold, Revenue, Avg Rate.
- Revenue by Package Type: Package Type, Bookings, Revenue, % of Total.
- Daily Occupancy Trend: for each date, the bookings Occupied that night (checked in on or before the date, checking out after it), Available, Rate and a bar.
Note
The rate counts a booking's whole stay when it checks in inside the range, even nights that fall after the End Date. A long stay arriving on the last day can push the rate above 100%. Revenue here is the full stay total, and deposit stays keep their stay total as well. Rooms under maintenance or out of service are not in the room count.
Which Report Should I Use?
- Room Summary and Discount Report group bookings by the day they were created.
- Daily Guest Report groups by check-in day.
- Occupancy Report (in Accommodation Reports) counts check-in days per room.
- Accommodation > Occupancy counts nights.
- For lodge money actually received, use Sales & Collections or Cashier Collections in Financial Reports.
Because each report counts differently, the same month can give different numbers in each. That is expected.