What is an inventory variance?
An inventory variance is the difference between the quantity recorded in the inventory system and the quantity physically available in the warehouse. A negative variance means the physical quantity is lower than the system quantity. A positive variance means more stock was counted than the system shows.
Inventory variance = Physical quantity − System quantity
A variance should not be treated as an automatic instruction to adjust the system. It is a signal that a transaction, movement, count or control may need investigation. Correcting the number without identifying the cause can allow the same issue to happen again.
Inventory variance investigation checklist
Recount the stock independently
Ask a second person to recount the item without seeing the first count. Check unopened cartons, loose units and different units of measure. Confirm that carton quantity and individual-unit quantity were not confused.
Confirm the correct SKU and description
Compare the item code, barcode, description, pack size, batch and variant. Similar products, old item codes and nearly identical packaging frequently cause counting errors.
Check every possible storage location
Review the main bin, overflow racks, staging areas, receiving zones, dispatch lanes, quarantine, returns, damage areas and temporary locations. Stock may be physically present but stored outside its recorded bin.
Review recent receiving transactions
Check goods received notes, purchase orders and system receipts. Look for quantities received physically but not posted, duplicate receipts, incorrect pack conversions, rejected quantities or stock placed in another location.
Review picking and dispatch activity
Compare pick lists, goods issue notes, delivery documents and system issues. Check whether stock was picked but not confirmed, confirmed twice, short-picked, substituted or moved to dispatch staging.
Check transfers, returns and adjustments
Review inter-bin and inter-warehouse transfers, customer returns, supplier returns and recent adjustments. Confirm that both sides of each movement were completed and posted to the correct item and location.
Inspect damages, expiry and write-offs
Look for damaged, expired, obsolete, sampled or consumed stock that was physically removed but not recorded. Confirm that supporting forms and approvals match the system transaction.
Document the cause before adjustment
Record the confirmed system quantity, physical quantity, variance, value, investigation performed, probable root cause and approval. Adjust only after the available evidence has been reviewed.
Common causes of stock discrepancies
- Receiving errors: incorrect quantity, wrong SKU, duplicate receipt or unposted receipt.
- Picking errors: wrong item, excess issue, short pick or unconfirmed dispatch.
- Location errors: stock moved physically without a corresponding system transfer.
- Unit-of-measure errors: cartons recorded as pieces, or pack-size conversions applied incorrectly.
- Damage and expiry: unusable stock separated or disposed of without a system adjustment.
- Count errors: mixed batches, hidden stock, double counting or missed locations.
- Master-data problems: duplicate SKUs, incorrect barcodes or outdated pack configurations.
- Unauthorized movement: stock removed, used or relocated without documentation.
Practical variance example
System stock: 1,250 units
Physical stock: 1,215 units
Variance: 1,215 − 1,250 = −35 units
If the unit cost is USD 8, the variance value is −35 × USD 8 = −USD 280.
The warehouse should not immediately reduce the system by 35 units. The investigation should first check recent receipts, dispatches, pending transfers, damage records, staging areas and units of measure. If the shortage remains unexplained after those checks, it should be documented and escalated according to the organization’s approval process.
When should inventory be adjusted?
An adjustment should be made only after the recount and transaction review are complete, the variance is documented, and the required approval has been obtained. The supporting record should show who counted the stock, who investigated it, the reason code used and who approved the correction.
High-value, repeated or unusual variances should receive additional review. A pattern affecting the same SKU, shift, customer, supplier or location may indicate a process weakness rather than an isolated counting mistake.
How to reduce future variances
- Use barcode scanning where practical and validate pack sizes in the item master.
- Complete system transactions at the time of the physical movement.
- Keep receiving, storage, quarantine and dispatch areas clearly separated.
- Perform regular cycle counts based on item value, movement and risk.
- Investigate recurring reason codes and assign corrective actions.
- Train staff on location control, batch handling and units of measure.
- Track variance quantity, variance value, count accuracy and repeat discrepancies.
Use free DIXANI resources
Compare quantities online, organize the physical count and document the final variance using these practical resources.
Frequently asked questions
What should be checked first when stock does not match?
Start with an independent recount and confirm the SKU, unit of measure and storage location. Then review recent receipts, issues, transfers, returns and damage records.
Should the system be adjusted immediately after finding a variance?
No. Investigate and document the discrepancy first. The adjustment should follow the organization’s authorization procedure and include a clear reason.
What is a negative inventory variance?
A negative variance occurs when physical stock is lower than system stock. For example, 95 physical units against 100 system units produces a variance of −5 units.
How often should cycle counts be performed?
The frequency should reflect value, movement and risk. High-value or fast-moving items are normally counted more frequently than low-risk, slow-moving items.