Rematching vouchers and refunds

This topic explains how to rematch partially matched vouchers and refunds in the Automatic Reconciliation module by redefining the document amend limits in the database definitions. After you redefine the document amend limits you can rematch partially matched tickets according to the new limits.

You need the user permits Perform actions in Supplier Reconciliation module and Update Database and Website Definitions

  1. Go to Setup - Database Definitions - Reconciliation.

  2. In the Auto Document Amend Limits section, enter the new amend limits:

    Field

    Description

    Gross

    Enter the gross value range of the documents

    Net

    Enter the net value range of the documents.

    Tax

    Enter the tax value range of the documents.

  3. Go to the Automatic Reconciliation module, and select the Match Vouchers tab.

  4. Enter the search parameters.

  5. Field

    Description

    Import Date

    The date range in which the vouchers and refunds were imported

    File Date

    The date range of the file dates of the imported Excel files

    From Voucher

    The range of voucher or refund reference numbers

    PNR

    The PNR

    Document

    The document type: voucher, itemized refund, or refund.

    Currency

    The document currency.
    When you enter the tab for the first time, or before a file is imported, you can select the supplier currency or the system currency.

    After a file is imported, or after performing a search in this tab, you can select the currencies included in the File Data column.

  6. In the Status section, select Partially Matched.

  7. Click Find.

  8. The vouchers and refunds are displayed in the results section.

    Shared Data

    Voucher

    Voucher/refund reference number

    PNR

    Reservation number

    T. File #

    Travel file number

    File Data

    Amount

    Amount of the document as reported by the supplier

    Currency

    Currency of the transaction as reported by the supplier

    Tax

    Amount of tax charged for the service as reported by the supplier

    Commission

    Amount of commission granted for the reservation as reported by the supplier

    Net to Remit

    Net amount of payment remittance as reported by the supplier

    System Data

    Amount

    Amount of the ticket as returned from the system

    Currency

    Currency of the transaction as returned from the system

    Tax

    Amount of tax charged for the service as returned from the system

    Commission

    Amount of commission granted for the reservation as returned from the system

    Net to Remit

    Net amount of payment remittance as returned from the system

  9. Select a partially matched voucher with amount discrepancies that fall within the new amend limits that you described, and at the end of the row, click the , and select Re-Match.

    The ticket is matched according to the newly defined definitions.

    The original document is amended, previously defined parameter values are overwritten, and the row becomes green.

Related links