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.

"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.

This best-selling dictionary includes more than 3,800 entries covering all aspects of accounting, including financial accounting, financial reporting, management accounting, taxation, auditing, corporate finance, and accounting bodies and institutions. Its international coverage includes important terms from UK, US, Australia, India, and Asia-Pacific. Over 150 new entries have been added to this edition to reflect the very latest developments in the accounting profession, e.g. Accounting Coucil, European Financial Stability Mechanism, and General Anti-Abuse Rule. In addition, existing entries have been updated to cover the latest developments, most notably the Financial Reporting Standard Applicable in the UK and the Republic of Ireland, which sets out new rules in areas such as goodwill, hedge accounting, and fair value accounting. There is increased coverage of topics such as corporate governance, accounting ethics, accounting scandals, and major firms and professional bodies. With its authoritative and accessible definitions and its wide-ranging coverage, this dictionary is essential for students and professionals in accounting and finance. It is also an ideal source of reference for anyone seeking a clear guide to the often-confusing world of accountancy terms.

Praise for Computer-Aided Fraud Prevention and Detection: A Step-by-Step Guide "A wonderful desktop reference for anyone trying to move from traditional auditing to integrated auditing. The numerous case studies make it easy to understand and provide a how-to for those?seeking to implement automated tools including continuous assurance. Whether you are just starting down the path or well on your way, it is a valuable resource." -Kate M. Head, CPA, CFE, CISA Associate Director, Audit and Compliance University of South Florida "I have been fortunate enough to learn from Dave's work over the last fifteen years, and this publication is no exception. Using his twenty-plus years of experience, Dave walks through every aspect of detecting fraud with a computer from the genesis of the act to the mining of data for its traces and its ultimate detection. A complete text that first explains how one prevents and detects fraud regardless of technology and then shows how by automating such procedures, the examiners' powers become superhuman." -Richard B. Lanza, President, Cash Recovery Partners, LLC "Computer-Aided Fraud Prevention and Detection: A Step-by-Step Guide helps management and auditors answer T. S. Eliot's timeless question, 'Where is the knowledge lost in information?' Data analysis provides a means to mine the knowledge hidden in our information. Dave Coderre has long been a leader in educating auditors and others about Computer Assisted Audit Techniques. The book combines practical approaches with unique data analysis case examples that compel the readers to try the techniques themselves." -Courtenay Thompson Jr. Consultant, Courtenay Thompson & Associates

There are many webinars and training courses on Data Analytics for Internal Auditors, but no handbook written from the practitioner’s viewpoint covering not only the need and the theory, but a practical hands-on approach to conducting Data Analytics. The spread of IT systems makes it necessary that auditors as well as management have the ability to examine high volumes of data and transactions to determine patterns and trends. The increasing need to continuously monitor and audit IT systems has created an imperative for the effective use of appropriate data mining tools. This book takes an auditor from a zero base to an ability to professionally analyze corporate data seeking anomalies.