Inventory Variance Calculator

How to use this calculator

Select the measurement or holding-cost mode where available. Enter the required quantities using the labels and formula shown. Results update as you type. Copy result includes only the visible calculation summary; Reset clears all modes and values. Blank required fields need valid inputs before a result can be copied. The displayed examples are fixtures, not targets or recommended purchasing quantities.

Result · Inventory Variance Calculator

Compare the same SKU, count cutoff and unit of measure. Unit cost is optional; leave it blank when unknown. Use the same currency for all monetary inputs.

Compare one SKU at one count cutoff

Inventory variance is the difference between the physical quantity counted and the quantity expected in the stock record. This calculator compares one SKU at a time. It keeps the sign because a physical shortage and a physical overage require different operational checks. The result describes a discrepancy; it does not establish why the discrepancy occurred.

Enter the expected quantity and physical counted quantity in the same unit of measure. Optionally enter a unit cost to see the monetary value of the difference. Leave cost blank if you do not know it; a blank cost is different from a genuine zero cost. Results update in your browser as you edit. Copy result captures the input summary and calculated outputs as plain text. Reset clears all entered figures. The tool needs no account or email and does not send calculation data to a server.

Read the sign and percentage correctly

The unit formula is physical counted quantity minus expected quantity. For an expected quantity of 24 and a count of 19, the result is −5 units. The physical count is lower than the record by five units. For an expected quantity of 19 and a count of 24, the result is +5 units, an overage relative to the record. Equal quantities produce an exact match.

Percentage variance uses the recorded quantity as its base: signed unit variance / expected quantity × 100. Thus −5 / 24 × 100 is approximately −20.83%. This is a signed discrepancy percentage, not an inventory accuracy score. When the expected quantity is zero and the physical count is three, the unit result is +3 but the percentage is not applicable. There is no meaningful division by a zero recorded base. Small bases can also produce very large percentages; keep the quantities visible when interpreting them.

Optional value: weight the discrepancy by unit cost

When a unit cost is supplied, signed discrepancy value equals signed unit variance multiplied by that cost. A difference of −5 units at a cost of 12 per unit gives −60 in the same currency as the cost input. A positive value indicates more physical units than recorded, weighted by cost. The absolute monetary discrepancy is the magnitude of this result, without its sign.

Use a consistent cost basis at the count cutoff and label that basis in your records. The calculator does not choose an accounting valuation policy, convert currencies or estimate a sales margin. A negative value alone does not prove a loss, theft or shrinkage. A missed receipt, a timing mismatch, a wrong unit conversion or stock placed on another shelf may explain it. Reconcile the cause before deciding whether the stock record needs correction.

Check count scope and units before adjusting

Freeze or document the relevant count cutoff so receipts and consumption are compared on the same basis. A record captured before a delivery and a count taken after it can disagree even when both observations are correct. Use the same SKU identity and unit of measure in both fields. Cases and individual pieces must be converted consistently before comparison. Decimal quantities are appropriate when the item is genuinely measured in fractional units, such as weight or volume.

Recount the item, check the barcode and SKU mapping, and inspect other shelves, bins or back-room storage. Review recent receiving, sales or usage, transfers, customer returns, supplier returns, damaged goods, samples and write-offs around the cutoff. Record what you checked and what remains uncertain. An adjustment should follow evidence and your approval process rather than being an automatic reaction to the calculator’s sign.

Keep discrepancies visible across a larger count

Do not add signed differences across unrelated SKUs and call the net total an accuracy measure. One item’s five-unit overage can hide another item’s five-unit shortage. Both records still need investigation. For a count-wide measure, preserve each line’s discrepancy and sum its absolute magnitude before using the linked inventory accuracy calculator.

Use the reconciliation guide for the worked case and investigation sequence. The physical count guide helps establish a repeatable counting process, while the shrinkage guide explains why a discrepancy is not automatically shrinkage. Track repeated causes separately from unresolved differences so later process changes address demonstrated problems. Keep the original count and record snapshot as evidence even after a justified adjustment.