Generating the Wholesaler Billing report

Use the Wholesale Billing report to view the guest details of the bookings made through the wholesaler and amount to be paid by the wholesaler for the room bookings made for a property. The wholesaler collects the amount directly from the guest. The billable charges are posted to an A/R account and the hotel can bill from that account.

To generate this report:

  1. Select Administration > Reports > Accounts Receivable > Wholesaler Billing Report .
  2. Specify this information in the Report Parameter section:
    Property
    The property code for which the report is generated. This value is defaulted.
    Note: You can modify this value.
    A/R Account
    The account number of the customer.
    Invoice Number
    The A/R invoice number.
  3. Select these check boxes in the Report Options section:
    • Include Cost Breakdown to replace the Booking Amount, Tax Amount and the Total Amount details with the sum of A/R charge details such as:
      • Room Total, for records with the revenue type set to ROOM.
      • Porterage Total, for records with revenue type set to TIP.
      • Meals Total, for records with revenue type set to FOOS, BEVG.
      • Additional Charges, for records with revenue type set to TAX, ROOM, FOOD, BEVG.
      • Total Net, which is the summation of the Total, Meal Total and the Additional Charge amounts.
      • Total Tax, with revenue type set to TAX.
      • Invoice Total, which is the summation of the Total Net and Total Tax amounts.
    • Include Property in Detail to include the property information.
  4. Select the Start Date and the End Date in the Date Range section. The report includes a day column for each day in the selected date range.
    Note: 
    • The rooms with the selected report date same as or later than the Invoice Date are only included in the report.
    • The rooms with the selected report date same as or prior to the Invoice Date are only included in the report.
    • By default, the Start Date and the End Date are set to the Hotel Date.
  5. Click Print.
    Note: 
    • By default, this report is sorted by Guest Name. However, you can also sort this report by External Reference (third party confirmation number) and Check-In Date (arrival date).
    • By default, the output format is Excel.