Restaurant Inventory Template

Track expected stock against a physical closing count in consistent units.

Working example

For a hypothetical ingredient, record 20 kg opening, 8 kg received and 22 kg used. Expected closing stock is 6 kg. If counted stock is 5.5 kg, the variance is minus 0.5 kg. Enter the signed difference in the variance column; the sheet does not calculate it.

Review control

Agree the count cutoff and unit conversion. Check receipts, wastage and transfers before an adjustment. Do not interpret every difference as theft.

Read the worksheet guide on Restrova

Fill one row per record. Keep the reporting period and units consistent. These blank working sheets are not customer data or accounting advice. Check totals independently and keep personal information only where necessary. Use your browser Print action to save a completed PDF; data is not transmitted.

Business / period: ____________________

ItemUnitOpening quantityReceivedUsedClosing countVarianceChecked by

Restrova working resource. No automatic calculations are performed by this sheet. Save or print your completed version before closing.