This report provides an overview of the hotel's daily revenue from all revenue departments for any selected time period. The report shows the revenue generated by the different revenue streams at the property, such as from Room Rate, Room Cancellation Charge, Room No-show Charge, F&B Charge, Tourism Tax, Housekeeping Charge, etc. By default, it displays data on a daily basis, but it can also be adjusted to aggregate the data by week, month, quarter, year, or a custom period.
The Daily Revenue Report is organised into two tabs: 1. Recognised Date, and 2. Charge Type. Users can choose to view the data by clicking on the respective tabs found below the report filters. Each tab contains a chart and three tables.
Tab 1: Recognised Date
Data shown on this tab is sorted based on the date when the revenue has been earned (or recognised).
(1) The Daily Revenue by Recognised Date chart displays a stacked bar chart of the daily gross amount for various charge types at the property, grouped by the date the revenue was recognised.
For example: the gross amount for the Room Rate metric that was recognised on 15 June 2024 is $5,990.
(2) The Daily Revenue by Recognised Date table shows the data for various charge types, grouped by the recognised date.
(3) The Revenue by Recognised Date (Month) table shows the data by month, according to the selected date range.
For example: if the selected dates are 1 June to 21 July 2024 and all charge types available at the property are included in the report, the data will be grouped into 2 rows: “Jun 2024” and “Jul 2024”.
To retrieve the data from a specific date and time range, customise the time period from the Report Filters, located at the top of the page.
(4) The Revenue by Recognised Date (Total) table shows the combined Total (Sum) of all revenue that has been recognised, for the selected date range.
For any selected date range, there will be only one row of data, reflecting the aggregated metrics for the entire date range.
Tab 2: Charge Type
Data shown on this tab is grouped based on the Revenue/Charge Type. Charge Type metrics will only show on the report if properties are recording them in HMS.
(1) The Revenue by Charge Type Mix chart shows the revenue share of the various charge types available at the property.
To view specific Charge Type metrics, click the INV button to hide all metrics first. Then, select the metrics to be displayed in the chart.
For example: to see only the Room Cancellation Charge and Room No-show Charge, click the INV button and select the two metrics. To make all metrics shown again, click the ALL button.
Read this article about Chart Filters to learn more about this functionality.
(2) The Daily Revenue by Charge Type table shows the daily revenue organised by the dates when the revenue was recognised, grouped by the various charge types available at the property.
(3) The Revenue by Charge Type (Month) table shows the monthly data for various charge types based on the selected date range.
For example: if the selected dates are 1 June to 21 July 2024 and all charge types available at the property are included in the report, the data will be classified by charge type (e.g.: Other Charges, Room Rate, Tourism Tax, etc) and organised by 2 months, "Jun 2024" and "Jul 2024".
(4) The Revenue by Charge Type (Total) table shows the total revenue generated by each charge type available at the property, for the selected date range.
Charge Type Filter
By default, the Daily Revenue Report will include all Charge Types that are available at the property. Users can choose to include or exclude specific types of charges from the report by selecting or deselecting the Charge Type.
Always remember to click on the master Apply button after changing the selected filters.
Scenario 1: Using the Recognised date tab
Hotel wants to view a daily breakdown of the different types of Revenue/Charges earned at the property for the period of 1 June to 21 July 2024. The data is grouped by day by default.
Explanation:
- The Time Filter is set to 'Custom' as the range type, configured with a Specific Date/Time starting on 1 June (inclusive) and ending on 22 July* (exclusive), grouped by date. By default, all Charge Type metrics are included.
*To include 21 July, the end date must be set to 22 July with timestamp 00:00:00, NOT 21 July. - On the Daily Revenue by Recognised Date table, the data of all Charge Type metrics for this customised period are grouped by 'Recognised Date'.
Scenario 2: Using the Charge type tab
Hotel wants to view a breakdown of the total revenue generated by each Charge Type: Room Cancellation Charge and Room No-show Charge, for the period of 1 June to 21 July 2024.
Explanation:
- The Time Filter is set to 'Custom' as the range type, configured with a Specific Date/Time starting on 1 June (inclusive) and ending on 22 July* (exclusive). Click on the Charge Type tab to group the data based on the selected metrics.
*To include 21 July, the end date must be set to 22 July with timestamp 00:00:00, NOT 21 July. - On the Daily Revenue Totals by Charge Type table, there will be 2 rows of total data, reflecting the Charge Type metrics that have been selected for this customised period: Room Cancellation Charge and Room No-show Charge.
Downloading the report
The entire page of the Daily Revenue Report can be downloaded as an image/PDF file by clicking the three horizontal dots at the upper right corner of the page.
Each of the views can be downloaded individually as well, by clicking on the three dots at the top-right corner of each view. A dropdown list will appear with three options: as a .CSV file, an Excel file, and an image.
Can't find your answer? Contact the ZUZU Helpline
Tags: Daily revenue report, analytics, hotel's revenue, daily revenue by recognised date, daily revenue by charge type, daily gross amount, chart filter, report filter, charge type filter, time range, time period, specific date/time, timestamp 00:00:00