An occupancy report should help the hotel prepare rooms, staffing and cash expectations. A percentage without a reliable room count or date range can mislead the team.
What occupancy means
Occupancy is commonly calculated as rooms sold or occupied divided by rooms available for sale during the same period, multiplied by 100. Your hotel should define how complimentary, day-use and out-of-order rooms are treated and use the definition consistently.
The daily operating view
- Rooms occupied last night and expected tonight.
- Arrivals, departures, stayovers and extensions.
- Available, ready, dirty and out-of-order rooms.
- Unconfirmed reservations and possible no-shows.
- Expected room revenue and unsettled balances.
This view helps the front desk and housekeeping coordinate today. It is not a substitute for a monthly management review.
The weekly view
Compare occupancy by day of week, booking source and lead time. Look at cancellations and rooms unavailable due to maintenance. A full Saturday and weak weekdays suggest a different action from low occupancy on every day.
The monthly view
Compare the same definitions across periods: available room nights, sold room nights, occupancy, room revenue, average realised room rate, cancellations and no-shows. Add a short note for unusual closures, group stays or local events so the numbers keep their context.
Questions the report should answer
- Which dates need more demand or tighter availability control?
- Are rooms being lost to preventable maintenance?
- Which sources create confirmed stays rather than only enquiries?
- Are cancellations or no-shows changing?
- Does expected revenue reconcile with invoices and payments?
Common reporting mistakes
Avoid mixing date ranges, comparing gross booking value with collected revenue, changing the treatment of blocked rooms, or relying on a room board that staff update late. Record corrections rather than quietly rewriting past data.
Turn the report into a weekly meeting
Keep the meeting short and action-based. Begin with the accuracy of room inventory, then review the dates with high and low demand, rooms lost to maintenance, cancellations, no-shows and unpaid balances. Assign an owner to each action and revisit it the following week.
Example decisions
- Repeated weekend sell-outs may justify closing low-value inventory earlier or improving direct-booking follow-up.
- Several out-of-order room nights may justify preventive maintenance before the next busy period.
- Weak midweek demand may call for local partnerships or clearer direct offers rather than a blanket discount.
- High occupancy with payment gaps calls for a billing-process review, not more demand.
Keep definitions beside the report
Add a small note defining available room, sold room, complimentary stay, cancellation and no-show. State the reporting period and generation time. When someone revisits the report months later, these definitions make comparisons meaningful and prevent a change in method from looking like a change in performance.
Frequently asked questions
Is higher occupancy always better?
No. The hotel must also consider realised room rate, operating cost, guest experience and unavailable rooms.
How often should a small hotel review reports?
Use a concise daily operating view and a deeper weekly or monthly management review. Do not create reports nobody acts upon.