SAP Knowledge Base Article - Public

3736492 - Small Differences between 2 Posting Areas for Foreign Currency Electronic Bank Statements When Using Posting Rules - SAP S/4HANA Cloud Public Edition

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

  1. Post an electronic bank statement in a foreign currency for a bank account maintained in the company code currency.
  2. Clear items automatically using one of the posting rules.
  3. 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: 

  1. 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. 
  2. 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

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

Product

SAP S/4HANA Cloud Public Edition all versions