Computerized Auditing Using Acl Data Analytics

Computerized Auditing Using ACL Data Analytics

Audit Command Language (ACL) Analytics: A Practical Guide for Beginners (UUM Press)

Tired of performing an audit manually? This module provides a useful step-by-step approach to perform an audit using ACL. Easy to understand and follow. No such module in the market so far. This module is designed to assist users on how to use ACL as a powerful tool to audit. The module is divided into 8 Chapters. Chapter 1 introduces audit and information technology (IT) audit, audit assertions, audit procedures, and the relationship between audit assertions and audit procedures. Chapter 2 explains ACL in the audit, describing in brief its advantages and disadvantages. Chapter 3 assists users with using ACL. In this chapter, users will learn how to install ACL (version 9), and get familiar with the ACL menus and user interfaces. This module uses a step-by-step approach to guide users from creating a new project from ACL to viewing and modifying the table in ACL. Chapter 4 elaborates how to use ACL commands for data integrity verification. For this purpose, users will learn how to count records, total numeric fields or expression, and check for validity errors. Chapter 5 shows users how to analyse their data using the ACL command. The analyse include statistics, stratify, classify, examine the sequence, check for gaps, check for duplicates, ageing, and summarise commands. The remaining chapters cover three main accounting information systems (AIS) cycles, namely, sales and cash receipts (Chapter 6), purchase and cash payments (Chapter 7), and human resource (Chapter 8). For each cycle, cases are given for better assimilation.

Fraud Analysis Techniques Using ACL

"When people ask me what they can do to better utilize ACL, I tell them, 'Take an instructor lead course, participate in the ACL Forum, and study (not read, study) David Coderre's Fraud Analysis Techniques Using ACL.' I studied this book, and would not be where I am today without it. Even without the anti-fraud material, the book is worth the investment as a tool to learning ACL!" —Porter Broyles, President and founder of the Texas ACL User Group, Keynote Speaker at ACL's 2009 San Francisco Conference, Official ACL Super User "For individuals interested in learning about fraud analysis techniques or the art of ACL scripting, this book is a must-read. For those individuals interested in learning both, this book is a treasure." —Jim Hess, Principal, Hess Group, LLC Your very own ACL Fraud Toolkit—at your fingertips Fraud Analysis Techniques Using ACL offers auditors and investigators: Authoritative guidance from David Coderre, renowned expert on the use of computer-assisted audit tools and techniques in fraud detection A website containing an educational version of ACL from the world leader in fraud detection software An accompanying website containing a thorough Fraud Toolkit with two sets of customizable scripts to serve your specific audit needs Case studies and sample data files that you can use to try out the tests Step-by-step instructions on how to run the tests A self-study course on ACL script development with exercises, data files, and suggested answers The toolkit also contains 12 'utility scripts' and a self-study course on ACL scripting which includes exercises, data files, and proposed answers. Filled with screen shots, flow charts, example data files, and descriptive commentary highlighting and explaining each step, as well as case studies offering real-world examples of how the scripts can be used to search for fraud, Fraud Analysis Techniques Using ACL is the only toolkit you will need to harness the power of ACL to spot fraud.