Can you quickly find fraud in an organization….sometimes within minutes? Are you maximizing simple automation tools like Microsoft Excel to speed the process?
The presenter, a 20 year veteran with fraud and analytics, will explain how to take weeks of discussions, ledger and process reviews and replace them with quick-to -run data analytics, thereby providing that needed time-warp to review a majority of the business transactions fast.
This training will explain how to start with tools like the IIA’s Proactively Detecting Fraud Using Computer Audit Reports, authored by the webinar presenter, to efficiently select the best report ideas and then work towards obtaining the right data for analysis.
Specific learning objectives include:
- Which data files should be requested in the area of concern or what should the data request look like when there is no specific area of concern.
- How to quickly gather report ideas and techniques for analysis, as well as, obtain a list of some of the top fraud tests by process area.
- Using a fast-track process to validating data and understanding statistical norms for benchmarking purposes. Statistical techniques to be utilized include: standard deviation, a unique method of combining Benford’s Law and other electronic analysis techniques, time/size stratifications, and value/volume difference scattergraphs.
- How to combine your reports for maximum impact and understanding this concept within a specific review of accounts payable. Additional report techniques that can be applied to expected data files include user transaction analysis, data file change reviews, and external data mapping.
- How 90% of the work performed can be completed using simple and available tools like Microsoft Excel, while other audit softwares will be explained for some of their unique benefits.
- Concluding with an approach on how these tools could be part of a continuous fraud monitoring program.
This is a previously recorded 2-hour webinar from AuditNet® with Jim Kaplan and Rich Lanza.
Delivery Method: Self-Study
AuditNet® is the Global Resource for Auditors, and serves the global audit community as the primary communications resource with an online digital network where auditors share resources, tools, and experiences including audit work programs and other audit documentation.
As the first online portal for the global audit community, AuditNet® has been at the forefront of audit websites dedicated to promoting the use of technology. http://www.auditnet.org/
Jim Kaplan, the founder of AuditNet®, became a Certified Internal Auditor in 1984. He has continuously promoted and encouraged the use of technology and the Internet for audit productivity.
As an active member of the IIA, he has held many positions at the local and International level. He is a founding member of the Northern Virginia Chapter and served as Chapter President in 1989. He retired from his government audit director position in 2005. He is the founder and President of AuditNet®, the global resource for auditors, and has been identified as an Internet for Auditors pioneer. Jim's contributions to the profession were recognized by the IIA (2007 Bradford Cadmus award) and the Association of Local Government Auditors (Lifetime Achievement Award). In addition to the IIA, he is a member of the Association of Local Government Auditors and the Association of Certified Fraud Examiners.