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.
SAP Business ByDesign
Reproducing the Issue
- Go to the Liquidity Management work center.
- Navigate to the Bank Statements view.
- Select all bank statements for a unique Bank Account ID.
- 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.
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.
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, 3 options lend themselves for consideration.
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).
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.
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.
Creation of a new notional bank account sharing the same account determination as the affected bank account. Generate a new bank statement for the previous fiscal which contains credit/debit transactions balancing the difference. As in the first option this statement has to be post-processed.
KBA , SRD-FIN-MOP , Payment Management , Problem