Internal Control - receipt of checks

dbfromnewjersey
dbfromnewjersey used Ask the Experts™
on
A business unit receives a relatively large volume of checks each day (around a thousand checks a day on average).  In a recent audit, the auditors specified that checks need to be logged upon receipt. Because of the large volume involved, I'm wondering if anyone out there has experience with or is aware of an acceptable alternative (in regard to internal control) to literally manually logging each and every check every day in some sort of a check register.  Doing it that way would be very labor intensive and time consuming.  Thanks.
Comment
Watch Question

Do more with

Expert Office
EXPERT OFFICE® is a registered trademark of EXPERTS EXCHANGE®
vguzmanPresident

Commented:
what about creating a database in Access to do this ? or, are you looking for a "off the shelve" to do this for you ?

Author

Commented:
An Access database is already in the works.
vguzmanPresident
Commented:
You can probably also use a check reader/scanner to populate most of the info on the screen for you and just "double check" everything before you post it.

Good luck !
Developer
Fellow 2017
Most Valuable Expert 2018
Commented:
> a relatively large volume of checks each day (around a thousand checks a day on average)

How are they processing such a large number of checks now? If they already have a check scanner, software should be available for it that will log each scanned check into a database, at the very least with the MICR information, and possibly with other info from OCR/ICR/IWR (and, of course, the image). If they don't have a check scanner, I would get one, put it right in the mail room where the checks come in and scan them immediately (the auditors should like that). There are plenty of check scanners on the market, but I can't make recommendations based on recent experience — all of my work on this was on equipment that is now considered obsolete, but I would look at name-brand manufacturers, like Burroughs and Digital Check. Regards, Joe

Do more with

Expert Office
Submit tech questions to Ask the Experts™ at any time to receive solutions, advice, and new ideas from leading industry professionals.

Start 7-Day Free Trial