Sage 100

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

Interesting. Thanks for the info Wayne.

Not all fields are required - for example at first we tried importing check date -- which apparently is different than the date that the check CLEARED (which is what the bank knows) --- and the system balked. We took out that check date and were able to clear items with just the three fields I mentioned (Bank Acct, Check#, Amount)

Have used this in quite a few places, works great and save time. Wayne is right on about the date field skip it as it never matches the date from the bank.

I agree - great tool! I started working on VI job to do this with a client and then we realized it was a new added enhancement and it's easy to setup.