SAP Knowledge Base Article - Public

2603493 - How to Correct Inconsistent Bank Account Balances for Previous Fiscal Years

Symptom

After having processed bank statements for the current fiscal year, you notice that you are left with an inconsistent bank account balance for bank account XYZ for the previous fiscal year. A correction via application or repeating an initial migration appears difficult since numerous subsequent bank statements have been posted and processed. Reversing all subsequent statements therefore is not a viable option.

XYZ stands for Bank Account ID.

Environment

SAP Business ByDesign

Reproducing the Issue

  1. Go to the Liquidity Management work center.
  2. Navigate to the Bank Statements view.
  3. Select all bank statements for a unique Bank Account ID.
  4. Compare the Closing Balance of the last statement in the previous fiscal year with the Opening Balance of the first statement in the current year.

Cause

When uploading the first statement for bank account XYZ in the new fiscal year, the statement has been posted. However, the user has been presented with a warning message indicating a possible inconsistency relating to a gap between Closing Balance and Opening Balance of subsequent statements reading:
"Opening balance ABC does not match closing balance DEF of last bank statement in the previous year. Check whether a bank statement is missing." This warning, however, has been ignored.

ABC stands for the Opening Balance of bank statement created in the new year.

DEF stands for the Closing Balance of bank statement created in the previous year.

Resolution

Given the essential rule that bank statements must be continuously numbered and the opening balance has to equal the closing balance of a preceding statement for bank account XYZ, two options lend themselves for consideration.

  1. Manual creation of a consistent, additional bank statement for the previous fiscal year including the items representing the difference. In case several accounts are affected, those corrections have to balance between the accounts. In the resulting payment allocation, this transaction has to be processed in accordance with the original posting intention (e.g. posting against G/L account).

Example:

Statement ID 0, originating from the migration of bank account balances has a Statement Date 31.12.2012. Its Closing Balance is 1.000,00 EUR. Statement ID 1 in the next year shows an Opening Balance of 1.500,00 EUR. Manually create an additional statement with a Statement Date 31.12.2012 with an Opening Balance of 1.000,00 EUR and a credit transaction which renders its Closing Balance 1.500,00 EUR. This statement will assume the Statement ID 1 in 2012.

  1. Rectify the imbalance by posting Journal Entry Vouchers against the affected G/L accounts. This however leaves an imbalance between bank account balance and G/L bank account balance.

Keywords

bank statement; opening balance; closing balance , KBA , SRD-FIN-MOP , Payment Management , Problem

Product

SAP Business ByDesign all versions