How to Handle Inventory Discrepancies Correctly

An inventory discrepancy occurs when the quantity recorded in your system differs from the quantity physically available. Your records may show 100 units while a warehouse count finds only 94—or reveal extra stock that was never recorded.

Correcting the number is only part of the job. A reliable process verifies the difference, identifies its cause, documents the adjustment, and reduces the chance of it happening again.

1. Verify the Physical Count

Before changing your inventory records, confirm that the discrepancy is real.

Recount the affected items, preferably with a second employee. Check the SKU, barcode, unit of measure, and storage location. Similar packaging, misplaced products, and confusion between individual units and cases can all produce incorrect counts.

Look beyond the primary shelf. Stock may be in receiving, packing areas, returns processing, quarantine, or another warehouse location.

When possible, conduct a blind recount: ask the counter to record what they find without showing the expected quantity.

2. Compare Quantities on the Same Basis

A physical count and a system balance must represent the same stock at the same point in time.

For example, “available inventory” may exclude units reserved for customer orders, while “on-hand inventory” includes them. Comparing available stock with everything physically present can create an apparent discrepancy.

Confirm:

• Which locations and inventory statuses are included.

• Whether the system tracks units, packs, cases, or another measure.

• Whether receipts, shipments, and transfers occurred during the count.

• Whether damaged, returned, or quarantined goods are recorded separately.

Temporarily pause movements for the affected stock when practical. If operations must continue, record movements carefully so you can reconcile them to the count cutoff.

3. Trace Recent Inventory Activity

Once the variance is confirmed, review the transactions that could explain it.

Start with activity since the last reliable count:

ActivityWhat to checkReceivingMissing receipts, short deliveries, duplicate entries, or incorrect quantitiesPicking and shippingWrong items, incorrect pick quantities, or shipments posted at the wrong timeTransfersStock removed from one location without a matching receipt at the destinationReturnsItems physically received but not inspected or recordedDamage and disposalProducts removed without a corresponding inventory transactionSystem updatesFailed imports, delayed synchronization, or duplicate transactions

Check supporting records, such as purchase orders, receiving documents, transfer records, and shipment confirmations. A variance is a signal to investigate; it does not establish the cause by itself.

4. Correct the Underlying Error

Choose the correction that matches what actually happened.

If a receipt was never posted, complete the receiving transaction using the appropriate workflow. If stock was recorded in the wrong location, correct the location record or transfer. If a duplicate transaction created the difference, reverse or correct it through the system’s supported process.

Use a quantity adjustment when the verified physical balance requires one and no more specific transaction correction applies. Avoid posting an adjustment and then processing the missing transaction later, which would count the correction twice.

For example, suppose the system shows 100 units and the recount confirms 94. If six units were shipped but the shipment was never posted, completing that shipment resolves the difference. A separate six-unit reduction would create another error.

5. Document and Approve the Correction

Every correction should leave a clear audit trail.

Record the affected SKU and location, the system quantity, the verified count, the variance, and the reason for the correction. Include supporting evidence, the people who counted and investigated, and any required approval.

Use specific reason codes where possible. “Unrecorded damage” or “receiving quantity error” provides more useful information than a general “inventory correction.”

Follow your organization’s approval process, with closer review for high-value, large, or recurring discrepancies. If the cause remains unknown, record that clearly rather than assigning an unsupported explanation.

6. Confirm That the Records Now Agree

After the correction, verify the updated balance and any connected systems that rely on it.

Check whether the discrepancy affected open orders, replenishment decisions, or stock availability shown to customers. Where needed, notify the responsible team so it can address shortages or revise commitments.

The investigation is complete when the physical stock, transaction history, and recorded balance are consistent—or when any remaining uncertainty is explicitly documented and assigned for follow-up.

7. Prevent Repeat Discrepancies

Use the findings to improve the process that allowed the error.

Practical improvements may include clearer location labels, barcode checks during receiving and picking, separate areas for returns and damaged goods, and better tracking of transfers.

Cycle counts can help detect problems between full inventory counts. Prioritize items based on value, movement, operational importance, and previous discrepancy patterns.

Review trends as well as individual incidents. Repeated shortages for one SKU may point to a packaging or unit-of-measure problem. Differences concentrated in one location may indicate an unclear transfer process.

A Simple Discrepancy Checklist

Before closing a case, confirm that you have:

• Verified the count, SKU, location, and unit of measure.

• Aligned the count with the correct system balance and cutoff time.

• Reviewed relevant transactions and supporting records.

• Applied the appropriate correction without duplicating it.

• Documented the evidence, reason, and approval.

• Assigned preventive action where needed.

Accurate inventory depends on more than matching a number on a screen. Treat each discrepancy as an opportunity to restore reliable records and strengthen the process behind them.