Summary
This article provides steps to correct Statement Ending Balance, Register Balance as of Statement Date, and/or Adjusted Bank Balance totals on the Bank Reconciliation report in Cash Management.
Description
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
- From Cash Management Reports, select Reconciliation, Bank Acct Bal Verification.
- Select the Register file and click OK.
- Click Print Preview.
- Select the bank account from the list on the left side of the report.
- 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