Why does the stock on your shelves never match the number in your system? Theft, damage, and counting errors quietly remove value from every store. The Inventory Shrinkage Calculator compares your recorded book value with a physical count and shows the dollar loss.
It also shows the loss as a share of inventory and of sales. Retailers, warehouse managers, and small shop owners can use it after any stock count.
Table of Contents
- What the Calculator Does
- How to Use It, Step by Step
- The Shrinkage Formulas
- Worked Example
- How to Read the Results
- Where Shrinkage Comes From
- Limitations and Assumptions
- FAQs About the Inventory Shrinkage Calculator
What the Calculator Does
The tool updates as you type. It needs three dollar amounts and gives five results.
- Total Inventory Shrinkage Unaccounted Loss: book value minus counted value. If the count is higher, the card reads Inventory Overage (Count Above Book).
- Inventory Shrinkage Rate: the loss as a percent of book inventory.
- Shrinkage % of Total Revenue: the loss as a percent of sales.
- Physical Verified Stock Value: the counted value you entered, shown back to you.
- Monthly Average (Gap / 12): the dollar gap divided by 12.
- Copy Shrinkage Report and Reset buttons.
How to Use It, Step by Step
- Enter your system value in Recorded Book Inventory Value ($).
- Enter the value from your latest count in Physical Count Inventory Value ($).
- Enter sales for the same stretch of time in Total Retail Sales / Revenue ($). Use 0 if you do not know them.
- Read the loss and the two percentages.
- Press Copy Shrinkage Report to copy the inputs and results. Press Reset to restore the sample figures.
Value both inventory figures the same way. Mixing cost value with retail value will distort the loss.
The Shrinkage Formulas
The math is simple subtraction and division. The tool uses the size of the gap, so a count above book shows as an overage.
Book Value-Counted Value=Shrinkage Loss
- Shrinkage loss = book value - counted value. A negative gap is shown as an overage of the same size.
- Shrinkage rate = loss ÷ book value × 100. It shows "N/A (no book value)" if book value is 0.
- Share of revenue = loss ÷ sales × 100. It shows "N/A (no sales entered)" if sales are 0.
- Monthly average = loss ÷ 12.
Worked Example
Hannah manages a home goods store. Her system lists $212,400 of stock. The year-end count finds $205,500. Sales for the year were $1,150,000.
| Result | Calculation | Output |
|---|
| Shrinkage Loss | $212,400 - $205,500 | $6,900.00 Loss |
| Shrinkage Rate | $6,900 ÷ $212,400 × 100 | 3.25% of Inventory |
| Share of Revenue | $6,900 ÷ $1,150,000 × 100 | 0.60% of Revenue |
| Verified Stock Value | Counted value | $205,500.00 |
| Monthly Average (Gap / 12) | $6,900 ÷ 12 | $575.00 / Mo |
Hannah lost about $575 of stock value each month. That is money she paid for goods she can no longer sell.
How to Read the Results
The loss amount is the cost of stock you cannot account for. It is a gap between records and reality, not a confirmed cause.
The inventory rate shows how big the gap is compared with what you hold. The revenue share shows how much of your sales it eats up. A small revenue share can still hide a large loss in a thin margin business.
The monthly average spreads the gap over 12 months. It only makes sense when your two inventory values span a full year. Divide by the real number of months yourself if your count covered a shorter period.
Where Shrinkage Comes From
Shrinkage usually comes from four places: theft by customers, theft by staff, supplier shortages, and paperwork errors. Damage and spoilage also count when nobody writes them off. Better receiving checks and regular cycle counts catch many of these early.
Once you know the dollar loss, see what it does to your margins with the gross profit calculator. The inventory turnover calculator shows how fast stock moves, and slow stock often shrinks more.
To price in the loss, try the markup calculator. The inventory value calculator helps you total stock before a count. For wider planning, see the finance and business calculator hub.
Limitations and Assumptions
- The tool compares two dollar totals. It cannot tell you why stock went missing.
- If your count is higher than your records, the card shows an Overage with an amber note. Check for unrecorded receipts or counting errors.
- All three fields are required and cannot be negative. A blank or negative entry shows a message and the results show "--".
- The monthly figure always divides by 12, even if your count covered a shorter period.
- The tool does not check that your sales cover the same period as the inventory gap.
FAQs About the Inventory Shrinkage Calculator
What is inventory shrinkage?
Shrinkage is stock that disappears between purchase and sale without being recorded. Common causes are theft, damage, and data entry mistakes.
How do I calculate the shrinkage rate?
Subtract your counted value from your book value. Divide that loss by the book value, then multiply by 100. The tool does this for you.
What is a normal shrinkage rate?
It varies by industry and store type. Compare your own rate across several counts rather than against one outside number.
Why does my result say Overage instead of Loss?
Your counted value is higher than your book value. The tool shows that gap as an overage, and a $0.00 Loss means the two values match.
Should I use cost value or retail value?
Either works if you use the same basis for both inventory fields. Cost value is common because it shows what you actually paid.
How often should I count inventory?
Many businesses count once a year and spot check busy items more often. Frequent small counts find problems sooner.
This calculator gives planning estimates only and is not financial advice. Reviewed for general accuracy by Prof. Dr. Khalil Mudassar, PhD.