Symptom
Upload and process bank statement in Manage Bank Statements App. After execution bank ledger document is posted, clearing of customer/vendor line items are failed in posting area 2. In Reprocess Bank Statement Items App in the Log error message says "The difference is too large for clearing".
Environment
SAP S/4HANA Cloud
Reproducing the Issue
- Upload and process bank statement in App Manage Bank Statements.
- In this case example Interpretation algorithm 019 (DME reference number) is used.
- The status of bank statement is 'Not Completed'.
- In Reprocess Bank Statement Items App in the Log you can see the error: "The difference is too large for clearing".
Cause
System tries to clear the invoices using the information which is stored in the bank statement file (note to payee). System tries to post documents in posting area 1 and 2 based on posting rules/processing rules and interpretation algorithm. Algorithm 019 expects the reference number to be available in the CHECT field of the electronic bank statement. If this field is not filled and remains empty, the system tries to look for the reference number in the note to payee field. If the reference number does not exist in the system, the clearing fails (reference number is the payment media reference number or DME reference number, not reference document number XBLNR!).
If the search via algorithm fails, the system tries to do the clearing via the amount. If there is any document with the same amount it carries out the clearing, otherwise if there are several documents with the same amount or none, the clearing cannot be done and error "The difference is too large for clearing" will happen.
Resolution
Ask your bank to put the reference number to the tag ChqNb which will be mapped to the field CHECT.
In the meantime reprocess the bank statement item and clear it manually.
See Also
2979670 - Upload bank statement without entering number intervals causes error The difference is too large for clearing
Keywords
bank statement, difference, clearing, F5263, F5 263, algorithm, interpretation, Manage Bank Statement, reprocess, CHECT, 019, DME reference, F1 564, F1564, F1520, F1 520 , KBA , FI-BL-PT-BA-2CL , bank statement (Public Cloud) , Problem