A comprehensive overview of revenue across all room types and key metrics, making it easier to track and analyze data intuitively.
The 'New Revenue Report By Booking' allows users to filter and generate reports based on specific criteria, such as time period, booking source, and room type. This flexibility ensures that users can customize reports to meet their specific needs.
How to Access
To access this report, navigate to:
Reports > Revenue Reports > New Revenue Report By Booking
Understanding the report
The New Revenue Report by Booking includes two main sections:
Printout Conditions
Users can choose the report type they want to generate. There are three options in the Printout Condition section:
-
Accommodation: For Admin and Partner accounts only, you can search for a hotel to export the report.
-
Revenue Recognition By: Choose how revenue is recognized. There are two options:
- Stay Duration – Calculates revenue for the entire booking period.
- Nights in Period – Allocates revenue to specific nights within the selected timeframe.
-
Example: A booking with stay dates from January 7, 2025, to January 10, 2025 will be reflected differently depending on the selected revenue recognition method. If Stay Duration is selected, the report will show 3 nights, covering the entire booking period. If Nights in Period is selected and the filter period is January 1, 2025, to January 8, 2025, the report will show 2 nights, excluding January 9, 2025, as it falls outside the selected date range.
- Detailed by: Allow users to choose how the report should be detailed:
- Line items (Default): Breaks down the report by individual booking items (including booking extras, taxes & fees)
- Room types (Coming soon): Breaks down the report by grouping different room types.
Filters
The filters allow users to customize the bookings displayed in the report based on specific conditions. There are five main fields:
- Period: The Period filter determines which bookings appear in the report based on the nights guests actually stayed at the hotel, not the booking date. When selecting a date range, the system includes all reservations where at least one night of the stay falls within that period. The maximum selection allowed is 3 months at a time.
- Booking source: Filter bookings based on where they originated from (e.g., direct bookings, OTAs).
- Source Type: This filter applies only when the booking source is set to Channel Manager. Select the specific platform from which the bookings were received. If both Channel Manager and another booking source are selected, this field will be locked.
-
Booking Status: Filter bookings based on their current status, including Confirmed, Operational, Completed, Cancelled, Cancelled with Penalty, No Show, and No Show with Penalty.
-
Currency: Select the currency in which you want to view the data. If multiple currencies are selected, the report you download will be divided into separate sheets for each one. Choose a sheet to view data for a specific currency.
Instructions
This section provides a clear summary of the filters and settings applied to the report, helping users verify the included data before downloading or printing. It ensures the selected date range, booking sources, statuses, and currencies are correct.
Additionally, it clarifies the report structure, especially when multiple currencies are selected, as separate sheets will be generated. The note at the bottom explains how rates, taxes, and fees are displayed for transparency.
Report Summary
This section provides a summary of key revenue and booking performance metrics for the selected period, offering insights into overall business trends. It highlights total revenue, room nights, reservations, average daily rate (ADR), length of stay, lead time, and cancellations, along with percentage changes compared to a previous period. The data helps hotels track financial growth, booking patterns, and operational efficiency, making it easier to identify trends and areas for improvement.
Graphics
Channel: This graphic provides a breakdown of room nights and revenue by booking channel, helping users analyze which platforms contribute the most to overall performance. The left chart displays the total number of room nights booked through different channels, while the right chart shows the room revenue generated by each.
By comparing these metrics, users can identify high-performing channels, track revenue distribution, and assess the effectiveness of different booking sources over time. This data supports better channel management and pricing strategies to maximize revenue.
Room type: This graphic provides a breakdown of room nights and revenue by room type, helping users analyze which room categories generate the most bookings and revenue. The left chart displays the total room nights booked for each room type, while the right chart shows the room revenue associated with each. By comparing these metrics, users can identify high-performing room types, evaluate occupancy trends, and adjust pricing or promotions accordingly to optimize revenue and room utilization.
Rate plan: This graphic provides a breakdown of room nights and revenue by rate plan. The left chart displays the total room nights booked under different rate plans, while the right chart shows the room revenue associated with each. By comparing these metrics, users can identify high-performing rate plans.
Trends
The "Trend" graphic provides a visual representation of every graphic above. In this example it displays room nights over time, showing fluctuations in booking volume across different channels. Unlike the "Room Nights by Channel" chart, which provides a total count of bookings per channel, the Trend graphic helps track daily or periodic booking trends. This allows users to identify high and low-demand periods, seasonal patterns, and the impact of promotions or external factors on bookings.
The Trend view can be adjusted based on different time breakdowns. Users can choose between Daily, Weekly, or Monthly breakdowns to analyze booking trends over different periods.
