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.
Variance: —
Common causes
- Unrecorded waste.
- Over-portioning.
- Receiving errors.
- Theft.
- Counting or unit errors.
Step by step: a weekly variance report
- Expected quantity per item = last count + received − used. "Used" comes from the POS (units sold) or recipes × items sold.
- Count the same items, same units, same time of day as last week.
- Variance = counted − expected, in units and in dollars (× unit cost).
- Variance % = variance ÷ usage × 100.
- Sort by dollars, investigate the top lines first.
| Item | Expected | Counted | Variance | Unit cost | Variance $ | % of usage |
|---|---|---|---|---|---|---|
| Chicken breast (lb) | 42 | 36 | −6 | $3.20 | −$19.20 | −14% |
| Tequila 750 ml | 11.4 | 10.6 | −0.8 | $24.00 | −$19.20 | −9% |
| Heavy cream (qt) | 16 | 15 | −1 | $4.10 | −$4.10 | −4% |
| Lemons (each) | 60 | 64 | +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
| Cause | Fix |
|---|---|
| Unrecorded waste | A waste log at each station, with reasons |
| Over-portioning | Scales, portion cups, recipe cards with photos |
| Receiving errors | Check every delivery against the invoice before signing |
| Theft | Weekly counts on high-value items, locked storage, variance by shift |
| Counting/unit errors | Same units every time; scanning instead of reading labels |
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.
Scan the barcode or snap a photo: mise's AI finds the product and categorizes it. Free trial.
Start freeFrequently 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.
