We use cookies to understand which pages and tools are useful, nothing more — no ad tracking across other sites. You can change this later from the footer.

Skip to content
Lekhya.in

Explainer4 min readPublished

The stock count that didn't match the ledger, and why

An illustrative, composite walkthrough of a physical inventory count that disagreed with the perpetual stock ledger, how the variance was traced, and what it turned out to be.

This is a composite, illustrative scenario built from how a stock count variance typically gets worked, not an account of a named client. A year-end physical inventory count showed one product line roughly 6% below the quantity recorded in the perpetual stock ledger — large enough that ordinary counting error was an unlikely sole explanation, and too large to simply book as shrinkage without finding out why. The eventual cause was a scanning gap in the warehouse's goods-out process for that specific product, which had been shipping out without a corresponding system deduction for several months.

Why it wasn't treated as ordinary shrinkage

Some variance between a perpetual ledger and a physical count is normal — breakage, minor miscounts, small theft. A 6% gap concentrated in a single product line, rather than spread thinly across the whole inventory, is a different pattern: it points at something specific to that item's handling, not general wear on the system as a whole.

What was checked

  1. 01Recounted the product line independentlyA second count team, working from a blank sheet rather than the first team's tally, got the same result — ruling out a counting or recording error in the physical count itself.
  2. 02Reviewed the goods-out process for that product specificallyFound the item was one of a small number shipped using a separate, older packing-slip process that didn't route through the main barcode scanner at dispatch.
  3. 03Checked how long that process had been in useRoughly five months — since a packaging change for that product required different dispatch handling that nobody had updated the scanning step for.
  4. 04Estimated the cumulative effectFive months of unscanned dispatches, at the product's typical shipping volume, reasonably accounted for the full variance — no further gap was left needing a different explanation.

What it actually was

A system gap, not theft and not a counting failure. The product had genuinely left the warehouse and been genuinely sold — the ledger simply never recorded the reduction, because the dispatch process for that one item bypassed the scanner that every other product's dispatch went through. The inventory was overstated in the books because the system quantity had been silently diverging from the real quantity for months, surfacing only at the year-end physical count.

What the finding changed
AreaEffect
Inventory valuationWritten down to the physical count quantity — the ledger quantity could not be relied on for this product line
Cost of goods soldIncreased by the same amount, since the “missing” stock had in fact already been sold, just never recorded as such
Dispatch processThe packaging-change workaround was flagged and the product routed back through the main scanning process
What the finding changed

What went into the file

  • The independent recount result, ruling out a physical-count error as the explanation.
  • The root-cause trace to the bypassed scanning step, with the packaging-change date that started it.
  • The adjusting entry: inventory written down, cost of goods sold increased, for the one affected product line.
  • A check of other products on the same packaging-change list, to confirm this gap was isolated to this one item and not a wider pattern.
  • A management letter point on the control gap in the dispatch process, specifically naming the trigger (an unflagged packaging change) rather than describing it only as a general scanning weakness.

How we think about this

The variance itself only told the team something was wrong. What resolved it was tracing the specific process the affected item moved through, rather than assuming the standard shrinkage explanation applied by default — a 6% gap concentrated in one line is a different investigation from a thin, even variance spread across the whole count.

This is practical guidance written for audit teams, not an authoritative statement of any standard or statute. Standards, forms and timelines change. Check the current text issued by the ICAI and the relevant authority before relying on anything here in an audit file.

Free tools, no signup

Each one reads a file entirely in your browser — or, for two of them, just answers a few questions — and nothing is ever uploaded.