🆕 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 Q2 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.Â
The Daily Financial report is a quick glance at the previous day's financial statistics. It summarizes all the required data management uses on a daily basis, such as ADR, REVPAR, Occupancy, Total Revenue, and more.
Access the Daily Financial Report
 The Property Owner has access to Financial Reports by default. Other users must have permission enabled under Roles. Learn more about Roles and Permissions.
- From the Main Menu
, go to Classic Reports
.
- Select Financial Reports.
- Click Daily Financial Report
Navigate the Daily Financial Report
By default, the report displays data from the previous day.
- Click the calendar icon to change the date.
- Click the Export To button to download the report in PDF or Excel format.
 Today's data will only be available tomorrow.
 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.
This section displays yesterday's (1) and the current month's (2) occupancy data.
- Availability: Total number of rooms minus occupied and blocked rooms.
- Occupancy: Percentage of rooms sold divided by total rooms available. Blocked rooms and out-of-service rooms are included in the Total Rooms Available. It complies with USALI standards.
- Blocks and Holds: Total number of rooms blocked.
Occupancy Example
Total room inventory = 30
- Availability formula:Â Total number of rooms on property minus occupied rooms minus blocked rooms (30 - 9 - 4 = 17 or 100% - 30% - 13.33% = 56.67%).
- Occupancy formula: Total number of rooms occupied divided by total number of rooms (9 rooms occupied / 30 rooms total = 30%).
- Blocks and Holds formula:Â Total number of rooms blocked divided by total number of rooms (4 rooms blocked / 30 rooms total = 13.33%).
This section of the report is where most of your financial data will be retrieved. Check the definition of each category below.
 Text in blue represents hyperlinks that, when clicked, redirect you to the associated report.
- Items & Services Revenue: Sum of all revenue collected for products that were added to reservations.
- Payments: Sum of all payments collected. This includes all payment types for Reservations and House Accounts.
-
Comps: Number of rooms compensated (with a $0 price) on the specified date.
- Example: Today is February 10, and you have a 3-day reservation for $100/night each. The guest comes and complains, so you choose to allow the guest to stay for free tomorrow (February 11). On the report for the 10th, you will see 0 comps since the room was not made 0 price for the 10th. When you view the report for the 11th, you will see 1 comp.
- Walk-Ins: Total number of reservations created with the source Walk-In. It includes confirmed, confirmation pending, in-house, and checked-out reservation statuses (excludes no-shows and canceled).
- Number of Guests: Total number of guests that stayed at the property on the specified date. It includes confirmed, confirmation pending, in-house, and checked-out reservation statuses (excludes no-shows and canceled).
- Check-Ins: Number of reservations that were checked in.
- Check-Outs: Number of reservations that were checked out.
- AVG LOS (Nights Stayed): Average length of stay of current In-House, Confirmed, Confirmation Pending, and Checked-Out reservations. Looks only at how long each reservation has stayed at the property, not how long they are expected to stay. The calculation includes only dates that have passed. Check the examples below.
- AVG LOS (Total Room Nights): Average length of stay of current In-House, Confirmed, Confirmation Pending, and Checked-Out reservations. The calculation uses the full reservation length, including dates that have passed and upcoming booked nights. Check the examples below.
Examples of AVG LOS (Nights Stayed) and AVG LOS (Total Room Nights)
|
Examples (The current date: 2025-02-14) |
AVG LOS (Nights Stayed) | AVG LOS (Total Room Nights) |
|---|---|---|
| Start date = 2025-02-13, End date = 2025-02-15 | 1 | 2 |
| Start date = 2025-02-14, End date = 2025-02-16 | 1 | 2 |
| Start date = 2025-02-07, End date = 2025-02-16 | 7 | 9 |
| Start date = 2025-02-01, End date = 2025-02-16 | 13 | 15 |
| Start date = 2025-01-01, End date = 2025-02-16 In this case, the system does not consider January in the calculation. |
13 | 15 |
- ADR Per Guest: Room Revenue divided by the number of guests.
- No Shows: Number of reservations marked as No-Show.
- Blocks: Number of Out of Service and Room Block created for the specified date.
- Adjustments: Total value of all adjustments made on the specified date.
- Total Revenue: The sum of total room revenue and total other revenue. This includes items and services, add-ons, cancellation fees, and adjustments. It excludes inclusive or exclusive taxes and fees.
This section provides details for Today and the Month to Date.
- ADR: Average Daily Rate of rooms sold 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. Excludes inclusive or exclusive taxes and fees, and cancellation fees. For properties with split inventory, the Total Rooms Sold includes physical rooms only. It complies with USALI standards.
- REVPAR: Revenue per available room calculated as Total Room Revenue divided by Total Rooms Available. This includes room rate, manual room revenue, no-show fees, and manual room revenue adjustments. Excludes inclusive or exclusive taxes and fees, and cancellation fees. For properties with split inventory, the Total Rooms Available includes physical rooms only. It complies with USALI standards.
- Room Revenue: Calculated as Total Room Rate plus Other Room Revenue plus Room Revenue Adjustments. This includes room rate, manual room revenue, no-show fees, and manual room revenue adjustments. Excludes inclusive or exclusive taxes and fees, and cancellation fees. It follows USALI standards.
This section projects the Total Rooms Sold, ADR, REVPAR, and Room Revenue for the current month.
Displays projected Occupancy, ADR, REVPAR, and Room Revenue for the next 14 days.
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:Â
- 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 graph is not displayed if there is no data for the day.‬
- 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.
- The Revenue in the average daily rate formula will be total room revenue instead of room rate only. This includes Room Rate, No Shows, and Manual Adjustments. Taxes and fees are NOT‬ included (inclusive or exclusive).‬
- The Items and Services Revenue includes items and services adjustments.
- The Total Rooms Sold accounts for split inventory, but only applies to physical rooms using‬ virtual room relationships.‬
- 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:
In this report, the codes are bucketed as follows:
| Description | Code |
|---|---|
|
Total Revenue: Room Rate Other Room Revenue Room Revenue Adjustment Other Revenue Other Revenue Adjustment Miscellaneous Income |
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 |
|
Adjustments: Room Revenue Adjustment Other Revenue Adjustment |
1000A + 1100A + 1200A + 3000A + 2000A + 4000A |
| Total Room Revenue |
1000 + 1000R + 1000V+1100 + 1100R + 1100V + 1200 + 1200R + 1200V +1000A + 1100A + 1200A |
| Items and Services |
2000 + 2000V + 2000A + 2000R |
| Payments |
9000 + 9000A + 9000R + 9000V + 9100 + 9100A + 9100R + 9100V + 9200 + 9200A + 9200R + 9200V + 9300 + 9300R + 9300A + 9300V |
Unlike other reports, the Daily Financial report does not show Accounting Codes.
Below are examples 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 Q2 2025. For more information, visit this article.
Comments
Please sign in to leave a comment.