How to Use This Restaurant Inventory Template
Open the file in Excel or Google Sheets and list every ingredient you buy, grouped by category. For each item, fill in the unit of measure, the cost per unit, and a par level — the minimum quantity you want on hand between deliveries. Then, on a fixed day each week, count what you actually have and enter it in the count column. The template multiplies your count by unit cost to give you a running total inventory value and flags anything sitting below par so reordering takes seconds, not guesswork.
What Each Column Means
- Item & Category — what you are counting and where it lives, so counts stay organized by storage area.
- Unit & Cost per unit — the basis for valuing stock and, later, costing recipes.
- Par level — your reorder trigger; counts below par mean it is time to buy.
- Current count & Total value — what you have right now and what it is worth on the shelf.
Turn Your Counts Into a Food Cost Number
A spreadsheet tells you what you have; pairing it with your purchases tells you what you are spending. Once you have a beginning and ending inventory value, drop them into the food cost & waste calculator to see your food cost percentage, where money is leaking through waste and overstock, and how much you could save by tightening control. For the underlying math, see how to calculate food cost percentage.
If you run multiple locations, manage hundreds of items and recipes, or lose hours each week to manual counts and variance chasing, dedicated software usually pays for itself. Compare your options in our guide to the best restaurant inventory software and best food cost software.
FAQ
How do I use a restaurant inventory spreadsheet?
List every ingredient you buy, grouped by category, with its unit of measure and cost per unit. Set a par level (the minimum you want on hand) for each item, then count what you actually have on a fixed schedule — usually weekly. The template multiplies count by unit cost to show the total value of your inventory and flags anything below par so you know what to reorder.
How often should I count restaurant inventory?
Most operators do a full count weekly, on the same day and time, before a delivery. High-value or fast-moving items (proteins, liquor) are often spot-counted more frequently. Consistency matters more than frequency: counting at the same point in your order cycle every week is what makes your food cost numbers comparable from week to week.
What is a par level?
A par level is the minimum quantity of an item you want to have on hand to get through to your next delivery without running out or over-ordering. When a count drops below par, it is time to reorder. Good par levels reduce both stockouts and the overstock that leads to spoilage.
When should I move from a spreadsheet to inventory software?
A spreadsheet works well for a single small location with a simple menu. Once you run multiple locations, manage hundreds of items and recipes, need real-time theoretical-vs-actual variance, or spend hours each week on manual counts, dedicated inventory software usually pays for itself in reduced waste and labor.