Prepare for your Upgraded Finance and Occupancy Reporting

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 2025timelines 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.

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 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.

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 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.

Overview tab

Rate Manager tab

Rate Shopper tab

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.

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 will 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
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:

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 Cancelation 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

Cancelation 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

Cancelation 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 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:

  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.

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.

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 🚀‬

Was this article helpful?
0 out of 0 found this helpful

Comments

0 comments

Please sign in to leave a comment.