Why Excel no longer cuts it for your restaurant admin
Stock, supplier orders, food cost and the staff rota: in many restaurants, it all lives in separate spreadsheets that nobody updates consistently. As long as things run smoothly, that goes unnoticed, but on a busy night you immediately feel what it costs when nobody's sure which file is the latest one. In this article you'll read where Excel breaks down in practice for a restaurant, and what changes once you bring those separate files together.
Where it goes wrong: four files that don't talk to each other
A stock list, a template for ordering from suppliers, a spreadsheet for food cost per dish, and a rota in a separate tab: in most restaurants, these are four different files, kept up to date by different people at different times. As long as things run smoothly, that goes unnoticed. It's only on a busy night, when the chef wants to know if there's enough stock left while the owner is trying to finish next week's rota at the same time, that you notice nobody's sure which file is actually the latest one.
The problem isn't Excel itself, it can calculate perfectly well. The problem is that separate files know nothing about each other: a change in the stock list doesn't automatically update the order list, and an adjusted rota doesn't automatically show up for whoever's scheduled that night.
Stock and orders: two lists, one reality
If you keep stock in one file and order through another, someone has to manually retype what's left into what needs ordering. Forget that once, and you order too much of one product and too little of another, and you only notice once the delivery arrives. On a busy weekend, that's the difference between simply serving a dish or having to strike it off the menu because an ingredient has run out.
Food cost that's only right after the fact
A food cost spreadsheet is only as good as the last time someone updated the purchase prices in it. If a supplier changes prices in between, you keep calculating with a cost price that's out of date for weeks, while your selling price on the menu stays exactly the same. Your margin quietly drops, without any signal going off anywhere.
The rota as an isolated island
A rota that's disconnected from how busy you expect a shift to be is mostly guesswork. You schedule by feel instead of based on what's actually coming in that evening in bookings and expected covers, and a last-minute sick call means someone has to go through the file by hand to make everything add up again.
- Stock and the order list are disconnected, so you type the same numbers in twice.
- Food cost calculates with purchase prices nobody updates consistently.
- The rota gets adjusted by hand for every change, instead of moving automatically.
What changes once it comes together
Once stock, orders, food cost and staff sit in one place, nobody has to remember which file is the latest anymore. A change in stock automatically feeds through into what you still need to order, an updated purchase price immediately updates your food cost per dish, and the rota accounts for what's actually planned that day. That's not a matter of working harder with Excel, it's choosing something that already lets those four things talk to each other.
Excel isn't the problem as a tool, it's the problem when it's the only place your entire restaurant admin leans on. Once stock, purchasing, food cost and staff start drifting apart, that costs you more time every week than it saves.
Frequently asked questions
Is Excel inherently bad for a restaurant?
No, Excel calculates perfectly well. The problem starts when stock, orders, food cost and staff sit in separate files that don't automatically update each other, so you have to remember yourself which file is current.
When do you actually notice separate Excel files are a problem?
Usually only on a busy shift, when several people need something at once from a file someone else has just changed. During a quiet stretch, it barely shows.
How do I keep my food cost calculation up to date?
By updating purchase prices in one place as soon as a supplier changes them, instead of in a separate file nobody consistently checks. That way you're not calculating with an outdated cost price for weeks.
Do I have to move everything out of Excel at once?
No. Start with whatever's causing the most errors or double work right now, stock and orders for example, and expand from there into food cost and staff.
Finally get stock, purchasing, food cost and staff in one place? That's what Catermonkey is for.
Start free