Import and Reconcile Generic File

GlobalWare can also reconcile data from other entities, providing it can be supplied in the generic format.

Importing

Before you import, make sure the previous file has been reconciled as much as possible. When you import, the data from the previous file will be deleted. Then, follow these steps:

  1. On the Commission Reconciliation screen, select Generic from the Reconciliation File drop-down list.

    Note: To access the Commission Reconciliation screen, see Using the Commission Reconciliation Screen.

  2. If the file is for one provider only and does not have the provider in it, enter it in the Provider field.

  3. Use the File to Reconcile field to specify the location of the unzipped file (type the drive, path, and file name).

    Note: You can use the ellipsis () button to the right of the File to Reconcile field to navigate to the file you want to reconcile.

  4. Click List Disk to review the transactions in the file before you import.
  5. Click IMPORT.

Reconciling and Reporting

  1. In the Paid Date field, enter the date that you want the commission received date on reconciled invoice items to be.

  2. Select Reconcile Transactions and the matching type (Standard Match or Optional Match) to reconcile the payments with GlobalWare transactions. For details about standard and optional matching, see How Commission Reconciliation Finds Matches.

  3. Select Reconciled Transactions Report, Unreconciled Transactions Report, or both.

  4. Select Update Booked Info with Paid Info if you want GlobalWare to update the booked information with what the customer actually paid.  For detailed information about this option, see Reconciling. This step is relevant only if you are reconciling.

  5. Select how the reports are sorted.

    Note: The Reconciled Report is subtotaled by booking location, and the sort options for this report are within each booking location.

    • Sort by chain code, then property name, then arrival date (at the hotel)

    • Sort by traveler, then chain code, then property name, then arrival date

    • Sort by confirmation number, then chain code, then property name, then arrival date

  6. Click OK.

After you reconcile, use the Unreconciled Transactions report to review transactions and determine what you need to edit to make the items reconcile. Use Invoice Edit & Query or Commission Tracking to edit the transaction. Then you can run the reconciliation again to reconcile transactions that did not reconcile the first time. Or you can mark them received in Commission Tracking (this will not remove them from the Unreconciled Report).