Generating Revenue Report

To generate the report:

  1. Select Administration > Reports > Accounting > Revenue Report.
  2. Specify the Property for which the report is generated; in the Report Parameters section.
  3. Specify this information in the Report Parameters section:
    Group By
    The group by code to display the matched records on the report. For example, if Rate code is selected as the Group By value, the report displays Rate Codes configured on the Guest stay record.
    Group By Code
    This field is defaulted with values based on the Group By field. For example, if Group By is set to Room Type, this field lists all the available room types to report.
    Building
    The building code type based on which the Property and Building details are displayed.
    Output Format
    The format in which the report is displayed.
  4. Specify the type of data that must be printed in the report in the Report Options section:
    Include House Accounts
    If this checkbox is selected, in the Maintain Room Rate screen, the report includes this reservation information with the recently created house rate plan:
    • House Use Rooms (Total number of occupied rooms)
    • The numerical value of the remaining rooms available to occupy after excluding the house use rooms, is displayed in percentage.
    • The numerical value of the remaining rooms available to occupy after excluding the Complimentary House Use rooms, is displayed in percentage.
    Note: You can select this checkbox, only if the House Use checkbox is selected in the Maintain Room Rate screen.
    Include Waitlist Status
    If this check box is selected, the waitlist reservations are only included for report dates that are after the current hotel date.
    Include Inactive Codes
    If this check box is selected, the application includes all codes irrespective of the status that meet the criteria provided on the report parameter screen.
    Include Zero Values
    If this checkbox is selected, the application includes records that contain a value (revenue or rooms) not equal to zero in the printed report.
    Cancelled Status for past dates/ No-Show Status for past dates
    If this checkbox is selected, the report displays records that have a posting date greater than the hotel date.
    Include No-Shows in Revenue
    Select this check box to include the revenue of the no-show reservations in the total revenue.
    Note: By default, this check box is selected.
    Include No-Shows in Rooms Sold
    Select this check box to include the no-show reservations based on the arrival date by calculating the total room nights and guest counts.
    Include Lease Reservations
    If this check box selected, the room, guests and revenue for lease reservations details are included in the report.
    Include Un-Reserved Lease
    If this checkbox is selected, the Revenue columns includes the Revenue for Un-Reserved Leases.
    Include Tentative Lease
    If this checkbox is selected, the Revenue columns includes the Revenue for Tentative Leases.
    Include Day Use Rooms
    If this check box is selected, revenue is included from guest stays having a departure date that is the same as the arrival date, but the guest stays are not included in any room or guest columns of the report.
    Include Day Use in Rooms and Revenue
    If this check box selected, the revenue, rooms, and guest (adult and children) details of the Day Use reservations (where the Arrival Date is the same as the Departure Date) are included in the report.
    Include Day Use in Revenue
    If this check box selected, the revenue details of the Day Use reservations (where the Arrival Date is the same as the Departure Date) are included in the report.
    Report Revenue as Net
    If this checkbox is selected, the revenue calculations displayed in the report are based on net amounts.
    Include Complimentary in ADR
    If this check box selected, the rooms sold as complimentary rooms are considered for ADR calculation.
    Include House Use in ADR
    If this check box selected, the rooms sold as house use rooms are considered for ADR calculation.
    Group By Building
    If this checkbox is selected, the report includes information related to building, wing and floor. The report is grouped by the building code and includes the associated Reservation data.
    Note: 
    • The report is categorized based on the building defined at the Room Type level.
    • If the rooms have no building assigned, ‘No Building’ text is displayed in the report.
    • The rooms assigned with no building have reports displayed with “No Building” text.
    • The revenue related data for reservations of Room Numbers that are associated with the Building are included in the report. However, the data for Room Numbers that do not have Building associated is displayed as ‘’***.
    • The revenue posted to these accounts with no room number and reservation associated, is displayed in the Building section field as ‘***’.
      • House Accounts
      • Group Accounts
      • Event Accounts
      • Organization
      • Booking Agency Profiles
      • Guest Profiles
  5. Specify the Start Date and the End Date in the Date Range field.
  6. Click Print Record.