Inventory Shrinkage: Reconcile Book Stock With What You Can Count

Shopify says 84 units are available. Your 3PL can find 79. That five-unit gap can turn into oversold orders, a margin adjustment, or an argument about who owns the loss. None of those outcomes improve until you establish which number is wrong and why.

Inventory shrinkage measures the shortfall between recorded stock and physically verified stock. The calculation takes one line. The hard part is controlling the count so receipts, shipments, returns, and transfers do not create a false difference.

Book inventory is the quantity your inventory system says you own at a defined location and time. Physical inventory is the quantity a person can count under the same boundary. When book inventory exceeds physical inventory after you account for documented movements, the remaining shortfall is shrinkage.

Shopify describes shrinkage as inventory that disappears for reasons other than sales. Its examples include damage, administrative errors, theft, and units lost in transit or inside a warehouse. The operational lesson is broader: your team needs evidence for each inventory movement, not a single adjustment called warehouse variance.

Keep discrepancies separate from confirmed loss during the investigation. A transfer may have shipped from one location without posting at the other. A return may sit in quarantine. A case pack may have been entered as individual units. Those records create a difference, but correcting them does not mean inventory vanished.

Pick one location and one cutoff time. Export book quantity at that cutoff. Decide whether the count includes sellable shelves, damaged stock, return quarantine, open receiving, and staged outbound orders. Write those rules on the count sheet so the warehouse and finance team use the same definition.

Pause movements in the area while the count runs when you can. If operations must continue, record every receipt, pick, transfer, and adjustment after the cutoff so you can roll the physical count back to the same moment as the book quantity.

Use a blind count. Give the counter the SKU and location without showing the expected quantity. A visible book number invites the counter to stop when the shelf appears close enough. Recount a material difference with another person before changing the system.

Cycle counting lets you apply this process to selected products throughout the year instead of closing the whole operation for one annual count. Shopify's cycle counting guide recommends scheduled counts of smaller product groups to verify stock and find discrepancies with less disruption.

Start with the unit variance: book units minus physical units. Divide the missing units by book units and multiply by 100 to calculate the shrinkage rate. If the system records 1,000 units and the count finds 960, the shortage is 40 units and the shrinkage rate is 4%.

Units help an operator investigate a SKU and location. Cost value shows the financial effect. Multiply the missing quantity by the inventory cost basis used in your reporting. At a $12 unit cost, 40 missing units represent $480 of inventory value.

Do not value shrinkage at retail price. The missing unit never generated that sale, and the selling price includes gross margin that the business did not earn. Use cost for the inventory adjustment, then track lost sales or customer impact separately if the shortage caused an oversell.

Consider a hypothetical homeware brand that sells a ceramic mug through Shopify. At Monday's 8:00 a.m. cutoff, the brand's inventory ledger shows 1,000 sellable units at its 3PL. The team freezes movements in the mug's two pick locations and asks the warehouse to count without seeing the book quantity.

The first count finds 960 sellable units. A second counter confirms the total. The operator then checks open movements around the cutoff. Twenty units sit in a documented damage location, but the inventory feed still labels them sellable. Twelve units were short on a recent inbound receipt. Six orders show the mug picked even though another SKU shipped. Two units remain unexplained.

The full 40-unit sellable shortage still matters because customers cannot buy those units. The reasons lead to different work. The team moves the 20 damaged units out of available inventory, opens a supplier or 3PL claim for the receipt shortage, reviews the six fulfillment errors, and assigns the two unknown units for follow-up.

That breakdown is more useful than posting a $480 adjustment called shrinkage. It corrects availability today and shows which process needs repair before the next count.

Use a short reason-code list that matches the records your team can produce. Receiving shortage, unrecorded damage, return not restocked, wrong-SKU pick, transfer timing, unit-of-measure error, misplaced stock, and unknown cover many ecommerce cases. Add a note or source record rather than expanding the list for every incident.

Reason codes turn repeated variance into process work. Receiving shortages point to purchase-order and dock checks. Unrecorded damage points to warehouse handling and disposal logs. Return gaps point to the handoff between the returns system and available inventory. Unknown loss deserves attention, but it should not swallow every variance the team did not investigate.

Shopify's guide to inventory discrepancies advises teams to isolate the product and location, inspect for damage or misplaced stock, and use regular cycle counts to find problems earlier. That sequence protects the evidence you need to fix the cause.

ShopDucky can bring inventory records, receiving events, fulfillment activity, returns, and warehouse adjustments into one exception review. An AI employee can prepare the variance packet and flag missing evidence while your operations or finance owner approves the inventory change. See the store operations workflow or the Reporting OS.