Schulz Consulting

Consulting and Upgrades

  • Home
  • Services
  • Contact

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

Share this:

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

Secure cloud hosting for Sage 100
Call 1-888-244-6559 (toll-free)

About Wayne Schulz

Wayne Schulz is a Sage 100 Consultant located in Connecticut. He has worked with Sage 100 since 1986 and provides advanced support to companies located throughout the United States. If you are experiencing an issue with Sage 100 and would like to schedule a support session - please request assistance here or call 860-657-8544.

Access Sage 100 in the cloud today. 3rd party applications supported Available 24/7 from anywhere. Dedicated hosts

Call 1-888-244-6559 (toll-free)

Search Our Site

Sage 100 Newsletter

Sage 100 News

  • Sage 100 Updated TLS 1.2 Licensing Requirements ( February 2023 )
  • Shipment Tracking Functionality Restored to Sage 100
  • How To Edit 1099 Totals In Sage 100
  • How to Reconcile Sage 100 Accounts Payable Detail to the General ledger
  • Sage 100 Year-End 2022 Training Series
  • Minimum Sage 100 Versions for E-Filing for Tax Year 2022
  • What Are The Differences Between These Sage Fixed Asset Versions: Lite, Single-User, Network and Premier?
  • Sage 100 Paperless Email Electronic Delivery Failing With Rackspace
  • How To Check Sage 100 Compatibility with Avalara’s TLS 1.2 Requirement
  • Sage 100 TLS 1.2 Compliance Update ( Nov 2022)

Contact Us

Schulz Consulting
Connecticut Office
Click Here To Contact Schulz Consulting
Email Us
Available remotely nationwide.
We are a local branch of DSD Business Systems Connecticut.

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