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. Rerun the report on the period before and work back to locate the first out of balance period.
   2. Confirm the list of outstanding items shows only transactions that haven’t cleared as of the statement date. If there are transactions that you don't want outstanding, see why a Reconciled Item shows 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.
   3. See how to fix balances that are incorrect because of the Cleared Date or Statement Date.
   4. If the same variances exist on earlier reports, verify Cash Management balances to itself.
   5. See how to fix balances that are incorrect due to reconciled items 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, go to section 4.
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 More 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 Modify Date Range box.
4. Enter the Start date and End date for the period.
5. Click Ranges and select the bank’s GL cash accounts.
6. Click Start or Print Preview and review the report.
7. Note the Ending Balance on the GL cash accounts.
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”. You need to reconcile the item. See Register Balance Adjusted for Future Period Voids can be incorrect on the Bank Reconciliation report.
     3. If the Register Balance Adjusted for Future Voids 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.
   • No balance prints. Or 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, verify the balances.
     3. If the Register Balance Adjusted for Future Voids 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.
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 More 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 More 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 More 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

More Troubleshooting

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

Adjusted Bank Balance doesn’t match the Register Balance as of Statement Date

• The item's Cleared date is before the Reference date
• Items have a Cleared status instead of a Reconciled status
• The Payroll accounting date uses the Period End Date
• A reconciled transaction has a future date

Bank Statement Ending Balance doesn’t match the actual bank statement

• An item that cleared the bank is open
• A reconciled item didn't clear the bank
• An entry has an incorrect Cleared Date and/or Statement Date
• An item that cleared the bank was deleted

Cash Management has correct balances, but they don't match General Ledger

Cash Management balances

• Adjusted Bank Balance
• Register Balance as of Statement Date
• Register Balance Adjusted for Future Voids

General Ledger balances

• The cash account's Ending Balance on the YTD Ledger

Solutions

• What could cause the Cash Management and the General Ledger to be out of balance?
• How do I reconcile Cash Management to General Ledger? (By Transaction or Batch)

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)