Match Bank Statements (tfcmg5210m000)
Use this session to assign bank statements to open entries.
Field Information
-
- Bank Statement Type
-
.
Default value
Bank Account Statement
- Bank Relation
- Bank Statement Date
-
The date on the bank statement.
- Electronic Bank Statement
-
electronic bank statement
-
- Match Options
-
The options for matching a business partner's open entries with a bank statement line.
Allowed values
- Match - Surplus on Aging / Unallocated
-
The matching functionality matches the amount to invoices according to the matching algorithm. Any surplus amount is matched automatically to an open invoice based on aging. If no open invoice is available, the surplus amount is posted as ‘unallocated’.
- Match - Surplus on Unallocated
-
The matching functionality matches the amount to invoices according to the matching algorithm. Any surplus amount is always posted as ‘unallocated’.
- Match - Surplus to be allocated Manually
-
The matching functionality matches the amount to invoices according to the matching algorithm. Any surplus amount remains as unmatched needs to be allocated manually.
- Advanced Reference Matching
-
If this check box is selected, LN performs extended matching, where the description or document reference fields do not include the transaction type and document number only.
For example, if the document reference field include the text "ETEA9F169E9FF954A4FA77CDAE3663765AA" then 169 could be subtracted as document number which LN executes for matching.
If this check box is cleared, LN matches based on the 'Reference must Fully Match' logic.
In this case, LN assumes that the description or document reference fields of the Electronic Bank Statement line (sequence) only contain the "Transaction type" + "Document number".
Examples are "ACR12345678", "ACR-12345678", "ACR 12345678" or "A9/1234" .
-
- Allow Underpayments
-
If this check box is selected, and the Accounts Receivable invoice amount exceeds the bank statement line amount, the latter amount becomes the matched amount, and you accept a partial payment.
If the bank statement line amount applies to multiple invoices and the sum of these invoice amounts exceeds the bank statement line amount, the automatic matching process will match the relevant open invoices as much as possible.
If this check box is cleared, and the Accounts Receivable invoice amount exceeds the bank statement line amount, these amounts will not be matched. Consequently, no partial payments are found and no user intervention will be required.
- Use Payment Difference Tolerance
-
If this check box is selected, the payment difference tolerances defined in the CMG Parameters (tfcmg0100s000) and Payment Authorizations (tfcmg1100m000) sessions are taken into account.