Upgraded Finance and Occupancy Reporting: What’s Changed

This article explains the Finance and Occupancy Reporting updates now live in Cloudbeds, including how financial transactions and occupancy metrics are calculated and where these changes are reflected across reports and the PMS.


Overview

  • At Cloudbeds, we’re committed to continually improving our platform to meet the evolving‬ needs of the hospitality industry.
  • As part of this commitment, Cloudbeds has upgraded its backend systems to align with industry standards, hospitality accounting best practices, and the Uniform System of Accounts for the Lodging Industry (USALI).

  This update is live as of December 2025. No action is required from properties.

Two Big Changes to the Data

Occupancy Data Standardization‬

Occupancy-related metrics have been brought in line with the Uniform System of‬ Accounts for the Lodging Industry (USALI), improving consistency and comparability:‬

  • Standardized Definitions: Occupancy is now calculated uniformly across all‬
    dashboards and reports as 'Total Rooms Sold / Total Rooms Available'
  • Updated availability counts: Temporarily Out of Service and Blocked Rooms are included in availability counts, in line with USALI.

    Per USALI, only long-term closures (e.g., 6+ months) would be excluded; however, since Cloudbeds PMS doesn’t have a “long-term” status, all Blocked and Out of Service rooms remain included in the calculations across the PMS and reports.

    If you’d like to see occupancy without Blocked and Out of Service rooms, Cloudbeds Insights offers an Adjusted Occupancy field, available in stock reports like Occupancy Statistics, Occupancy History and Forecast, and Production Report.
  • ADR & RevPAR Aligned to USALI:
    • ADR (Average Daily Rate) = Total Room Revenue / Total Rooms Sold‬
    • RevPAR (Revenue Per Available Room) = Total Room Revenue / Total Rooms‬ Available (including temporarily out of service and blocked rooms)‬
  • Room Revenue Definition Updated: Room Revenue now excludes cancellation fees‬
    and both inclusive and exclusive taxes and fees.‬
  • New Reporting Granularity: Room-level and room-type data are now available, and‬
    work seamlessly with Split Inventory setups (physical rooms counted only).‬
  • PMS-wide Improvements: These occupancy changes are reflected across the‬
    Dashboard, Calendar, Groups, PIE, and all Reports within the PMS.‬

Places within the PMS that display the updated occupancy data:

Calendar

The Calendar gives you a convenient, visual way to manage your property. From there, you can check the occupancy percentage to forecast and track real-time availability.

Key Change:

  • Blocked and Out of Service rooms remain included in Total Rooms Available (inventory) but are not counted as rooms sold when calculating occupancy.

Occupancy Calendar.png

Dashboard

The Dashboard makes operations easier by allowing you to have a quick summary of the current day, including an overview of the Occupancy and Forecast highlights metrics.

Key Changes:

  • Room Sold is not include held allotment blocks.
  • Average Daily Rate (ADR) is calculated using Total Room Revenue instead of Room Rate.
  • Revenue is Total Room Revenue, including Room Rate, Additional Room Revenue (manual and no-show), and Room Revenue Adjustments.

Occupancy Dashboard.png

PIE (Price Intelligence Engine)

The Price Intelligence Engine (PIE) feature effortlessly gathers and displays market data in real-time, serving as a Revenue Management System (RMS).

Key Changes:

  • Blocked and Out of Service rooms remain included in Total Rooms Available (inventory) but are not counted as rooms sold when calculating occupancy.
  • Average Daily Rate (ADR) is calculated using Total Room Revenue instead of Room Rate, which includes Room Rate, Additional Room Revenue (manual and no-show), and Room Revenue Adjustments.
  • Capacity, Rooms Available, and Rooms Sold only include physical rooms, as virtual rooms are excluded.

Overview tab

Occupancy PIE overview tab.png

Rate Manager tab

Occupancy PIE rate manager tab.png

Occupancy PIE rate manager tab second image.png

Rate Shopper tab

Occupancy PIE rate shopper tab.png

Groups

The Group feature is a powerful tool that enables hoteliers to enhance their capabilities for managing Group and Contracted Corporate business. This functionality organizes related reservations under Group Profiles. Each Group Profile page includes a header summarizing important information about the respective group.

Key Changes:

  • Revenue is Total Room Revenue, including Room Rate, Additional Room Revenue (manual and no-show), and Room Revenue Adjustments.
  • Average Daily Rate (ADR) is calculated using Total Room Revenue instead of Room Rate.
  • Blocked and Out of Service rooms are not removed from the Night Available calculations.

