Average Daily Rate (ADR) Report

Juss Reyes

Updated October 03, 2025 20:40

🆕 This article reflects the latest version of this report.

We're excited to announce that we're upgrading our reporting suite! These enhancements are aimed at providing greater transparency, accuracy, and actionable insights to support your daily operations and help you achieve your business goals. For a comprehensive overview of the changes, please visit: Prepare for your Upgraded Finance and Occupancy Reporting.

Currently, these enhancements are in a limited-release phase and will be gradually rolled out for each property by the end of Q4 2025. Please note that timelines may change.

We recognize that adjusting to updates can take time, and we appreciate your patience and support during this transition! If you have any questions or concerns, our support team is ready to assist you.

Overview

The Average Daily Rate is an important metric that is mainly used to compare your property with the competition. It gives you the average revenue for all of your booked rooms.

The ADR of rooms sold is calculated as Total Room Revenue divided by Total Rooms Sold. This includes room rate, manual room revenue, no-show fees, and manual room revenue adjustments.

For example, a property sells multiple rooms at different prices:

If I sell 1 King room for $100, my ADR is $100. ($100/1 accommodation) = $100 per accommodation.
If I sell 1 King room for $100 and 1 Queen room for $50, my ADR is $75. ($150/2 accommodations) = $75 per accommodation.
If I sell 1 King room for $100, 1 Queen room for $50, and 1 dorm bed for $30, my ADR is $60. ($180/3 accommodations) = $60 per accommodation.

In this article, you'll learn how to observe these changes graphically.

Important to know:

- The ADR excludes inclusive or exclusive taxes and fees, as well as cancellation fees.
- For properties with split inventory, the Total Rooms Sold includes physical rooms only.

Access the ADR Report

From the Main menu , go to Classic reports
Click on Production Reports
Select Average Daily Rate

Navigate the ADR Report

Apply filters

Once there, you can click on Filters to begin narrowing down what you need to see.

Select the exact dates, year, and the comparison year
Choose which room types you would like to analyze.
You can select which reservation source you would like to check. In most cases, it's best to leave them all selected.
Click on the Apply button to generate the report.
Export To: Download the report as a PDF/Excel.

This report uses the service date, which is the date the product or service is delivered. With proper permission, the service date can be backdated to recognize revenue and expenses in the correct period. To learn the difference between the Service Date and the Transaction Date, click here.

How to understand the graphic

In the example below, today is marked by the vertical line. Today's line is very important for understanding pace.
In the comparison, blue is this year, and red is last year. All the dates before today are in the past and, therefore, unworkable.
The bottom of the Shaded Area is what we call the Paceline. This line shows you the forecast of the ADR for the month of November as of October 15th. As long as this year's line is on or above the Paceline, you should do better than last year. However, if this year is below the Paceline, it may suggest that you may be falling behind and there is work to be done.
The top or Red line shows where you ended up. The area in the middle shows the reservation growth (or pace) you experienced between today and that specific date.
Comparison year legend (in the example below, 2024 vs 2023)

Toggle between day, week, or month to see the exact detail you are looking for.
Today's line advances to the next month in month mode/view. By selecting the day or week view, the line will appear on the corresponding day or week.

How to understand the report

With the filters applied, you will receive the report generated with the following information:

Date range (1 day, week, month) - according to the interval settings.
ADR for the primary selected year.
Accommodations booked for the primary selected year in number of rooms.
Revenue for the primary selected year.
Change % comparison: Percentage difference in ADR between two time periods (for example, from 2023 to 2025). It’s used to evaluate whether the average price per room has increased or decreased over time. To calculate the Change % from 2023 to 2025, the following formula is used: subtract the 2023 ADR from the 2025 ADR, divide the result by the 2023 ADR, then multiply by 100.
Example:

For January, using the values from the table below, the calculation would be: ($10 − $3.99) ÷ $3.99 × 100 = 150.55%
- Positive percentages are shown in green to show an increase in ADR, while negative percentages are displayed in red to show a decrease.
- If the ADR for the earlier year (e.g., 2023) is $0, the percentage change is not calculated and is represented as 0%.

Why is my report different now?

As mentioned at the beginning of this article, we are upgrading our reporting suite capabilities, and this article reflects the latest report version. These are the key changes:

The Transaction Date/Time is now immutable for rigorous accounting.
The Service Date has been‬ added as an alterable date to support common associations. Now the report is‬ filterable by Service Date to meet common reporting needs. Its respective tooltip was added.
Transaction data will be pulled from the new accounting service, which is more detailed and aligned with USALI‬ standards. Transactions are not mutable; reversals have equal and‬ opposite transactions.‬
The Revenue in the average daily rate formula will not include any taxes and fees (previously, it‬ included inclusive taxes and fees, as well as cancellation fees). Room Rates, No shows, and‬ Manual adjustments are included.
Accommodations booked will take into account split inventory and will include only‬ physical rooms using their virtual room relationship.
The Email option (Green button) is being removed. While this feature is no longer available, you can download the report as needed by clicking Export To (Blue button).
We have implemented Accounting Codes to categorize‬ specific transactions following USALI standards:

Accounting Codes list and examples

In this report, the codes are bucketed as follows:

Description	Code
‬Total Room Revenue:‬ Total of Room Rate‬ Other Room Revenue‬ Room Revenue Adjustments	1000 + 1000R + 1000V + 1100 + 1100R + 1100V + 1200 + 1200R + 1200V + 1000A + 1100A + 1200A‬

Unlike other reports, the ADR Report does not show Accounting Codes.

Below is an example of the codes associated with the transactions:

Some customers already have access to the new version of this report.

If you can't see the updated version, don't worry! The enhancements will be gradually rolled out for each property by the end of Q4 2025. For more information, visit this article.