Inventory
Restaurant Inventory Spreadsheet: A Count Sheet Layout and When to Outgrow It
A good inventory spreadsheet is a count sheet in walking order with a few simple formulas. Here is the layout, and how to tell when it has stopped being enough.
By ChefMind AI Team · · 6 min read
A spreadsheet is a perfectly good way to start controlling inventory. It is free, flexible and everyone already knows how to open one. The trouble comes later, when it becomes the thing nobody trusts. This guide covers the layout that keeps a sheet useful, and the signs that you have outgrown it.
This is a layout you can copy into Excel or Google Sheets; there is no file to download. Figures are illustrative examples.
The count sheet layout
Use one row per item and these columns:
| Column | What goes in it |
|---|---|
| Item | Name as it appears on your invoice, so matching is easy |
| Location | Walk-in, dry storage, freezer, bar |
| Counting unit | The unit you count in: kg, case, each, litre |
| Pack size | Units per case, if you buy by the case |
| Par | The level you want on hand after a delivery |
| On hand | What you counted |
| Order qty | Par minus on hand, if above zero |
| Unit cost | Latest invoice price per counting unit |
| Value | On hand times unit cost |
See how to set par levels for the par column.
Example rows
| Item | Location | Unit | Par | On hand | Order | Unit cost | Value |
|---|---|---|---|---|---|---|---|
| Chicken thighs | Walk-in | kg | 40 | 22 | 18 | $7.50 | $165.00 |
| Romaine | Walk-in | case | 3 | 1 | 2 | $38.00 | $38.00 |
| Olive oil | Dry | litre | 20 | 14 | 6 | $10.00 | $140.00 |
The formulas are short. Order quantity is Par minus On hand, with a floor of zero. Value is On hand times Unit cost. Subtotals by location and category give you the numbers you need for food cost.
Rules that make the sheet trustworthy
- List items in walking order, not alphabetically. One pass, nothing missed.
- Count in one unit per item, and always the same one.
- Count at the same time each period, ideally after close, so deliveries and service do not move the numbers.
- Use the same one or two counters. Different counters see different things.
- Count opened items honestly: by weight, by fraction of a container, or by a defined rule.
- Update unit cost from each new invoice, and record the date it changed.
- Keep one master copy. Five versions named final-v2 are how errors breed.
Five signs you have outgrown the spreadsheet
- Counting takes longer than you can spare each week, so counts get skipped.
- Unit costs are out of date, so inventory value and recipe costs are wrong.
- You cannot see how an ingredient's price has moved without digging through old invoices.
- Recipes and inventory live in different files, so costing is manual.
- Nobody trusts the numbers, which means nobody acts on them.
If two or more are true, the sheet is costing you more than it saves.
Where software can help
Software does not replace the discipline of counting, but it can keep quantities, costs and expiration dates in one place. ChefMind AI's inventory tools track ingredient quantities, par levels and expiration dates, and its invoice reading can bring invoice prices into your records. The guide to inventory management explains the full system.
The short version
- A good sheet is item, location, unit, par, on hand, order, cost, value.
- List in walking order and count the same way every time.
- Update costs from invoices and keep one master file.
- Move on when counts are skipped, costs are stale or nobody trusts the numbers.
Frequently asked questions
What columns should a restaurant inventory spreadsheet have?
At minimum: item, storage location, counting unit, pack size, par level, quantity on hand, unit cost, and value. Add an order quantity column if you use the sheet to build orders.
Should I list items alphabetically?
No. List them in the order you walk through each storage area, so counting is a single pass and nothing is missed.
How often should I count?
Weekly for the full count is a common routine, with a faster check on high-cost or fast-moving items between counts. Choose a rhythm you can actually keep.
Keep reading
Inventory
Restaurant Inventory Management: A Practical Guide for Busy Kitchens
A simple inventory routine for a busy kitchen: how to count, how to set par levels around your delivery schedule, and how to spot variance before it costs you.
Inventory
How to Set Par Levels in a Restaurant
Par is usage until the next delivery plus a safety cushion. Measure real usage, set pars around your delivery days, and review them when demand changes.
Inventory
A Restaurant Food Waste Log You Will Actually Use
A waste log works when it takes ten seconds. Record what, how much, why and what it cost, then review the top reasons once a week.
Newsletter
Practical kitchen operations, now and then
New articles on food cost, inventory and purchasing. No spam, and you can unsubscribe at any time.