Financial Statement Fraud Indicators
This dataset simulates detailed financial statement records for public and private companies, enriched with fraud risk indicators and audit outcomes. It is designed for developing and benchmarking machine learning models to detect financial statement fraud, with comprehensive fields for financial metrics, suspicious activity counts, and risk scoring. The dataset is ideal for forensic analysis, risk assessment, and audit research in the finance industry.
Sample rows
preview · 8 of 200 rows · all 27 columns| record_idstring | auditor_opinionstring | fraud_risk_scorefloat | fraud_flagboolean | industry_sectorstring | company_idstring | company_namestring | fiscal_yearinteger | fiscal_periodstring | statement_datedate | total_revenuefloat | cost_of_goods_soldfloat | gross_profitfloat | operating_expensesfloat | net_incomefloat | total_assetsfloat | total_liabilitiesfloat | total_equityfloat | cash_and_equivalentsfloat | accounts_receivablefloat | accounts_payablefloat | inventoryfloat | suspicious_transactions_countinteger | unusual_journal_entries_countinteger | large_adjustments_countinteger | company_typestring | countrystring |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| FS0001 | Unqualified | 0.06 | false | Retail | C101 | Horizon Retail Ltd. | 2019 | FY | 2020-03-15 | 3845021.73 | 2667310.72 | 1177711.01 | 436595.17 | 741115.84 | 7689223.54 | 3821151.29 | 3868072.25 | 1252122.65 | 678312.89 | 597145.22 | 1104109.13 | 0 | 0 | 0 | Private | Canada |
| FS0002 | Qualified | 0.15 | false | Biotechnology | C102 | BlueSky Biotech PLC | 2020 | Q2 | 2020-07-20 | 215480000 | 136892000 | 78588000 | 61270400 | 17317600 | 289000000 | 260123000 | 28877000 | 34500000 | 17500000 | 13400000 | 21000000 | 1 | 1 | 0 | Public | United Kingdom |
| FS0003 | Qualified | 0.18 | false | Mining | C103 | Atlas Mining Corp. | 2021 | Q1 | 2021-04-10 | 120000 | 150000 | -30000 | 25000 | -55000 | 400000 | 515000 | -115000 | 22000 | 7000 | 43000 | 17000 | 0 | 1 | 1 | Private | South Africa |
| FS0004 | Unqualified | 0.1 | false | Food Processing | C104 | Green Valley Foods LLC | 2022 | Q3 | 2022-10-02 | 14500000 | 10220000 | 4280000 | 2570000 | 1710000 | 23900000 | 13600000 | 10300000 | 2280000 | 1670000 | 1450000 | 2100000 | 1 | 0 | 0 | Public | Australia |
| FS0005 | Unqualified | 0.21 | false | Technology | C105 | FirstWave Technologies Inc. | 2018 | FY | 2019-02-28 | 96000000 | 65800000 | 30200000 | 22000000 | 8200000 | 114000000 | 55400000 | 58600000 | 13200000 | 6700000 | 8600000 | 10500000 | 2 | 1 | 0 | Public | United States |
| FS0006 | Unqualified | 0.03 | false | Hospitality | C106 | Sunset Hospitality Group | 2021 | Q2 | 2021-07-10 | 4500000 | 3060000 | 1440000 | 932000 | 508000 | 8200000 | 2940000 | 5260000 | 1020000 | 420000 | 380000 | 900000 | 0 | 0 | 0 | Private | Singapore |
| FS0007 | Qualified | 0.17 | false | Textiles | C107 | NextGen Apparel PLC | 2020 | Q4 | 2021-01-14 | 1500000 | 1650000 | -150000 | 175000 | -325000 | 780000 | 890000 | -110000 | 53000 | 29000 | 130000 | 70000 | 1 | 0 | 1 | Public | Bangladesh |
| FS0008 | Qualified | 0.23 | false | Financial Services | C108 | Equinox Financial Group | 2021 | FY | 2022-02-28 | 430000000 | 289100000 | 140900000 | 98780000 | 42120000 | 670000000 | 536000000 | 134000000 | 43500000 | 35400000 | 22000000 | 15000000 | 3 | 2 | 1 | Public | Germany |
| FS0009 | Qualified | 0.19 | false | Textiles | C109 | Aspire Textiles Co. | 2019 | Q1 | 2019-04-15 | 210000 | 235000 | -25000 | 17000 | -42000 | 180000 | 220000 | -40000 | 9000 | 8000 | 30000 | 6000 | 1 | 0 | 1 | Private | Vietnam |
| FS0010 | Unqualified | 0.08 | false | Healthcare | C110 | Nova Healthcare Ltd. | 2022 | FY | 2023-01-22 | 89900000 | 62930000 | 26970000 | 18879000 | 8091000 | 129000000 | 110000000 | 19000000 | 17300000 | 8100000 | 9000000 | 12000000 | 0 | 1 | 0 | Public | India |
| FS0011 | Unqualified | 0.04 | false | Retail | C101 | Horizon Retail Ltd. | 2020 | Q1 | 2020-04-20 | 893210 | 679820 | 213390 | 91000 | 122390 | 1520000 | 920000 | 600000 | 178000 | 36500 | 42000 | 185000 | 0 | 0 | 0 | Private | Canada |
| FS0012 | Unqualified | 0.03 | false | Agriculture | C111 | Urban Roots Agriculture | 2021 | Q3 | 2021-09-28 | 625000 | 476000 | 149000 | 77000 | 72000 | 882000 | 540000 | 342000 | 87000 | 28000 | 32000 | 30000 | 0 | 0 | 0 | Private | United States |
| FS0013 | Qualified | 0.21 | false | Real Estate | C112 | Celestial Real Estate PLC | 2018 | FY | 2019-01-20 | 48900000 | 35400000 | 13500000 | 9685000 | 3815000 | 88000000 | 67900000 | 20100000 | 10000000 | 4200000 | 5900000 | 2100000 | 2 | 1 | 0 | Public | Sweden |
| FS0014 | Not Available | 0.01 | false | Nonprofit | C113 | Pioneer Nonprofit Org | 2022 | Q2 | 2022-07-17 | 0 | 0 | 0 | 22000 | -22000 | 7000 | 2000 | 5000 | 7000 | 0 | 0 | 0 | 0 | 0 | 0 | Private | Norway |
| FS0015 | Unqualified | 0.1 | false | Manufacturing | C114 | Summit Manufacturing LLC | 2021 | Q2 | 2021-07-01 | 2750000 | 1925000 | 825000 | 328500 | 496500 | 3850000 | 1450000 | 2400000 | 385000 | 245000 | 195000 | 185000 | 1 | 0 | 0 | Private | Mexico |
| FS0016 | Unqualified | 0.07 | false | Logistics | C115 | Vertex Logistics Ltd. | 2019 | FY | 2020-02-10 | 13400000 | 10600000 | 2800000 | 1480000 | 1320000 | 18100000 | 10300000 | 7800000 | 1480000 | 710000 | 900000 | 1200000 | 0 | 1 | 0 | Public | Brazil |
| FS0017 | Qualified | 0.2 | false | Energy | C116 | Radiant Energy PLC | 2020 | Q1 | 2020-04-06 | 72000000 | 48960000 | 23040000 | 16380000 | 6660000 | 92700000 | 52800000 | 39900000 | 8340000 | 5300000 | 4800000 | 4700000 | 2 | 1 | 1 | Public | Nigeria |
| FS0018 | Unqualified | 0.04 | false | Hospitality | C117 | Alpine Hospitality Group | 2022 | Q3 | 2022-10-03 | 2400000 | 1548000 | 852000 | 533000 | 319000 | 4450000 | 1810000 | 2640000 | 343000 | 180000 | 166000 | 209000 | 0 | 0 | 0 | Private | Austria |
| FS0019 | Qualified | 0.23 | false | Technology | C118 | Innova Tech Solutions | 2020 | Q2 | 2020-07-18 | 120000000 | 78000000 | 42000000 | 27600000 | 14400000 | 210000000 | 165000000 | 45000000 | 18500000 | 12000000 | 10500000 | 6200000 | 2 | 1 | 1 | Public | Japan |
| FS0020 | Unqualified | 0.14 | false | Food Processing | C119 | Evergreen Foods Ltd. | 2021 | FY | 2022-01-11 | 5200000 | 3432000 | 1768000 | 1090000 | 678000 | 9850000 | 4680000 | 5170000 | 985000 | 610000 | 509000 | 1100000 | 0 | 1 | 0 | Private | Italy |
What the 200 rows show
from the 200-row sampleNot Available (auditor opinion) stands out: mean fraud_
- 2%fraud_
flag = true - 0.12median fraud_
risk_ score - 2company types
- 5fiscal periods
- 48countries
- 3,650,000median total_
revenue
Every row with fraud_
- string 8
- integer 4
- float 13
- date 1
- boolean 1
Columns
27 columns in four groups| column | type | description | example |
|---|---|---|---|
| Text 8 columns | |||
record_id | string | Unique identifier for each financial statement record.unique | FS0001 |
company_id | string | Unique identifier for the company. | C101 |
company_name | string | Legal name of the company. | Horizon Retail Ltd. |
fiscal_period | string | Fiscal period covered (e.g., Q1, Q2, Q3, Q4, FY).Q1 · Q2 · Q3 · Q4 · FY | FY |
auditor_opinion | string | Type of auditor's opinion issued for the statement.5 values · optional | Unqualified |
company_type | string | Type of company: public or private.Public · Private | Private |
industry_sector | string | Industry sector of the company.optional | Retail |
country | string | Country where the company is registered.optional | Canada |
| Numbers 17 columns | |||
fiscal_year | integer | Fiscal year of the financial statement.1,900 to 2,100 | 2019 |
total_revenue | float | Total revenue reported for the period.0 or more | 3845021.73 |
cost_of_goods_sold | float | Cost of goods sold for the period.0 or more | 2667310.72 |
gross_profit | float | Gross profit for the period. | 1177711.01 |
operating_expenses | float | Total operating expenses for the period.0 or more | 436595.17 |
net_income | float | Net income (profit or loss) for the period. | 741115.84 |
total_assets | float | Total assets reported at the end of the period.0 or more | 7689223.54 |
total_liabilities | float | Total liabilities reported at the end of the period.0 or more | 3821151.29 |
total_equity | float | Total shareholders' equity at the end of the period. | 3868072.25 |
cash_and_equivalents | float | Cash and cash equivalents at the end of the period.0 or more | 1252122.65 |
accounts_receivable | float | Accounts receivable at the end of the period.0 or more | 678312.89 |
accounts_payable | float | Accounts payable at the end of the period.0 or more | 597145.22 |
inventory | float | Inventory value at the end of the period.0 or more | 1104109.13 |
suspicious_transactions_count | integer | Number of transactions flagged as suspicious in the period.0 or more · optional | 0 |
unusual_journal_entries_count | integer | Number of unusual journal entries detected in the period.0 or more · optional | 0 |
large_adjustments_count | integer | Number of large, non-routine adjustments made during the period.0 or more · optional | 0 |
fraud_risk_score | float | Calculated risk score (0-1) indicating likelihood of financial statement fraud.0 to 1 · optional | 0.06 |
| Dates and times 1 column | |||
statement_date | date | Date the financial statement was issued. | 2020-03-15 |
| True or false 1 column | |||
fraud_flag | boolean | Indicates if this record is labeled as fraudulent (true) or not (false).optional | false |
15 SQL practice questions for the Financial Statement Fraud Indicators
Written for this data and checked against it: 12 SQL and 3 Power BI exercises from beginner to advanced. Try the first three free; the practice kit has all 15, a starter .sql file and an answer key with every expected result.
High-risk statements list
Return record_id, company_name, fiscal_year and fraud_risk_score for every statement whose fraud_risk_score is greater than 0.7. Order the results by fraud_risk_score from highest to lowest, then by record_id ascending.
Tables: financial_statement_fraud_indicators · your result: 4 columns, 3 rowsDistinct auditor opinions
Return the distinct values of auditor_opinion as a single column named auditor_opinion, sorted alphabetically.
Tables: financial_statement_fraud_indicators · your result: 1 columns, 5 rowsStatements per company type
Return company_type and the number of statements for each type as statement_count. Order the results by company_type.
Tables: financial_statement_fraud_indicators · your result: 2 columns, 2 rows
- 04Average net income by sectorBeginner
- 05Flagged statements by opinionPower BI
- 06Sectors with many flagged statementsIntermediate
- 07Leverage bucketsIntermediate
- 08Sectors riskier than overallIntermediate
- 09Statements per year with a CTEIntermediate
- 10Average risk by countryPower BI
- 11Top risk statement per sectorAdvanced
- 12Revenue spikes vs previous statementAdvanced
- 13Running flagged total by yearAdvanced
- 14Country share of total revenueAdvanced
- 15Top three risk ranksPower BI
Get the practice kit: the full dataset, all 15 exercises, a starter .sql and the answer key. One-time $3.99.
Get the practice kit · $3.99Use it for
A finance dashboard
The fraud_
flag rate, fraud_ risk_ score by auditor_ opinion and a breakdown of industry_ sector. Excel, Power BI or Tableau. Why do the 27 Not Available rows have a mean fraud_
risk_ score of 0.03? A root-cause class exercise
Hand out the rows and one question. The answer is in the data, not in the brief.
- Records200FS00010.06Unqualif…FS00570.92AdverseFS00840.97Disclaim…
A software demo
Believable records with company_
id, company_ name and fiscal_ year to fill a screen in front of a buyer.
blueprint · financial-statement-fraud-indicators
Behind this dataset
Same schema. As many rows as you need.
These 200 rows came out of a blueprint — 27 columns with generation rules behind each one. Open it in Data Factory to retune a column, add your own, wire in foreign keys, and run it at the size you actually need.
- Includes balance sheet, income and cash flow figures
- Flag columns for suspected fraudulent entries
- Incorporates industry benchmarks for realism
- Anomalies follow realistic fraud scenarios
1 credit per row. Preview 20 rows free. Buy rows for the full run.
- Exports
- CSV, JSON, JSONL, Parquet, SQL, Excel, TSV, XML
- Licence
- yours to use, including commercially
- API slug
- financial-statement-fraud-indicators