Inventory Discrepancies: Common Causes and How to Investigate Them

Finding inventory discrepancies is normal. Every warehouse that counts honestly finds lines where the physical quantity does not match the system quantity. What separates well-run operations from struggling ones is not the absence of discrepancies. It is how they investigate them: whether they find the real cause and fix it, or simply adjust the number and move on until the same problem returns.

This guide explains the most common causes of inventory discrepancies and a practical, step-by-step way to investigate them. It is written for warehouse staff and small-business owners who need records they can order, sell, and plan from with confidence.

What Counts as a Discrepancy?

A discrepancy, also called a variance, is any difference between the quantity recorded in your system or spreadsheet and the quantity physically in the location. It can be a shortage, where you have less than the record says, or an overage, where you have more. Both matter. An overage is not good news; it usually means a receipt was missed, a similar product was miscounted, or stock was put away in the wrong place, and it can cause you to under-order and run out later.

Treat small and large discrepancies differently. A difference of one unit on a fast-moving, low-value line may need only a quick recount and a note. A large difference on a high-value or fast-selling line needs a proper investigation before anyone adjusts the record. Agreeing those thresholds in advance, as part of your stocktake day checklist, keeps the response proportionate and consistent.

Common Causes of Inventory Discrepancies

Counting Errors

The count itself is often the problem. Missed shelf levels, double-counted bays, misheard quantities between counting partners, and simple tiredness all produce false variances. Similar-looking products counted as each other are another classic: the totals look plausible while both lines are wrong. This is why so many entries on any list of common stocktaking mistakes come back to counting discipline.

Receiving Errors

Stock can be wrong from the moment it arrives. A delivery booked in as the ordered quantity rather than the quantity actually received, a part-delivery recorded as complete, or cartons put away before they are checked will all create a shortage that only appears at the next count. Weak goods-in habits store up discrepancies for months. Tightening your receiving goods-in process prevents a large share of them at source.

Picking and Despatch Errors

Picking the wrong item, picking the right item in the wrong quantity, or taking a similar product from the neighbouring bin all leave the system believing stock remains when the shelf is empty, or the reverse. Because the despatch paperwork looks correct, these errors are invisible until someone counts or a customer complains.

Putaway and Location Errors

Stock put into the wrong location is effectively lost until it is found. The system shows it in location A, the picker finds location A empty, and the count records a shortage, while an unexplained overage sits in location B. Mixed bins, where two products share one location without clear separation, cause the same pattern repeatedly.

Unit of Measure Errors

Counting or transacting in the wrong unit creates dramatic variances that are often a neat multiple of a pack size. A receipt entered as cases when it should have been eaches, or a count recorded in units when the system holds cases, can make a healthy line look disastrous. Always check the unit early in any investigation; it is the cheapest fix there is.

Data Entry and Paperwork Errors

Transposed digits, a delivery note filed without being entered, a return entered twice, or a count sheet line typed against the wrong product code all corrupt the record without anything physical going wrong at all. These errors are frustrating but good news in one sense: the stock is fine, only the paperwork needs correcting, with a clear note of what happened.

Damage, Returns, and Unrecorded Write-Offs

Damaged stock thrown away without a write-off, returns put back on the shelf without being booked in, and samples or display items taken without a record all drift the physical quantity away from the system. Individually these are small. Across a year and many products, they add up to persistent, puzzling shortages.

Theft and Loss

Shrinkage from theft, whether internal or external, does happen and should not be ignored, especially for small, valuable, easily resold items. But it should be the conclusion of an investigation, not the first assumption. Most discrepancies in most warehouses turn out to be process errors. Jumping straight to theft damages trust and stops people looking for the fixable cause.

How to Investigate a Discrepancy, Step by Step

1. Recount first. Have someone who did not do the original count recount the location, blind, including every shelf level and any overflow or secondary location for that product. A large share of variances disappear at this step.
2. Check nearby locations. Look in the bins either side, above, and below, and in any known overflow area. Stock in the wrong location is one of the most common findings.
3. Check for the mirror variance. Look for a similar product with an opposite difference of the same size. If one line is short by ten and a lookalike line is over by ten, you have almost certainly found a mis-pick or mis-count between the two.
4. Check the unit. Confirm the count unit and the system unit match, and test whether the variance is a multiple of an inner or case quantity.
5. Review recent transactions. Look at the last receipts, orders, returns, and adjustments for that product. Check quantities, dates, and whether a delivery or return was entered once, twice, or not at all.
6. Check paperwork waiting to be processed. Look for delivery notes, return forms, or damage write-offs sitting in a tray or inbox that never reached the system.
7. Inspect the stock itself. Check for damaged items included or excluded inconsistently, empty packaging counted as full, and part-used cases estimated rather than counted.
8. Decide, adjust, and record. Once you have a cause or have exhausted the checks, adjust the record to the verified physical quantity and write down what you found and what you changed. An adjustment without a note teaches you nothing.

Work the largest and most valuable variances first. Investigating every one-unit difference with the same depth is not practical, and it is not necessary. Focus effort where the difference affects ordering, customer orders, or significant value.

Recording What You Learn

Keep a simple discrepancy log: date, product, location, system quantity, counted quantity, recounted quantity, cause found, and action taken. After a few counts, patterns emerge clearly. Perhaps one supplier’s deliveries are often short. Perhaps one product family is always confused at picking. Perhaps one zone has repeated location errors because its labelling is poor. Those patterns are far more valuable than any single adjustment, because they tell you where to fix the process.

Share the findings with the team in a short, blame-free review. The aim is to fix the step that failed, not to name the person who was standing nearest. Teams that feel safe reporting errors surface problems early, when they are small and cheap to fix.

Preventing the Same Discrepancies Next Time

Prevention follows directly from the causes. Check deliveries against the physical goods, not just the paperwork. Use clear bin locations and keep one product per location where you can. Add a second check for high-value or easily confused picks. Record damage and returns the same day they happen. And count the most error-prone lines more often instead of waiting for the annual count: a light routine based on cycle counting, prioritised with ABC analysis, catches drift while it is still small and easy to explain.

Over time, this is how inventory accuracy improves in practice: not through one heroic count, but through investigating honestly, logging causes, and removing one recurring cause at a time.

When to Escalate a Discrepancy

Most discrepancies should be handled by the warehouse team using the steps above. Some, however, need to be escalated to a manager or owner the same day. Escalate when the value involved is significant for your business, when the same product or location produces large differences repeatedly, when paperwork appears to have been altered or has gone missing, or when an investigation suggests stock may have been taken. Escalation is not an accusation. It simply means the decision about adjustments, security checks, or process changes is above the team’s level.

When you escalate, bring facts rather than suspicions: the counted and recounted quantities, the transactions you checked, the locations you searched, and the paperwork you found or could not find. That summary lets a manager decide quickly and fairly. It also protects the team, because it shows the investigation was thorough. Over time, keeping these escalation notes with your discrepancy log builds a clear record of which problems were one-off errors and which ones pointed to a weakness that needed investment, training, or a change in who handles valuable stock.

Conclusion

Inventory discrepancies are messages about your process, not just wrong numbers to correct. Recount first, check neighbouring locations and mirror variances, verify the unit, and review the recent paperwork before concluding anything. Record the cause every time, and use the pattern to fix the step that keeps failing. Do that consistently and each count will produce fewer surprises, and the records your business runs on will steadily become records you can trust.