Generating the commission report

Use the Commission Report page to generate a report that lists the commissions already paid by a property to a booking agency or the commissions that still needs to be paid; for the selected date range.

The following are the available fields:

  • Parameter List: Click the Save button to create and save a parameter.
  • Property: Select the property for which you want to generate the report.
  • Booking Agency: Specify the booking agency name or IATA number to generate a report that includes only the commissions associated with the selected booking agency.
  • Commission Paid: Specify an amount to include only records where the commission paid is equal or greater than the amount entered.
  • Group ID: Specify the group ID to generate a report that includes only guest account or group records that are associated with the selected group ID.
  • Rate Plan: Specify the rate plan to generate a report that includes only commission that are associated with the selected rate plan.

Specify the Report Options that you require. See additional information about these fields:

  • Checked Out:Select this check box to include the checked-out reservations. By default, this check box is selected..
  • Cancelled:Select this check box to include the cancelled reservations. By default, this check box is selected.
  • No Show:Select this check box to include the no-show reservations. By default, this check box is selected..
  • View Pending Extract: If you select this check box, the report will only present results where the commission IATA number is not null and the commission batch ID is null which are in agreement with the end date specified. The end date used will be from the selected date preset option. This option will ignore the start date. Report will include all possible records regardless of status, whether Checked Out, Cancelled, or No Show. Instead of showing the start date in the report title when this option is used, it will read, "Pending Extract Through <End Date>".
  • No Commission Batch ID: Select this check box to filter the records based on reservation status.
  • Page Break By Agencies: Select this check box to insert a page break between the agencies included in the report.
  • Include Comments: If you select this check box, the report will include comments for each commission where they are configured .
  • Date Presets: Specify the option for which date preset you would like to run the report for. If you select Use Custom Date you must then enter dates in the custom date range fields.
  • Custom Date Range: Specify the custom start date and custom end date, the report will display records where the departure date is equal to or between the dates entered. If dates are not specified, no results will be returned in the report. Additionally the custom end date entered must be hotel date -1 or no records will be returned. Commissions are only written to the commission table after EOD runs for the current Hotel Date.

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

  • Commissions are only written to the commission table after end of day runs for the current hotel date.