IDEA Users Working Remotely: We’re here to help! Please contact our IDEA Help Desk to ensure there is minimal disruption to your daily workflow.
Turn over the time-consuming aspects of preparing data, building tests and using data visualization to our experts. We can handle everything from complex data imports to automating any process to save you hours of effort.
We team up with your IT and data stewards to obtain the right data in optimal formats to achieve your objectives.
Convert print documents into electronic databases, ready for analysis
Import large data sets into IDEA or other data analytics platforms
Clean up poorly-formatted fields
Verify data against customer-supplied standards to ensure data is imported correctly and properly aligned
Confirm control totals for an extra measure of accuracy
Bring your results to life using progressive data visualization technologies and dashboards
Drill-down capabilities help you answer the “why” and “where” behind the numbers
Perform more regular analysis by scheduling tasks to run automatically
Stay ahead of risks with automated processes that can be set up and modified to meet your objectives – no matter how small or complex
Top U.S. CPA firm providing audit, investigations and consulting services.
Perform cash flow analysis on 40 printed pages of brokerage statements.
Applied Optical Character Recognition (OCR) technology to convert the paper statements into electronic data files. The process included scrubbing the data to correct interpretation errors and verifying the data for accuracy.
Statements were successfully imported and sorted into separate files based on cash flow information, preparing all data for further analysis.
A workforce management global software company needed assurance that their employees were following company spending protocol for T&E purposes.
A list of T&E tests were reviewed on a one-by-one basis where a user could employ all of the tests or a subset. Based on the multiple tests performed, a summary database consisting of the most suspicious employees was created.
A program was designed to import and process data from the expense reimbursement system, including data about travel expenses, such as airfare, hotels and car rentals, and corporate credit card charges. It scored and summarized results from 15 different tests including mileage, cash transactions, and above average spending.
Tests identified multiple offenders who were prosecuted for their fraudulent actions. Policy changes and new controls were implemented to prevent future infractions.
Non-profit service organization with approximately $40 million in annual resources.
Automate frequent audits of accounts payable records to identify improper payments.
Developed IDEAScripts to automatically run when new data becomes available. Output data is formatted and made available for immediate import into the Microsoft® Dynamics CRM system.
Fully automated the import of data into IDEA and output records of all user IDs on outgoing payments to check identification codes and review exceptions. The results uncovered multiple misstatements on time sheets, totaling hundreds of thousands of dollars. The program includes 16 different tests to help detect fraudulent activity.
The internal audit department of a university with 9,500+ students purchased IDEA data analysis software to assist in ad hoc reviews of various data sets.
The University wanted to quickly implement IDEA to analyze accounts payable, P-Card and employee data for duplicates and potential matches to identify potential fraud, but were uncertain about which tests to run.
Audimation proposed various tests for the areas of interest, and provided recommendations about which tests would be most effective.
The University was able to quickly detect matches between AP, P-Card and employees based on unknown addresses and names. IDEAScripts were also developed to create a repeatable process for future audits.
Once the data is imported, we can perform a sample selection in 20 minutes that may have taken us 8 hours to complete. More importantly, the built-in logic gives us a consistent approach to audits and uniform output to work with for testing. It does the work for us!