Inventory variance is the gap between what your records say an ingredient should have used and what the count says actually left the shelf. It is useful precisely because it is not an accusation. It is a prompt to look more closely.
Actual usage vs theoretical usage
Actual usage comes from a count: beginning inventory, plus receipts, minus ending inventory. Theoretical usage comes from what the kitchen should have used if every recorded sale followed the recipe. Restaurant365 describes the same distinction in its actual versus theoretical guidance: theoretical usage depends on reliable sales and recipe inputs.
Use one sign convention and keep it. In this guide, a positive variance means actual usage was higher than theoretical usage.
Work through one ingredient first
Start with an ingredient that is expensive, frequently used, and straightforward to count. Here is an illustrative chicken example:
| Weekly movement | Amount |
|---|---|
| Beginning stock | 20 kg |
| Receipts | 30 kg |
| Ending stock | 12 kg |
| Actual usage | 38 kg |
If the restaurant sold 180 portions and the approved recipe uses 0.20 kg per portion, theoretical usage is 36 kg. The variance is therefore 2 kg: 38 kg actual usage minus 36 kg theoretical usage.
The arithmetic is simple; the interpretation takes care. The example does not include transfers, returns, staff meals, or documented waste. Add those deliberately if they apply — do not hide them inside a mysterious adjustment.
Investigate the record before the people
A bad count, the wrong unit, an unrecorded delivery, or an outdated recipe can make a variance look dramatic. Check the operational chain in order:
- Recount the item using the same unit at both ends of the period.
- Match delivery paperwork to the receipts entered.
- Check whether returns, transfers, staff meals, and waste were recorded.
- Confirm the recipe yield and portion size reflect what the kitchen actually makes.
- Only then discuss repeated patterns with the relevant team.
Variance can reveal over-portioning, spoilage, or a receiving mistake. It cannot tell you which one happened on its own.
Make it a weekly review, not a monthly surprise
Weekly checks shorten the distance between the cause and the count. Choose a quiet, repeatable time; count the same key items; and leave a brief note when a result needs follow-up. A complete count of every dry-good can wait. A consistent check on your high-value items cannot.
TableAI can help preserve the stock quantities your team reports in WhatsApp. It does not calculate recipe-based theoretical usage automatically — that needs separate sales and recipe data. If an item is simply running low, start with a sensible minimum level and the restaurant inventory spreadsheet.
Common questions
Is inventory variance proof of theft?
No. Treat it as an investigation signal. Count errors, waste, receiving errors, transfers, and recipe changes are common explanations.
Should I track every ingredient?
Start with the items that matter most to cost and service. Expand once the routine is reliable.