Forensic Audit Case Study on Inventory Manipulation

A detailed forensic audit case study explaining inventory manipulation, misappropriation, and valuation fraud in an Indian listed company. Learn how forensic auditors detect red flags, use data analytics, verify stock, quantify losses, and strengthen internal controls to prevent inventory fraud.

19 December, 2025

1. BACKGROUND OF THE COMPANY

Astra Mobility Components Ltd. is a listed Indian auto-ancillary company manufacturing EV components and spare parts.

  • Annual Revenue: ₹2,400 crore
  • Inventory Value: ₹680 crore
  • Inventory Types:
    • Raw materials
    • Work-in-progress (WIP)
    • Finished goods
  • Warehouses: 6 (3 company-owned, 3 third-party)
Inventory valuation is done at lower of cost or NRV, with perpetual records maintained in ERP.

2. TRIGGER FOR FORENSIC INVESTIGATION 

The Audit Committee observed the following red flags:

  1. Inventory increased by 28%, while sales grew only 9%
  2. Inventory days rose from 64 days to 102 days
  3. High volume of manual inventory adjustments
  4. Repeated delays in physical stock verification
  5. Gross margins fluctuated without clear explanation
A forensic investigation was initiated to examine inventory existence, valuation and movement.

3. SCOPE OF ENGAGEMENT (FAIS 110, 130) 

The engagement scope included:

  • Verification of inventory existence
  • Review of inventory valuation and adjustments
  • Examination of inventory movement & write-offs
  • Identification of misappropriation or manipulation
  • Quantification of financial impact

4. PLANNING & RISK ASSESSMENT (FAIS 210–240) 

CONTROL WEAKNESSES IDENTIFIED Inventory Controls

  • Manual overrides without approvals
  • No cycle counting mechanism
System Controls
  • ERP allowed negative stock and back-dated entries
Governance
  • No independent inventory audit
  • Over-reliance on warehouse staff
Preliminary Analytical
  • Incentives linked to gross margin and inventory levels
Fraud Risk Indicators
  • Manual override rights in ERP
  • Lack of real-time integration between stores and finance
  • Third-party warehouses with weak oversight
  • Incentives linked to gross margin and inventory levels

5. HYPOTHESIS DEVELOPMENT (FAIS 210, 220)

Based on 4 above, the forensic team formulated the following hypotheses:

H1: Certain inventory recorded in books does not physically exist.
H2: Inventory quantities are being inflated through manual adjustments.
H3: Obsolete or slow-moving inventory is deliberately over-valued.
H4: Inventory is being siphoned off with falsified issue records.
H5: There is collusion between warehouse staff and inventory accounting personnel.

For readers who want to understand such investigations more deeply, concepts like hypothesis building, data analytics, ERP log analysis, and evidence evaluation are explained practically in my Master Blaster of Forensic Accounting and Investigation, which mirrors real-life cases like this one.

6. EXECUTION / FIELDWORK (FAIS 310–350)

6.1 Physical Verification & Surprise Checks (FAIS 310)
  • Surprise physical verification at all 6 warehouses
  • Independent counting of high-value SKUs
  • Reconciliation of physical stock with ERP records
Observation:
  • Significant shortages in 14 high-value items
  • Excess quantities recorded only in ERP
6.2 Data Analytics (FAIS 340)
 Performed the following tests:
  1. Inventory Aging Analysis
    • ₹118 crore inventory lying >18 months without movement.
  2. Manual Adjustment Analysis
    • 62% of upward adjustments approved by one warehouse manager.
  3. Cut-off Testing
    • Goods issues recorded without dispatch documents.
  4. Shrinkage Pattern Analysis
    • Losses consistently booked just before audits.
6.3 Document Review (FAIS 310)
 Reviewed:
  • Goods receipt notes (GRNs)
  • Stock transfer notes
  • Inventory adjustment memos
  • Obsolescence write-off approvals
Findings:
  • Back-dated GRNs
  • Same handwriting on multiple issue slips
  • Missing transporter challans
6.4 Digital Forensics (FAIS 320)
  • Reviewed ERP logs for inventory edits
  • Identified bulk quantity increases late at night
  • Detected override of negative stock controls
6.5 Interviews (FAIS 330) Warehouse Staff:
  • Claimed adjustments were “management instructed.”
Finance Team:
  • Relied on store records without independent verification.
Third-Party Warehouse:
  • Confirmed discrepancies between physical stock and system data.

7. FINDINGS (FAIS 410)
Finding 1: Inventory Non-Existence Confirmed Physical verification confirmed shortages of inventory valued at ₹42 crore. ✔Hypothesis H1 — Accepted
Finding 2: Artificial Inflation Through Adjustments Inventory quantities were increased through unauthorized manual entries.
✔Hypothesis H2 — Accepted
Finding 3: Obsolete Inventory Over-Valued NRV not assessed for slow-moving items, overstating inventory by ₹27 crore.
 ✔ Hypothesis H3 — Accepted

Finding 4: Misappropriation of Inventory Issue records were falsified to cover physical theft.
 ✔ Hypothesis H4 — Accepted
Finding 5: Collusion Established Evidence showed coordination between warehouse manager and inventory accountant.
 ✔ Hypothesis H5 — Accepted

8. QUANTIFICATION OF LOSS (FAIS 420)

Particulars Amount
Inventory shortages ₹42 crore
Overvaluation of obsolete stock ₹27 crore
Artificial quantity inflation ₹19 crore
Total impact ₹88 crore

9. RECOMMENDATIONS (FAIS-ALIGNED) Immediate

  1. Suspend implicated warehouse and inventory staff
  2. Lock manual override access
  3. Write-down obsolete inventory
Long-Term
  1. Implement RFID/barcode-based tracking
  2. Quarterly cycle counts
  3. ERP alerts for abnormal adjustments
  4. Independent inventory verification by Internal Audit

10. LIMITATIONS (FAIS 430)

  • Certain third-party warehouse records were incomplete
  • Historical data gaps due to ERP migration
  • Understanding cases like this requires not just audit knowledge but a structured forensic mindset, which is exactly what practical learning in programs like Master Blaster of Forensic Accounting and Investigation helps develop over time.

11. CONCLUSION (FAIS-COMPLIANT)

The forensic investigation, conducted in accordance with ICAI FAIS standards, confirms deliberate manipulation of inventory records through inflated quantities, over-valuation, and misappropriation. These actions resulted in a material overstatement of inventory and profits amounting to ₹88 crore, necessitating immediate corrective, disciplinary, and governance actions.

Frequently Asked Questions (FAQs) 

1. Why is inventory manipulation difficult to detect during regular audits? 
Inventory manipulation often involves manual overrides, back-dated entries, and collusion between departments. Regular audits rely heavily on controls and samples, whereas forensic audits dig deeper using data analytics, surprise checks, and transaction pattern analysis. 

2. What are the biggest red flags of inventory fraud in companies?
Common red flags include inventory growing faster than sales, rising inventory days, frequent manual adjustments, delays in physical stock verification, unexplained margin fluctuations, and weak controls over third-party warehouses. 

3. How does a forensic audit differ from a statutory or internal audit in such cases?
A forensic audit starts with suspicion and focuses on proving or disproving fraud through evidence, documentation, data analytics, and interviews. Unlike statutory audits, it aims to identify manipulation, quantify losses, and establish responsibility.

CA Tushar Makkar

Author - Auditing in real life | Consulting in India, US, Europe and Middle East | Content creator | Ex-PwC | CA AIR 47 Nov' 17 | YouTuber 40k+ | Expertise in manage accounts and Audit