Why Attend
While forensic accounting and fraud auditing and control are not new concepts, they are becoming increasingly important. We are constantly hearing about fraud cases and accounting schemes committed by corporations and individuals in the accounting world. This course takes participants from the theory and concept of forensic accounting to its implementation and practice. In addition, this course provides the necessary tools to help professionals add value to their organizations by examining fraud controls and applying forensic accounting and analysis to their data.
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
