Free restaurant inventory template: an editable count sheet with item, unit, par level, on-hand and unit cost that auto-totals extended value. Print or save as PDF.
Restaurant Inventory Template
An editable count sheet. Fill in item, unit, par level, on-hand and unit cost — extended value totals automatically. Add rows, then print or save as PDF.
Inventory Count Sheet
Location: __________________ Date: __________ Counted by: __________________
| Item | Unit | Par | On hand | Unit cost ($) | Ext. value | |
|---|---|---|---|---|---|---|
| Total inventory value | $0.00 | |||||
Par is your target on-hand level for the next order cycle; anything counted below par gets ordered. For live counts, invoice capture and theoretical-vs-actual variance, see restaurant inventory software.
How to run a count that produces usable numbers
A count is only useful if it is repeatable. Count the same items in the same order, at the same point in the week, and after the last delivery rather than before it — otherwise the variance you calculate is a scheduling artifact, not usage. Walk the kitchen in physical order (walk-in, freezer, dry storage, line, bar) and let the sheet follow that route, so nobody hunts for the row they are standing in front of.
Two numbers come out of it. Usage is opening count plus purchases minus closing count. Variance is that usage against what the recipes say you should have used for the items the POS rang — the item-level product mix. Variance, not the count itself, is what tells you whether portions, waste or ordering is the problem.
Set par levels before you order again
A par level is the on-hand quantity that carries you to the next delivery with a thin cushion — not a maximum. Once the sheet shows a few weeks of real usage, set par per item from that usage plus lead time, then order the difference between par and the count instead of ordering by instinct. That single change is what stops the twin problems of running out mid-service and carrying dead stock through a slow week.
When to stop counting on paper
Paper works for one room with a short list. It stops working when counts need to roll up across locations or when invoice prices move faster than anyone can retype them. At that point the platforms in this catalog take over the same workflow: MarketMan (from $249/month) centralizes counts, purchasing and vendor orders with an HQ view across locations and supports barcode counts on mobile; MarginEdge ($350 per location/month) digitizes invoices line by line and computes usage by comparing purchased, sold and on-hand; Craftable adds barcode scanning and three-way invoice matching for groups with an AP function.
Deeper: restaurant inventory software, the platform shortlist, and the food cost calculator for costing a single plate.