GRC report
The GRC report shows which groups are in-house during a specified date range and how many rooms have been blocked for each night of their stay.
The GRC report is useful for tracking what's on the books for future months and provides a convenient summary for weekly sales meetings.
Run the report by booking status or dig deeper and group by room block status. This separates each room block that could have a different status than the booking, providing a granular view, and more insight when forecasting. For a different approach, interrogate your guestroom data to identify room night, revenue, and average rate patterns by market segment.
A few things to keep in mind:
- You must have R31 installed to access this report.
- 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.
- Your property must be "live" before you can use this report—backlog mode is not supported.
To run the report
- Navigate to Amadeus Reports.
- Under Booking, click GRC Report.
- Complete the report criteria.
Field Description Pattern Start Date/End Date Enter a date range to search for bookings that are in-house during that time. The current month is selected by default. Pattern Date refers to the guestrooms blocked on a specific date, regardless of the booking’s arrival and departure dates. For example, if a booking’s arrival and departure dates are October 30 – November 3 and the Pattern Start and End Dates are October 1 – October 31, only the booking’s guestrooms on the 30th and 31st will be included in the report.
Properties Select the properties whose guestroom information you want to include in the report. You can only select properties you have access to. Booking Owner By default, bookings from all Sales Managers will be included in the report (including those who are inactive). If needed, select only those users whose bookings you want to include. Status The report includes Definite, Tentative, and Prospect bookings by default; however, you can also include Lost, Cancelled, and/or Turned Down bookings. Room Count Types Select to view one or more of the following: - Agreed – The number of rooms contracted with the group.
- Forecast – The number of rooms you expect the group to consume.
- Blocked – The number of rooms taken out of inventory for the group (default).
- Picked Up - The actual number of rooms consumed by the group.
When you run the GRC report with only Blocked selected as the Room Count Type, pickup numbers are shown if the entire booking has been marked pickup complete. Otherwise, blocked numbers are shown. A “Blk/Pck” label is displayed next to the booking name to indicate that the room counts might be blocked or pickup depending on the status of the Pickup Complete flag on the booking. A message is also displayed in the header of the report.
Housing Method By default, all housing methods will be included in the report (including those that have been deleted). If needed, select only those methods you want to report on. Booking Type By default, all booking types will be included in the report (including those that have been deleted). If needed, select only those types you want to report on. Booking Market Segment By default, all booking market segments will be included in the report. If needed, select only those segments you want to report on. Group By: Select to view one of the following: - Booking Status– The total of all the booking's room blocks displayed in a single row based on the status of the booking (default).
- RoomBlock Status Individual– Room blocks in separate rows based on their own status. For example, if you have two room blocks at prospect status, both will be displayed.
- RoomBlock Status– The sum of room blocks belonging to the same booking and status in a single row under the status of the room block. For example, if you have two room blocks at prospect status, they will be combined and displayed under prospect.
Market Segment Info Select Yes to group by market segment. This provides a second group under the status with a summary of room night, revenue, and average rate. In addition, select Include Monthly Total to see the overall totals by day and month. Display Booking Reference Choose between Post As or Abbreviation. The default selection is Abbreviation. When grouping by Booking Status or RoomBlock Status, select Post As to display the name of the booking. Additional Info Select Yes to add the following details to the report: Owner, Booked Date, Cutoff Date, Decision Due, Materialization %, PMS ID, Booked By, and Housing Method. Include Monthly Total Select Yes to display each month's total room count, guestroom revenue, and average rate. - Click View Report.
For each property and month in the pattern date range, the report groups bookings by status and then by arrival date. Click the booking name to open the Booking page.
Booking Name/Abbreviation If the booking has been marked pickup complete, a caret symbol (^) is displayed next to the booking name. This can help you reconcile the GRC report against your PMS and confirm that groups are meeting their pickup requirements.
The entire booking (not an individual room block on the booking) must be marked pickup complete for the caret to display.
RCT The number of rooms for each selected count type: Agr (Agreed), Fcs (Forecast), Blk (Blocked), and/or Pck (Picked Up). This information is displayed for each day in the report's date range.
When you run the GRC report with only Blocked selected as the Room Count Type, pickup numbers are shown if the entire booking has been marked pickup complete. Otherwise, blocked numbers are shown. A “Blk/Pck” label is displayed next to the booking name to indicate that the room counts might be blocked or pickup depending on the status of the Pickup Complete flag on the booking. A message is also displayed in the header of the report.
Avg Rate The average daily rate for the booked guestrooms. Total Rms The total number of rooms for the selected date range. Total Rev The total guestroom revenue for the selected date range. Monthly Totals The room count, average rate, and revenue totals for each day in the selected date range. If the date range spans multiple months, the report data is grouped by month. If Market Segment Info is selected in the report criteria, a subtotal of each segment is included. The following information is displayed if you selected the Additional Info check box in the Report Options: Owner The booking owner. Cutoff The date by which the group is required to finalize the guestroom reservation (typically 30 days prior to the group's arrival). Due The date by which the group is required to return the signed contract (typically 14 days after the booking is created). PMS ID The reservation ID or code for the room block. Booked The date the booking was created. Housing The method the group will use to handle their guestroom reservations (for example, Individual Call-In or Reservation List).
Good to know:
When including additional information, the following items are version dependent:
R45 or higher:
-
Cutoff date: The room block cutoff date displays when grouping by Room Block Individual.
-
Pickup Complete: If the room block is marked complete, a carat ^ will display next to the name to indicate the data is the final pickup when grouping by Room Block Individual.
-
The Materialization % from the booking page displays when grouping by the Booking Status or the Room Block Status
If you see a booking where the Materialization % is not displayed, simply trigger an update on the booking. This percentage was not stored for the purpose of this report for bookings created prior to R45 and will therefore not display on the report until an update has been made.
R44 or higher:
-
Housing Method: Do not apply a filter to Housing Method if your org is on R43 or below when grouping by Room Block Individual.
Here's a quick reference of what's included in each of the groupings:
Group by | Guestroom Information | Display Booking Reference | Additional Information |
Booking Status | The total of all room blocks on a booking displays in single row under the status of the booking. | Booking Post As or Abbreviation | Owner, Booking Cutoff Date, Decision Due, Booked Date, Materialization %, Booking Housing Method. |
Room Block Status Individual | Room blocks display in separate rows under their own status. | Abbreviation - Room Block Name | Owner, Booking Cutoff Date, Room Block Cutoff Date, Decision Due, Booked Date, Room Block PMS ID, Room Block Housing Method. |
Room Block Status | The sum of room blocks belonging to the same booking and status shows in a single row under the status of the room block. | Booking Post As or Abbreviation | Owner, Booking Cutoff Date, Decision Due, Booked Date, Materialization %. |
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.