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.
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.
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.
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.
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.
| 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:
- 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.
- 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.
- 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:
| 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
|
| Other Room Revenue | 1100 + 1100R + 1100V + 1200 + 1200R + 1200V |
No Show Manual Room Revenue
|
| 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
|
| Other Revenue | 3000 + 3000V + 3000R + 2000 + 2000V + 2000R + 4000 + 4000V + 4000R |
Add-ons Items & Services Custom Items (POS)
|
| Total Other Revenue Adjustments | 3000A + 2000A + 4000A |
Add-ons Adjustments Items & Services Adjustments Custom Items (POS) Adjustments
|
| Total Miscellaneous Income | 5000 + 5000A + 5000V + 5000R |
Cancellation Fees and Cancellation Fee 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)
|
| 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)
|
| Total Taxes | 8000 + 8000R + 8000V + 8000A |
Taxes – Inclusive and Exclusive
|
| Total Fees | 8100 + 8100R + 8100V + 8100A |
Fees – Inclusive and Exclusive
|
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:
- Occupancy by Room Type - Last Month
- Occupancy Comparison - Month
- Occupancy Comparison - Today
- Occupancy History and Forecast
- Occupancy History and Forecast by Room Type
- Occupancy History and Forecast by Room Type and Source
- Occupancy Statistics
- Occupancy Statistics by Room Type
- Occupancy Statistics by Room Type - Month to Date
- Occupancy Statistics by Room Type - Today
- Occupancy Statistics - Month to Date
- Occupancy Statistics - Today
- Production
- Production Report by Month - Year to Date
- Production Report by Room Type
- Production Report - Month to Date
- Production Report - Today
- Rooms Sold and Occupancy
- Rooms Sold and Occupancy by Month
- Rooms Sold and Occupancy - Today
You can access these reports by going to Reporting > 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.
Suggested article: Create, edit, or delete occupancy-based rules/alerts in PIE.
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:
How to confirm whether a rename occurred:
- From your Account Menu
, go to Logs > Activity Log.
- In Filter, open Change Made and select ROOM TYPE MODIFIED.
- Click APPLY. Look for entries like “Room type name was changed from X to Y,” with date/time and user.
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!
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.
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!
Article is closed for comments.