Fraud Scenario Library and Risk Assessment Worksheet (Excel)
26 common fraud schemes in 4 categories, each explained with an example, with space to record how it could happen, controls and gaps.
Guides · editable Excel · 4 sheets · ₹99 / $0.99 · lifetime access, up to 5 downloads
Carry out the fraud risk assessment expected under internal financial controls (IFC in India, SOX 404 in the US) and the auditing standards on fraud (SA / ISA 240). The worksheet lists 26 common schemes under fraudulent financial reporting, misappropriation of assets, corruption and improper expenditure, and fraudulently obtained revenue or avoided costs. Each scheme explains how it works, in plain English with an example, and how to check it. Record how it could happen in your organisation, who and which accounts are involved, the controls in place and any gap or action. Editable Excel.
What's inside
- Read Me: purpose and how to use the workbook
- Key terms explained in plain language
- 26 fraud schemes in 4 categories: financial reporting, asset misappropriation, corruption, revenue and costs
- Each item: what it means in plain English and how to check it, with an example
- Columns for how it could happen here, controls in place and gap / action
- Summary sheet: results by area, updated automatically
Topics: Fraud and Ethics · Risk Management
Learn it on video
- COSO Principles 8-9 Explained: Fraud Risk and Managing Change (7 min)
- How to Conduct a Risk Assessment and Prepare a Risk Register (10 min)
- How to Link Risks to Controls: The Risk and Control Matrix (RCM) (12 min)
More guides
- Building a Code of Conduct That Works: What to Include and Warning Signs to Watch (editable Word, ₹99 / $0.99): What a strong code contains, how to roll it out and enforce it, the board's role, and eight signs a code exists only on paper.
- Building an Effective Ethics Programme: 15 Good Practices and a Health Check (editable Word, ₹99 / $0.99): Fifteen practices that turn stated values into everyday decisions, each with an example and what to look for, plus a health check.
- Designing a Speak-Up and Whistleblowing Programme: Plan, Communicate, Respond (editable Word, ₹99 / $0.99): A three-stage framework for confidential reporting channels, with legal basics, a programme checklist and measures for the audit committee.
- Financial Performance Indicators of Fraud: Red Flag Checklist (Excel) (editable Excel, ₹149 / $1.49): 54 warning signs in financial results across 9 fraud types, each with a plain-English explanation and how to check it.
Short internal audit videos · Free articles and guides · YouTube
Learn Internal Audit is run by SKYBOT Technology LLP. The founders, Amit Salla and Zehra Maccawala, are partners at ZMAS and Associates, a Chartered Accountancy firm specialising in internal audit.