Inventory Variance: Formula, Causes and How to Investigate It

Inventory variance is the difference between what your inventory system says you have and what a verified physical count shows is actually on hand. The number itself matters, but the real value comes from identifying why the discrepancy happened and preventing it from repeating.

Inventory variance formula

A simple quantity formula is:

Inventory Variance = Physical Count − Recorded Quantity

If the system shows 100 units and the physical count finds 96, the variance is -4 units. A negative result means the physical count is lower than the system record. Some companies use the opposite sign convention, so define the reporting rule clearly.

Inventory variance percentage

To compare variance across products of different sizes, calculate a percentage:

Inventory Variance % = |Physical Count − Recorded Quantity| ÷ Recorded Quantity × 100

For 96 physical units versus 100 recorded units:

|96 − 100| ÷ 100 × 100 = 4%

Using the absolute difference makes comparison easier, but keep the signed quantity variance too so you know whether the stock is over or short.

Inventory variance vs inventory accuracy

Variance and accuracy describe the same mismatch from different angles.

Metric	What it shows
Inventory variance	How far physical inventory differs from the record
Inventory accuracy	How closely records match verified physical inventory

For record-level accuracy, see the full inventory accuracy guide.

Quantity variance vs value variance

Quantity variance counts units. Value variance translates the discrepancy into money.

If four missing units cost $25 each, the inventory value variance is $100 at cost. A small unit variance can therefore be financially important when the affected SKU is expensive.

For prioritization, review both quantity variance and value variance. High-value discrepancies deserve faster investigation even when the unit count is small.

Common causes of inventory variance

• Receiving errors: stock physically arrived but was not received correctly, or the wrong quantity or SKU was posted.
• Sales mapping errors: a sale reduced the wrong item or variation.
• Returns: refunded or returned items were added back incorrectly.
• Transfers: stock left one location but was never received at the destination, or vice versa.
• Damage, waste, or spoilage: physical stock disappeared without an inventory adjustment.
• Theft or loss: stock is physically missing without a valid transaction.
• Unit-of-measure errors: cases, packs, bottles, pounds, or individual units were mixed.
• Counting errors: stock was missed, double-counted, or assigned to the wrong SKU.
• Timing differences: sales, receiving, or transfers happened during a count and were not handled consistently.
• Duplicate or missing integrations: a connected system sent a transaction twice or failed to send it.

How to investigate inventory variance step by step

1. Recount the item. Confirm the discrepancy before changing the system.
2. Verify the exact SKU and variation. Check size, color, pack configuration, barcode, and unit of measure.
3. Confirm the location. Make sure the count and system record refer to the same store, warehouse, or stockroom.
4. Establish the last trusted point. Find the most recent reliable count or reconciliation.
5. Review the stock ledger. Trace sales, receipts, returns, transfers, adjustments, damage, and waste since that point.
6. Check open operational events. Look for unreceived purchase orders, stock in transit, pending returns, or transactions posted during the count.
7. Identify the most likely cause. Avoid labeling every unexplained difference as shrinkage.
8. Correct the quantity with a reason. Preserve an audit trail rather than overwriting the number without context.
9. Fix the process. If the same variance repeats, change the receiving, counting, transfer, return, or catalog workflow that caused it.

For a full process, see inventory reconciliation and what a stock ledger should record.

Example: tracing a 5-unit shortage

A store's system shows 50 units of a jacket, but a physical count finds 45. The variance is -5 units.

Instead of immediately changing the system to 45, the manager reviews activity since the last trusted count. The history shows:

• 20 units were received from a supplier
• 14 units were sold
• 2 units were returned
• 3 units were transferred to another location
• 1 damaged unit was physically removed but never adjusted

The unrecorded damaged unit explains only one of the five missing units. The remaining four still need investigation. This is why a recount alone can correct the balance without solving the operating problem.

Inventory variance vs shrinkage

Inventory shrinkage is one possible cause of variance, usually referring to inventory loss from theft, damage, administrative error, or other unrecorded loss.

Variance is broader. A positive or negative discrepancy can also come from timing, wrong location assignment, an unreceived purchase order, duplicate transactions, or a counting mistake. Investigate before classifying the difference.

Inventory variance vs write-off

A variance identifies a mismatch. An inventory write-off is a decision to remove inventory value because stock is no longer recoverable or saleable.

Do not use write-offs as a shortcut for unexplained operational discrepancies. First determine whether the stock was damaged, stolen, expired, incorrectly received, transferred, or simply miscounted.

How often should inventory variance be reviewed?

Review frequency should match the business risk.

• High-value or fast-moving SKUs may justify weekly or even more frequent cycle counts.
• Stable, low-risk products can be counted less often.
• Locations with recurring discrepancies should receive more frequent review.
• Large variances should be investigated immediately rather than waiting for the next scheduled count.

ABC inventory analysis can help prioritize counting effort.

How to reduce recurring inventory variance

Improve receiving discipline

Receive against the correct purchase order, count what physically arrived, and record shortages or damage before stock reaches the shelf.

Use consistent adjustment reasons

Separate damage, waste, theft, recounts, returns, and administrative corrections. Good reason codes make patterns visible.

Use transfers instead of unrelated adjustments

A connected transfer record is easier to audit than a negative adjustment at one location and a separate positive adjustment at another.

Count high-risk inventory more often

Use cycle counting to catch discrepancies sooner instead of relying only on occasional full counts.

Keep product identifiers clean

Unique SKUs, correct variations, and consistent units reduce errors in receiving, selling, scanning, and counting.

How Stash helps with inventory variance

Stash connects inventory, purchasing, receiving, transfers, suppliers, supported POS sales data, and multiple locations in one workflow. That gives teams more context when a count is wrong because they can review the operational events that should explain how stock moved.

The goal is not just to make the current quantity correct. It is to make future quantities more trustworthy.

Frequently asked questions

What is a good inventory variance percentage?

There is no universal acceptable percentage for every business. A small percentage may still be material for expensive or critical inventory. Track the trend by SKU and location, investigate recurring causes, and set tighter tolerances for high-impact items.

What does a negative inventory variance mean?

Using the formula physical count minus recorded quantity, a negative variance means the physical count is lower than the system record.

What does a positive variance mean?

It means the physical count is higher than the recorded quantity. Possible causes include unrecorded receiving, returns, wrong-location transactions, or earlier counting errors.

Should I overwrite inventory when I find a variance?

Only after confirming the physical count and reviewing likely causes. Record the correction with an auditable reason so the system history remains useful.

Is every inventory variance shrinkage?

No. Shrinkage is one cause. Timing errors, receiving mistakes, transfers, returns, catalog problems, and counting errors can also create variance.

Next steps

Start by identifying the SKUs and locations with the largest value variance, then review their transaction history and counting process. Continue with the inventory reconciliation guide and cycle counting process.