Generating Booking Agency Production Report

To generate the report:

  1. Select Administration > Reports > Profile and Production > Booking Agency Production Report.
  2. Specify this information, in the Report Parameters section:
    Property
    The property to which the booking agency is associated.
    Report View
    The report view type based on which the revenue information is displayed in the report.
    Note: 

    If the Report View is set to Summarized by Parent View the report displays the reservation data grouped by the Parent Organization and the Parent’s Child Organizations.

    Booking Agency
    The booking agency ID used to generate a report that includes only guest account or group records that are associated with this agency.
    Booking Agency Type
    The booking agency type code used to generate a report that includes only the selected agency type. The possible values are:
    • Corporate
    • Group
    • Leisure
    Salesperson
    The username of the booking agency sales manager.
    Building
    The assigned building code based on which the revenue information for the booking is displayed in the report.
    Lease Status
    The status of the Lease associated with the booking agency. The report includes the records based on the selected Lease Status.
    Note: You can select multiple Lease Status.
  3. Specify this information, in the Report Options section:
    Guest Cancelled/No-show/Waitlist Status
    If this checkbox is selected, the guest reservation status (cancelled/no-show/waitlist) with the related organization name is displayed in the report.
    Group Prospect/Tentative/Definite/Cancel/In-House/Checked Out Status
    If this checkbox is selected, the group booking status (Prospect/Tentative/Definite/Cancel/In-House/Checked Out) is displayed in the report.
    Include Inactive Booking
    If this checkbox is selected, the organizations with inactive status are displayed in the report.If this checkbox is cleared, the organizations with active status are displayed in the report.
    Include Complimentary in ADR
    If this checkbox is selected, the ADR column in the report displays the total amount of revenue extracted from the transaction value for the complimentary rooms.
    • If Include Complimentary in ADR checkbox is selected, the ADR amount displayed in the report is calculated using this process: ADR Calculation= Total Rooms Revenue / Sold Rooms
    • If Include Complimentary in ADR checkbox is cleared, the ADR amount displayed in the report is calculated using this process: ADR Calculation: Total Rooms Revenue / (Sold Rooms – Complimentary Rooms)
    Include House Use in ADR
    If this checkbox is selected, the ADR column in the report displays the total amount of revenue extracted from the transaction value of the house use rooms.
    • If Include House Use in ADR checkbox is selected, the ADR amount displayed in the report is calculated using this process: ADR Calculation= Total Rooms Revenue / Sold Rooms
    • If Include Complimentary in ADR checkbox is cleared, the ADR amount displayed in the report is calculated using this process: ADR Calculation: Total Rooms Revenue / (Sold Rooms – House Use Rooms)
    Report Revenue as Net
    If this checkbox is selected, the Revenue columns in the report displays the transaction amount excluding the inclusive taxes for the rooms.
    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.
  4. Select the sort options in the Sort By section. You can sort the report by organization, organization type, room nights, room revenue, salesperson, or total revenue.
  5. Click Print.