Support doesn't include help with the following items. Review the Scope of Support for further details.

• Analyzing your individual transactions to determine the source of a data entry error
• Advice regarding how to code individual transactions
• Account reconciliation

Steps to Reconcile Bank Reconciliation Report to General Ledger

If the General Ledger doesn’t match the Bank Reconciliation Report, follow these steps to find and fix the issue.

Check Beginning Balances in Both Modules

1. Go to Bank Reconciliation, then Reports.
2. Run a Bank Recap Report. Set the Bank Code to Equal to, and choose your bank code.
3. Find the ending balance from the previous month on this report.
4. Go to General Ledger, Main, Account Maintenance, and select the account for the bank code.
5. On the History Tab, find the ending balance for the same prior month.
6. Compare both balances. If they don’t match, the issue started last month.
   • Check to see if a transaction posted after reconciliation in one module but not the other.

Check Data in General Ledger

1. In General Ledger, Main, Account Maintenance, select the account for the bank code.
2. Compare the ending balance on the History Tab with the Transaction Tab.
3. If they don’t match, refer to How to recalculate G/L account balances and dates.

Check Data in Bank Reconciliation

Even if your bank statement matches, verify the following:

1. Run Bank Recap Report, set Bank Code to Equal to, and choose your bank code.
2. The beginning balance must match the ending balance from the last reconciled and purged bank statement.
3. If not, refer to How the system calculates the beginning balance on the Bank Recap Report.
4. The ending balance must match the Current Balance in Bank Code Maintenance.
5. If not, refer to Ending Balance on the Bank Reconciliation Recap Report doesn't match the Current Balance.

If Reconciliation Was in Balance but Now Isn’t

Use caution with repair tools. Always back up first. Contact a Sage partner or support if needed.

• For versions 4.40.0.2 and higher: Go to Bank Reconciliation, Utilities, Recalculate Outstanding Balances
• For versions 4.20 – 4.40.0.1: Rebuild sort files for Bank Reconciliation
• See: How to rebuild sort files
• If still out of balance, refer to How to resolve an Out of Balance in Bank Reconciliation

Confirm All Entries and Dates Match

1. Make sure all transactions appear in both modules.
2. Posting Dates in the General Ledger must match Document Dates in Bank Reconciliation.
3. Any mismatch is a reconciling item.

Use these reports to check:

• Bank Recap Report
• General Ledger Detail Report

Review transactions before, during, and after the month.