Sage ERP MAS 90 – Bank Reconciliation Tips & Tricks

Many times users of the MAS 90 Bank Reconciliation Register will come upon an out of balance condition when performing their reconciliation. Here are some steps to help in finding the cause of that condition:

· Verify the Ending Statement Balance has been entered correctly

· In Reconcile Bank, use the Search Icon and search each tab for the out of balance amount

· Verify all transactions on the bank statement have been cleared in Reconcile Bank

o Print the Bank Reconciliation Register (Cleared Documents Only) – Deposits and Adjustments are listed in chronological order, while checks are listed in numerical order

o Print the Bank Recap Report (Cleared Documents Only) – all transactions are printed in chronological order, and the total of each transaction type is listed at the bottom of the report

· Verify that any future entries have not been cleared – print the Bank Recap Report for Cleared Transactions and All Dates

· Verify the Beginning Balance on the Bank Recap Report is correct – the Beginning Balance should be equal to the Ending Balance on the previous month’s Bank Statement (providing, of course, that the Bank Reconciliation balanced in the previous month). The Bank Statement to use to proof this is the last Bank Statement that you reconciled and removed all cleared documents.

· Verify that the Ending Balance on the Bank Recap Report matches the Current Balance in Bank Code Maintenance

· Verify that the totals displayed for your outstanding transactions on both reports are correct

· Verify the Out of Balance in Reconcile Bank matches the Out of Balance on the Bank Reconciliation Register

· Additional steps if none of the above worked

o Check the Daily Transaction Register in the G/L > Main folder to ensure that all A/P transactions have posted to the G/L. Update any outstanding transactions.

o Verify in the G/L Detail Report for the Bank Code Cash Account that all transactions posted through either the CR, CD, or MC source journals; if not, verify that any General Journal entries to the cash account were made via the Transaction Journal Entry task and were posted to the correct Bank Code.

Recently, I’ve had two cases where the Reconcile Bank out of balance displayed 0.00, but the out of balance amount on the Bank Reconciliation Register was different, thus presenting the reconciliation and purge of cleared documents. Here are the steps to resolve this issue:

· NOTE: Always use caution when working with the MAS 90 Utilities. Always make a backup first. If necessary, seek the assistance of a qualified Sage Software business partner, such as Ennis, Pellum & Associates in Jacksonville, Florida (shameless plug!)

· In Version 4.05 and below

o Rebuild the BR1 Key File

o Rebuild Bank Reconciliation Sort Files

· Version 4.10 to 4.40.0.1

o Rebuild the Bank Reconciliation Sort Files

· Version 4.40.0.2 and above – New Feature

o Use the new Recalculate Outstanding Entries Totals Utility to recalculate the totals of all outstanding check, deposit, and adjustment entries that have not been marked clear from the B/R module.

Finally, if you’ve exhausted all of these steps and still encounter an out of balance condition in your bank reconciliation, contact your Sage ERP MAS 90 reseller or Business Partner for assistance. In the Northeast Florida area, Ennis, Pellum & Associates will be glad to assist you.

Advertisements
This entry was posted in Sage Software and tagged , , , , , , . Bookmark the permalink.

4 Responses to Sage ERP MAS 90 – Bank Reconciliation Tips & Tricks

  1. Bridget H. says:

    Does anyone know of a good step by step procedure to reconcile the deposits account? We are continuously posting credit card payments and invoicing. I am finding it hard to reconcile a moving target. Any ideas?

  2. You ought to be a part of a contest for one of the best blogs on the net.

    I am going to highly recommend this web site!

  3. Dennis Allen says:

    I just started at a company that has never reconciled the bank account in MAS 90, so I am trying to clean up data going back to 1997.

    I have managed to reconcile the adjusted bank balance to the GL, but it is out of balance with the calculated book balance by $547.78. How do I adjust or fix the caluculated book balance to match the GL and adjusted bank balance?

  4. Robert Wood says:

    Great post!

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s