Revenue Report overview

This report displays guest and non-room account revenue generated within the specified date range and is summarized by the group by code selected. The report includes total room nights, total adults, total children, room revenue, ADR, other revenue, total revenue, and the percentage of revenue for the group by option used, then gives a total for all combined. When you select Group By Room Type and there are Suites configured in HMS, the report includes an additional section called Suite Room Types that includes rooms where the unit type is Suite. The Component Room Count value indicates how many rooms of unit type Suite are configured under the Suite.

You can filter the report by specifying the property or rate plan. You can group the report by geographical code, market segment, rate category, room category, room number, rate plan, reason for stay, room type, source, or track. You can optionally include house accounts, wait list status, day use rooms, cancelled status for past dates, no show status for past dates, zero values, and inactive codes.

The following are some of the important points to be noted:

• Report only displays the selected group by codes that have information to report for the specified dates.
• If there are no Room Types configured under a Room Category for the selected Property, the Room Category will not display on the report.
• If a guest account is a part of a share it will be counted under the share master. The report will look at the columns on the Share Master for values and revenue. When the Share Master's value is blank, the report will look to the Primary Share. This is done since not all report values are configured on the Share Master, for example the Geo Code.
• The report will not separate out revenue per Share Accounts should the Group By option selected have different values on each component. The report should always include nights and the associated revenue of those nights on the same line.
• If the Include Day Use Rooms check box is selected, revenue is included from guest stays having a departure date that is the same as their arrival date, but the guest stays are not included in any room or guest columns of the report.
• When Cancel and/or No Show records are included in the report, only the revenue from these records is counted in the report. Regardless of the Group By option selected, any column that calculates Room Nights, Adults or Child information would exclude Cancel and No Show values.
• If a user does not select the Include Zero Values option on the report parameter screen, system will only include records that contain a value (revenue or rooms) not equal to zero.
• If a posting exists outside of stay dates that is prior to the arrival date the arrival date rate plan is used, if the posting is on or after the departure date the last stay date's rate plan is used.
• Only reservations checked in using the Walk-In screen are counted as walk-ins and only on arrival date, subsequent nights are reported as stay overs.
• If the report is run for future dates, group remaining is reported under the group booking code and the default number of guests is used for any rate calculations.
• If grouping the report by market segment: group remaining uses the group booking market segment, group pickups use the reservation stay date's rate plan market segment, non group reservations with an organization or booking agency profile will use the reservation market segment, non group reservations without an organization or booking agency profile will use the reservation stay date's rate plan market segment. Guest stays with a lease associated will use the lease market segment when the report date is within the lease period, reservation market segment when the report date is outside of the lease period.
• If a lease account has no guest stay associated for days within the report period, the report will include any room revenue on the lease account folio and no room night.
• If a guest stay on a lease upgrades from the lease account room to another room and pays privately for the rate difference, the report includes the room revenue on the guest stay folio and on the account folio.
• The statistical information related to a reservation is excluded from the report, when a Group By Code is specified and one or more of the selected codes have a zero value and are inactive.
• When the report is grouped by rate category, the guest stays that are associated with a lease will be reported under the rate category of the lease's rate plan.
• If the report is grouped by the promotion code, the guest stay details associated with the promotion code that is active, are printed in the report.
  Note: The promotion code is applicable for all the dates of a guest stay.
• If the Report Revenue as Net check box is selected, the revenue calculations are based on the net amounts.
  Note: 

  • You can select multiple room types, when the report is grouped by Room Type.
  • If the Group By option is not specified, the reservation data is displayed with ‘***’.