Hotel Statistics Comparison

This report displays a list of statistical information for the date selected as well as compares the information based on Month-To-Date statistics, Year-To-Date statistics, Last Year MTD (Month-To-Date) statistics and Last Year YTD (Year-To-Date) statistics.

The Revenue section is based on the ‘Revenue Type’ configured on a transaction code. A property specifies the revenue type that the transaction code will represent as it is posted on an account such as Tax Charge, Room Charge, and Other Charge.

The report displays a comparative room statistical data for the:

  • Current date
  • Month-To-Date
  • Year-To-Date
  • Last year Month-To-Date
  • Last year Year-To-Date

Service Fee: Some properties have ‘fees’ that are considered a tax, while some properties have ‘fees’ that are considered revenue.

The following are the available fields:

  • Parameter List: Click the Save button to create and save a parameter.
  • Property: Specify the property for which you want to generate the report.
  • Use Fiscal Date: If you select this check box, the standard year starting value of 01/01 is not used by the system. The default year starting value of 01/01 is used by the system to determine which date to use when calculating or displaying yearly information. When the property parameter FiscalYr is configured and this check box is selected, the report uses the specified fiscal year date to determine the starting value of the year.
  • Include House Accounts: If you select the check box, the report will include revenue from non-guest accounts. The REVENUE section displays the revenue earned from the components of the ACCOUNT COUNTS section. The components of the ACCOUNT COUNTS section are
    • RESERVATIONS
    • CHECK INS
    • WALK INS
    • NO SHOWS
    The revenue from the following sections are based on where ACCOUNTTYPE is set to GUEST:
    • ROOM STATISTICS
    • GUEST STATISTICS
    • ACCOUNT COUNTS
    However, when a field under one of ROOM STATISTICS, GUEST STATISTICS, ACCOUNT COUNTS sections is calculated or includes a field from the Revenue section, the field is not excluded from the REVENUE section.
  • If the Report Revenue as Net check box is selected, the revenue calculations are based on the net amounts.
  • Date Range: Specify the date for which you want to generate the hotel statistics. The default value is Hotel Date less one day.
  1. You can use the code for posting charges that are related to revenue type only.
  2. You cannot specify a value in the Pay Type field.
  3. In reports, if the service fee is to be considered a tax, you must select a revenue type of Tax. It is not required to set up all the other tax configurations on the code. This setup allows reports to summarize the service fee under tax revenue.
  4. In reports, if the service fee is to be considered as revenue, you must select a revenue type of Service. It is not required to set up all the other tax configurations on the code. This setup allows reports to summarize the fee as service fee.

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

  • This report is intended to be a snap shot from the previous day.
  • Calculations for MTD (Month-To-Date), YTD (Year-To-Date), Last Year MTD and Last Year YTD columns are accumulative. Each day’s values are added to the next day’s values.
  • The Out of Order field counts rooms that are configured with a Unit Type set to Room and excludes rooms configured with a Unit Type set to Suite.
  • When revenue is transferred from a Guest Account’s folio to the Account folio, the report takes into account the revenue value in the From Account field only.
  • When the House Use checkbox is selected in the Rate plan screen, the Rate Plan is used by the Property for the employees residing in the hotel.