The Bank Statement Ending Balance on my Bank Reconciliation report is incorrect in Cash Management (item that cleared the bank is open)
Description
Cause

The Bank Statement Ending Balance on the Bank Reconciliation report is calculated based on the Bank Balance on the bank account less the total of all entries with a Cleared Date greater then the Statement Date on the report.

If an entry was previously cleared or reconciled and later changed back to open, the Bank Statement Ending Balance will not match the bank statement.

Resolution
To view transactions with an Open status in Cash Management, print the Open Worksheet report (Reports, Worksheets, Open Worksheet) or the Bank Register inquiry (Inquiry, Bank Register) and add a condition for Reconciliation Status equal to O.

After you have identified the transaction that should be reconciled, see How do I change the reconciliation status of a transaction in Cash Management? to correct the reconciliation status.



[BCB:156:Chat 300 CRE US:ECB]

Steps to duplicate
Related Solutions

The Bank Statement Ending Balance, Adjusted bank balance, or Register balance as of statement date on my Bank Reconciliation report is incorrect in Cash Management (Bank totals are incorrect)