In this article
Introduction
Monday morning. You open the fridge and realise something you need for lunch is missing. You don’t know when it ran out. You don’t know how often it has happened in the last few months. And you have no data to tell you whether you’re spending too much or too little with your suppliers. It happens to almost every restaurant owner, especially at the start. The good news is that there’s a simple way to bring order — it’s called a stock count, and a restaurant inventory system makes it part of every day. In this guide we explain how to do it step by step, with a template ready to use.
Quick answer
How to take restaurant inventory correctly: use a 6-column template (product, unit, quantity, cost, value, expiry date), check fresh products every 1–2 days, drinks every week and dry goods every month. At the end of each count, calculate the inventory variance — compare what you used with what you sold. If the numbers don’t match, you’re losing margin somewhere.
What a stock count is and why every restaurant needs one
Let’s start from the beginning, without jargon.
A stock count simply means knowing what you have in storage at a given moment. How much meat is in the fridge. How many bottles of wine are left. How much flour is in the pantry.
It sounds obvious. But without this information you can’t know how much you’re really spending. You can’t plan purchases precisely. And you can’t calculate your food cost correctly.
In short: learning how to take restaurant inventory is one of the first things to master if you want to keep costs under control — and one of the most neglected.
A well-run inventory isn’t paperwork. It’s a real management tool — it tells you exactly where you’re making money and where you’re losing it, ingredient by ingredient.
How often to take restaurant inventory: the right frequency for each product
There isn’t one right frequency. It depends on the type of product.
A full inventory every day is impossible. Never doing one is an expensive mistake. The answer is a different frequency for each product category.
| Category | Examples | Recommended frequency | Why |
|---|---|---|---|
| Fresh products | Meat, fish, dairy, vegetables | Every 1–2 days | They expire quickly, high risk of waste |
| Drinks | Wine, beer, water, soft drinks | Weekly | Fast turnover, easy to count |
| Dry goods | Pasta, flour, rice, oil, spices | Monthly | Long shelf life, slow turnover |
| Non-food supplies | Paper, detergents, packaging | Monthly | Non-perishable, easy to manage |
The best moment for the full monthly inventory? The day before your weekly order to suppliers. There’s less to count — stock is at its lowest — and the figures you get are immediately useful for deciding what to order.
Tip: many restaurants take inventory between lunch and dinner service. It works well because the restaurant is empty, staff are available and the figures are fresh.
How to take restaurant inventory: a step-by-step guide
Nothing complicated. Six steps are enough.
Organise the storeroom before you count
Before you start counting, tidy up. Group products by category: fresh with fresh, dry with dry, drinks with drinks. If the storeroom is chaos, the count will be wrong.
Use the FIFO method (First In, First Out): products that arrived first go at the front, new ones at the back. That way the oldest products are always in front during the count — and you know straight away which to use first. To learn more about FIFO, read our article on how to reduce food waste in restaurants.
Prepare the inventory template
Open a spreadsheet. Create the columns you need (see the template below). Nothing complicated is needed: 6 basic columns are more than enough to start.
If the restaurant has several storage areas — fridge, pantry, cellar, bar — create a separate sheet for each area. It’s much faster to fill in and much easier to update.
Count everything — physically, without relying on memory
Count every product by hand. Don’t trust what you think you have. Don’t trust the last order. Count.
Use the same units every time: kg, litres, pieces, packs. Don’t mix different units for the same product — it creates confusion and wrong data.
Done properly, this step takes 1–2 hours a week for fresh products alone. That’s exactly why most restaurant owners skip it — and end up finding shortages in the middle of service.
Practical tip: give the count to two people — one counts, the other writes. It reduces mistakes and goes faster. Giving staff specific roles in the storeroom makes the inventory more accurate.
Record the figures in the template
Enter the figures in the template as you count. Don’t wait until you’ve finished everything to write them down: you risk forgetting numbers or mixing them up.
For each product, note: name, quantity counted, unit, unit cost (from the supplier’s latest invoice), total value (quantity × cost) and expiry date where relevant.
If supplier prices change and you don’t update the sheet, the stock value you calculate is wrong. Small mistakes here multiply over the months.
Calculate the inventory variance
This is the step almost no restaurant owner takes — and the one that makes all the difference.
The inventory variance tells you whether what you used matches what you sold. If it doesn’t, there’s a loss: from waste, oversized portions or — in the worst cases — theft.
Compare actual usage with what you sold, from your sales data. If the two numbers don’t match, something has been lost — and you need to find out where.
Doing this calculation by hand needs accurate figures from three different sources — stock, purchases and sales. If one of the three is approximate, the result is worthless. This is where many restaurant owners give up.
Use the figures to plan purchases
Inventory on its own is useless if you don’t use it to decide what to buy.
After each count, compare current stock with average usage over the last few weeks. Order only what you really need to cover the period until the next order. No more.
This link between inventory and purchasing is at the heart of precise stock control in a restaurant. It replaces buying out of habit, and swaps intuition for data.
Tired of counting stock by hand every week?
Kappino updates stock automatically with every order completed. No more manual counts, no more spreadsheets to update.
The restaurant inventory template: ready to use
Here is the basic template you can use right away — in a spreadsheet or on paper.
Copy the columns, add them to your file and start filling it in. You can customise it by adding columns for the supplier, the category or the minimum reorder quantity.
| Product | Category | Unit | Qty in stock | Unit cost | Total value | Expiry | Notes |
|---|---|---|---|---|---|---|---|
| Beef fillet | Fresh meat | kg | 3.5 | €22.00 | €77.00 | 13/06 | — |
| Rigatoni pasta | Dry goods | kg | 8.0 | €1.80 | €14.40 | 12/2027 | — |
| Red wine (house) | Drinks | bottles | 24 | €4.50 | €108.00 | — | — |
| Fior di latte mozzarella | Dairy | kg | 2.0 | €9.00 | €18.00 | 12/06 | Use today |
| Extra virgin olive oil | Dry goods | litres | 5.5 | €7.00 | €38.50 | 06/2027 | — |
| + add all your products here… |
Recommended total row: add a row at the bottom that adds up all the total values → you get the overall value of your stock. Compare it month by month to see whether you’re buying too much or too little.
How to use the template effectively
Filling it in isn’t enough. You have to use it well.
- Sort products by category — not alphabetically. That way, during the physical count, you follow the same order as the storeroom.
- Always use the same units every month. Switching from kg to grams halfway through the year makes the data unusable.
- Add a "minimum stock" column — when the quantity drops below that number, you order. Every time.
- Compare each month with the previous one to see how usage changes over time.
Restaurant inventory in a spreadsheet or with a digital tool?
A spreadsheet template works well to start with. It costs nothing, takes an hour to set up and gives you a structure straight away.
It has one limit: you have to update it by hand every time something goes in or out of the storeroom. Skip a day and the figures no longer add up. If a different person updates it every week, the formats change and comparisons become impossible.
If you want to know what to look for in a more structured tool for restaurant inventory management, you’ll find all the details on the dedicated page.
The most common restaurant inventory mistakes (and how to avoid them)
Taking inventory the wrong way is almost worse than not taking it at all. Here are the most common mistakes restaurant owners make.
- Doing it too rarely. Once every three months is useless. The data is old and the money is already lost.
- Using different units. One month in kg, the next in pieces. Comparison becomes impossible.
- Not involving the team. If only the owner takes inventory, it becomes a bottleneck. Give staff specific roles.
- Never calculating the inventory variance. Counting stock without comparing it with sales is a pointless count.
- Not updating supplier prices. If costs change and the template doesn’t, the stock value is wrong.
Restaurant inventory and food cost: the link that changes everything
Inventory isn’t an isolated task. It’s at the heart of cost control in your restaurant.
Without an accurate inventory, you can’t calculate your real food cost. Without your real food cost, you don’t know which dishes make you money and which lose it. And without that, you can’t manage your menu properly.
The link is direct:
- Accurate inventory → measurable real usage
- Real usage → food cost per dish you can calculate
- Food cost per dish → informed menu decisions
- Informed menu decisions → growing margins
💡 The key point: a well-run restaurant inventory isn’t a formality. It’s a management tool. The more accurate and regular it is, the more the decisions you make every day — from menu to purchasing, from portions to prices — rest on real data instead of impressions.
