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 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 is 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 not be retrieved, because 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 not be retrieved, because 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.