Booking Situation Report

Use the Booking Situation report to compare the business on books of two periods and as of a certain date, like a month before each period. You can select the data level, like Business View, and you can schedule the report for rolling dates, like the next 14 days.

For example, in three weeks a Special Event of a first-time city-wide convention begins. To analyze the size of the event's impact, you run the report to see how business on books (Rooms, ADR, RevPAR) for each event day compares to the same period last year, as of three weeks prior.

Reporting Steps

  1. Click , then Reports, and then Booking Situation.
  2. Click the Analysis Start Date and Analysis End Date to define the monitored period by using one of the following options:
    • Enter a date in the Selection field and click Apply.
    • Select Specific Date from the menu. Click the single left or right arrows to navigate between months or the double arrows to navigate between years. Click the appropriate date in the calendar and click Apply.
    • Use flexible dates by selecting Rolling Date from the menu:
      1. Select the System Date, Start of Month (the first day of the System Date month) or End of Month (the last day of the System Date month).
      2. Optionally, choose to offset that date by selecting the option with either - or +. For System Date, the offset is number of days. For Start or End of Month, the offset is the number of months. Enter the number of days or months to offset the date in the Selection field.
      3. Click Apply.
  3. Set the Analysis as of Date using the same date selection method that you used to define the Analysis period. This date defines the booking window for which you want data captured. For example, for the Special Event described above, the Analysis As of Date would be three weeks prior to the Start Date:
    1. Click Analysis as of Date.
    2. Complete one of the following options:
      • If you selected Rolling Date to define the Analysis period, select Last year this day or Last year start of month. Optionally, choose to offset that date by selecting the option with either - or +. Enter the number of days or months to offset the date in the Selection field.
      • If you selected specific dates to define the Analysis period, select the date from the calendar.
    3. Click Apply.
  4. Set the Comparison period. The date range for the Comparison period must include the same number of days as the Analysis period and use the same date selection method. When you set the Comparison Start Date, the Comparison End Date adjusts accordingly:
    1. Click Comparison Start Date.
    2. Complete one of the following options:
      • If you selected Rolling Date to define the Analysis period, select Last year this day or Last year start of month. Optionally, choose to offset that date by selecting the option with either - or +. Enter the number of days or months to offset the date in the Selection field.
      • If you selected specific dates to define the Analysis period, select the date from the calendar.
    3. Click Apply.
  5. Set the Comparison as of Date. This date defines the booking window for which you want data captured for comparison. If necessary, you can use a different booking window from the one selected for the Analysis period in Step 3 above.
    1.  Click Comparison as of Date.
    2. Complete one of the following options:
      • If you selected Rolling Date to define the Analysis period, choose either Last year last update date or Last year last update date - and enter the number of days to offset the date in the Selection field.
      • If you selected specific dates to define the Analysis period, select the date from the calendar.
  6. Select a filter under Data Selection for the business level that you want to see in the report.
  7. Select the Data Elements that you want to include in the report. RevPAR is only available at the Total Property level.
  8. Select a report Format:
    • Select On Screen to open the report in a new browser window. Use the paging arrows on the top of the window to page through multiple windows of data.
    • Select Excel to open or save the report as an Excel spreadsheet.
  9. Click Generate. Note that if you select a large Data Range for the report as Excel file, G3 RMS emails you the report. This allows you to continue to work in the system.

See Exporting and Printing Reports for more information about managing report downloads in your browser.

Data Details

Begin by running the report with Total Property as the Data Selection to get an overview of the variances. Then drill down into more detail by running separate reports for Total Transient, Total Group, and selected Forecast Groups or Business Views. The report displays the following information, displayed at the Total Property, Transient, Group, Forecast Group, or Business View level, depending on your Data Selection.

Column Description
Day of Week The day of the week for the Day of Arrival.
Day of Arrival The arrival date for which the data in the row is displayed. G3 RMS shows a separate column for the Analysis and the Comparison period.
Occupancy On Books as of The number of rooms that are on books or sold for the Day of Arrival, as of the date shown. G3 RMS shows a separate column for the Analysis and the Comparison period.
Variance Occupancy On Books The Occupancy that is on books for the Analysis Period minus the Occupancy on Books for the Comparison Period.
Revenue On Books as of The revenue that is on books or sold for the Day of Arrival, as of the date shown, displayed in the currency shown. G3 RMS shows a separate column for the Analysis and the Comparison period.
Variance Revenue On Books The revenue that is on books for the Analysis Period minus the revenue on books for the Comparison Period.
ADR On Books as of The Average Daily Rate (ADR) that is on books or sold for the Day of Arrival, as of the date shown. G3 RMS shows a separate column for the Analysis and the Comparison period.
Variance ADR On Books The ADR that is on books for the Analysis Period minus the ADR on books for the Comparison Period.
RevPARClosed Revenue Per Available Room. The total room revenue divided by the total number of rooms (capacity). For the capacity definition, see the At a Glance - RevPAR topic (under Data Details). On Books as of (Total Property level only)

The Revenue Per Available Room (RevPAR) that is on books or sold for the Day of Arrival, as of the date shown. G3 RMS shows a separate column for the Analysis and the Comparison period.
Variance RevPAR On Books The RevPAR that is on books for the Analysis Period minus the RevPAR on books for the Comparison Period.
Special Event The names of Special Events and Instance Names, if applicable, that you entered for this Day of Arrival. G3 RMS shows a separate column for the Analysis and the Comparison period.