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. 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. 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. 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. 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

ColumnYou enterFormula
Ingredient, storage area, unit, vendorYes
Par levelYes
On handYes, each count
Order qtyMAX(0, par − on hand)
Cost per unitYes, update when a price changes
Value on handOn hand × cost per unit
Weekly log: usagePrevious 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.