Daily Revenue Report

• Amount: Revenue registered for the selected date
• MTD: Month-to-date
• YTD: Year-to-date

For example, the date selected is 05/15/2024.

• Amount: One day only (05/15/2024)
• MTD: It’s the first day of the month until the selected date (05/01/2024 - 05/15/2024)
• YTD: It’st the first day of the year until the selected date (01/01/2024 - 05/15/2024)

• Revenue by Rooms Revenue: The total amount of revenue generated from room rates on the selected date.
• Revenue by Items & Services: The total amount of revenue generated on the selected date posted under items and services.
• Revenue by Add-On: The total amount of revenue generated on the selected date posted under add-ons.
• Revenue by Cancellation: The total amount of revenue associated with cancellation fees.
• Revenue by Taxes & Fees: The total taxes and fees associated with room rates, items, etc.
• Revenue by Adjustment: The total amount of adjustments that were done on the selected date.
• Revenue by Payment: A breakdown of each payment transaction method generated on the selected date.
• Revenue by Refunds: The total amount of processed refunds for the selected date.
• Revenue by Disputes: The total revenue generated by disputed charges.

• Grand Total (Revenue): The total of all revenue transactions posted to guest accounts for the selected date.
• Grand Total (Payments): The total of payments and refunds applied to guest accounts for the selected date.
• Grand Total (Revenue + Payments): The overall revenue for transactions for the selected date.

• Ledger: If you used the Ledger toggle before clicking "apply," you will see the following rows at the bottom of the report:

  • Opening Balance: It’s equivalent to the closing balance of the previous date (Amount field), month (Mtd field), and year (Ytd field). For example, if the date 05/15/24 is selected, the opening balance in the columns:

    •  
      • The Amount will be the closing balance of the previous date (05/14/24).
      • MTD will be the closing balance of the previous month (04/30/24).
      • YTD will be the closing balance of the last day of the previous year (12/31/23).

    The opening balance will always be zero on the system's first day of operation.

  • Change: It is calculated by subtracting the Grand Total (Payments) from the Grand Total (Revenue). It's the difference between the two.
  • Closing Balance: The sum of the Opening Balance plus the Change. The closing balance will be the opening balance for the next work day.

Transaction data is pulled from the Cloudbeds Accounting service, which provides detailed transaction-level records aligned with USALI standards. Transactions are immutable, and changes are recorded using equal and opposite reversal entries.

Revenue is grouped into distinct categories such as Room Revenue, Items & Services, Add-Ons, Taxes & Fees, Payments, Refunds, and Adjustments. Some categories appear only if they apply to your property configuration and integrations.

Transaction amounts are calculated as Debits minus Credits: Debits add value (e.g., charges or revenue), while Credits remove value (e.g., payments or refunds).

When a payment is recorded:

• The Debit is typically $0
• The Credit reflects the payment amount (e.g., $100)

So the formula becomes: 0 − 100 = −100

That's why payments are shown as negative amounts— the same goes for adjustments!

The Amount balance will be zero ($0.00) if today's date is selected because the system updates room rates at 2:00 AM the following day.

The Daily Revenue Report will be available after all transactions are posted for that day (at 2:00 AM the next day). Even though the report will be available after 2:00 AM, it will display transactions done until 11:59 PM.

When comparing totals between the Daily Revenue Report (DRR) and the Daily Financial Report (DFR), it’s important to note several key differences in how each report is calculated:

To download the report, click Apply to generate it. Once the report loads, the Export To button becomes available, allowing you to download the report as a PDF or Excel file.

Automatic emailing is not available for the Daily Revenue Report. Downloaded files can be shared manually as needed.

Accounting Codes categorize transactions following USALI standards and are used to group revenue consistently across reporting. These codes determine how transactions are bucketed in the Daily Revenue Report, although the report itself does not display the codes.

In this report, transactions are bucketed as follows:

Below are examples of the codes associated with some of the report categories: