Monthly Revenue and Guestroom Summary report

How much money is on the books for next month? Run this report to see both your group booking and volume contract revenue totals. Using the report criteria, you can slice and dice the data to include exactly what you need—events, group guestrooms, volume contract guestrooms, specific market segments, and more.

Good to know:

• Booking guestroom information is based on pickup figures when all room blocks are marked pickup complete. Otherwise, blocked numbers are used.
• Volume contract guestroom information is based on actual revenue if the period end date is less than or equal to today. If the period end date is greater than today, forecasted numbers are used. If the future period is quarterly or yearly, the forecasted revenue for the period will be equally distributed among the months.
• You must have R32 installed to include Volume Contracts, and R37 to select Volume Contract Types.

The data in the report may be delayed by up to 15 minutes. If the data doesn't match what you'd expect to see, please run the report again in a few minutes.

To run the report

1. Navigate to Amadeus Reports.
2. Under Booking Reports, click Monthly Revenue and Guestroom Summary Report.
3. Complete the report criteria.

Consumption Year	Rooms and revenue that are in house during this year will be included, with totals for each month. Consumption refers to the actual dates that revenue is generated, regardless of the booking's arrival and departure dates. For example, if a booking is in house December 29, 2020 – January 2, 2021 and you run the report for 2020, only those guestrooms on Dec. 29, Dec. 30, and Dec. 31 will be included.
Properties	If you sell multiple properties, you can include them in the report. Only active properties you have access to are shown.
Include Booking/Volume Contracts	Do you want to include group bookings, volume contracts, or both?
Revenues	Select Guestrooms and/or Events.
Revenue Classifications	If you selected to include event revenue, all classifications are included by default—adjust if necessary.
Status	Active statuses are selected by default. You have the option to include inactive statuses like cancelled.
Booking Types	All types are included by default - adjust if necessary. (If only reporting on volume contracts, NA is displayed.)
Guestroom	Blocked is selected by default. You have the option to choose Agreed or Forecast instead. (If only reporting on volume contracts, NA is displayed—you will use the Volume Contract Guestroom field below.)
Revenue Types	Select the booking revenue types you want to report on. (If only reporting on volume contracts, NA is displayed.) By default, Banquet revenue will be selected. You can also include Catering and/or In House.
Volume Contract Types	All types are included by default - adjust if necessary. (If only reporting on bookings, NA is displayed.) This field is dependent upon version R37 or higher.
Volume Contract Guestroom	Forecast is selected by default. You have the option to choose Contracted instead. (If only reporting on bookings, NA is displayed.)
Owners	Select which Sales Managers you want to be included.
Market Segment Type	If you group the report by market segment, or if you select only certain market segments to be included, select if you want the market segment on the booking/contract, account, or either to be used. If Either is selected, we first pull based on the booking/contract segment, and then pull based on the associated account's market segment.
Market Segments	All segments are included by default - adjust if necessary.
Show Detail	When first viewing the results on screen, select Expanded if you want each section to be open, or Collapsed if you want them to be closed. You can then adjust each section after you run the report.
Group By	If you want to see which segments are producing, group the report so it is subtotaled by market segment. Your other grouping option is Booking/Contract Owners.

4. Click View Report.

The following information is displayed for each property, and then each month in the consumption year:

Yearly Summary	If you selected to include booking, volume contract, and event revenue: Rooms (both booking and volume contract), average rate (both booking and volume contract), and total revenue (booking guestroom, volume contract guestroom, and event revenue) consumed in that month.
Yearly Breakdown	Based on your criteria selections, the subtotals for booking, booking event, and contract figures.
Group By Summary	If you selected to group by market segment, each segment is displayed with summary totals of all parameters you included in the report criteria. If you selected to group by Booking/Contract Owners, each sales manager is displayed.
Group By Breakdown	The subtotals for each type of revenue are displayed below the summary section.

Here are a few additional things you can do after you've run the report:

• To export the report data to Excel, PDF, CSV, or another supported file format, use the Export picklist.
• To scroll through a multi-page report, use the First Page , Previous Page , Next Page , and Last Page buttons.
• To change the report zoom, use the Zoom picklist.
• To print the report as a PDF, use the Print button.
• To use the search field, enter the first few characters of the word you want to find (for example, the booking post as) and press Enter or click Find. Click Next to view all instances that match your search criteria.