Fraud Analysis Techniques Using ACL

Front Cover
John Wiley & Sons, Jul 23, 2009 - Business & Economics - 176 pages
"When people ask me what they can do to better utilize ACL, I tellthem, 'Take an instructor lead course, participate in the ACLForum, and study (not read, study) David Coderre's Fraud AnalysisTechniques Using ACL.' I studied this book, and would not be whereI am today without it. Even without the anti-fraud material, thebook is worth the investment as a tool to learning ACL!"
Porter Broyles, President and founder of the TexasACL User Group, Keynote Speaker at ACL's 2009 San FranciscoConference, Official ACL Super User

"For individuals interested in learning about fraud analysistechniques or the art of ACL scripting, this book is a must-read.For those individuals interested in learning both, this book is atreasure."
Jim Hess, Principal, Hess Group, LLC

Your very own ACL Fraud Toolkit—at yourfingertips

Fraud Analysis Techniques Using ACL offers auditors andinvestigators:

  • Authoritative guidance from David Coderre, renowned expert onthe use of computer-assisted audit tools and techniques in frauddetection
  • A website containing an educational version of ACL from theworld leader in fraud detection software
  • An accompanying website containing a thorough Fraud Toolkitwith two sets of customizable scripts to serve your specific auditneeds
  • Case studies and sample data files that you can use to try outthe 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-studycourse on ACL scripting which includes exercises, data files, andproposed answers.

Filled with screen shots, flow charts, example data files, anddescriptive commentary highlighting and explaining each step, aswell as case studies offering real-world examples of how thescripts can be used to search for fraud, Fraud Analysis TechniquesUsing ACL is the only toolkit you will need to harness the power ofACL to spot fraud.

 

What people are saying - Write a review

We haven't found any reviews in the usual places.

Contents

Start and Menu
16
Completeness and Integrity
22
CrossTabulation
30
Duplicates
38
Data Profile
56
Ratio Analysis
74
Benfords Law
88
Developing ACL Scripts
100
Running Scripts
114
Macro Substitution
120
Subscripts
122
LOOP and OFFSET
133
ACL Installation Process 745
145
Index 755
155
Copyright

Other editions - View all

Common terms and phrases

About the author (2009)

David Coderre has over twenty years of experience in internal audit, management consulting, management information systems, system development, and application implementation areas. He is currently President of CAATS (Computer-Assisted Analysis Techniques and Solutions). He is the author of three highly regarded books on using data analysis for audit and fraud detection and the Institute of Internal Auditors' publication on Continuous Auditing (GTAG #3).

Bibliographic information