Template
Restaurant inventory count sheet
A count sheet that tells you what to order, and a weekly log that turns your counts into food cost percentage. Two sheets, 45 ingredient rows, formulas built in.
What it does: for each ingredient you enter the par level, what is on hand and the cost per unit; the sheet computes the order quantity (par minus on hand) and the value on hand. The weekly log takes each count's total value and the purchases since the last one and gives usage (cost of goods) and food cost % against that week's sales.
Download
Restaurant inventory count sheet
Excel file (Count sheet, Weekly log). Opens in Excel, Google Sheets (File, Import) and Numbers. Blue cells are yours to fill; black cells are formulas; the first rows are an example to overwrite.
How to use it
- 1
List your ingredients
One row each, in the unit you buy (lb, case, 20 lb bag), grouped by storage area so you count in walking order.
- 2
Set par levels
Par = average daily usage × (days between deliveries + 1 or 2 safety days). Start with a guess and correct it after two weeks.
- 3
Count weekly, same day, same time
Before the first delivery of the day. Write On hand; the Order qty column is your order.
- 4
Log the total
Copy the total value into the weekly log with purchases since the last count and the week's net food and beverage sales. Usage and food cost % appear.
Columns
| Column | You enter | Formula |
|---|---|---|
| Ingredient, storage area, unit, vendor | Yes | |
| Par level | Yes | |
| On hand | Yes, each count | |
| Order qty | MAX(0, par − on hand) | |
| Cost per unit | Yes, update when a price changes | |
| Value on hand | On hand × cost per unit | |
| Weekly log: usage | Previous value + purchases − this value | |
| Weekly log: food cost % | Usage ÷ net sales |
What the sheet cannot do
It does not know what you sold, so it cannot tell you what you should have used. The gap between actual usage and what the recipes say you should have used (theoretical vs actual) is where waste, over-portioning and theft hide, and finding it needs recipes tied to sales. That is what Orqestra inventory adds: ingredients deplete as POS orders sync, counts show the variance in dollars, and the same ingredients import from this sheet.
See it with your own numbers
Request access, connect Clover in a minute, and your first reports are ready after the first sync. No card needed.