How we've helped our clients...

Data Cleansing

When the World Bank needed someone to clean and de-dupe their 300,000+ record vendor database, they turned to Automated Auditors, LLC. The Procurement department submitted an RFP for the project, which Automated Auditors won in conjunction with Recovery+Solutions (strategic partner), beating out the large-company competition such as EDS and IBM. For a reasonable price, Automated Auditors identified duplicate vendor records by name, address, phone, bank account number, and delivered all results in an Access database, along with a comprehensive report describing the duplicates found and the reasons behind their formation. This task involved a great deal of fuzzy-matching, because international address often lack the standardization found in U.S. addresses, thereby creating the need for phrase-matching. Our analysts created customized software to identify all duplicate records and link them together in "vendor families", giving the World Bank a database that logically tied all related records together.

A/P Fraud Detection

We conducted a duplicate payment audit for a medium-sized health product manufacturer. During the audit, we identified several above-average payments for an employee. After bringing it to the Controller's attention, we learned that several employees had already been fired for stealing checks. What the Controller didn't know was that these checks were written to the employee for over $40,000 each (3 of them + other checks). Our staff was able to identify this fraud because we read in the client's CHECK REGISTER file, not their A/P file. The fraudulent checks had no invoice number, which probably would have been rejected in their A/P system. Because our staff can read "messy" data such as Check Register data, we were able to detect the fraud.

Duplicate payment detection

Our analysts helped MCI Telecommunications identify millions in duplicate invoices. We developed a customized software solution for this client so that they could detect duplicate payments on an as-needed basis without referring to a collection agency. Because of the dupe payment detection tool, they were able to keep their profit recovery initiative discreet - a must in this age of accounting scandals.

We recently conducted a duplicate payment audit for a health product manufacturer and successfully identified $93,000 in duplicate payments.

Statistical Analysis: Tax Shelter Lawsuit Support

One of our clients, Dubinsky & Co. (www.dubinskyco.) is a leading forensic accounting firm in Bethesda, Maryland. In support of a high-profile tax shelter lawsuit, we used SAS to determine the probability that customers seeking a legitimate tax shelter would actually see a profit on the tax shelter scheme. The effort involved customized SAS programming and the use of statistical binomial probability calculations.

Vendor Fraud: Benford's Law Analysis

We used our proprietary software, A/P Fraud Detector, to identify unusual invoice activity for one of our clients, Investigative and Forensic Accounting Services (www.ifas.cc). Using Benford's Law of Numbers, we identified several vendors with unusual invoice activity. These vendors were then flagged for further investigation.

Accounting Software: Development

Our staff developed a Microsoft Access software solution for Sensormatic Security Corporation (SSC) that enabled their Controller to query their Accounts Receivable payment detail files. In addition, our analysts supported SSC in an ongoing lawsuit with their parent company, Tyco, by analyzing SAS programs. Staff analyzed the SAS programs to gain an in-depth understanding of how Tyco was (or was not) paying SSC correctly for sales in the Maryland/Virginia/DC region.

Prediction Analysis: Loan Consolidation