Inventory shrinkage — the loss of stock between recorded book balances and physical counts — costs retailers and distributors billions annually. Causes include theft, damage, administrative errors, and vendor fraud. Measuring shrinkage rate after each physical inventory count is essential for loss prevention, financial statement accuracy, and insurance claims.
How to use this calculator
- Enter the perpetual inventory balance from your system (recorded inventory).
- Enter the result of your physical count or cycle count.
- Review shrinkage in units and as a percentage of recorded inventory.
- If shrinkage exceeds your industry benchmark, investigate root causes and tighten controls.
- Multiply shrinkage units by unit cost for dollar impact on your P&L.
Formula
Shrinkage (units) = Recorded inventory − Physical count. Shrinkage rate (%) = (Shrinkage ÷ Recorded inventory) × 100. Positive shrinkage means you have less inventory than records show. Negative shrinkage (overage) means physical count exceeds records.
Example
Recorded inventory of 5,000 units with a physical count of 4,850 yields 150 units of shrinkage — a 3.0% shrinkage rate. At $25 unit cost, that is $3,750 in lost inventory value.
Frequently asked questions
What is an acceptable shrinkage rate?
Retail industry averages range 1–2% of sales (not inventory). For inventory-based shrinkage, under 1% is strong; 2–3% signals a problem; above 3% requires immediate investigation.
What causes inventory shrinkage?
Employee theft, shoplifting, vendor fraud, receiving errors, damage/spoilage, and point-of-sale mistakes. Root cause analysis by SKU category helps target prevention efforts.
How do I record shrinkage in accounting?
Debit Cost of Goods Sold (or Shrinkage Expense), Credit Inventory for the dollar value of missing units. Adjust perpetual records to match the physical count.
What if physical count exceeds recorded inventory?
Negative shrinkage (overage) may indicate receiving errors, unrecorded returns, or count mistakes. Investigate before adjusting records upward.