1974687 - Bank Statement's Cleared Amount Mismatch The Difference Between Opening and Closing Balance

SAP Knowledge Base Article - Public

1974687 - Bank Statement's Cleared Amount Mismatch The Difference Between Opening and Closing Balance

Symptom

You have created bank statement XXX and maintained the closing balance for that period, however after reviewing the assigned payments you noticed that the cleared amount mismatch the difference between the Opening and Closing balance that you have calculated, which causes an unexpected difference and turns the bank statement into inconsistent status. (XXX, YYY and ZZZ represent IDs in the system)

Reproducing the Issue

  1. Go to Liquidity Management work center.
  2. Go to Bank Statements view.
  3. Open the bank statement XXX.

The Cleared Balance is bigger than the calculated difference between opening and closing balance.

Cause

Before creating the bank statement XXX, you have assigned one of the payments to another bank statement YYY. Since the payment was not confirmed yet, you were able to select the same payment again on bank statement XXX. When you posted bank statement YYY the payment in question got confirmed, however it was also being locked by bank statement XXX, which cause the inconsistency against the calculated balance for XXX.

Resolution

Since the difference is caused by a payment which was already confirmed, you may remove the concerned entry from the current bank statement by following the below steps:

  1. Go to Liquidity Management work center.
  2. Go to Bank Statements view.
  3. Open bank statement XXX and go to the third step, 3-Create and Edit Items.
  4. Identify the inconsistent payment. To do so, you may either search by the Difference amount or press the Check button. A warning message will be raised informing that the Item ZZZ is already selected in another payment allocation.
  5. Select the Item ID ZZZ  and press Delete. Note that you are able to select multiple line items and delete them in one go.

After the above steps, the bank statement should be consistent and the Cleared Balance matches the Opening and Closing balance difference that you've calculated.

Keywords

KBA , SRD-FIN-CLM , Cash and Liquity Managment , How To

Product

SAP Business ByDesign all versions