Start free

Inventory Variance: Formula, Report and Causes

By mise · Updated October 7, 2026

Quick answer: inventory variance = counted quantity − expected quantity (beginning + received − used/sold). Expressed in dollars and as a percentage of usage. Under 1–2% is good; above 3–5% needs a look at waste, portioning, receiving and theft.

The variance report is the most useful inventory report you can run. It tells you what is missing and where to look.

Example: expected 42 lb of chicken, counted 36 lb. Variance −6 lb × $3.20 = −$19.20 (−14% of usage). Check portions and receiving.
Variance calculator

Variance: —

Common causes

Step by step: a weekly variance report

  1. Expected quantity per item = last count + received − used. "Used" comes from the POS (units sold) or recipes × items sold.
  2. Count the same items, same units, same time of day as last week.
  3. Variance = counted − expected, in units and in dollars (× unit cost).
  4. Variance % = variance ÷ usage × 100.
  5. Sort by dollars, investigate the top lines first.
ItemExpectedCountedVarianceUnit costVariance $% of usage
Chicken breast (lb)4236−6$3.20−$19.20−14%
Tequila 750 ml11.410.6−0.8$24.00−$19.20−9%
Heavy cream (qt)1615−1$4.10−$4.10−4%
Lemons (each)6064+4$0.30+$1.20+3%

Reading positive variances

More counted than expected is not good news. It usually means a sale or use was not recorded, a delivery was entered twice, a unit was mixed up (a case counted as single units) or the last count was too low. Investigate it like a negative one.

Fixing the common causes

CauseFix
Unrecorded wasteA waste log at each station, with reasons
Over-portioningScales, portion cups, recipe cards with photos
Receiving errorsCheck every delivery against the invoice before signing
TheftWeekly counts on high-value items, locked storage, variance by shift
Counting/unit errorsSame units every time; scanning instead of reading labels
Worked example: after adding a scale at the grill and logging dropped portions, the chicken variance above falls from −14% to −3% over four weeks: about $15 a week on one item, and the same routine works for every protein.

See also inventory shrinkage, actual vs theoretical food cost and cycle counting.

Variance in dollars or in percent?

Both. Percent tells you whether a line is out of control relative to its usage; dollars tell you whether it is worth your time. A 20% variance on parsley is a few dollars; a 4% variance on beef can be the biggest number on the report. Sort by dollars, then read the percentage.

Comparing variance between units only works with the same item list and count day everywhere: franchise inventory management.

Try mise in your business

Scan the barcode or snap a photo: mise's AI finds the product and categorizes it. Free trial.

Start free
Download on the App StoreGet it on Google Play
Keep reading Restaurant waste log: free template and how to track waste Actual vs theoretical food cost: how to find the gap Inventory shrinkage: meaning, formula and how to reduce it Cycle Counting: How to Do Inventory Cycle Counts All guides

Frequently asked questions

What is an acceptable inventory variance?

Under 1–2% of usage for most items; spirits and proteins should be tighter.

How do I reduce variance?

Waste logs, portion tools, checked deliveries and weekly counts of A items.

What is a variance report?

A list of items with expected vs counted and the dollar difference.

How often should I run a variance report?

Weekly for high-value items (proteins, spirits, wine), monthly for the rest.

Is variance the same as shrinkage?

Close: shrinkage usually means the negative, unexplained part of variance. Variance also includes positive differences, which point to recording errors.

Who should see the variance report?

The manager who orders and the person responsible for each area (kitchen, bar). Reviewing it together each week is what turns the numbers into fixes.

Can I try mise for free?

Yes. You get a free trial, with no card needed.