Bank Account balances are incorrect
Description

Cause
Resolution
The Adjusted Bank Balance total calculates as follows:

  • The Last Reconciled Balance plus all transactions that have an Accounting date less than or equal to the Last Reconciled Date with a status of open (O) or cleared (C).

The Register Balance as of Statement Date total calculates as follows:

  • The current Register Balance minus all transactions with a Reference date greater than the Last Reconciled Date.

The Bank Statement Ending Balance total calculates as follows:

  • The Bank Balance on the bank account less the total of all entries with a Cleared Date greater than the Statement Date on the report.

Note: Before you proceed, complete the verification process in Section 1 and Section 2 of DocLink: Reconciling the Cash Management Bank Reconciliation Report and General Ledger

  1. From Cash Management Reports, select Reconciliation, Bank Acct Bal Verification.
  2. Select the Register file and click OK.
  3. Click Print Preview.
  4. Select the bank account from the list on the left side of the report.
  5. If the report prints values in any of the Variance fields, follow DocLink: The Cash Management Bank Account Balance Verification report has variancesto reconcile your Cash Management

DocLink: Can the CM Bank Account Balance Verification report be ran for one bank instead of all of them?
DocLink: The Cash Management Bank Account Balance Verification report has variances
DocLink: The Bank Statement Ending Balance on my Bank Reconciliation report is incorrect in Cash Management (entry has an incorrect Cleared Date and/or Statement Date)
DocLink: Reconciling the Cash Management Bank Reconciliation Report and General Ledger

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


Steps to duplicate
Related Solutions