Automatic matching of electronic bank statements

In the Match Bank Statements (tfcmg5210m000) session, LN matches each electronic bank statement amount with as many open entries as possible.

Transactions for matching

LN can match these transactions:

  • Outgoing payments with anticipated payments (automatic supplier reconciliation).
  • Incoming receipts with anticipated receipts (automatic customer reconciliation).
  • Outgoing payments with open purchase invoices, if you do not use the automatic payment procedure in Accounts Payable.
  • Incoming receipts with open sales invoices, if you do not use the direct debit procedure in Accounts Receivable.
  • Incoming receipts with open sales invoices, if you do not use the direct debit procedure and a remittance advice exists for the receipt.
Matching options

For matching a business partner's open entries with a bank statement line, the Match Bank Statements (tfcmg5210m000) session provides these options:

  • Match - Surplus on Aging / Unallocated

    The matching process will first match open entries that exactly correspond with the information in the description field of the bank statement line.

    If the total amount of the matched open entries is less than the amount of the bank statement line, the surplus will be allocated to the remaining open entries of the business partner based on aging. If no (remaining) open entries of the business partner are found or if a surplus remains, an unallocated payment or a receipt line will be added to the Matching Results section of the Bank Statement Workbench (tfcmg5610m100)/ Bank Statement (tfcmg5610m000) session.

  • Match - Surplus on Unallocated

    The matching process will first match open entries that exactly correspond with the information in the description field of the bank statement line.

    If no open entries of the business partner are found that can be matched exactly, or if exactly matched open entry amounts are less than the bank statement line amount, an unallocated payment or a receipt line will be added to the Matching Results section of the Bank Statement Workbench (tfcmg5610m100)/ Bank Statement (tfcmg5610m000) session.

  • Match - Surplus to be allocated Manually

    The matching process will first match open entries that exactly correspond with the information in the description field of the bank statement line.

    If no open entries of the business partner are found that can be matched exactly, an unmatched amount remains on the bank statement line. If the amount of the open entries is less than the bank statement line amount, the difference remains as an unmatched amount on the bank statement line.

    To handle the unmatched amount, you can do either of the following:

    • Manually add an unallocated payment or receipt line.
    • Reconcile the surplus with remaining open entries of the business partner.
Payment options

In addition to the matching options, the Match Bank Statements (tfcmg5210m000) session provides these payment options:

Matching rules

After LN determines the business partner and matches the relevant open entries, the effective rules that were defined in the EBS Matching Rules (tfcmg5115m000) session, are taken into account in the automatic matching process.

Exceptions

When the automatic matching process has completed, the matching results may have exceptions in these cases:

  • The bank account or IBAN number in the bank statement line could not be found in LN.
  • The business partner could not be identified in LN.
  • From the information in the bank statement line description field, no or not all corresponding open entries could be retrieved.
  • From the information in the bank statement line description field, the corresponding open entries could be retrieved, but the bank statement line amount exceeds the total amount of the corresponding open entries.
  • From the information in the bank statement line description field, the corresponding open entries could be retrieved, but the bank statement line amount is less than the total amount of the corresponding open entries.
  • From the information in the bank statement line description field, more than one corresponding open entry could be retrieved.

In all these cases, the Exception check box in the Matching Results section of the Bank Statement Workbench (tfcmg5610m100)/ Bank Statement (tfcmg5610m000) session will be selected. To clear the Exception check box, you must either make an adjustment or confirm the exception.

Main steps in the matching process

The main steps in the automatic matching process are the following:

  1. Match on bank reference.
  2. Match on remittance advice.
  3. Match on anticipated payment (using checks).
  4. Match on anticipated payment.
  5. Match on document description or reference.
  6. Match on rules.