Daily Financial Report

By default, the report displays data from the previous day.

1. Click the calendar icon to change the date.
2. Click the Export To button to download the report in PDF or Excel format.

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.

• 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)

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

The report uses Service Date as an editable date to associate revenue and expenses with the correct stay or service period. The Transaction Date/Time remains immutable to ensure accurate accounting.

Transaction data is pulled from the Accounting Service, which provides detailed transaction-level records aligned with USALI standards. Transactions are not editable, and changes are recorded through equal and opposite reversal entries.

The ADR calculation uses Total Room Revenue, which includes room rate, no-shows, and manual room revenue adjustments. Inclusive and exclusive taxes and fees are excluded.

Items and Services Revenue includes revenue from items and services added to reservations, including any associated adjustments.

When Split Inventory is used, room counts apply only to physical rooms, using their relationship to virtual room types.

Automatic emailing is not available for this report. The Daily Financial Report can be downloaded using the Export To option and shared as needed.

Accounting Codes categorize transactions following USALI standards and are used to group revenue and payments consistently for reporting.

In this report, the codes are bucketed as follows:

The Daily Financial Report does not display Accounting Codes.

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