At closing time, a supermarket’s inventory system shows 40 bottles of cooking oil. A supervisor counts 35. Five bottles appear to be missing. How much stock has the store actually lost?
A second check turns up two bottles on a promotional display near the checkout. A neighbouring branch confirms it received another two that afternoon, but the transfer has yet to appear in the sending store’s records. Of the five bottles the supervisor set out to find, only one remains unaccounted for.
Inventory shrinkage is the shortfall between the stock a retailer should have and what it can physically account for after checking its records. The first count tells the team where to investigate. The financial loss depends on what that investigation finds.
How to calculate inventory shrinkage
Start with one SKU, one location, and one point in time. Compare the physical count with the quantity the system expected at the time of the count. If staff counted the shelf at 6 p.m. but downloaded the inventory balance at 8 p.m., sales in those two hours can create a discrepancy even when every bottle is accounted for.
Two calculations are useful at store level:
Inventory shortfall in units = Expected stock after reconciliation − Verified physical stock
Inventory shrinkage at cost = Unaccounted-for units × Cost per unit
Here is how the supermarket would reconcile the cooking oil example. Assume each bottle costs the retailer USD 4.
| What the supervisor checks | Result | Gap still to investigate |
|---|---|---|
| Compare the initial count with the system | 40 bottles recorded; 35 counted | 5 bottles |
| Check the promotional display | 2 more bottles found; physical count rises to 37 | 3 bottles |
| Verify the outgoing transfer | The receiving branch confirms 2 bottles; corrected expected stock falls to 38 | 1 bottle |
| Reconcile the final count | 38 expected; 37 physically accounted for | 1 bottle, worth USD 4 at cost |
Booking the original five bottles as a loss would have put shrinkage at USD 20. The checks reduce that figure to USD 4 and uncover a separate issue worth fixing: stock can leave the store before its transfer is recorded. The remaining shortfall can be recorded under the retailer’s inventory adjustment policy even if its cause is still unknown.
What does a 1.5% shrinkage rate actually mean?
A shrinkage percentage needs a denominator. For an internal report, a retailer might express the cost of missing inventory as a percentage of cost of goods sold (COGS). Another report might express shrinkage relative to sales. The same loss can produce two different percentages.
Consider a retailer with USD 2 million in annual net sales, USD 1 million in COGS, and USD 15,000 of confirmed inventory shrinkage valued at cost.
| Reporting method | Calculation | Result |
|---|---|---|
| Shrinkage at cost as a percentage of COGS | USD 15,000 ÷ USD 1,000,000 × 100 | 1.50% |
| The same shrinkage at cost as a percentage of net sales | USD 15,000 ÷ USD 2,000,000 × 100 | 0.75% |
The store has lost the same USD 15,000 in both rows. If one branch reports 1.50% and another reports 0.75%, check how each calculated its figure before concluding that one has better stock controls. Also check whether missing goods were valued at purchase cost or retail price. Matching the denominator alone does not make two reports comparable.
For context, the U.S. National Retail Federation’s 2023 survey reported an average shrink rate of 1.6% of sales for fiscal year 2022. That historical U.S. figure uses a sales basis. A retailer in Indonesia or Singapore tracking losses at cost against COGS will get a more useful operating benchmark by comparing similar stores under the same reporting method. NRF
Where should a store look when stock is missing?
The fastest starting point is usually the item’s last recorded movement. If a discrepancy appears immediately after a delivery, check receiving. If it appears after a promotion ends, check the secondary display and the stock removed from it. The timing gives the team a narrower question than “Where did the inventory go?”
| What the team observes | What to check first | What the finding could explain |
|---|---|---|
| The shelf is short, but the store balance looks reasonable | Backroom, checkout displays, promotional stands, and adjacent shelf positions | Stock is still in the store but was left out of the first count. |
| One branch is short and another has extra units of the same SKU | Transfer reference, dispatch quantity, receiving confirmation, and posting times | A transfer was recorded at only one end. |
| The discrepancy starts on delivery day | Purchase order, delivery note, actual quantity received, and units per carton | The system recorded the quantity ordered rather than the quantity delivered, or someone entered cartons as individual units. |
| Fresh or damaged goods are missing from sellable stock | Waste records, damage reports, and the time goods were removed | Staff may have discarded goods before recording the write-off. If the loss was already recorded, avoid counting it twice. |
| The same SKU repeatedly comes up short after recounts | Movement history, transaction exceptions, and who handled the stock between checks | A recurring process error or potential loss needs a targeted investigation. |
A misplaced item can create two problems at once. The customer sees an empty shelf, and the person counting that shelf sees missing inventory. Finding the item resolves the count discrepancy. Moving it back to the correct selling location resolves the availability problem.
Why shrinkage can make sell-through look better than it is
A store starts the week with 100 bottles and records 60 sales. There are no deliveries, returns, or transfers. The expected closing balance is 40, but staff find only 35. If the manager subtracts the physical closing count from opening stock, it looks as though 65 bottles sold. The till records only 60.
Sell-through is 60%. The five-bottle gap belongs in the stock investigation. Treating all 65 bottles as sales would overstate demand and conceal the discrepancy. It could also encourage the buyer to replenish a product on the assumption that customers purchased more of it than they actually did. For the calculation when a store receives additional stock during the period, see how to calculate sell-through rate in retail.
This distinction matters for inventory planning at Digitalplace.ai. If a store repeatedly reports fewer units than expected, the planner needs to know whether customers bought those units, another branch received them, or the stock is still missing. Each explanation leads to a different next order.
How to reduce shrinkage across multiple stores
Start with one recurring pattern. Suppose three minimarkets report missing cartons after inter-store transfers. Asking every branch to count every SKU more often adds work, but it may leave the transfer problem untouched. Instead, select the affected SKU and match each dispatch to a receipt at the destination. Record who confirms the quantity and when both branches update their balances. At the next count, check whether the same discrepancy returns.
Then prioritise by value and frequency. A single missing high-value item may justify immediate investigation. A low-cost item that comes up short every week may reveal a process problem affecting an entire category. A useful monthly review shows the value of confirmed losses, the value of discrepancies still under investigation, and the SKUs or locations where the same issue has returned. That gives the operations team a clearer assignment than a single company-wide shrinkage percentage.
For retailers using inventory optimization from Digitalplace.ai, corrected store balances also improve the inputs available for replenishment planning. If two cartons were transferred, the destination branch should account for them. If the cartons remain in the backroom, staff can move them to the shelf. If the loss is confirmed, the planner can revise the available quantity and decide whether a replacement order is needed.
A good first exercise is to choose one SKU that showed a shortage in each of the last two counts. Reconstruct its receipts, sales, transfers, and write-offs up to the count time. Then record three figures: how many units appeared to be missing, how many the team accounted for, and what the remaining shortfall cost. Those figures tell the store manager both how much was lost and where to look next time.





