ERP systems have become the central system for most organizations where information is fed, captured, cultivated and ultimately used to make critical business decisions. It can also be a complex environment, one that is challenging to navigate, understand and extract value from – that is unless you use data analytics to unlock its value. This webcast covers how IDEA can be used to import, analyze and glean insights from ERP system data, such as Banner. The presenter will demonstrate how IDEA is used to test areas including Affordable Care Act data from human resources and student records. It will also cover how auditors saved hundreds of audit hours by using IDEA.
One hour (1 CPE)
1:00 PM - 2:00 PM Central
Benjamin Johnson, CPA, CIA
Internal Auditor, Utah State University
Ben has served as the Data Analytics Auditor at Utah State University since 2013 where he develops tests and reports from data from the University’s ERP system, Banner. His current role includes helping fellow auditors find the right data to support audits and develop automated processes. He has performed testing in both financial and non-financial areas of the institution, which built connections for internal audit with other departments on campus. Using IDEAScripts, Ben has automated monthly and quarterly testing to achieve higher levels of efficiency.
After completing this training, participants will learn:
How to work with data stewards and understand data sources to identify areas where IDEA testing will be most effective
Understand the importance of standardizing non-financial data and dealing with outliers
Determine which aspects of a test lead to easy and useful automation
Audimation Services, Inc. is registered with the National Association of State Boards of Accountancy (NASBA) as a sponsor of the continuing professional education on the National Registry of CPE Sponsors. State boards of accountancy have final authority on the acceptance of individual courses for CPE credit. Complaints regarding registered sponsors may be submitted to the National Registry of CPE Sponsors through its website: nasbaregistry.org
CPAs may contact us by email at [email protected] to receive promotional materials containing details on the required elements of the National Registry of CPE Sponsors.