Free tool · How do I calculate my shrinkage rate?

Shrinkage rate calculator

Shrinkage is stock your records say you have but your count can't find: theft, damage, admin errors and short deliveries. Enter the stock value your records show and the value you counted, both at cost, for the same location and date.

The formula

  • Shrinkage = recorded stock value − counted stock value
  • Shrinkage % of stock = shrinkage ÷ recorded stock value × 100
  • Shrinkage % of sales = shrinkage ÷ sales for the period × 100

What your system or spreadsheet says you hold.

What you found when you counted.

Only needed for shrinkage as a % of sales.

Shrinkage
1,500
As % of recorded stock
3%
As % of sales
—

Add sales to see this.

Example: your records show 50,000 of stock at cost and the count finds 48,500. Shrinkage is 1,500, which is 3% of recorded stock. If sales for the period were 120,000, it is 1.25% of sales. Always say which base you used.

Link straight to a result, for example https://www.ceazr.com/tools/shrinkage-calculator?recorded=50000&counted=48500&sales=0

Questions people also ask

Should I measure shrinkage against stock or sales?
Either, as long as you are consistent. Against stock tells you how much of what you hold goes missing; against sales lets you compare periods with different trading. The same loss gives two very different percentages, so always say which one you mean.
What if the counted value is higher than recorded?
Then the result is negative: you have more than your records say. That usually means receipts, returns or transfers weren't recorded. It is still a problem worth tracing.
Do I use cost or selling price?
Use cost for both values. Mixing cost and selling price makes the figure meaningless.

Ceazr tracks these numbers for every product at every location. Try it free for 14 days.

Get a quote