This article outlines the changes that will improve the accuracy and reliability of financial transactions and occupancy reporting, detailing which reports and other PMS components will be affected by these enhancements.
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, we are upgrading our backend systems to align with industry standards, best practices in hospitality accounting, and the Uniform System of Accounts for the Lodging Industry (USALI).
The enhancements are currently in a limited-release phase and will be progressively released per property by the end of Q2 2025; timelines are subject to change.
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, per USALI. Only long-term closures should be removed.
-
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 will 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 will not be removed from the calculations.
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 will not include held allotment blocks.
- Average Daily Rate (ADR) will be calculated using Total Room Revenue instead of Room Rate.
- Revenue will be 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 will not be removed from the occupancy calculations.
- Average Daily Rate (ADR) will be calculated using Total Room Revenue instead of Room Rate, which will include Room Rate, Additional Room Revenue (manual and no-show), and Room Revenue Adjustments.
- Capacity, Rooms Available, and Rooms Sold will 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 will be Total Room Revenue, including Room Rate, Additional Room Revenue (manual and no-show), and Room Revenue Adjustments.
- Average Daily Rate (ADR) will be calculated using Total Room Revenue instead of Room Rate.
- Blocked and Out of Service rooms will not be 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 will 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 |
Cancelation | 5000 |
Cancelation - Adjustment | 5000A |
Cancelation - 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 Cancelation | 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 |
We will also introduce a feature allowing you to assign specific codes when necessary.
- Improved Categorization: Transaction codes ensure that revenue and payments are classified into the correct financial “buckets,” supporting cleaner reporting and compliance.
As we implement these improvements, some of the familiar reports you rely on will change.
List of enhanced reports
The changes mentioned above will 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
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 will have 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 Cancelation Fee Adjustments
|
Total Other Revenue |
3000 + 3000V + 3000R + 2000 + 2000V + 2000R + 4000 + 4000V + 4000R + 3000A + 2000A + 4000A + 5000 + 5000A + 5000V + 5000R |
Cancelation 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 Cancelation 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 will be available in the PMS. However, in Cloudbeds Insights, there will be 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 will be 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.
I have the PIE feature in my PMS. Do I have to take direct action as a result of these changes?
If you have occupancy-based pricing rules in PIE, you may want to turn them off while we roll out the changes until you understand how they will affect your occupancy.
Suggested article: Create, edit, or delete occupancy-based rules/alerts in PIE.
We’re here to support you during this transition 🤝
While these updates are necessary for compliance and consistency, they may require some adjustments in your current workflows. Our Support Team will guide you through the changes, address any questions, and ensure your property is positioned for success!
Your collaboration in adopting these changes is key, and we’re excited to help you take full advantage of these new capabilities 🚀
Comments
Please sign in to leave a comment.