Your inventory system shows 500 units, but the stock count finds 475. You have a 25-unit discrepancy to investigate.
Some units might be on another shelf. A shipment might have left without its stock movement being recorded. There could also be damaged goods or an unexplained loss.
Learning how to calculate inventory shrinkage and investigate the difference helps you put a value on the gap, check the supporting records, and make a documented adjustment.
What Is Inventory Shrinkage?
Inventory shrinkage describes a shortfall between recorded inventory and actual inventory. NetSuite’s inventory guide calculates it by subtracting actual stock quantity or value from the recorded amount. NetSuite
When you first discover a gap, record it as a count discrepancy under review. Investigation determines how much results from counting or transaction errors and how much represents inventory loss.
Overages also deserve attention. Finding more stock than expected can reveal an unrecorded receipt, an incorrect product code, or another recording problem.
How to Calculate Inventory Shrinkage
1. Calculate the Unit Difference
For one SKU at one location and count cutoff, use this formula.
Unit shortage = Recorded on-hand units − Verified physical units
If the system records 500 units and you count 475, the initial shortage is 25 units.
Compare the same product, variant, location, unit of measure, and point in time. Five cartons cannot be compared directly with five individual items.
2. Calculate the Value Difference
For a simple example with one consistent unit cost, multiply the shortage by that cost.
Shortage value = Unit shortage × Inventory unit cost
At an inventory cost of $12 per unit, the initial difference is 25 × $12 = $300.
Use the cost basis that matches your inventory records. If costs vary by purchase batch or your system uses a valuation method such as weighted average or FIFO, obtain the appropriate value from those records. A selling-price estimate should be labelled separately.
3. Calculate an Inventory-Based Percentage
For the inventory-based rate used in this guide, divide the shortage by the corresponding recorded inventory.
Inventory-based shrinkage rate = Shortage value ÷ Recorded inventory value × 100
NetSuite publishes this book-value-based formula. NetSuite
Using the example, recorded inventory value is 500 × $12 = $6,000.
$300 ÷ $6,000 × 100 = 5%
For this single SKU with a consistent unit cost, the unit-based calculation also gives 25 ÷ 500 × 100 = 5%.
Across different products, calculate values consistently and divide total shortage value by the corresponding recorded inventory value. Averaging individual SKU percentages can distort the result.
Label the Denominator Clearly
Some retail reports express shrinkage relative to sales. Shopify’s inventory-reporting guide provides a sales-based calculation. That measures a different relationship from the inventory-based percentage above. Shopify
Record the formula, valuation basis, scope, and reporting period alongside your rate. Compare results only when those definitions match.
Set Up a Fair Comparison Before Counting
Use a dated inventory snapshot and a clear cutoff time. Pause stock movements in the count area if practical. Otherwise, log receipts, dispatches, returns, and transfers during the count and reconcile them to the same cutoff.
Oracle’s inventory-count documentation explains that movements processed during a count must be accounted for when comparing physical quantities with the inventory snapshot. Inventory Count
Compare On-Hand Stock With the Same Physical Scope
Available-to-sell stock can differ from total on-hand stock.
For example, Shopify defines on-hand inventory as available, committed, and unavailable units at a location. Incoming inventory is tracked separately. Stock reserved for an unfulfilled order may still be physically present. Understanding inventory states
Count reserved and quarantined goods separately so their status remains clear. Record physically present damaged stock separately from missing stock, then assess any required value adjustment.
How to Investigate the Inventory Difference
Step 1. Recount the Affected SKU
Have a second person recount where possible, without showing them the expected quantity first.
Check barcodes, variants, pack sizes, and nearby bins. Look in overflow storage, packing areas, return shelves, and quarantine areas included in the count scope.
Keep the original count and recount results.
Step 2. Review Recent Stock Movements
Start with the last reliable count and trace movements through the cutoff.
Expected closing stock = Opening stock + Recorded inflows − Recorded outflows
Inflows can include receipts, restocked returns, and transfers in. Outflows can include dispatches, supplier returns, transfers out, samples, and disposals.
Use the stock-movement event defined by your system. An order date does not necessarily establish when goods physically left the location.
Step 3. Match Entries to Supporting Evidence
Compare receiving records with supplier delivery notes. Check dispatch quantities against packing records and carrier handovers. For returns, confirm whether the goods arrived and were accepted back into inventory.
Look for duplicate receipts, incorrect quantities, missing transactions, and transfers recorded at only one location.
Step 4. Review Adjustments and Integrations
Inspect manual edits and changes made by connected apps or sales channels.
Shopify’s adjustment history, for example, shows the activity, who or what created it, and its effect on inventory quantities. Viewing inventory adjustment history
A shared login or app error can complicate the record. Document what the evidence establishes before assigning a cause.
Step 5. Classify and Approve the Resolution
Separate findings into counting errors, transaction corrections, documented losses, and unresolved shortages.
Post each correction once, with its supporting reference. Keep an unresolved cause labelled as unresolved and assign someone to follow it up.
An authorized stock adjustment may be necessary before the cause is fully established.
Worked Example of an Inventory Investigation
The following figures are hypothetical. Every unit has an inventory cost of $12.
| Initial count result | Amount |
|---|---|
| Recorded on-hand quantity | 500 units |
| Initial physical count | 475 units |
| Initial discrepancy | 25 units |
| Initial discrepancy value | $300 |
| Initial inventory-based rate | 5% |
The investigation then finds the following.
| Finding | Effect |
|---|---|
| Ten units were missed on an overflow shelf | Verified physical quantity increases to 485 |
| Five units were shipped before the cutoff but not recorded | Corrected expected quantity decreases to 495 |
| Six units were damaged and disposed of without an entry | Documented loss of 6 units |
| Four units remain unexplained | Unresolved shortage of 4 units |
After the recount and shipment correction, the remaining shortage is 495 − 485 = 10 units.
The value is 10 × $12 = $120.
Using corrected recorded inventory before the loss adjustment, the rate is:
$120 ÷ (495 × $12) × 100 = approximately 2.02%
The $120 consists of $72 in documented damage and $48 in unresolved shortage.
Record the five-unit shipment through the appropriate transaction correction. Then record the six-unit disposal and four-unit shortage through the approved process. These entries bring the recorded quantity to 485. Avoid posting another ten-unit reduction afterward.
Track the Review in Excel
Use one row per SKU and location.
| Column | Heading | Entry or formula for row 2 |
|---|---|---|
| A | SKU | Product identifier |
| B | Location | Counted location |
| C | Recorded Units | Quantity at the cutoff |
| D | Verified Physical Units | Recounted quantity |
| E | Shortage / Overage | =C2-D2 |
| F | Unit Inventory Cost | Consistent cost for this example |
| G | Variance Value | =E2*F2 |
| H | Inventory-Based Variance % | =IF(C2>0,E2/C2,"Check base") |
| I | Finding | Evidence-supported explanation |
| J | Action Reference | Correction or adjustment reference |
| K | Review Status | Open, approved, or closed |
Format column H as a percentage. Positive variance means a shortage under this sign convention. Negative variance means an overage.
These formulas assume one consistent cost per SKU. Keep original counts and an adjustment log when updating working figures.
Use the Findings to Improve Stock Control
Match the response to the cause.
| Finding | Practical response |
|---|---|
| Items missed in overflow storage | Add overflow locations to the count sheet |
| Similar variants mixed together | Improve bin labels and scan variant barcodes |
| Dispatches posted late | Review the dispatch-to-system update process |
| Damage removed without records | Introduce a documented disposal process |
| Repeated unexplained shortages | Increase targeted counts and review stock access |
| Duplicate app adjustments | Investigate synchronization and transaction handling |
Do not offset unrelated shortages and overages before investigating them. They may represent separate errors or losses.
For period reporting, also review losses already recorded between stocktakes. A new count discrepancy alone does not capture every loss during the period.
Frequently Asked Questions
1. Does inventory shrinkage always mean theft?
No. Counting mistakes, transaction errors, damage, supplier discrepancies, and other causes can contribute. Investigate the evidence before concluding what happened.
2. What if the physical count is higher than the system quantity?
Record an overage and investigate receipts, returns, transfers, SKU selection, and duplicate dispatch entries. Under the formula above, the variance will be negative.
3. Should I use cost or selling price?
For this inventory-value reconciliation, use the valuation basis consistent with your records. Keep any retail-value estimate separately labelled so the two measures remain clear.
4. What is an acceptable inventory shrinkage percentage?
There is no single threshold that fits every business. Compare consistently defined results over time and consider product value, handling conditions, and the cause.
A repeated discrepancy can need attention even when its percentage is small.
5. When should I adjust the inventory records?
After verifying the count, reconciling timing differences, and obtaining the required approval. Document the adjustment and keep any unresolved investigation open.
Coordinate financial entries with the person responsible for your accounts.
Conclusion
Calculate the initial gap, then test it against a recount and the stock-movement records. That process helps distinguish misplaced goods and missing entries from documented or unexplained losses.
Keep the original evidence, post each approved correction once, and use recurring findings to improve the process that created the difference.


