How to Investigate and Resolve Stock Discrepancies
Knowing how to investigate stock discrepancies in a warehouse is the difference between accuracy and creative accounting. When the bin shows 40 in VORQ and the shelf shows 37, the wrong first move is “adjust to 37” and walk away. The right first move is a short investigation so you learn whether the three units are on Van 2, still in transit, sitting in receiving, or genuinely gone.
This article gives a checklist to run before you post an adjustment from Stock counts. It pairs with cycle counting vs full physical inventory for when to count, and with multi-site reality in track stock across multiple warehouses.
Answer first
Investigate until one of these is true: you found the stock, you found the process miss (and can correct the document), or you confirmed a real loss. Only then post a Stock counts variance. Adjusting first trains the team to skip the detective work.
What counts as a discrepancy
- Physical quantity ≠ system on-hand at a location or Storage site
- Negative on-hand (system allowed a pick that stock could not support)
- Transfer in transit older than SLA with no receive
- Purchase order marked received but cartons never put away
- Low stock firing while a full pallet sits in the wrong aisle
Not every mismatch is theft. Most SMB variances are process: wrong site, partial Transfer, missed Scan to deduct, or double putaway into a neighbour bin.
Investigation checklist (before any adjustment)
1. Confirm you are counting the right thing
- Verify SKU, unit of measure, and Storage site. FLR-120 at Main DC is not FLR-120 on Van 2.
- Recount once with a second person if the variance is material (value or volume).
- Check neighbour bins and the floor under the rack. “Missing” stock often moved one bay left.
- Confirm labels: are you looking at the batch you think you are? Wrong label reads as wrong quantity.
2. Replay recent movements (last 7 to 14 days)
- Receive stock: was a partial Purchase order booked as full, or full as partial?
- Putaway: did 60 land in the system at A-03-B-02 while 10 stayed on the dock?
- Scan to deduct: any dispatch without scan, or scan without dispatch?
- Transfers: open or in-transit lines for this SKU between Main DC and Van 2? Partial receives outstanding?
- Prior Stock counts: was an earlier adjustment posted to the wrong location?
If TR-118 still shows 2 in transit, those 2 are not a Main DC shelf variance and not Van 2 pickable stock. Close the Transfer story before you adjust either site. Use the warehouse stock transfer SOP language: shipped, in transit, received, partial.
3. Check the “shadow homes”
- Receiving stage and quarantine
- Pack bench and returns cage
- Van 2 and other mobile Storage sites
- Customer holds or staged outbound that never deducted
- Supplier collection pallets waiting for credit
4. Separate document fixes from stock loss
| Finding | Action | Adjust via Stock counts? |
|---|---|---|
| Transfer not received at Van 2 | Receive (full or partial) on the Transfer | No, unless remainder is confirmed lost |
| PO short-booked | Correct with proper receive / supplier claim process | Only if stock never existed and books are wrong |
| Pick never scanned | Post the missing Scan to deduct if goods left | Maybe not needed if dispatch can still be recorded |
| Stock in wrong bin | Move / relocate to the correct location | No quantity change if total site qty is right |
| Cannot find after full search | Supervisor sign-off, then variance | Yes |
Worked example: system 40, shelf 37
Main DC, bin A-03-B-02, FLR-120. System on-hand 40. Physical 37.
- Recount: still 37. Neighbour bin A-03-B-01 holds 0 of this SKU.
- Movement history: Transfer TR-118 shipped 10 to Van 2 yesterday; Van 2 partial-received 8. Two still in transit. Those 2 are not on this shelf, but they also should already have left Main DC on-hand when shipped. So they do not explain a shelf short of 3 by themselves.
- Dispatch log: one order for 3 cartons shows packed, but Scan to deduct was skipped during a device outage. Cartons left on a customer job.
- Action: post the missed Scan to deduct for 3 if the order workflow allows, or adjust via Stock counts with note “missed scan order SO-9041”, then fix the floor rule (no load without scan).
The variance was real on the shelf, but the root cause was process. Adjusting to 37 without the note guarantees a repeat next week.
When you finally adjust
- Open Stock counts for the Storage site and location.
- Enter counted quantity.
- Write a cause code or short note (missed scan, damage, theft suspected, admin error, unresolved after search).
- Supervisor approves above your variance threshold (set a money or unit trigger).
- If Low stock flips after the post, review Purchase orders before panic-buying. A corrected number should drive replenishment, not a second wrong order.
Never “fix” company totals by adjusting Main DC when the stock actually sits on Van 2. Move or receive correctly so site-level analytics stay trustworthy.
Prevent the next discrepancy
- Enforce Scan to deduct at the door, including van loads for jobs.
- Close Transfers same day where distance allows; escalate in-transit leftovers.
- Receive Purchase orders at the true destination Storage site.
- Keep a weekly A-class cycle count so 3-unit drifts do not become 30-unit surprises. See cycle counting vs physical inventory.
- When batch identity matters on dispatch, use controlled labels as in dispatch stock from a specific batch.
Quick card for the shift lead
- Recount and check neighbours
- Check Transfers in transit and partials
- Check recent Receive stock and Scan to deduct gaps
- Check Van 2 / other Storage sites
- Fix the document if the stock still exists
- Only then post Stock counts with a reason
Stock discrepancies shrink when investigation is a habit and adjustment is a last step. Run the checklist, use Stock counts for the honest remainder, and keep multi-site movements on Transfers so the next count is dull. Ready to tighten the loop in VORQ? Start at signup.
