| Automatic matching of electronic bank statementsIn 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: - Match on bank reference.
- Match on remittance
advice.
- Match on anticipated
payment (using checks).
- Match on anticipated
payment.
- Match on document
description or reference.
- Match on rules.
| |