What is included
- Stock records compare entered physical counts with par levels, unit costs and pack sizes.
- Supplier order lists round recommended quantities to purchase packs.
- A waste log calculates recorded waste cost, while count dates support configurable recount reminders.
- Includes Google Sheets and demo/blank Excel editions; on-hand quantities are updated on count day.
Based on the Etsy listing reviewed October 28, 2026. Check the current listing for any later changes.
What to prepare
For the workflow this product is designed around, gather:
- Consistent ingredient names and count units
- Recent stock counts and delivery records
- Par-level plans and kitchen waste notes
A practical way to use your records
Choose a consistent unit for each ingredient before recording stock. Compare a count with your planned par levels and review pending orders before placing another order. Keep waste notes alongside the count cycle so unexplained differences are easier to investigate.
A worked example
Fictional example: a kitchen reviews a physical ingredient count, its supplier pack size and a separate waste entry before ordering.
- Counted on hand
- 10 kg, counted today
- Par level
- 25 kg
- Supplier pack
- 6 kg per pack
- Waste entry
- 2 kg at the recorded $3 per kg unit cost
- Update On hand and Count date in Stock, using the same unit for the count, par level and pack size.
- Review the supplier order list and enter the waste quantity with its date and reason in Waste Log.
Result: The gap to par is 15 kg. Rounding to 6 kg packs gives three packs, or 18 kg to order. The separate waste entry costs $6. This count-based review does not treat an order as stock already received.
Fictional figures explain the workflow; they do not represent customer results or guarantee particular template fields. See the included features above and the current Etsy listing.
A closer look at Restaurant Inventory Spreadsheet with Order Tracker & Kitchen Waste Log
Additional previews from this product's Etsy listing. Open any image for a larger view.
Learn the method
Questions about this product
Is a kitchen waste log included?
Yes. The template includes food inventory, order tracking, par levels and kitchen waste records.
Does this replace physically counting stock?
No. The spreadsheet organizes the stock information you supply; reliable counts and delivery records remain part of the workflow.
Which spreadsheet formats are listed?
This product is described for Google Sheets and Excel. Confirm the included files, software requirements and delivery instructions on its current Etsy listing.
