Your spreadsheet doesn’t know what your dishes cost

Ask most operators what their best-selling main costs to put on the plate and you’ll get a confident number. Ask when they last checked it against a supplier invoice, and the confidence drains out of the room.

It isn’t carelessness — it’s the tool. A recipe costed in a spreadsheet is a photograph: accurate the moment you took it, and slowly wrong from then on. Every price on it was true on some Tuesday months ago. Since then your fishmonger has moved twice, butter is up across the board, and the “€3.10 per kg” you typed in is now €3.74. The spreadsheet doesn’t know. It shows you the same margin it always has — right up until month-end tells you a different story.

A recipe cost is a live number pretending to be a static one

A plate of food is assembled from a dozen prices, and not one of them holds still. Wholesale meat and fish move weekly. Dairy and oil swing with commodity markets. Produce is seasonal by definition. The moment you save a recipe, the clock starts — and a spreadsheet has no way to tell you how far the real number has drifted from the one on the screen.

So the cost you’re pricing against, staffing against and reporting against is a figure you last verified… when, exactly? For most kitchens the honest answer is “when we wrote the menu.”

The three ways pen and paper hides the truth

1. Prices update; your recipes don’t

When a supplier raises a line item, that increase should ripple through every recipe that uses it. On paper, nobody re-opens forty recipe cards to change one ingredient. So the increase just… sits in the invoice folder — real, but invisible — until you notice the margin’s gone at the end of the quarter.

2. The best-sellers are the ones that hurt

A 40-cent cost creep on a dish you sell twice a week is a rounding error. The same creep on the dish you sell 200 times a week is €80 off your margin, every week — and it looks identical on the plate. Spreadsheets treat every recipe the same. They don’t weight the drift by how often you actually sell the thing.

3. You find out at month-end, when it’s already spent

The classic loop: cook all month, add up the invoices, compare to sales, discover food cost ran at 34% instead of 29%. By then the money is gone and the month is closed. You can resolve to “watch it” next month — with the same tools that hid it this month.

A spreadsheet will happily show you a 68% margin on a dish that’s actually running at 61%. It isn’t lying. It just answered a question about last spring.

“We’ll just update it more often”

Every operator has tried this. Block out a morning, re-cost the menu, feel good for a week. But re-costing by hand is exactly the kind of job that loses to a busy service, a covering shift and a broken glasswasher. It’s important and never urgent, so it slips — and a costing that’s only right one week a quarter is barely better than one that’s never right.

The problem was never discipline. It’s that the work scales with your supplier count and your menu size — and both of those only grow.

What “live costing” actually means

The fix isn’t a fancier spreadsheet. It’s closing the loop between the invoice and the recipe, so the number maintains itself.

When an invoice arrives — photographed, uploaded, or forwarded straight from your supplier’s email — the price on it should update the ingredient it belongs to, and every recipe that ingredient touches should re-cost on the spot. No morning blocked out. No forty cards re-opened. The margin you see on a dish is the margin as of this week’s prices, weighted by what you actually sell. That’s the whole idea behind how ShiftPlate handles costing:

• ✓Invoices set the price. OCR reads each line item and matches it to your ingredients, so the recorded cost is what you were actually charged — not what you typed in once.
• ✓A price change cascades. Update one ingredient and every recipe using it recalculates automatically, so a supplier increase shows up as a margin change the same day, not the same quarter.
• ✓Margin is ranked by menu mix. Sales from your POS weight the picture, so the dishes quietly costing you the most float to the top instead of hiding in an average.
• ✓You can just ask. “Which dishes are below target margin?” is a question Pepper answers in plain language, off live numbers — no export, no pivot table.

The point isn’t the spreadsheet. It’s the blind spot.

Spreadsheets are wonderful. They’re also a snapshot — and a restaurant is a live system. The gap between “what this cost when I wrote it down” and “what it costs tonight” is exactly where margin leaks: quietly, at the price of a busy service and a menu that never stops moving.

You don’t need to work harder at the costing. You need the costing to keep up with the kitchen on its own.