Course Objectives
Forensic Accounting and Fraud Control
Course Methodology
The course uses a blend of instructor presentations, individual and group exercises and participants working on real life case studies and applying analytical MS Excel tools learned during the course.
Course Objectives
By the end of the course, participants will be able to:
Explain fraud and forensic accounting
Implement fraud controls to decrease the likelihood of fraud in the organization
Utilize Microsoft Office tools to find fraudulent transactions and report on them
Apply statistical and forensic accounting tools to analyze data
Assist internal audit and senior management in testing data and finding anomalies
Utilize Excel efficiently to identify suspicious information that needs further fraud investigation
Identify fraud and anomalies using Excel
Target Audience
Professionals in the field of finance and accounting, controllers, accounting managers, senior and chief accountants, analysts, internal and external auditors and accountants at all levels seeking to enhance their practical forensic accounting skills.
Target Competencies
Understanding forensic accounting
Applying forensic auditing
Analyzing financial data
Detecting fraud
Preventing fraud
Identifying fraud and fraudsters
Controling fraud
Examining data in Excel
Utilizing Excel for data analysis
Course Outline
Fraud and forensic accounting
Introduction to fraud
Fraud triangle
Fraudsters’ profile
Introduction to forensic accounting
Introduction to fraud examination
Corporate governance and ethics
Code of conduct
Fraud schemes and controls
Financial statements
Corruption schemes
Fraud Schemes in Assets
Fraud Schemes in Liabilities
Fraud Schemes by outsiders
Fraud Schemes in Purchasing
Fraud Schemes in Sales
Red flags
Fraud detection
Fraud prevention
Fraud response
Internal controls
Forensic analysis with MS Office
Importing data into Excel
Analyzing data in Excel
Protecting data in Excel
Reporting data in Word
Reporting data in PowerPoint
High-level data tests
Data profile
Periodic graph
Histogram
Utilizing Excel to prepare data profile
Utilizing Benford’s law to test numbers
Data sets that could be used
Effect of data size
Basic digit test
First two digit tests
Summation test
Number duplication test in Excel
Last two digits test
Identifying fraud and anomalies using Excel
Largest growth test
Largest subsets test
Relative size factor test
Same-Same-Same test
Same-Same-Different test
Fraud and forensic accounting
Introduction to fraud
Fraud triangle
Fraudsters’ profile
Introduction to forensic accounting
Introduction to fraud examination
Corporate governance and ethics
Code of conduct
Fraud schemes and controls
Financial statements
Corruption schemes
Fraud Schemes in Assets
Fraud Schemes in Liabilities
Fraud Schemes by outsiders
Fraud Schemes in Purchasing
Fraud Schemes in Sales
Red flags
Fraud detection
Fraud prevention
Fraud response
Internal controls
Forensic analysis with MS Office
Importing data into Excel
Analyzing data in Excel
Protecting data in Excel
Reporting data in Word
Reporting data in PowerPoint
High-level data tests
Data profile
Periodic graph
Histogram
Utilizing Excel to prepare data profile
Utilizing Benford’s law to test numbers
Data sets that could be used
Effect of data size
Basic digit test
First two digit tests
Summation test
Number duplication test in Excel
Last two digits test
Identifying fraud and anomalies using Excel
Largest growth test
Largest subsets test
Relative size factor test
Same-Same-Same test
Same-Same-Different test