Operations & Staffing
Inventory Tracking Template
A restaurant inventory spreadsheet organized by storage area, in shelf order, with par levels and unit costs. Enter the count and it tells you what to reorder and what your stock is worth, ready to drop into the food cost calculator.
The Copper Skillet
Inventory Count Sheet — Monday, August 24, 2026
Counted by: ______________________ Date / time: ______________________
Pre-filled with 21 common items and 2026 wholesale prices for a full-service restaurant. Edit any cell, add your own items, or collapse an area. Reorder quantity and value on hand update as you type.
Count Summary
Total Inventory Value
$1,639.45
Items Below Par
16
of 21 items tracked
Storage Areas
4
Value by Storage Area
Reorder = par minus on hand (never below zero). Value = on hand × unit cost. Red numbers mean the item is below par and belongs on this week's order.
What Is an Inventory Tracking Template?
An inventory tracking template is a count sheet that lists every product you stock, where it lives, how much you want on hand (par), how much is actually there, and what it is worth. Multiply the count by unit cost and you have the dollar value sitting in your walk-in and dry storage. That number feeds your food cost formula and tells you what to order. Without it you are guessing at both.
A restaurant doing $80K a month in sales at 30% food cost buys roughly $24K of product every month. A weekly count is the only way to know how much of that is still on the shelf and how much walked out as waste, theft, or over-portioning.
How to Use This Template
- 1Enter your restaurant name and the count date at the top
- 2Rename the four storage areas or add rows so every item you buy has a line, in shelf order
- 3Set a par level and unit cost for each item (use your latest invoice for cost)
- 4Print the sheet, walk the storage areas, and write the on-hand count next to each item
- 5Type the counts back in. Red reorder numbers are this week's order list
- 6Copy the totals into your food cost worksheet so ending inventory is ready for the formula
How to Run a Weekly Inventory Count
Count on the same day, at the same time, every week. Most kitchens pick Sunday night after close or Monday morning before deliveries, when stock is lowest and nothing is moving. Same person, same order, same units. Consistency matters more than speed.
Sheet-to-shelf
Read the sheet, then hunt for the item
Slow. The counter walks back and forth, skips items that moved shelves, and double-counts product split between the walk-in and the line.
Shelf-to-sheet (use this)
Walk the shelf, then find the line
The sheet is ordered the way the storage area is organized: top shelf to bottom, left to right. You never backtrack, and anything on a shelf that is not on the sheet gets caught immediately.
That is why the rows in this template are grouped by storage area rather than by food category. Reorder the rows to match your actual shelves. If proteins sit on the bottom shelf of the walk-in (they should, per FDA Food Code storage order), list them last in that group. Pair the count with your cleaning checklist so the walk-in gets wiped down and reorganized the same night it gets counted.
Setting Par Levels
Par is the amount you need on hand right after a delivery to make it to the next one without running out. It is not a round number you pick because it feels safe. Work it from usage:
Par = (daily usage × days until next delivery) + safety stock
Safety stock is usually 20 to 30% of expected usage, higher for items with one supplier or a long lead time.
| Worked example: chicken breast | Value |
|---|---|
| Average daily usage (from last 4 weeks of counts) | 14 lb |
| Days between deliveries (Tue / Fri schedule) | 4 days |
| Base need: 14 × 4 | 56 lb |
| Safety stock at 25% | +14 lb |
| Par level | 70 lb |
| Counted on hand Monday night | 38 lb |
| Reorder quantity (par − on hand) | 32 lb |
Revisit pars every quarter and any time the menu changes. A par set in January for a soup that came off the menu in May is dead money on the shelf. Behind the bar, run the same math per bottle and check the result against your pour cost. If pour cost is climbing while pars stay flat, product is leaving without being rung in.
Where Inventory Fits in Food Cost
Your ending inventory from one count is the beginning inventory for the next period. The difference between what you had, what you bought, and what is left is what you actually used. That is your cost of goods sold, and it is the top line of every food cost calculation.
Using the pre-filled sheet, ending inventory is about $1,640. If last week's count was $2,100 and you bought $6,200 in between, you used $6,660 of product. Divide that by the week's food sales in the food cost calculator and you have an actual food cost percentage, not the theoretical one from your recipe cards. The gap between actual and theoretical is the leak. The full walkthrough is in the food cost formula guide.
A count is only as good as the unit cost next to it. Update costs from the most recent invoice, not the price list from last quarter. Beef and eggs have moved enough in the past two years to swing a weekly inventory value by hundreds of dollars.
FIFO Labeling Basics
First in, first out. New product goes behind or under old product so the oldest gets used first. It sounds obvious, and it fails in most kitchens for one reason: nobody can tell which case is older. Fix that with labels, not reminders.
Date every item on arrival
Received date on the case, in marker, before it hits the shelf. Opened date on anything you break down.
Rotate at delivery, not at count
The person putting away the order pulls old stock forward. If it waits until inventory night, it is already too late.
Use-by on prepped product
Day-dot or tape every hotel pan and deli container. Prepped items get counted too, at their recipe cost.
FIFO is also what a health inspector expects to see. The FDA Food Code requires date-marking on ready-to-eat, time/temperature control for safety foods held longer than 24 hours, and a walk-in with clear dates passes that check without discussion. Put the labeling rule in your receiving SOP so it survives staff turnover.
5 Signs Your Inventory Is Leaking
The count sheet does not stop shrinkage by itself. It shows you where to look. These are the patterns operators see most often.
Actual food cost runs 3+ points above theoretical
Recipe cards say 29%, the count says 33%. Four points on $80K in monthly sales is $3,200 a month gone. Anything past 2 points deserves a line-by-line look.
High-value items miss par by more than usage explains
Shrimp, steaks, and top-shelf liquor vanish faster than sales tickets account for. Compare units sold in the POS to units used on the sheet. A gap on the same items week after week is theft, not a counting error.
Waste log and count sheet disagree
If the count says 20 lb of produce disappeared and the waste log shows 4 lb, the other 16 lb went somewhere. Industry studies put restaurant food waste at 4 to 10% of food purchased. Above that, tighten prep pars and FIFO.
Usage per cover keeps climbing
Divide pounds of protein used by entrees sold. If the number creeps up while the menu is unchanged, cooks are over-portioning. Put a scale on the line and spot-check plates for a week.
Invoices and deliveries do not match the count
Short cases, substituted brands, and wrong weights show up as inventory that was paid for but never counted. Check every delivery against the invoice before it goes on the shelf.
Spreadsheet vs. Inventory Software
Honest take: a spreadsheet like this one is enough for most single-unit restaurants with under 150 SKUs and one person doing the ordering. It costs nothing, everyone can read it, and it forces you to actually walk the shelves.
| Stay on a spreadsheet if | Move to software when |
|---|---|
| One location, one buyer | Two or more locations, or a GM and a chef both ordering |
| Under ~150 items on the count | Counts take more than 90 minutes a week |
| Food cost is within 2 points of theoretical | You need recipe-level variance reports to find the leak |
| Invoices are entered by hand once a week | You want invoice scanning and automatic cost updates |
| Vendor orders are a phone call or email | You want the count to generate purchase orders |
Software typically costs a few hundred dollars a month per location and only pays for itself if someone maintains it. If nobody on your team counts consistently with a spreadsheet, they will not count consistently with an app either. Get the habit first. Then upgrade when the sheet becomes the bottleneck, not before.
Related Tools & Guides
Food Cost Calculator
Turn your beginning and ending inventory into an actual food cost percentage
Food Cost Formula Guide
Every formula operators use, with worked examples and benchmarks
Recipe Cost Calculator
Build theoretical cost per dish to compare against your counts
Pour Cost Calculator
Check bar inventory usage against liquor sales
Restaurant SOP Template
Write the counting and receiving procedure so every manager does it the same way