Symptom
Error occurrs in Reconciliation Run
Error message:'Cash Ledger Balance for Bank Account XXX Differs from Cash Register'
XXX represents the Bank Account number.
Environment
SAP Business ByDesign
Reproducing the Issue
- Go to the General Ledger work center.
- Go to the Reconciliation view.
- View the relevant run and jump to the Messages tab.
Can see error: Cash ledger balance for Bank Account XXX differs from Cash register.
- Go to the Cash tab.
- Can see the Absolute difference amount.
Cause
- A tax payment via bank statement has been created directly. The payment allocation is posted, which updated the balance in the cash-register, however the tax payment remains In Preparation (or In Approval).
- Since this tax payment is not posted, the same amount was not updated in the ledger, which is causing the absolute difference in the reconciliation.
- To find the source of the difference, use the Cash Reconciliation report. Use the key date to identify precisely when the difference is raised. For example, if the Reconciliation is executed for 001/2016, the same difference is displayed when run the Cash Reconciliation with key date 31.01.2016.
- Therefore, change the key date to i.e. 15.01.2016. If there is no difference in this date, it means that the transaction from where the difference comes from dates somewhere between 15.01.2016 and 31.01.2016 and so on. When the cut-off date is identified, drill down the amount to the Payment List Reconciliation report and see the documents (usually Bank Statements) with the Proposed Posting Date equal to the key date in the report (cut-off date you found). In this bank statement ID, one of the transactions is a payment from or to a tax authority, whose payment allocation is creating the aforementioned tax payment.
Resolution
In order to clear the difference, it's necessary to post the tax payment. After that re-run the Reconciliation run or the Cash Reconciliation report.
Keywords
Reconciliation, Cash Ledger Balance for Bank Account Differs from Cash Register, closing activities, Periodenabschluss, Technischer Abgleich der Bücher, Kontoauszuges, Finanzamt, Steuer, tax autority, VAT , KBA , reconciliation run , cash ledger balance for bank account , differs from cash register , SRD-FIN-GL , General Ledger , How To