Schulz Consulting

Consulting and Upgrades

  • Home
  • Services
  • Technical
    • Sage 100 New Features ( Brief )
  • Sage 100 Support

MAS90 Automatic Bank Reconciliation – Two Thumbs Up

September 29, 2011 by Wayne Schulz

Just back from a client today. Went through the automatic bank reconciliation with them. I’d never set one up before (this functionality is new in 4.4 and imports a list of checks from the bank into your BR and clears them and provides a list of exceptions – wrong $ or checks that cleared bank not on BR).

I highly recommend you go through all your customers who use BR and help set this up.

I had not done this previously — took maybe 10 minutes and all you need to provide is a CSV with:

Bank Acct# (it will clear against multiple cash files)
Check No
Amount

I found the Amount has to be positive or it balked (though I didn’t search to see fi there was a config I missed).

Recommended

Filed Under: Sage 100 ERP Tagged With: bank reconciliation, import

MAs90 Tip: How To Use The New Bank Reconciliation Posting To GL Feature

October 21, 2010 by Wayne Schulz

Since Sage have moved to using Product Updates for quarterly updates and fixes they’ve also doubled down on adding new features into the product.

Product Update 3 — aka PU3 — adds an ability to post Bank Reconciliation transactions from Bank Reconciliation module into the General Ledger. Amazingly up until no the Bank Reconciliation would not support posting of adjustments entered into that module back into the General Ledger.

That’s all changed and my friend Robert Wood at DDF Consulting in sunny Florida has all the details on how it works.

Post GL Bank Fees and Adjustments From Bank Rec in Sage MAS 90 / MAS 200 | DDF Consulting.

Filed Under: Sage 100 ERP, Tips and Tricks Tagged With: bank reconciliation, mas200, product update 3, Sage 100 ERP

Sage 100 Newsletter

Search Our Site

Sage 100 News

  • How to Fix: Sage 100 Desktop Launcher Closes Immediately After Login (No Error)
  • How To Update Sage Intelligence Keys as Sage Moves Away From Unlimited Licenses
  • Get More From Your Sage 100 Partnership
  • Sage Future 2025 Preliminary Agenda Released
  • Upgrading Sage 100 to 64-bit: Avoid These Integration Pitfalls
  • What’s New in Sage 100 2024? ( Video )
  • Sage 100 Users: Conquer Minnesota’s New Sales Tax & Delivery Fee Headache-Free
  • Elevate Your Sage 100 Expertise with SchulzSays: The Ultimate Newsletter for Users and Consultants
  • How To Purge Cleared Bank Reconciliation Transactions in Sage 100
  • 10 Exciting New Features in Sage 100 2024

Contact Us

Schulz Consulting
Connecticut Office
Click Here To Contact Schulz Consulting
Phone: 860-657-8544
Email Us
Available remotely nationwide.
We are a local branch of DSD Business Systems Connecticut.

Copyright © 2026 · Parallax Pro Theme on Genesis Framework · WordPress · Log in

Loading Comments...

You must be logged in to post a comment.