| Reconciling Cash Management to Cash Management |
Description | Follow the steps below if: • The balances on the Bank Reconciliation report appear incorrect (Bank Statement Ending Balance, Adjusted Bank Balance, Register Balance as of Statement Date, or Register Balance Adjusted for Future Voids) • The cash account does not balance to your financials |
Resolution | [BCB:5:Third-party support:ECB] Before you print the report, ensure: - No bank reconciliation is in progress
- In Cash Management from the Setup menu, select Bank Accounts, General tab, the Last reconciled date and the Last reconciled balance are correct. Verify the Last reconciled balance matches the ending balance on the bank statement.
- Outstanding or open items are correct and have a Reconciliation Status of O. Look for previously reconciled items changed to "O" for error correction but were not re-reconciled. Look for items that should be outstanding/open but are not. Their status may have changed to C or R. Correct items with a status of C to O or R before correcting balances.
- Cleared but not reconciled items should have a Reconciliation Status of C. These are items marked cleared between bank statement reconciliations from using Import Cleared Checks. Look for Previously reconciled items changed for error correction that don't have the R status.
- Look for items that may have a cleared status (C) but should be outstanding/open (O).
WARNING: The Derived totals on the report will not calculate correctly if any of the ABOVE items are incorrect. - In Cash Management from the Reports menu, select Reconciliation, Bank Acct Bal Verification.
- Select the Register file click OK.
- Click Print Preview or click Start to print the report.
- Review the report to verify your bank account balances are correct:
- Verify the Derived Bank Balance equals the Bank Account Bank Balance.
- Verify the Derived Posted CM Balance equals the Posted (CM) Balance.
- Verify the Derived Register Balance equals the Register Balance.
- Verify the Open Derived amounts equal the Open from Bank Account amounts.
- Verify the Unreconciled Derived amounts equal the Unreconciled from Bank Account amounts.
- If any totals do not match, turn on Audit setup activity and correct the totals on your bank account using the derived balances from the Bank Account Balance Verification report as follows:
- Note: See How do I use Audit setup activity? for more information.
- In Cash Management, from the Setup menu, select Bank Account.
- If prompted, click Start to print the audit report.
- In the Bank account list, select your bank account.
- On the General tab, replace the Register balance with the Derived Register Balance.
- On the General tab, replace the Bank balance with the Derived Bank Balance.
- On the Totals by GL Cash Acct tab, replace the Posted (CM) Balance and Amount with the Derived Posted CM Balance.
- On the Totals by GL Cash Acct tab determine the correct amount for each cash account and adjust the amount(s) for each account accordingly. If you use multiple cash accounts with your bank account, you may have multiple cash accounts and amounts to verify and / or correct. Delete any lines with blank cash accounts. When you finish, the amounts for each cash account should sum to the Posted (CM) Balance. In a one-to-one relationship, the amounts should equal.
- On the Totals tab, replace each of the various open amounts with the appropriate Open Derived amounts.
- On the Totals tab, replace each of the various unreconciled amounts with the appropriate Unreconciled Derived amounts.
- Press ENTER to update the Open total and Unreconciled total after you correct the appropriate open and unreconciled amounts.
- Click Close and then turn off Audit setup activity.
|
|