SAP Knowledge Base Article - Public

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


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).


SAP Business ByDesign

Reproducing the Issue

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

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


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.


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 the Liquidity Management work center.
  2. Go to the 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.


bank statement; cleared balance; difference , KBA , bank statement , cleared balance , difference , SRD-FIN-CLM , Cash and Liquity Managment , How To


SAP Business ByDesign all versions