Reconciling the Cash Management Bank Reconciliation Report and General Ledger
Description

Cause

Resolution

1. Post entries

  1. Go to Cash Management, Tasks, Post Entries.
  2. Review the posting journal for issues to resolve.
  3. Go to General Ledger, Tasks, Post Entries.
  4. Review the posting journal for issues to resolve.

2. Verify the Bank Statement Ending Balance

  1. Go to Cash Management, Reports, Reconciliation, Bank Reconciliation.
  2. Select only the CM Register (Register) file.
  3. Click OK.
  4. Enter the Statement Date of the last bank statement reconciled for this bank.
  5. Click Ranges and select the bank account.
  6. Click OK.
  7. Click Print Preview and review the report.
  8. Confirm the Bank Statement Ending Balance matches the bank statement.
  9. If the balance doesn’t match:
    1. Confirm the list of outstanding items shows only transactions that haven’t cleared as of the statement date. If there are transactions that shouldn’t be outstanding, see why does a Reconciled Item show as Outstanding?
      Note:  You can void checks using a date other than the original check date. Reconcile voided checks in the same statement period as the void date.
    2. See how to fix balances that are incorrect because of the Cleared Date or Statement Date.
    3. See how to fix balances that are incorrect because you reconciled an item that didn't clear the bank.

3. Verify the Adjusted Bank Balance matches the Register Balance as of Statement Date

  1. If the Adjusted Bank Balance matches the Register Balance as of Statement Date, see Step 4 to compare the balance to GL.
  2. If the Adjusted Bank Balance doesn't match the Register Balance as of Statement Date:
    1. Perform these steps to reconcile Cash Management to Cash Management.
    2. Run the Bank Reconciliation report.
    3. Verify the Adjusted Bank Balance and the Register Balance as of Statement Date match.
      • If they don’t match, see the Additional Troubleshooting section below
      • If they do match, proceed to Step 4 and compare the balance to GL

4. Compare the Register Balance to General Ledger

  1. Note the Register Balance as of Statement Date on the Bank Reconciliation report.
  2. Go to General Ledger, Reports, Year-to-Date Ledger.
  3. Check the box Modify Date Range.
  4. Enter the Start date and End date for the period.
  5. Click Ranges and select the bank’s GL cash account(s).
  6. Click Start or Print Preview and review the report.
  7. Note the Ending Balance on the GL cash account(s).
  8. Compare the Ending Balance to the Register Balance as of Statement Date on the Bank Reconciliation report.

Balances match

If the GL cash account’s Ending Balance and the Register Balance as of Statement Date match, STOP HERE. General Ledger and Cash Management are in balance for this statement period. You’re finished with these steps.

Balances don’t match

If the GL cash account’s Ending Balance and the Register Balance as of Statement Date don’t match:

  1. Is there a Register Balance Adjusted for Future Voids balance that prints on the report?
    • If yes, inspect the Void Dates of the voided items on the Bank Reconciliation report:
      1. If the Void Date is after the Statement Date, then it’s considered a “future void”.
      2. If the Void Date is on or before the Statement Date, then it isn't a “future void”. The item should be reconciled. See Register Balance Adjusted for Future Period Voids may be incorrect on the Bank Reconciliation report.
      3. If the Register Balance Adjusted for Future Voids now matches the GL cash account's Ending Balance, STOP HERE. General Ledger and Cash Management are in balance for this statement period. You’re finished with these steps.
    • If no, or if the Register Balance Adjusted for Future Voids doesn’t match the GL cash account’s Ending Balance:
      1. See Bank Reconciliation report balances are off by voided checks.
      2. After correcting the future voided items, if the Register Balance Adjusted for Future Voids and the GL cash account’s Ending Balance match, STOP HERE. General Ledger and Cash Management are in balance for this statement period. You’re finished with these steps.
  2. Run the Bank Reconciliation report for prior periods to identify the first period the Register balance matches:
    1. If the following is true, go to step 1 of Additional Troubleshooting:
      • Adjusted Bank Balance doesn’t match the Register Balance as of Statement Date
    2. If the following is true, go to step 2 of Additional Troubleshooting:
      • Bank Statement Ending Balance doesn’t match the actual bank statement for that statement period
    3. If the following is true, go to step 3 of Additional Troubleshooting:
      • Bank Statement Ending Balance matches the actual bank statement for that statement period
      • Adjusted Bank Balance matches the Register Balance as of Statement Date 
      • Balances don’t match the GL cash account’s Ending Balance on the YTD Ledger

Additional Troubleshooting

Important: The following steps are complex. Contact your Sage Consultant if you need assistance.

  1. Adjusted Bank Balance doesn’t match the Register Balance as of Statement Date
  2. Bank Statement Ending Balance doesn’t match the actual bank statement
  3. Adjusted Bank Balance, Register Balance as of Statement Date, and/or Register Balance Adjusted for Future Voids is correct but doesn’t match the GL cash account’s Ending Balance on the YTD Ledger in General Ledger

 

 

 

Need more help?

Chat now




 

Steps to duplicate
Related Solutions

Can the CM Bank Account Balance Verification report be ran for one bank instead of all of them?

How does an Accounts Payable check with a void date in the future affect my Cash Management reconciliation to General Ledger?

Bank Account balances are incorrect

The Adjusted Bank Balance is incorrect on the Cash Management Bank Reconciliation report (Bank Reconciliation in progress)