Occupancy Group.png

Accounting and Financial Transaction Enhancements

We’ve standardized how transactions are recorded to ensure greater accuracy, auditability,‬ and alignment with proper accounting principles:‬

  • No Backdating: All transactions are locked to the actual posting date, ensuring‬ chronological accuracy.‬
  • Service Date Added: Each transaction now includes a service date for clearer‬ alignment with when services were delivered. This may be back-dated.‬
  • Voided, deleted, or routed transactions now appear as equal and opposite entries, preserving a complete audit trail.‬
  • Transaction codes: These are now reportable within Cloudbeds Insights, allowing for detailed‬
    ‭ financial filtering.
  • Accounting codes implementation: ‬Below is a list of USALI codes Cloudbeds has implemented to categorize specific‬ transactions. Additional codes may be added in the future.
Code list
Description Code
Room Rate 1000
Room Rate - Adjustment 1000A
Room Rate - Void 1000V
Room Revenue 1100
Room Revenue - Adjustment 1100A
Room Revenue - Void 1100V
No Show 1200
No Show - Adjustment 1200A
No Show - Void 1200V
Item & Service 2000
Item & Service - Adjustment 2000A
Item & Service - Void 2000V
Addon 3000
Addon - Adjustment 3000A
Addon - Void 3000V
Custom Item (POS) 4000
Custom Item (POS) - Adjustment 4000A
Custom Item (POS) - Void 4000V
Cancellation 5000
Cancellation - Adjustment 5000A
Cancellation - Void 5000V
Tax 8000
Tax - Adjustment 8000A
Tax - Void 8000V
Fee 8100
Fee - Adjustment 8100A
Fee - Void 8100V
Payment 9000
Refund 9000A
Payment - Void 9000V
Payment (Cash) 9100
Refund (Cash) 9100A
Payment (Cash) - Void 9100V
Payment (Bank Transfer) 9200
Refund (Bank Transfer) 9200A
Payment (Bank Transfer) - Void 9200V
Payment (Credit Card) 9300
Refund (Credit Card) 9300A
Payment (Credit Card) - Void 9300V
Deposit Transfer 6000
Accounts Receivable Ledger Transfer 7000
Routed Rate 1000R
Routed Room Revenue 1100R
Routed Cancellation 5000R
Routed No Show 1200R
Routed Item & Service 2000R
Routed Addon 3000R
Routed Custom Item (POS) 4000R
Routed Tax 8000R
Routed Fee 8100R
Routed Payment 9000R
Routed Payment - Cash 9100R
Routed Payment - Bank 9200R
Routed Payment - Card 9300R

A feature is available that allows you to assign specific accounting codes when necessary.

  • Improved Categorization: Transaction codes ensure that revenue and payments are‬ classified into the correct financial “buckets,” supporting cleaner reporting and‬ compliance.

List of enhanced reports

The updates described above affect the following Standard Reports, also known as Classic Reports. The impact may vary by property and usage.

*Denotes reports affected by the Occupancy Data update, while all others are due to the‬ abovementioned financial and accounting data updates.‬

Frequently Asked Questions

Do I need to do anything after the Finance and Occupancy Reporting upgrade?

No action is required. The Finance and Occupancy Reporting upgrade is fully live and already applied across the PMS.

During the upgrade process, some preparatory steps were recommended to help properties transition smoothly to the new reporting logic. These included:

  1. Downloading any historic Classic Reports needed for reference. In each Classic Report, click Export To in the top-right corner and choose PDF or Excel. Learn more in the Classic Reports list.
  2. Reviewing and validating Split Inventory configurations. Confirm how occupancy works with Split Inventory and whether any configuration updates are needed: How do Occupancy Metrics work with Split Inventory. If you previously used Shared Inventory, refer to the Shared to Split Inventory Migration Guide.
  3. Reviewing occupancy-based pricing rules in PIE. Some properties temporarily disabled these rules during the upgrade to better understand how the updated occupancy logic affected their pricing strategy, then re-enabled and adjusted them if needed. See Create, edit, or delete occupancy-based rules/alerts in PIE.

 If you did not complete these steps at the time, no further action is required.

  • However, we recommend reviewing your current inventory, occupancy, and pricing configurations to ensure they align with the upgraded reporting logic and to avoid misunderstandings when interpreting your data.

