Restaurant inventory management accounts for 30% of your revenue
In a typical restaurant, raw ingredients usually account for 28% to 35% of turnover. It is the second largest cost after wages. Two points shaved off that ratio is often the equivalent of your entire net profit for the year.
Those two points don't come from squeezing your suppliers harder. They come from what ends up in the bin, from quantities ordered blind, and from the gap between what you buy and what you actually sell.
Sound restaurant management therefore rests on three repeated actions: count, measure waste, order accurately. Everything else is tooling. Software speeds the work up; it doesn't do it for you.
The classic trap is trying to track everything. On a 40-dish menu, you might hold 300 separate lines across your cellar and store room. A dozen or so items generally account for most of the value: meat, fish, cheese, alcohol. Start your controls there.
Running a reliable stocktake: the foundation of everything
Without a stocktake, no figure is usable. You know neither your waste, nor your real margin, nor the quantities you need for the week ahead. It's the first thing to put in place.
How often to count
The rhythm depends on how fast products turn over. Fresh goods get counted often, dry goods far less. One simple rule works in most establishments:
- Daily: meat, fish, opened dairy, the dish of the day.
- Weekly: fruit and vegetables, drinks, the base ingredients in your recipes.
- Monthly: dry goods, frozen items, consumables, the cellar.
Count in the right order
A stocktake always follows the same physical route: walk-in, store room, cellar, bar. You follow how the shelves are laid out, never the alphabetical order of a list. This halves counting time and stops things being missed.
Count in pairs, outside service, at a set time. One person calls out, the other writes down. And fix your units once and for all: butter in kilos or in blocks, never one or the other depending on who's counting.
The count sheet
An effective restaurant stocktake sheet fits on one page per area. It lists the item, the unit, the theoretical stock, the counted stock and a variance column. That last column is the one that teaches you something.
Measuring waste and cutting food waste
Food waste in commercial catering is estimated at around 13% of the food purchased, or roughly 100 to 150 grams per cover. At 60 covers a day, that's several thousand pounds a year thrown away in the kitchen.
The five causes of waste
Before looking for a fix, identify the cause. Each family of waste calls for a different answer.
- Expired use-by dates: a rotation problem and orders that are too big.
- Overproduction: prepared quantities exceed the portions sold.
- Inconsistent portions: no recipe cards, no weighing.
- Service errors: dishes sent back, breakages, till mistakes.
- Plate returns: the portion is too generous for your customers.
Put a waste log next to the bin in the wash-up. You note the product, the quantity and the cause, in ten seconds. After three weeks, you know where the real savings sit, and you can put a number on them.
In most kitchens, half the waste comes from just three products. Identifying them takes a month; fixing them takes a week.
Then apply first in, first out. Label every container with its opening date. And use products nearing the end of their life to build the dish of the day rather than discovering them out of date.
Ordering accurately: avoiding shortages without overstocking
Running out costs you twice: the lost sale and the impression left on the customer. Overstocking ties up your cash and often ends up in the skip. Purchasing lives between those two walls.
Working out your reorder point
For each significant item, set three levels: a minimum safety stock, a reorder point and a replenishment quantity. The reorder point equals average consumption over the delivery lead time, plus your safety margin.
A concrete example. You use 12 kg of beef fillet a week, your supplier delivers in two days, you hold 4 kg as safety stock. Your reorder point is therefore around 8 kg. Below that threshold, you order, no debate.
Managing your supplier relationships
Good purchasing rests as much on the relationship as on the price. Set specific delivery days, outside the rush, and check every delivery on arrival: weight, temperature, dates, match against the purchase order.
Keep two sources for each family of sensitive products. That protects you if one runs short and gives you a benchmark on your buying. Review rates twice a year, using your actual volumes as leverage.
When food cost climbs anyway, the answer isn't always to trim portions. A price rise planned around a calendar is usually healthier for your margin and better received in the dining room.
Spreadsheet or restaurant inventory software: how to choose
Plenty of operators start on a spreadsheet, and that's a fair choice. A restaurant stock file in Excel costs nothing and forces you to understand your own numbers. It hits its limits as soon as several people are entering data, or as soon as you open a second site.
| Criterion | Excel spreadsheet | Restaurant inventory software |
|---|---|---|
| Monthly cost | £0 | £30 to £150 per site |
| Stocktake time | 2 to 3 hrs per week | 30 to 45 min, entered on a tablet |
| Sales tracking | Manual re-entry | Deducted automatically from the till |
| Variances and waste | Calculated by hand | Automatic alerts and reports |
| Working as a team | Risk of overwriting the file | Access by role, full history kept |
| Multi-site | Unworkable beyond two | Built-in consolidation |
Switching usually makes sense at around £300,000 in turnover, or as soon as a second outlet opens. Below that, a well-kept spreadsheet is more than enough, provided it's filled in every week.
Automating: what software really brings
The value of a management tool isn't the dashboard. It's the link between your recipes, your tills and your stock. Every dish rung up deducts the matching ingredients, which lets you track available quantities in real time.
You then get the figure that matters: the gap between the theoretical stock derived from sales and the stock you counted. A 3% variance is normal. At 10%, there's a specific cause to find: portions, breakage, theft, or a wrong recipe card.
The genuinely useful features
- Costed recipe cards, with the portion cost updated every time a price changes.
- Threshold alerts to avoid running out on fast-moving items.
- Pre-filled purchase orders, sent to suppliers in one click.
- Date and waste tracking to cut waste month after month.
A restaurant management system really comes into its own when it's connected to the menu. If you run out mid-service, a QR code menu updates in seconds, whereas a printed menu stays wrong until the next print run.
Think about product information consistency too. When you change supplier on a stock or a sauce, the composition changes, and your allergen information has to follow the same day.
Training the team and keeping the routine going
The best software is useless if nobody fills in the waste log. Training the team is the most profitable part of the job, and the most neglected. Allow two 30-minute sessions, then a refresher a month later.
Appoint a stock lead per service, with a clear remit. One person signs off orders. One person takes deliveries. Responsibility shared by everyone is carried by no one.
Finally, set a standing appointment: 45 minutes every Monday to read the week's variances, adjust thresholds and prepare purchases. That hour saves you time on everything else and improves your financial decisions far more than an annual audit.
Your tracking indicators can come down to four: food cost as a percentage, stock value, waste rate, number of stockouts. If those four figures move in the right direction for three months, your management is in place. All that's left is fine-tuning.














