Would someone be willing to share their NOW account Audit process? In particular, what information you pull from your system to reports, and how you work the information once you have the reports. We have 31 branches and close to 6,000 accounts to review. It gets so burdensome, I need helpful ideas to streamline. Thanks.

Key on SSN number and look for those that typically look like EIN numbers and scan the rest of the names for Corp, Inc., LLC, etc.

When I used to conduct compliance reviews, I sorted the spreadsheet by entity type (corp, LLC, sole proprietor, etc.). Made it easier to sort through while conducting the "eyeball test".