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