How do these changes relate to Cloudbeds Insights?

When you are using Cloudbeds Insights, there are 2 Data Fields to help with accounting codes:‬

  • Cloudbeds Transaction Code‬
  • Cloudbeds Transaction Description‬

These correlate to the USALI codes implemented and discussed above.‬ Each transaction in the financial dataset has one of these codes. Here is an example:‬

In the new Occupancy Data Set, these codes are bucketed to a less granular level for‬ reporting purposes. To understand which codes are included in each bucket, check the code guide:

Code guide
Cloudbeds Data Field (CDF) Accounting Codes Notes
Room Rate 1000 + 1000R + 1000V

Room Rate

*It includes Regular, Voids, and Routes, but NOT Adjustments.

Total Room Revenue Adjustments 1000A + 1100A + 1200A

Room Rate adjustments

No Show adjustments

Manual Room revenue adjustments

  • It includes adjustments only, including manual room revenue adjustments.
Other Room Revenue 1100 + 1100R + 1100V + 1200 + 1200R + 1200V

No Show

Manual Room Revenue

  • It includes Regular, Voids, and Routed, but NOT Adjustments.
Total Room Revenue 1000 + 1000R + 1000V + 1100 + 1100R + 1100V + 1200 + 1200R + 1200V + 1000A + 1100A + 1200A

Total of Room Rate

Other Room Revenue

Room Revenue Adjustments

  • As seen on the cell on the left, it includes Regular, Voids, Routes, and Adjustments.
Other Revenue 3000 + 3000V + 3000R + 2000 + 2000V + 2000R + 4000 + 4000V + 4000R

Add-ons

Items & Services

Custom Items (POS)

  • It includes Regular, Voids, and Routed, but NOT Adjustments.
  • This includes food and beverages.
Total Other Revenue Adjustments 3000A + 2000A + 4000A

Add-ons Adjustments

Items & Services Adjustments

Custom Items (POS) Adjustments

  • It includes adjustments only.
  • This includes food and beverages.
Total Miscellaneous Income 5000 + 5000A + 5000V + 5000R

Cancellation Fees and Cancellation Fee Adjustments

  • As seen on the cell on the left, it includes Regular, Voids, Routes, and Adjustments.
Total Other Revenue 3000 + 3000V + 3000R + 2000 + 2000V + 2000R + 4000 + 4000V + 4000R + 3000A + 2000A + 4000A + 5000 + 5000A + 5000V + 5000R

Cancellation Fees

Add-ons

Items & Services

Custom Items (POS)

  • As seen on the cell on the left, it includes Regular, Voids, Routes, and Adjustments.
  • This includes food and beverages.
Total Revenue 1000 + 1000R + 1000V + 1100 + 1100R + 1100V + 1200 + 1200R + 1200V + 1000A + 1100A + 1200A + 5000 + 5000A + 5000V + 5000R + 3000 + 3000V + 3000R + 2000 + 2000V + 2000R + 3000A + 2000A + 4000 + 4000V + 4000R + 4000A

Room Rate

No-show

Other room-related revenue that is not room rate

Cancellation Fees

Add-ons

Items & Services

Custom Items (POS)

  • As seen on the cell on the left, it includes Regular, Voids, Routes, and Adjustments.
  • This includes food and beverages.
Total Taxes 8000 + 8000R + 8000V + 8000A

Taxes – Inclusive and Exclusive

  • As seen on the cell on the left, it includes Regular, Voids, Routes, and Adjustments.
Total Fees 8100 + 8100R + 8100V + 8100A

Fees – Inclusive and Exclusive

  • As seen on the cell on the left, it includes Regular, Voids, Routes, and Adjustments.

Here is an example of a report with some of these buckets:‬

Can I see the old occupancy metrics in the PMS or reports?

Only the new metrics are available in the PMS. However, in Cloudbeds Insights, there is an “Adjusted Occupancy” Cloudbeds Data Field (CDF) with the formula as follows:

  • Occupancy = Total Rooms Sold / (Capacity - Blocked Rooms - Out of Service Rooms)

Also, in Cloudbeds Insights with report builder, customers are able to create a formulated CDF for ADR that mimics what was previously available in some properties by using the Room Rate CDF.

  • ADR legacy = Room Rate / Total Rooms Sold

