Quick Answer
An inventory variance above 5% is a significant control red flag indicating systemic issues such as weak stock controls, theft, procurement and receiving errors, sales leakage, or ERP reconciliation failures, and it requires immediate internal audit investigation.
Key Takeaways
- A variance above 5% signals systemic control weaknesses rather than simple counting errors, especially in retail, manufacturing and distribution.
- Common causes include weak stock recording, unrecorded movements, theft, data entry errors, and poor sales-to-stock synchronization.
- Inventory fraud involves falsified movement records, unrecorded sales, collusion between warehouse and procurement staff, and manipulated period-end adjustments.
- Procurement and receiving errors, such as undocumented goods receipts and unreconciled purchase orders, are major contributors to variance.
- Real-time ERP-to-physical-stock reconciliation, segregation of duties, and standardized counting procedures reduce variance and financial leakage.
Frequently Asked Questions
What does an inventory variance over 5% mean?
It typically indicates systemic issues rather than simple counting errors, pointing to weaknesses in stock tracking, procurement recording, or warehouse management. Repeated variance patterns should be treated as a structural control failure.
What are common causes of stock discrepancies in Kenya?
Weak stock recording procedures, unrecorded stock movements, theft or pilferage, data entry errors, and poor synchronization between sales and stock systems are among the most common causes.
How can inventory fraud occur?
Through falsified stock movement records, unrecorded sales of physical inventory, collusion between warehouse and procurement staff, and manipulated stock adjustments at period end. Strong segregation of duties is essential to reduce this risk.
How do procurement and receiving errors cause variance?
Goods received without proper documentation, supplier delivery mismatches, unrecorded partial deliveries, and lack of reconciliation between purchase orders and receipts all create gaps that lead to persistent stock discrepancies.
What should businesses do when variance exceeds 5%?
Trigger an immediate internal audit review, including a full stock reconciliation, investigation of high-value items, a system audit of inventory controls, and a segregation of duties assessment to identify root causes and prevent financial leakage.