Guestroom Pace report
Using the Guestroom Pace report, you can compare your definite guestroom production to a previous year's actuals, and see if you're close to making your budget. We recommend running the report monthly to do the following:
- See changes in guestroom revenue due to new definite business, lost business, revaluations, and slippage.
- Compare the team's progress towards making the budget compared to where they were at the same time in previous years.
- Assess the available pipeline based on the number of prospect and tentative bookings.
Good to know:
- To display budget data, an administrator must create a property budget in Setup.
How can I tweak the report data?
The Report Options you select determine what is displayed in the report data. Here are a few tips to help you get started.
Report Options | Tips |
Beginning Activity Date Ending Activity Date |
Any bookings that were created or modified during the activity date range will be included in the report. Activity date range is typically last month. |
Beginning Consumption Date Ending Consumption Date |
Any roomnights consumed during this date range will be included in the report. Consumption date range is typically the first day of last month through the end of booking time. 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 – January 2, and you run the report using a consumption date range of December 1 – December 31, only those guestrooms on Dec. 29, Dec. 30, and Dec. 31 will be included. Here are a few examples of how you might set the activity and consumption date ranges for the Guestroom Pace report:
|
Properties | If you sell multiple properties, you can include them in the report. Only those properties you have access to are shown. |
Revenue Types | Select the booking revenue types you want to report on. By default, Catering and Banquet revenue will be included in the report. If needed, select only those revenue types you want to report on. |
Booking Owners | Booking changes made by these Sales Manager during the activity date range will be included in the report. Typically, this report is run for all Sales Managers (the default setting); however, you can select specific Sales Managers to run it against. |
Guestroom | Select to report on Agreed, Blocked, Forecasted, or Picked Up guestroom values. If you select Agreed, Blocked, or Forecasted, guestroom information is based on pickup figures when the room block is marked pickup complete. If you select Picked Up, guestroom information is always based on pickup figures whether marked complete or not. |
Booking Market Segments | By default, all booking market segments will be included in the report. If needed, select only those segments you want to report on. |
Booking Types | 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. |
Compare to | Based on the date parameters selected for Beginning/Ending Activity Date or Beginning/Ending Consumption Date the report will display the data for the same date range from last year, up to 5 years ago. For example:
|
How do I run the report?
Click View Report. Here are a few additional things you can then do:
- 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.
What does it all mean?
The following information is displayed for each month in the consumption date range:
Room Changes for <<activity date range>> | |
New Definite | Rooms, rates, and revenue that turned definite during the activity date range. |
Lost | The decrease in definite rooms, rates, and revenue from bookings whose status changed to Lost, Cancelled, or Turned Down during the activity date range. |
Revals | An increase or decrease in definite guestrooms and guestroom revenue during the activity date range. For example, 10 guestrooms are added to a definite booking during the activity date range, resulting in a positive reval. Or, the block on a definite booking drops by 10% during the activity date range, resulting in a negative reval. If pickup is not marked complete End Agreed/Blocked/Forecast/Pickup - Beginning Agreed/Blocked/Forecast/Pickup If pickup is marked complete End Pickup – Beginning Pickup |
Slippage | The following calculations use blocked or forecasted numbers: (Final picked up guestrooms) - (Blocked or forecasted guestrooms) (Final picked up guestroom revenue) - (Blocked or forecasted guestroom revenue) Slippage is only calculated for bookings that have been marked pickup complete during the activity date range. If any room block on the booking has not been marked pickup complete during that period, the booking is not included. |
Net | The final change in rooms, rates, and revenue during the activity date range. Slippage is only included for guestrooms and guestroom revenue. (New Definite) - (Lost/Downgrade) +/- (Reval) +/- Slippage |
Total | Definite rooms, rates, and revenue on the books at the end of the activity date range.
|
Definite Rooms, Rates, and Revenue as of <<activity end date>> | |
Act LY - 5Y (Actual) |
Actual rooms, rates, and revenue consumed for the same activity date range of the previous year selected in the Compare to field. |
STLY- ST5Y (Same Time) |
Definite rooms, rate, and revenue on the books for the same activity date range of the previous year selected in the Compare to field. |
Budget | The monthly budget goal for definite guestrooms. |
Var LY - 5Y (Variance) |
Total- Act from previous years |
Var STLY- ST5Y (Variance to Same Time) |
Total - ST from previous years |
Var BGT(Variance to Budget) | Total - Budget |
% |
Total / Act from previous year Total / ST from previous year Total / Budget |
Tentative & Prospect as of <<activity end date>> | |
Tentative | Total tentative room, rates, and revenue on the books at the end of the activity date range. Blocked or forecasted values will be used depending on the selected report options. |
Prospect | Total prospect rooms, rates, and revenue on the books at the end of the activity date range. Blocked or forecasted values will be used depending on the selected report options. |
The data in the report can be delayed by up to 15 minutes. If the data doesn't match what you expect to see, run the report again.