About the Retail Shrinkage Calculator
This retail shrinkage calculator measures how much inventory disappeared between what your records say you should have and what the physical count found. Enter book inventory, the physical count and sales for the same period, and it returns shrink in dollars, shrink as a percentage of sales (the standard industry measure) and as a percentage of book inventory.
Store managers, loss-prevention teams and small retailers use the shrink rate to spot problems with theft, vendor fraud, receiving errors, damage and administrative mistakes. Entering your cost complement converts retail-value shrink into the actual cost lost, and your net profit margin shows how many additional sales it takes to earn that money back — usually a sobering number.
Enter book and physical inventory on the same valuation basis (both at retail or both at cost) and use sales for the period since the last physical count. A book figure lower than the physical count produces negative shrink, which usually signals a recording error rather than a gain.
With the default inputs, the shrink rate (% of sales) is 1.59%. Change any value above to recalculate instantly.
How to use the retail shrinkage calculator
- 1Take book inventory from your perpetual records or retail inventory method.
- 2Enter the physical count value on the same basis (retail or cost).
- 3Enter net sales for the period since the last count.
- 4Add your cost complement and net profit margin.
- 5Read the shrink rate and the sales needed to recover the loss.
Formula and method
Shrink is the difference between the inventory your records say you should have (book) and what a physical count finds. Retailers usually express it as a percentage of net sales for the same period, which is how industry surveys such as the National Retail Federation’s report it; shrink as a percentage of inventory is shown for reference.
If inventory is valued at retail, multiplying shrink by the cost complement (cost ÷ retail) gives the actual cost lost. Dividing that cost by your net profit margin estimates the extra sales you would need to generate the same profit — the true business cost of shrink.
- Book
- Expected inventory from records
- Physical
- Inventory found in the count
- cost%
- Cost complement: cost value ÷ retail value
- net margin
- Net profit ÷ sales
Worked examples
Store with $6,500 of missing inventory
$250,000 book − $243,500 counted = $6,500 of shrink at retail, which is 1.59% of $410,000 sales. At a 60% cost complement the loss is $3,900 at cost, and with a 5% net margin it takes $78,000 of sales to earn that back.
Large store with a 1.2% shrink rate
A $30,000 gap on $2.5 million of sales is a 1.2% shrink rate. The $16,500 cost loss requires $550,000 of extra sales at a 3% net margin.
Small boutique with tight controls
Only $800 is missing, about 0.57% of sales. At cost that is $400, which an 8% margin recovers with $5,000 of sales.
Frequently asked questions
How do you calculate shrinkage in retail?+
Subtract the physical inventory count from the book inventory for the same date, then divide by net sales for the period and multiply by 100 to get the shrink rate as a percentage of sales.
What is a normal retail shrink rate?+
The National Retail Federation’s National Retail Security Surveys put average shrink at about 1.4% to 1.6% of sales for fiscal years 2019 through 2022, but rates vary widely by category, location and loss-prevention effort, so your own trend is the better benchmark.
What causes inventory shrinkage?+
The main causes are external theft (shoplifting and organized retail crime), employee theft, administrative and pricing errors, vendor fraud or short shipments, and damaged or spoiled goods.
Should shrink be measured at cost or retail?+
Either works if book and physical inventory use the same basis. Retailers using the retail inventory method measure at retail; converting to cost shows the true financial loss.
Why calculate the sales needed to recover shrink?+
Because lost merchandise comes straight out of profit. With thin net margins, replacing a small loss can require many times its value in new sales, which helps justify loss-prevention spending.