How to Calculate Inventory Shrinkage and Investigate the Difference

How to Calculate Inventory Shrinkage and Investigate the Difference

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 resultAmount
Recorded on-hand quantity500 units
Initial physical count475 units
Initial discrepancy25 units
Initial discrepancy value$300
Initial inventory-based rate5%

The investigation then finds the following.

FindingEffect
Ten units were missed on an overflow shelfVerified physical quantity increases to 485
Five units were shipped before the cutoff but not recordedCorrected expected quantity decreases to 495
Six units were damaged and disposed of without an entryDocumented loss of 6 units
Four units remain unexplainedUnresolved 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.

ColumnHeadingEntry or formula for row 2
ASKUProduct identifier
BLocationCounted location
CRecorded UnitsQuantity at the cutoff
DVerified Physical UnitsRecounted quantity
EShortage / Overage=C2-D2
FUnit Inventory CostConsistent cost for this example
GVariance Value=E2*F2
HInventory-Based Variance %=IF(C2>0,E2/C2,"Check base")
IFindingEvidence-supported explanation
JAction ReferenceCorrection or adjustment reference
KReview StatusOpen, 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.

FindingPractical response
Items missed in overflow storageAdd overflow locations to the count sheet
Similar variants mixed togetherImprove bin labels and scan variant barcodes
Dispatches posted lateReview the dispatch-to-system update process
Damage removed without recordsIntroduce a documented disposal process
Repeated unexplained shortagesIncrease targeted counts and review stock access
Duplicate app adjustmentsInvestigate 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.

Comments

No comments yet. Why don’t you start the discussion?

Leave a Reply

Your email address will not be published. Required fields are marked *