Food inventory template

Count stock the same way each week to control food cost and plan orders.

Use it on screen
Food inventory templateBefore countingFor each itemAfter countingSame day and time as last…🥫
How to use itCount at the same time each week, in the same order as your storage areas. Multiply counts by unit cost to get stock value and compare with par levels to plan orders.

Who needs a food inventory

Food cost is one of the two largest costs in a restaurant, next to labor. A regular count shows where money goes: waste, over-ordering or untracked use.

Organize the sheet in the order of your walk-in, freezer and dry store so counting is fast.

13 items. Complete it digitally or on paper, whichever your team prefers.

Before counting

For each item

After counting

Example row

Example row
Field What to write
Item Chicken breast, 10 lb case
Par 6 cases
On hand 2.5 cases
Unit cost $34.00
Value $85.00
Order 4 cases

How to put it to work

  1. Have two people count: one counts, one writes.
  2. Use units that match invoices.
  3. Calculate food cost: opening inventory + purchases − closing inventory.
  4. Review waste records with the count.
  5. Adjust pars after menu changes.

A food inventory in use

A burger restaurant counts every Sunday night. Opening inventory was $6,200, purchases $9,800 and closing inventory $5,900, so food used is $10,100. With $33,000 sales, food cost is 30.6%.

Why keep a food inventory

Counting at the same time each period and valuing at invoice cost gives a food cost percentage that can be compared week to week, which is how a restaurant notices waste, theft or a supplier price jump. Ending inventory is also needed to work out cost of goods sold on the business’s tax return.

Filled-in sample

Count Sun Feb 9, 10 pm, Rosa and Eddie, Taqueria Luna, San Antonio
Avocados Par 6 cases, on hand 2 at $42.00, value $84.00, order 4
Corn tortillas Par 10 cases, on hand 7 at $18.50, value $129.50, order 3
Chicken thighs Par 5 cases, on hand 3 at $76.00, value $228.00, order 2
Total, all areas $4,980.00
Food cost $5,210 opening + $8,340 purchases – $4,980 closing = $8,570; 31.1% of $27,600 sales
Order placed Mon Feb 10, 8 am

The food cost line uses this sheet’s closing total, $4,980, which only works because Sunday’s deliveries were put away before the count. Each order quantity is par minus count, so nobody reorders by feel.

Pitfalls to watch for

Edits most teams make to the food inventory

BarsCount open bottles in tenths or by weight, and keep beer kegs on their own sheet, since liquor cost is tracked apart from food.
Bakeries and pizza shopsCount flour, sugar and cheese by weight rather than by bag, since partial bags make up much of the stock.
Pro tipArrange the sheet in the exact order of your shelves, left to right and top to bottom. The counter never has to search the list, and nothing gets skipped.

Questions about the food inventory template

How often should we count?

Weekly is common; high-value items can be daily.

What is par level?

The amount you want on hand between deliveries.

How do I find food cost?

(Opening + purchases − closing) ÷ sales.

Should counting be paid time?

Yes.

Should inventory be valued at the latest invoice price or an average cost?

Using the latest invoice price is simple and close enough for most restaurants. What matters most is using the same method every count, so food cost moves because of usage and not because the valuation changed. Note the method at the top of the sheet.

How do I count prepped items like sauces and marinades?

Either value them at their ingredient cost or leave them off and count only raw stock, but choose one and stick to it. Kitchens that prep heavily on Sunday will see swings in food cost if the rule changes from week to week.

Useful next reads

More for the same job

More on this topic

Paperless forms and e-signatures

EZTime’s digital HR forms collect e-signatures and keep the signed copy in the employee’s digital file, with reminders before a document expires. Book a demo if you want a walkthrough.

General information to adapt to your business. Examples on this page are fictional.