Automatic matching of electronic bank statements

Transactions for matching

Infor 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.

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 Infor LN.
• The business partner could not be identified in Infor 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.

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.