If I don't have access to Cloudbeds Insights, can I still see an adjusted occupancy that removes blocked and OOS rooms from the stock reports?

Yes! We support adjusted occupancy Cloudbeds Data Fields (CDF) that remove the blocked and out of service rooms. You can use these reports:

  1. Occupancy by Room Type - Last Month
  2. Occupancy Comparison - Month
  3. Occupancy Comparison - Today
  4. Occupancy History and Forecast
  5. Occupancy History and Forecast by Room Type
  6. Occupancy History and Forecast by Room Type and Source
  7. Occupancy Statistics
  8. Occupancy Statistics by Room Type
  9. Occupancy Statistics by Room Type - Month to Date
  10. Occupancy Statistics by Room Type - Today
  11. Occupancy Statistics - Month to Date
  12. Occupancy Statistics - Today
  13. Production
  14. Production Report by Month - Year to Date
  15. Production Report by Room Type
  16. Production Report - Month to Date
  17. Production Report - Today
  18. Rooms Sold and Occupancy
  19. Rooms Sold and Occupancy by Month
  20. Rooms Sold and Occupancy - Today

  You can access these reports by going to Reporting Reporting icon.png > Cloudbeds Reports > Occupancy > and inserting the desired report name in the Search Reports bar.

Do I need to adjust my PIE occupancy-based rules after this update?

No immediate action is required. The upgraded occupancy logic is already applied across PIE and the PMS.

However, if you use occupancy-based pricing rules or alerts in PIE, we recommend reviewing them to ensure they still align with how occupancy is now calculated. Since Blocked and Out of Service rooms remain included in Total Rooms Available (inventory), your occupancy percentages may differ from what you previously saw.

Are definite allotment blocks included in the new occupancy calculation?

No, definite allotment blocks are not considered in the new occupancy calculation. The calculation includes only rooms sold that have reservations, and the rooms available count does not exclude allotment blocks, blocks, or out-of-service rooms.

Why do I see duplicate or old room type names in my Standard (Classic) report filters?

In Classic reports (for example, Rooms Sold/Occupancy or Production), the Room types filter may display duplicate or old names of the same accommodation type. This happens because Classic reports preserve a historical record of room type name changes. When you rename a room type in your property settings, past stays keep the old name while new stays use the updated one. Both names appear in filters to ensure the historical data remains accurate.

If your reporting period spans before and after a rename, you need to select all historical names of that room type to include the complete dataset. This is expected behavior (not an error) and is documented in the Rooms Sold/Occupancy Report article (FAQ).

Example of a filter showing historical names:

Room types filter showing historical names

How to confirm whether a rename occurred:

  1. From your Account Menu Account menu icon.png, go to Logs > Activity Log.
  2. In Filter, open Change Made and select ROOM TYPE MODIFIED.
  3. Click APPLY. Look for entries like “Room type name was changed from X to Y,” with date/time and user.

Activity Log filtered by ROOM TYPE MODIFIED showing rename entry

 Tip: To avoid long lists of names, consider minimizing frequent aesthetic or non-essential renames of room types unless absolutely necessary.

 Note about deletions: If a room type is deleted entirely, historical data tied to that room type may not be recoverable in Classic reports. Past reservations could appear under a “NULL” value.

 Need help or have questions?

These reporting enhancements are fully live and designed to improve accuracy, consistency, and compliance across financial and occupancy data.

If you have questions about how these updates affect your workflows or reports, our Support Team is available to assist you!

Was this article helpful?
3 out of 13 found this helpful

Comments

2 comments
  • Why was this not added as an integration option? Other large PMS providers allow for an integration to meet USALI standards if required. This affects all past reporting, PIE strategies/rules, and generally how Cloudbeds operates and reports. Insights, Classic Reports, and every different area where these statistics are being reported are all different. There is no consistency within the PMS, so to change how you display and report these statistics seems very counterintuitive.

    0
  • Hello, Jeff Delgado, 

    Thank you so much for sharing your feedback about Cloudbeds Reports.

    We understand how crucial accurate data is for your operations. Our team is currently prioritizing and actively working on optimizing our reporting features, and we're committed to providing you with the best possible experience.

    If you have specific examples or details regarding the inconsistencies you've encountered, we encourage you to contact our Support Team directly. This will allow us to investigate your concerns more thoroughly and provide you with targeted assistance.

    We appreciate your suggestions as we continue to enhance our platform.

    Regards!

    0

Article is closed for comments.