How to resolve an Out of Balance in Bank Reconciliation

Summary

Steps, tips, and tricks for reconciling bank accounts or resolving an Out of Balance in Bank Reconciliation in Sage 100.

Lists checks, deposits, and adjustments in the order they happened.
You can print it anytime before deleting the Bank Reconciliation file.
This report shows all transactions for a chosen date range.
You can print:
- One or more transaction types.
- Only cleared, only outstanding, or all transactions.
For each bank code, it prints:
- Transaction date, type, source, check number, and check type
- Reference, comment/payee name, cleared status, amount, and bank balance
The report prints the number of transactions and total amount for each selected transaction type.

Lists all transactions for a chosen date range.
The report provides a summary of reconciliation.
The register acts as an audit record of bank activity.
It Includes transactions from:
- General Ledger, Accounts Payable, Accounts Receivable
- Payroll, Purchase Order updates, and manual entries using Check, Deposit & Adjustment Entry
You normally print the Bank Reconciliation report after using the Reconcile Bank.
The reconciliation summary:
- Total all outstanding checks, deposits, and adjustments
- Shows calculated book balance up to the ending transaction date

Match these amounts with the bank statement summary:

You can create a template such as the example below. Enter the bank information and use it to Check amounts in Sage 100.

Open Bank Reconciliation, go to Reports, then select Bank Recap Report.
Enter the bank code only. Leave other fields blank.
Preview the report and compare its beginning balance to the Bank Statement's beginning balance.
If the balances don’t match, follow these steps to fix it:
Find the difference between:
- Ending balance on last purged Bank Statement.
- Beginning balance on Bank Recap Report. (For example: If you purged May, June's Bank Statement beginning balance need to match the Bank Recap Report.)
- Tip: Always purge cleared transactions monthly after printing a balanced Bank Reconciliation Report.
Go to Bank Reconciliation, then Main, and open Bank Code Maintenance.
Choose the correct bank code from the lookup list.
Write down the Current Balance before making changes.
Adjust the Current Balance using the difference from step 5:
- If the Bank Recap Report is too low: Increase the Current Balance.
- If the Bank Recap Report is too high: Decrease the Current Balance.
- Enter the new amount and click Accept.
Run the Bank Recap Report again and confirm the beginning balance matches the Bank Statement.

Make sure the ending balance on the bank statement matches the Ending Balance entered in the Reconcile Bank.

When the out of balance amount is zero, start reconciling against the General Ledger.
This process uses the Bank Recap Report and General Ledger Detail report for comparison.
- If not balance, check General Ledger doesn't balance to the Bank Reconciliation module
Print the Bank Recap Report through the last day of the month you're reconciling.
Print the Bank Reconciliation Report through the same date.
Answer Yes when asked, “Do you want to purge cleared documents?”

CAUTION: Retain these copies as you can't regenerate these reports.