Fraud Examination Casebook with Documents. Beecken William H.

>

      William H. Beecken

      A Hands-on Approach

      Founded in 1807, John Wiley & Sons is the oldest independent publishing company in the United States. With offices in North America, Europe, Asia, and Australia, Wiley is globally committed to developing and marketing print and electronic products and services for our customers’ professional and personal knowledge and understanding.

      The Wiley Corporate F&A series provides information, tools, and insights to corporate professionals responsible for issues affecting the profitability of their company, from accounting and finance to internal controls and performance management.

      Fraud Examination Casebook with Documents

       A Hands-on Approach

      WILLIAM H. BEECKEN, CFE, CPACLARK A. BEECKEN, CFE

      Copyright © 2017 by John Wiley & Sons, Inc. All rights reserved.

      Published by John Wiley & Sons, Inc., Hoboken, New Jersey.

      Published simultaneously in Canada.

      No part of this publication may be reproduced, stored in a retrieval system, or transmitted in any form or by any means, electronic, mechanical, photocopying, recording, scanning, or otherwise, except as permitted under Section 107 or 108 of the 1976 United States Copyright Act, without either the prior written permission of the Publisher, or authorization through payment of the appropriate per-copy fee to the Copyright Clearance Center, Inc., 222 Rosewood Drive, Danvers, MA 01923, [phone], fax [phone], or on the Web at www.copyright.com. Requests to the Publisher for permission should be addressed to the Permissions Department, John Wiley & Sons, Inc., 111 River Street, Hoboken, NJ 07030, [phone], fax [phone], or online at http://www.wiley.com/go/permissions.

      Limit of Liability/Disclaimer of Warranty: While the publisher and author have used their best efforts in preparing this book, they make no representations or warranties with respect to the accuracy or completeness of the contents of this book and specifically disclaim any implied warranties of merchantability or fitness for a particular purpose. No warranty may be created or extended by sales representatives or written sales materials. The advice and strategies contained herein may not be suitable for your situation. You should consult with a professional where appropriate. Neither the publisher nor author shall be liable for any loss of profit or any other commercial damages, including but not limited to special, incidental, consequential, or other damages.

      For general information on our other products and services or for technical support, please contact our Customer Care Department within the United States at [phone], outside the United States at [phone] or fax [phone].

      Wiley publishes in a variety of print and electronic formats and by print-on-demand. Some material included with standard print versions of this book may not be included in e-books or in print-on-demand. If this book refers to media such as a CD or DVD that is not included in the version you purchased, you may download this material at http://booksupport.wiley.com. For more information about Wiley products, visit www.wiley.com.

       Library of Congress Cataloging-in-Publication Data is available:

      ISBN 9781119349990 (Hardcover)

      ISBN 9781119349952 (epdf)

      ISBN 9781119349877 (epub)

      Cover Design: Wiley

      Cover Image: © Nomad_Soul/Shutterstock

      Foreword

      I am pleased to write this foreword to the Fraud Examination Casebook with Documents: A Hands‐on Approach by William H. Beecken and Clark A. Beecken, a redoubtable father‐son team of forensic accountants. Bill has been a seasoned forensic professional employed many years with the Federal Deposit Insurance Corporation (FDIC) Office of Inspector General, as well as the Bureau of Alcohol, Tobacco, Firearms and Explosives (ATF). Clark is currently working as a forensic auditor for the federal government.

      Several years ago, as a faculty member in the School of Accountancy at Kennesaw State University (KSU), I came to know Bill as a popular faculty member at Southern Polytechnic State University – now the KSU Marietta campus – who taught forensic accounting in an innovative way. At the end of his course, it was part of the students' end‐of‐term assignment to go through the real‐world experience of being deposed as an “expert witness” by the local district attorney and overseen by a judge in the actual environs of the Marietta, Georgia, courthouse. A couple of times, I was a member of the audience in the courthouse, rather envious of Bill's students who were being exposed to a mock‐trial scenario. Hence, I enthusiastically commend and recommend Bill's idiosyncratic interpretation of a hands‐on approach!

      From my very first meeting, Clark appeared to be a chip off the old block, cut of the same cloth, the apple that doesn't fall far from the tree, etc. – sharp, incisive, and blessed with the technological adeptness and adroitness that comes with having grown up digital. So, I am not surprised that he has left his indelible mark on the book by focusing on Microsoft Excel, the industry standard for spreadsheets, featuring calculation, graphing tools, pivot tables, and such.

      Among other things, this practical fraud casebook does a wonderful job of showing how Excel PivotTables may be profitably deployed – not only to summarize a huge amount of data but also to help trace Excel Pivot red flags back to source documents to understand the flow of money. After all, much of forensic accounting can be usefully described as the work of understanding and investigating people, money, and associated patterns of behavior with great tenacity – colloquially described as the “follow the money” approach. Such work cannot be carried out without sophisticated data analysis in today's data rich, information poor (DRIP) world.

      It is one thing to appreciate the scope and reach of forensic accounting at a conceptual level; quite another to get your hands dirty with data, and recognize the power of data‐driven insights and solutions. This book admirably makes that bridge from theory to practice happen. Rather than “hand waving,” you become hands‐on – you don't just talk, for talk is cheap, but you actually perform analyses and learn to manipulate data statistically to yield relevant and meaningful information. This information helps you gather evidence and arrive at inferences that support or challenge your hypotheses – a most exciting endeavor. After all, it is such information that can greatly help buttress one's arguments, defend one's position, persuade others in courtroom contexts, and thus, help win cases.

Dr. Sridhar Ramamoorti, ACA, CPA/CITP/CFF/CGMA, CIA, CFSA, CGAP, CRMA, CFE, CGFM, CRP, MAFFAssociate Professor of Accounting, School of Business Administration, University of Dayton, OhioManaging Principal, The Behavioral Forensics Group, LLC (www.bringingfreudtofraud.com)

      MEMBERSHIPS

      Standing Advisory Group, Public Company Accounting Oversight Board, 2014–2016

      Forensic Accounting Advisory Board, Georgia Southern University, 2015–

      Board of Trustees, Financial Executives Research Foundation, 2016–

      Litigation Forensics Board, National Association of Certified Valuators & Analysts, 2016–

      Lead author, A.B.C.'s of Behavioral Forensics (Hoboken, NJ: John Wiley & Sons, 2013)

      Preface

      Professors of graduate and undergraduate Fraud Examination courses often instruct students from a survey‐level textbook and, if available, supplement their course with guest lecturers who work in the field. Those new to Fraud Examination often simply read a Fraud Examination textbook, specialized book dealing with some aspect of fraud, or study for the CFE Exam. Students usually complete a typical Fraud Examination course with general