Skip to main content

Forecasted Revenue Report

The Forecasted Revenue Report displays expected revenue for reservations and group blocks that are currently booked.

Forecasted Revenue Report Options

To print the Forecasted Revenue report go to Reports > Forecasting and Availability > Forecasted Revenue. The prompt allows you to print the report to meet your needs.

Report Types:​

Daily - Revenue that will be posted on that particular audit date will be included and shown for each day.

Weekly - Revenue that will be posted for all audit dates for each week is included. A week in considered 7 days from the lower date selected. If the lower date is a Thursday, the weekly increments displayed will be Thursday to Thursday.

Note: Only data for whole weeks are included in the report. If you request a date range from July 15 to August 15, only the first 28 days, July 15 to August 11, will be included in the report.

Monthly - Revenue that will be posted for all audit dates for each month is included.

By RateCode/UserField - Revenue that will be posted for each audit date, broken down by the Rate Code and then User Field is displayed. Select which User Field you would like in the Userfield Selection section. This is usually used to show Forecasted Revenue by Market Source.

By Userfield1/Userfield2 - Revenue that will be posted for each audit date, broken down by the Userfield 1 and then Userfield 2 is displayed.

Revenue Based On:​

Daily Posting - Select this option to show the revenue to be posted each day for all the rooms expected to be in house.

CheckIn Date - Select this option to total all the room revenue expected for the entire guest stay and display it on the date the guest is scheduled to arrive. If you are interested in cash flow and have your guests pay at arrival, this will display how much money you should expect to receive for the time frame selected.

CheckOut Date - Select this option to total all the room revenue expected for the entire guest stay and display it on the date the guest is scheduled to depart. If your guests pay at checkout, this will display how much money should be received on the check out dates.

Room Revenue Calculation​

Base Room Revenue - This option will only include expected postings for Account Codes marked as Room Revenue accounts on the Other Options tab.

Packages rollup into room amounts - This option will include Room Revenue and any revenue for packages, special packages or daily charge amounts when the Package Rollup option is selected for items of the package or the daily charge.

Packages rollup into room amounts plus any Daily Charges - This option will include Room Revenue and any revenue for packages, special packages or daily charges regardless of whether the Package Rollup option is selected for the item or daily charge.

note

The configuration setting (Setup > Configuration > Reservations > Packages rollup in to room amounts for Total Stay and Snapshot) will control if the report defaults to base room selection or packages rollup option.

Export to Microsoft Excel​

This option will automatically export the report to an excel spreadsheet rather than displaying the report.

Forecasted Revenue Report Layout

The report type selected determines the format and columns included in the report.

When Daily, Weekly, or Monthly are selected.... The Forecasted Revenue Report displays the information for booked and unfilled group rooms by the number of rooms and the revenue associated with those rooms. Average daily rates, both including and excluding the unfilled group rooms, along with the total amount of deposits collected for the time period selected are also displayed.

Daily Filled - The number of rooms scheduled to be occupied for the date(s) requested.

Booked Rooms - The number of rooms that will be occupied and have revenue posted for the date(s) requested. COMP rooms or rooms with a zero rate would not be included in these figures.

Unfilled Groups Rooms - The number of rooms being held for group blocks for the date(s) requested. Group rooms that have a reservation are included in the Booked Rooms.

Unfilled Group Block Revenue is calculated in the following sequence:
  1. If there is an Override rate on the Group Block Record, this rate is used depending on Weekday/Weekend.
  2. If there is no override rate on the Group Block Detail level, then the Override Rate on the Group is used.
  3. If there is no override rate on the Group Block level, then the Rate Code on the Group is used.
  4. If there is no Rate Code on the Group, then the default Rate Code (RACK for example) is used.

For Unfilled Group Blocks, rates with "Rate Codes (Items 3 & 4 above)" are always calculated on 1 adult, 0 children.

ADR (Average Daily Rate) - This is Revenue/Rooms, Booked Revenue and rooms for Current ADR and Total Rooms and Revenue for Projected ADR. COMP rooms and rooms with a zero rate are not included.

Deposits - This is the amount of advance deposits for reservations scheduled to arrive on the day, week, or month, depending on the report type selected. Advance deposits for the following reservation types are NOT included:

  • Deposits for rooms designated as Meeting Rooms
  • Inventory Only reservations (zero rooms)
  • Gift Certificates (no arrival date)
  • Cancelled reservations
  • Reservations in History (advance deposit never transferred to folio)

When By Rate Code or Userfield are selected.... The Forecasted Revenue Report displays the information for guaranteed, non-guaranteed and unfilled group rooms by the number of rooms, persons and the revenue associated with those rooms. Average daily rates per room and per person are also displayed.

Gtd Rooms - The number of rooms with a guaranteed Hold for the date(s) requested. Any reservation with a Hold Code that has any Hold Type other than None are considered guaranteed. Click here for more information on Hold Codes and Hold Types.

Non Gtd Rooms - The number of rooms with a non guaranteed Hold Code for the date(s) requested. Any reservation with a Hold Code that has a Hold Type of None are considered guaranteed.

Unfilled Groups Rooms - The number of rooms being held for group blocks for the date(s) requested. Group rooms that have a reservation are included in the Booked Rooms.

Gtd, NonGtd, Unfilled Group Persons - The number of guests included for the respective rooms categories.

Rooms vs. Room Nights

When the Forecasted Revenue Report is run by Rate Codes or Userfields for more than one day, rooms on the report are totalled as room nights. For example, if the report is requested for a range of 10 days, a reservation within the dates selected for three nights would be totalled as three room nights on the report.

Note: Persons are treated the same way on report. A reservation with three guests for three nights would be totalled as 9 "person nights" on a Forecasted Revenue report run over the range of dates of the reservation.