Reconcile the Bank Reconciliation Register for the first time

Summary

How to clear Bank Reconciliation when using it for the first time or after a long absence in Sage 100

Description

  • 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

Resolution

  1. Open Bank Reconciliation, Main, Bank Reconciliation Register/Report.
  2. Select the Bank Code you want to reconcile.
  3. Choose the following options:
    • Transaction Type = All Transactions
    • Print Cleared Transactions = All Transactions
    • Report Format = All Activity
    • Document Date = All Dates
  4. 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
  5. Open Bank Reconciliation, Main, Bank Code Maintenance.
  6. Select the Bank Code you’re trying to reconcile.
  7. Write down the Current Balance.
  8. Add or subtract the out-of-balance amount from the report to/from the Current Balance.
  9. Enter the result as the new Current Balance in Bank Code Maintenance.
  10. 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.
  11. 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.

Need more help?

Chat now

 

Related Solutions

How to Clear Bank Transactions in Bank Reconciliation

Solution Properties

Solution ID
222924550020809
Last Modified Date
Tue Oct 07 14:36:25 UTC 2025
Views
0