nA Accounts Inquiry and Matching

First, one has to select a customer code (or a vendor code) in the rolling list. Then the invoices and the payments are displayed, including the total debit amount and the total credit amount.

By clicking in the corresponding cell, it is possible to display

      All past transactions,

      The transactions that have been matched (i.e. a link has been made between invoices and payments),

      The transactions that have not been matched (i.e. the link between invoice and payment has not been made),

      The past due transactions (i.e. transactions for which the due dates are anterior to the current date and for which the payment has not yet been made).

Matching

The matching is a process which consists in linking debit transactions with credit transactions (with equal amounts). This permits one to identify the invoices for which the payment has been made and the invoices for which the payment has not been done.

The matching code includes four letters (the first code is AAAA). For each payment a new matching code is generated. The next code to be used is displayed at the bottom of the page.

Transactions can be matched by clicking in the Matching column. The totals of matched amounts (debit and credit) are updated. The matching process for the considered transaction can be recorded by clicking on the Record button. A matching can be recorded only if the amounts of the matched transactions are equal.

A transaction can be “de-matched” by clicking on the line corresponding to a matched transaction. All the lines with the same matching code will be “de-matched”. This operation can be recorded by clicking on the Record button.

Automatic matching

The automatic matching function is a process which automatically matches debits and credits. Several variants exist for such a procedure:

      Descending matching: the non-matched transactions are considered by chronological order. When one amounts to a total equal to zero, all the transactions included in the total are matched.

      Sum matching: the process searches a pair of transactions with equal value for the debit and the credit.

      Group matching: the process searches a group of debit lines equal to a credit (or a group of credit lines equal to a debit).

      Difference matching: the process searches to explain the debit (or credit) total by adding of 1 to 4 transactions.

      Combined matching: the process compares any combination of 1 to 3 debits with any combination of 1 to 3 credits.

Once one method has matched some transactions, the matching is recorded and a complementary matching procedure can be launched.