Food traceabilityInventory and waste costs
Restaurant inventory variance: reconcile the count before assigning a cause
Rebuild the expected physical balance from opening stock and recorded movements, then compare it with a verified count in the same unit

At a glance
Rebuild the expected physical balance from opening stock and recorded movements, then compare it with a verified count in the same unit. Separate unavailable stock from missing stock, investigate the gap and post a correction once without repeating usage or waste already recorded.
Define the measurement
Choose a site, ingredient, base unit and cutoff. Include only movements belonging before that cutoff and distinguish an ordered quantity from an accepted receipt. Separate transfers into and out of the site. Count the physical quantity by lot before deciding which part is usable. A stock difference is an observation requiring evidence, not proof of theft, spoilage or recoverable savings.
Example record and review decision
Fictional record: opening 20 kg + receipts 30 kg + transfers in 4 kg − transfers out 2 kg − recorded usage 40 kg − recorded waste 3 kg = expected stock 9 kg. The verified physical count is 7 kg. Variance is counted minus expected: 7 − 9 = −2 kg. With the deliberately simplified constant cost of €4/kg, the count difference is −€8.
Check the result and its limits
One kilogram of the counted 7 kg is expired and unavailable. Physical count stays 7 kg, while usable stock is 6 kg. Do not describe the unavailable kilogram as another missing kilogram: the count gap remains 2 kg. Investigate cutoff, units, missed movements and a second count. If authorized, a −2 kg count adjustment reconciles 9 kg to 7 kg; a later recorded 1 kg write-off is a separate disposition.
Choose the next action
Do not post the 40 kg usage or 3 kg waste again to explain the discrepancy: both are already in the expected balance. Preserve the original record, reviewer, evidence and reason. If costs differ by lot, replace the simple €4 assumption with the appropriate documented valuation. Keep quantity reconciliation separate from invoice-price disputes and from claims that every variance euro can be recovered.
Use the downloadable record
The CSV includes every movement, expected quantity, physical count, unavailable quantity, usable quantity and signed count difference, with a blank record. It contains values rather than automatic formulas. Recalculate after editing and reconcile the movement signs before using the result. Leave unknown quantities or costs unresolved instead of filling them with zero. Record a correction reference only after the approved correction is actually posted.
Check the workflow in Kivloo
Kivloo's procurement beta records receiving, usage, waste, count changes and completed transfers, with eligible stock kept separate from held or expired lots. Its margin reports depend on complete inventory, cost and sales records; the worksheet is not a substitute for that reconciliation. Check the underlying movements before recording a count correction. Web setup and an active connection are required, and internal purchase approval does not send an order to a supplier.
Restaurant inventory variance: reconcile the count before assigning a cause
Worked example
| Expected | Counted | Usable | Count difference |
|---|---|---|---|
| 9 kg | 7 kg | 6 kg | −2 kg |
- Expected
- 9 kg
- Counted
- 7 kg
- Usable
- 6 kg
- Count difference
- −2 kg
Your record
Download the worked CSVA few useful answers
Does the CSV recalculate after editing?
No. It contains plain worked values and a blank record. Recalculate after changing inputs, keep units consistent and verify the result before using it.
Are the examples measured business results?
No. They are fictional planning examples with explicit assumptions, not evidence of savings or a guaranteed outcome.
Sources and further reading
MarkdownExplore starter templates
Start with a useful checklist
English
