1. Cloudbeds
  2. Cloudbeds Insights & Reports
  3. Classic Reports
  4. Reports Frequently Asked Questions

How does Cloudbeds PMS calculate Room Sold / Occupancy Report

Colin Slade
Updated

  Our system uses the following reservation statuses to calculate room nights sold for the selected period of time: Confirmation Pending, Confirmed, In-House, and Checked-out.

The following statuses are not part of the calculation: Cancelled and No-show.

You can use either the Room Nights Sold Method or the Percentage Method. Both are listed below with examples.

Room Sold / Occupancy Report:

  • Using the Room Nights Sold Method
    • Formula: Room Revenue / ADR = Room Nights Sold
      • Jan 2023 = $10,748.99 / $74.65 = 144 room nights sold
      • Feb 2023 = $619.24 /$11.06 = 56 room nights sold
      • Mar 2023 = $1925.64 / $24.69 = 78 room nights sold
      • Note: You can get the Average daily rate (ADR) daily, weekly, and monthly from the ADR Report listed under Production Reports. Also, these are room nights sold, not individual guest reservations.
      • Use the Room Revenue data obtained from the ADR report only. The following reports use different data sources for room revenue calculation: RevPar and Daily Financial. They will lead you to a mistaken Rooms Sold/Occupancy result.
  • Using the Percentage Method 
    • Formula: # of Room Nights Sold / Total Property Accommodation
      • When using the weekly statistics, you must multiply the total number of accommodations by 7.
      • When using the monthly statistics, you will need to multiply the total number of accommodations by the total number of days in that month.
    • Examples: 
      • Jan 2023 = 48 total units x  31 days  = 1488 total sellable room nights
        • 144 room nights sold /1488= 0.09677419  ----> 9.68%
      • Feb 2023 = 48 total units x 28 days = 1344 total sellable room nights
        • 56 room nights sold / 1344 = 0.04166666666667 -----> 4.17%
      • Mar 2023 = 48 total units x 31 days = 1488 total sellable room nights
        • 78 room nights sold / 1488 = 0.0524193548387097------> 5.24%
Was this article helpful?
7 out of 16 found this helpful

Comments

2 comments
Date Votes
  • Avatar
    Itswatsonmydear

    Is there a way to change the ADR to not include courtesy holds, out of service and blocked dates, in it's calculation?

    0
  • Avatar
    Juss Reyes

    Hello, Itswatsonmydear!

    Thank you so much for asking this question. 

    We can kindly suggest you to please contact our Support Team for dedicated assistance with this specific inquiry. 

    Kind regards!

    0

Article is closed for comments.