Skip to content
logo Knowledgebase

How to reconcile the Bank Reconciliation Register for the first time or if the Bank Reconciliation module has not been used for a while and Bank Reconciliation has been integrated during this time.

Created on  | Last modified on 

Summary

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

Resolution

Note: This procedure should only be done at the time you first start to use the Bank Reconciliation Module. Do not use to reconcile monthly statements that are out-of-balance. It is highly recommended that you make a complete Sage MAS 90 system back-up prior to performing this process.

  1. Open Bank Reconciliation, Main, Bank Reconciliation Register/Report. Select the specific Bank Code to reconcile.
  2. Select the following:
    • Transaction type = All Transactions
    • Print Cleared Transactions = All Transactions
    • Report Format = All Activity.
    • Document Date = All Dates
  3. Print the report, which will probably show an out-of-balance amount. If it does not show an out-of-balance amount, the correct amount is already in Bank Code Maintenance and a bank statement for a single month can be reconciled. If it does show an out-of-balance amount, proceed to next step.
  4. Open Bank Reconciliation, Main, Bank Code Maintenance and select bank code for the bank you are trying to reconcile.
  5. Write down the Current Balance figure.
  6. Add or subtract the out-of-balance figure on the report to/from the current balance figure. Enter the result of the calculation as the new Current Balance in Bank Code Maintenance.
  7. Re-run the Bank Reconciliation Register/Report with the same selection criteria used in the steps 1 -2. The out-of-balance figure should now be zero. If the out-of-balance figure has doubled,  the math function in the previous step was performed incorrectly. Go back and reverse the calculation just made, starting with the original bank balance you wrote down, then reprint the report to make sure the out-of-balance figure is zero.
  8. Bank Reconciliation can now be reconciled to a statement for a single month, following the procedures outlined in the Related Article below,  How to clear bank transactions in Bank Reconciliation


DocLink: How to Clear Bank Transactions in Bank Reconciliation