1 / 29

ACL User Conference

ACL User Conference. New York City June 8 th , 2009. The Road to Continuous Assurance by Jason Gross. Control Management versus Internal Audit No longer independent Actively participates in the business decisions Become more of the event driver towards continuous monitoring.

elia
Download Presentation

ACL User Conference

An Image/Link below is provided (as is) to download presentation Download Policy: Content on the Website is provided to you AS IS for your information and personal use and may not be sold / licensed / shared on other websites without getting consent from its author. Content is provided to you AS IS for your information and personal use only. Download presentation by click this link. While downloading, if for some reason you are not able to download a presentation, the publisher may have deleted the file from their server. During download, if you can't get a presentation, the file might be deleted by the publisher.

E N D

Presentation Transcript

  1. ACL User Conference New York City June 8th, 2009

  2. The Road to Continuous Assurance by Jason Gross • Control Management versus Internal Audit • No longer independent • Actively participates in the business decisions • Become more of the event driver towards continuous monitoring

  3. In Order To Succeed… • Obtain support & commitment from Audit Committee and Management • Continuous Auditing should complement the Audit Plan • Start small; build from success • Automate/leverage from well-defined periodic audits • Gain reliance by external auditors and add value

  4. Technology Tools… • Optimize current data analytic scripts and schedule routines on a ‘continual’ basis’ • Obtain direct access to the data • Cultivate core team of skilled auditors using technology for data extraction and analysis

  5. ContinuousAuditTechniques with ACL by David Toussas • No little blue box under our chairs • Interesting overview of the history of the company • The evolution of using ACL in their business • Overcoming the challenges/access to data • Get buy-in

  6. Evolution of ACL at Tiffany • 2001: Created A/P Testing Module in ACL • 2003: Initial Attempt at Continuous Audit • 2003: Identified Issue in Production Report • 2004: Utilized U.S. Sales Data Warehouse • 2005: Enhanced Post Void Testing • 2005: Travel & Entertainment (cash advances)

  7. Challenges they faced • Staffing • Turnover in the SOX-Era has been challenging • Limited resources with technical skills • Sustainability • Data exists on various platforms and databases • Majority of time spent developing/running queries • Staff is uncomfortable downloading/importing

  8. What they did about it • New Goals • Centralized repository for data gathering • Consistently refresh data • Ability to control changes to ACL Modules • Expand Continuous Audit into International Retail • Identify additional projects • Implement • Upgrade ACL Server to ACL AuditExchange

  9. Impact Award Winners • Manuel Coello - Stanley Works • North American Winner • Continuous Monitoring using ACL and their successes • David T. Miod - United States Air force • Overall winner • Cost reductions in the millions if not billion+

  10. Manuel Coello - Stanley Works

  11. Smorgageboard of ACL Uses • Travel Improvement Event • Contracts Improvement Event • GPC Improvement Event • Supply Improvement Event • AVPOL Improvement Event • Reimbursements Improvement Event • All with dollar savings in the millions

  12. Continuous Auditing and Assurance • By Dustin Lewis – ACL • Do ad hoc first then automate • Early wins/high risk areas • Analytic Essentials (for Audit Exchange Only) • Run Verify • Comment tricks • End of blank line ends comments • Making font bigger (or smaller) • Example of cleaning up files • All commands in upper case • Use of permanent variables (_status) • Set Debug?

  13. Benchmarking WorkshopUse it or lose it • Must not have been too eventful for me • Each table had ½ hour to come up with ACL application ideas that was unique • ½ hour to share our ideas • Mine was duplicate reporting – first thing facilitator said was no dup reporting ideas since everyone has one. • Our table wasn’t picked • Last item on the agenda before cocktail hour

More Related