Your Physical Count Doesn't Match the System: Decision Tree

Why this matters

You counted a bin, and the number on the shelf is not the number in the system. Before that gap becomes a theft accusation or a panicked reorder, understand what it is: two numbers that disagree, and either one could be wrong. A count variance is not automatically a loss. The system can say more than you have, or fewer, and the causes are different in each direction. This tree trues up the two numbers before you spend anything or accuse anyone.

Start here: recount before you react

The most common cause of a count mismatch is the count.

• Recount the item cleanly, slowly, once. Miscounts, double-counts, and skipped rows are ordinary.
• Check the unit of measure. A box of fifty counted as one, or singles counted as boxes, throws the number wildly. Confirm you and the system mean the same unit.
• Check for the same part in a second location. The rest of the count may be in another bin, on a truck, or in a returns pile. Stock split across places you did not count reads as missing when it is just elsewhere.

If a clean recount, in the right unit, across every location closes the gap, you are done. A large share of variances die here.

Which way does the gap run?

If the recount still disagrees, the direction tells you where to look. This is the split most people skip.

If the system shows MORE than you physically have, stock left without being recorded:

• Usage not logged. A part pulled off the truck or shelf for a job and never posted against it. This is the number-one cause of a true short.
• Non-billable use not recorded: warranty redos, comebacks, shop use, a part cannibalized from one job to another.
• A return or transfer to another location that was physically moved but never entered.

If the system shows FEWER than you physically have, stock arrived without being recorded:

• Receiving not posted. A delivery put on the shelf but never entered, so the system never learned you got it.
• A return from a job put back in the bin without crediting inventory.
• A prior count adjustment that was wrong in the other direction, now surfacing.

Is it a timing (cutoff) problem?

Many "variances" are real stock caught mid-motion. Cutoff is the discipline of counting a still picture, not a moving one.

• Stock in transit. Parts between the supplier and your shelf, or between the shop and a truck, belong to exactly one count. If both ends claim them, or neither does, the number is off by timing, not loss.
• Counted mid-transaction. A count taken while parts are being pulled for the day or while a delivery is being put away will never match. Count when the stock is at rest, or freeze movement while you count.
• Open jobs. Parts allocated to a job that is not yet closed may have left the shelf but not the system, or the reverse. Know how your system treats allocated-but-unposted stock.

Adjust, or investigate?

Once you know the direction and have ruled out cutoff, decide what to do with the gap.

• If you found the cause (an unposted receipt, an unlogged usage), fix the record at its source and move on. Post the receipt, log the usage, credit the return. The variance was an accounting gap, not a loss.
• If the gap is small, in cheap consumables, and one-time, adjust the count to physical reality, note it, and watch the item next cycle. Chasing every washer costs more than the washer.
• If the gap is large, recurring, or concentrated in high-value items you cannot explain, do not just adjust it away. An unexplained short that keeps coming back is the case for a real investigation. See related: You Suspect Parts Are Walking Off Decision Tree.

Recap

1. Recount cleanly, in the right unit, across every location.
2. Read the direction: system-high points to unrecorded outflow, system-low to unrecorded inflow.
3. Rule out timing: in-transit, mid-transaction, and open-job stock.
4. Found a cause? Fix the record at its source. Small and one-time? Adjust and watch. Large, recurring, unexplained? Investigate.

References

• See related: Parts Inventory Shrinkage Decision Tree, You Suspect Parts Are Walking Off Decision Tree
• See related: Running a Physical Inventory Count Without Shutting Down
• U.S. Small Business Administration (SBA), inventory control and cycle-counting guidance
• Trade-standard practice for inventory reconciliation and count cutoff