# 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

> 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.

Kivloo editorial team · 2026-11-14T08:18:22.287Z

## 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.

[BCcampus · Basic Inventory Procedures](https://opentextbc.ca/basickitchenandfoodservicemanagement/chapter/basic-inventory-procedures/)

## 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.

[Actual vs theoretical food cost: reconcile the gap without counting waste twice](https://kivloo.com/en/guides/actual-vs-theoretical-food-cost-reconciliation)

[Restaurant stock transfers: reconcile quantities and landed cost](https://kivloo.com/en/guides/restaurant-stock-transfer-reconciliation)

## 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 procurement software: what to test before you buy](https://kivloo.com/en/guides/restaurant-procurement-software)

[Food batch traceability: connect deliveries, ingredients and finished products](https://kivloo.com/en/guides/food-batch-traceability-records)

[Kivloo · Procurement beta](https://kivloo.com/features#mobile-procurement)

## 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 |

[Download the worked CSV](https://kivloo.com/worksheets/restaurant-inventory-variance-en.csv)

## 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.

## Continue reading

- [Actual vs theoretical food cost: reconcile the gap without counting waste twice](https://kivloo.com/en/guides/actual-vs-theoretical-food-cost-reconciliation)

- [Restaurant stock transfers: reconcile quantities and landed cost](https://kivloo.com/en/guides/restaurant-stock-transfer-reconciliation)

- [Restaurant procurement software: what to test before you buy](https://kivloo.com/en/guides/restaurant-procurement-software)

- [Food batch traceability: connect deliveries, ingredients and finished products](https://kivloo.com/en/guides/food-batch-traceability-records)

- [Restaurant food waste log: a practical UK template](https://kivloo.com/en/guides/restaurant-food-waste-log-uk)

- [Digital HACCP records: build a temperature log your team can actually use](https://kivloo.com/en/guides/digital-haccp-temperature-records)

## Sources and further reading

- [BCcampus · Basic Inventory Procedures](https://opentextbc.ca/basickitchenandfoodservicemanagement/chapter/basic-inventory-procedures/)

- [Kivloo · Procurement beta](https://kivloo.com/features#mobile-procurement)

Operational guidance, not a certification or a legal assessment. Adapt examples to your site, approved procedures and local requirements. Product links lead to the English website; this guide does not imply a fully translated application or verified hardware compatibility.

Canonical: https://kivloo.com/en/guides/restaurant-inventory-variance-count-reconciliation