Inventory Shrinkage Calculator

The calculation itself

Shrinkage is the gap between recorded and actual stock: (recorded value − counted value) ÷ recorded value × 100. It is normally expressed as a percentage of sales or of recorded inventory, and the two conventions give different numbers, so it is worth stating which.

The causes divide into theft, administrative error, damage, and supplier shortfall. Most businesses assume the first and most measurements find the second.

Running the numbers

Records show 198 units on hand; a physical count finds 174. That is 24 units, 12.1% of recorded stock, or $432 at $18 cost.

Against annual COGS of $37,868, that is 1.1% of throughput, which sits around the middle of typical retail shrinkage.

Now the diagnosis. If 10 of those units trace to a receiving error on one delivery, 6 to damage recorded but never adjusted, 5 to a picking error on a bulk order, and 3 are genuinely unexplained, then only $54 of the $432 is a loss prevention problem and the rest is process.

What gets missed

Shrinkage measured only at an annual count tells you a number and nothing about its cause. Twelve months of accumulated variance cannot be traced, which is why the finding is so often attributed to theft by default.

Negative shrinkage, finding more stock than recorded; is equally informative and usually ignored. It means receipts are being missed or sales are being recorded that did not happen, and it points at the same process failures from the other direction.

What to do next

Cycle count so that variances are found within weeks rather than months. A discrepancy found close to the event can be traced to a specific delivery or order; the same discrepancy found at year end cannot.

Then categorise every variance by cause. The distribution of causes is what tells you where to act, and it almost always points at receiving and picking rather than at loss.

What good shrinkage looks like

Retail industry surveys put average shrinkage around 1.4% to 1.6% of sales, with grocery and apparel higher and hard goods lower. Pure ecommerce operations without a public-facing shop typically run lower still: 0.5% to 1%: because the largest single retail cause, shop theft, is absent.

The composition differs too. In a warehouse operation, administrative and process error usually exceeds theft, and the largest single line is normally receiving: goods signed for that never arrived, or arrived short and were never claimed.

That last item is worth checking specifically, because it is recoverable. A supplier shortfall found within the claim window is a credit; the same shortfall found at the annual count is shrinkage. The difference between those two outcomes is entirely a matter of how quickly deliveries are checked, which makes goods-in the highest-return place to spend effort in most inventory operations.

One control worth having regardless of size: a rule that no delivery is signed as complete until it has been counted. Signing for a pallet on the driver's word is the single most common way a supplier shortfall becomes your shrinkage.

Where counting on the spot is impractical, signing as unchecked and counting within the claim window achieves the same protection, provided the claim window is actually known and tracked rather than assumed.