Symptom
When using Posting rules to clear electronic bank statements in a foreign currency, with exchange rate between Payment Currency and Company code Currency given by the bank, there's small differences between two posting areas.
For example: A USD payment posted to a bank account with EUR as company code currency, with USD/EUR conversion rate advised in the bank statement, results in a difference of few cents on subledger postings to compare with the main bank account clearing amount.
Environment
SAP S/4HANA Cloud Public Edition.
Reproducing the Issue
- Post an electronic bank statement in a foreign currency for a bank account maintained in the company code currency.
- Clear items automatically using one of the posting rules.
- Observe that the two posting areas produce a small difference, leaving residual amounts on the subledger posting.
Cause
This is a known issue that a small difference amount in FX conversion scenario occurs to two posting areas when a standard Posting Rule is applied to clear automatic bank statements.
Resolution
The issue can be avoided by following one of these 2 approaches:
- Going on forward, switch to Processing Rule to post electronic bank statements. It's confirmed that Processing rules (instead of posting rules) supports bypass the mentioned issue by taking the posting amount in Company Code currency for further processing, instead of posting to the foreign currency and revaluating the conversion.
- Besides, it's noticed that the issue with Posting rules does not appear to bank statements created manually. So it is possible to create manual bank statement for postings as a workaround solution if Processing rules are not available. But the main suggestion stays with the first option, which is to utilize Processing Rules.
See Also
- KBA 0003378744 - How to check posting and processing rule type in bank statement - SAP S/4HANA Cloud Public Edition
- KBA 0003695161 - How to create processing rule to clear document posted via Manage Bank Statement App with an open incoming/outgoing payment based on assignment number
- How to Create Processing Rules
- Posting Rules
- Interpretation Algorithms
- Overview on All Predelivered Processing Instructions
Keywords
electronic bank statement, ebs, bank clearing account, cent difference, rounding difference, foreign currency, company code currency, posting rules, processing rules, exchange rate difference, fx difference, automatic clearing, subledger difference, payments and bank communications, treasury management , KBA , FI-BL-PT-BA-2CL , bank statement (Public Cloud) , FI-AP-AP-B1 , Payment transfer (w/o DE, US) , Problem
SAP Knowledge Base Article - Public