| Automatic matching of electronic bank statements |  |
| In the Match Electronic Bank Statements (tfcmg5212m000) session, ERP LN matches each electronic bank statement amount with as many open entries as possible. Transactions for matching ERP LN can match the following 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 In the Match Electronic Bank Statements (tfcmg5212m000) sesison, you can select several matching options, among others: Payment Difference Tolerances Indicates whether ERP LN must take the payment difference tolerances that you define in the CMG Parameters (tfcmg0100s000) session into account. Create Unallocated Receipt Indicates whether ERP LN must create unallocated receipts for unallocated amounts. ERP LN can create unallocated receipts for unallocated amounts in the following situations: ERP LN can find the business partner. However, ERP LN cannot find the invoice that correponds with the payment. ERP LN can find the business partner and the invoice. However, the invoice balance is zero. ERP LN can find the business partner and the invoice. However, the payment difference exceeds the payment difference tolerance. Match Lesser Amounts Indicates whether ERP LN must match the payments with open entries if the open entry amount exceeds the payment amount. To match trade notes The invoices and anticipated documents that can be matched also include trade notes that replace invoices. The following rules apply to trade notes: For incoming receipts, ERP LN also checks whether the document number occurs as a trade note number in the Trade Notes Receivable table. If this is the case, the EBS is matched. For outgoing payments, ERP LN also checks whether the document number occurs as a trade note number in the Trade Notes Payable table. If this is the case, the EBS is matched. The automatic matching process The automatic matching process uses the following procedure steps: Remittance advice present for incoming receipt? If not, proceed to Step 6. Document known from remittance advice? If not, proceed to Step 4. Anticipated or invoice found? If so, match and go to next EBS. Reference or description known from remittance advice? If not, proceed to Step 6. Anticipated or invoice found? If so, match and go to next EBS. Payment reference filled? If not, proceed to Step 10. Payment reference known as reconciliation document? If not, proceed to Step 10. Anticipated document status ready for receipt/payment? If not, proceed to Step 10. Receipt/paid amount equals anticipated document amount, either complete or partial? If so, match and select next EBS. Is a check number known? If not, proceed to Step 13 Amount on check number equals paid amount? If not, proceed to Step 13. Anticipated payment document status ready for payment? If so, match and go to next EBS. Is an invoice number known? If not, proceed to Step 17. Invoice number found in open invoice table? If not, proceed to Step 17. Same business partner or child customer? If not, proceed to Step 17. Receipt/paid amount equals invoice amount? If so, match and go to next EBS. Is the business partner code known? If not, proceed to Step 20. Is there an open invoice with the same open amount? If not, proceed to Step 23 Match and go to next EBS. Does another (one-time) business partner exist with the same bank account? If not, proceed to Step 23. Does an open invoice exist with the same open amount? If not, proceed to Step 23. Match and go to next EBS. Automatic matching not possible. In the Electronic Bank Statements (tfcmg5103s000) session, you can manually match the transactions that cannot be automatically matched. Related topics To process electronic bank statements |