Multi-Revenue Report

This report summarizes guest account revenue by the date range specified and the group by code selected. The report includes the code and description of the group by option used and then the total room nights, room revenue, ADR , and percentage of revenue for the report view selected, then gives a total of each category combined.

You can filter the report by specifying the property. You can select the view of standard, daily, weekly, monthly, or yearly. 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 accounts in wait list status, house accounts, cancelled status for past dates, no show status for past dates, day use rooms, inactive codes, and codes with zero values. You can sort the report by code or revenue.

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 the revenue information gathered from a guest account or account does not have a Rate Code to report under, the revenue will be counted under a "***" code.
  • House account revenue will be captured under a '**' code.
  • The “***” code and the “**” *(House Account code) will only appear on the report if there is revenue associated to them, regardless of the Include Zero Valuescheck-box being selected on the report parameter page.
  • A guest reservation is made where at least one value, rate plan for example, changes during the stay. When this is the case and the requested report's date ranges covers the account's change dates, the report will include the account's information on multiple lines.
  • 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, like the geographical 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.
  • If the Include Waitlist Status check box is selected, the waitlist reservations are only included for report dates that are after the current hotel date.
  • 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 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.
  • 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.
  • If grouping the report by rate category: all Rate Categories for the property that have Rate Plans configured for it are used. The Rate Code field from the Guest Stay record is used to find the Rate Category on the Property Rate Plan.
  • 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 a guest account has more than one value under at one of the group by methods, the report will report the information under the configured values.
  • When the report is grouped by Nationality, the Group By Code lookup displays the source of business options such as Third Party, Corporate, Sales Department, Travel Package and so on.
    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 ‘***’.