How to clear Bank Reconciliation when using it for the first time or after a long absence in Sage 100
- Only run this procedure when you first start using the Bank Reconciliation Module
- Don’t use it for monthly statement reconciliation if balances don’t match
- Make a full Sage MAS 90 system backup before you begin
- Open Bank Reconciliation, Main, Bank Reconciliation Register/Report.
- Select the Bank Code you want to reconcile.
- Choose the following options:
- Transaction Type = All Transactions
- Print Cleared Transactions = All Transactions
- Report Format = All Activity
- Document Date = All Dates
- Print the report.
- If the report shows no out-of-balance amount, the Bank Code Maintenance balance is correct. Reconcile in a single month
- If the report shows an out-of-balance amount, continue to the next step
- Open Bank Reconciliation, Main, Bank Code Maintenance.
- Select the Bank Code you’re trying to reconcile.
- Write down the Current Balance.
- Add or subtract the out-of-balance amount from the report to/from the Current Balance.
- Enter the result as the new Current Balance in Bank Code Maintenance.
- Re-run Bank Reconciliation Register/Report using the same selections from steps 1–3.
- If the out-of-balance amount is now zero, the adjustment worked.
- If the amount doubled, the math was incorrect. Reverse the calculation using the original balance and reprint the report.
- You can now reconcile the bank statement for a single month. Follow the steps in the related article: How to clear bank transactions in Bank Reconciliation.
- Solution ID
- 222924550020809
- Last Modified Date
- Tue Oct 07 14:36:25 UTC 2025
- Views
- 0