Using the Commission Reconciliation Screen

Select the type of file from the drop-down menu.

Pre-formatted, non-editable commission profiles for Onyx, TACS, Paymode-X, and Commtrak are listed first in the drop-down list. Custom profiles created by using the Commission Profile Edit function are listed in the order of when they were created following the pre-formatted profiles. For details about this function, see Commission Profile Edit.

Full path to the file to reconcile. You can use the ellipsis () button to navigate to the file. By default, GlobalWare opens the GlobalWare\GWUser folder within your local user folder (C:\Users\userfolder\GlobalWare\GWUser). It is recommended that you put the file in this location. If you use a different location, navigate to that location.

This file must be a valid file type based on the selection in the Reconciliation File field.

GlobalWare can automatically populate this date field based on the type of file selected and if the file includes this field. Select a date from the calendar to adjust the paid date or to add a paid date if one is not included in the file.

A date is required to reconcile transactions. The selected paid date is the commission received date for all reconciled items in the file.

After a file is imported, this section displays the number of items in the file. After the file is reconciled, this will show the number of items reconciled, the number of items not reconciled, and the date of the file.

This section displays “No items in File” before importing a file, when items are not found in a file, or when a file is not found.

Reconciliation Options

Select the following options to determine how to reconcile transactions in the imported file.

This is selected by default to reconcile transactions in the file selected in the File to Reconcile field. Un-check this option to view the last reconciled report.

This is selected by default and recommended to reconcile the file. Generally, standard matching first checks the traveler last name, chain code, and confirmation number. If there are no matching items, then matching checks traveler last name, chain code, and start date.

For nuances and variations based on the file type selected, see How Commission Reconciliation Finds Matches.

Select this to expose a list of criteria to match. Select an item from the list, then click the right-arrow () button to move the item to the match criteria box. Click the left-arrow () button to remove the item.

You must select at least two fields, but it is recommended to select as many fields as possible to match. Carefully consider optional match criteria to avoid making incorrect matches.

For Confirmation #, you can select (exact) or (*xxx*) as a wildcard search. For example, the GlobalWare confirmation number might be 12345, but the file may have 12345GOLD. Using the wildcard option will consider this as a match.

Report Options

Select the following options to customize the commission reconciliation report for the imported file.

View reconciled transactions on the report. This is selected by default and is a recommended report option to view reconciled transactions. When selected in conjunction with the Unreconciled Transactions Report option, the reconciled transactions are listed first on the report.

View unreconciled transactions on the report. This is selected by default and is a recommended report option to view transactions that did not reconcile. When selected in conjunction with the Reconciled Transactions Report option, the reconciled transactions are listed first on the report.

Select to sort report based on branch location.

Drop-down menu of three report sorting options.

Update Options

The following selections are used to update invoices, add invoice items, or to only update items based on specific conditions.

When selected, additional Rates, Days/Nights, Units, and Commission options become available.

When selected, values from the file will update GlobalWare invoices.

This option is not commonly used as the fields selected replace information as it was booked with the information from the uploaded file.

When selected, GlobalWare checks to see if an item has been previously paid. When a duplicate confirmation number (and other matching criteria) is found on a previously paid item, GlobalWare will add a new invoice item for the commission amount found in the file.

This option addresses providers who pay commission per day instead of per booking. This will group up payments with the same confirmation number in the file and allow for multiple commission payments on a booking.

When the Reconciled Transactions Report option is selected, a separate section for partially paid reconciled transactions is added to the report.

Select this option to only update Tracking items.

The recommended best practice is to use the Commission Tracking function to update cruise and tour bookings. See Commission Tracking Overview.

After selecting a file in the File to Reconcile field, select this link to view file contents. This link generates a report of the records in the file and does not reconcile any transactions.

Select to import the file into GlobalWare.

Only use with Onyx ERTS reconciliation.

For information about exporting bookings from GlobalWare, see Import and Reconcile Onyx (ERTS).

Select to reconcile transactions and view the report.