A restaurant food cost spreadsheet does one job: it shows you the gap between what your recipes say a plate should cost and what your inventory says it actually cost. That gap is where your money goes. This is the template I ran for 20 years, the four numbers it forces you to see, and the weekly routine that turns it from a file you ignore into decisions you make.
Most operators do not have a food cost problem. They have a food cost visibility problem. They know roughly what they spend and roughly what they sell, and the word "roughly" is where a working restaurant quietly bleeds out.
I ran Grumpy Schnitzel, a seasonal concept in Dawson City, Yukon, on a spreadsheet. Not software. A spreadsheet I filled in by hand every week, because the discipline of touching the numbers is the whole point. When you type in the closing inventory yourself, you cannot lie to yourself about the walk-in.
Here is what that sheet is, and how to run it.
What a Food Cost Spreadsheet Actually Contains
Forget the fancy dashboards for a second. A food cost spreadsheet that works has three linked tabs. That is it. If a template has forty tabs, it was built to look impressive, not to be used at 11pm after close.
The Three Tabs
1. Recipe costing. Every menu item broken into its ingredients, each one yield-adjusted. A 5kg case of beef that trims down to 3.6kg of usable portion does not cost you the case price per kilo — it costs the case price divided by 3.6. Miss the yield and every plate cost is a fiction. This tab gives you your true plate cost.
2. Weekly inventory. Opening count, purchases, closing count, for every category. This tab tells you what you actually used — not what you bought.
3. Variance. This tab compares theoretical (what the recipes say you should have spent, given what sold) against actual (what inventory says you did spend). The difference is the leak.
You can build these three tabs in Google Sheets this afternoon for free. The structure below is the whole thing. If you would rather not build it from scratch, the Operator's Toolkit is eight of these calculators already wired together — recipe costing, prime cost, waste, par levels — the same structure I used at Grumpy Schnitzel, without the afternoon of formula-building.
The Four Numbers the Spreadsheet Forces You to See
A food cost spreadsheet is only worth the time if it produces these four numbers. Everything else is decoration.
1. Plate Cost (Yield-Adjusted)
The true cost to produce one serving of a dish, after trim, cook loss, and waste. Not the raw ingredient cost — the real cost of what lands on the plate. Get this wrong and your menu pricing is guesswork sitting on top of a mistake.
2. Food Cost Percentage
Food Cost Percentage Formula
Food Cost % = ((Opening Inventory + Purchases − Closing Inventory) / Food Sales) x 100The middle of that formula — opening plus purchases minus closing — is your cost of goods sold: what you actually consumed. A commonly cited target for a full-service independent is 28–35%. But the benchmark matters less than your own trend. A restaurant holding a steady 34% is healthier than one bouncing between 26% and 39%.
3. Theoretical vs Actual
Theoretical food cost is what your recipe costing tab says you should have spent, based on exactly what sold that week. Actual is what your inventory count says you did spend. When actual is higher than theoretical — and it almost always is — the difference has a cause: waste, over-portioning, unrecorded comps, or theft. The spreadsheet does not tell you which. It tells you how much, and points you at the category to go investigate.
4. Food Cost Variance
The change in that theoretical-vs-actual gap week over week. This is the number that tells you whether a fix held. You tightened portioning on the schnitzel last week? The variance on that category should shrink this week. If it did not, the fix did not take. Variance is how you know the difference between doing something and changing something.
How to Run It Every Week (15 Minutes)
The spreadsheet is worthless if you fill it in once and admire it. It is a weekly instrument. Monthly is too slow — by the time a monthly number shows you a problem, you have lost four weeks of margin you are never getting back. Here is the routine:
- Count opening and closing inventory. A real physical count — shelf, walk-in, freezer. Same day, same time each week. Estimates defeat the entire exercise.
- Enter every purchase. All food invoices for the week, including the emergency grocery-store run at 4pm on Saturday. Everything that came in the door.
- Read your actual food cost. Opening plus purchases minus closing, divided by food sales. The sheet does the math. You read the number.
- Compare actual to theoretical. The variance tab shows the gap. This is the only number that tells you where you are leaking.
- Act on the single largest variance. Not all of them. The worst one. Fix that this week. Next week, the next worst. That is how a restaurant gets tight — one category at a time, not one heroic overhaul that never happens.
"The sheet does not fix anything. It just removes your ability to pretend you do not know where the money is going."
What Grumpy Schnitzel Proved About the Number
Across the Grumpy Schnitzel season, the food cost number moved in a way that told a story a single snapshot never could.
Grumpy Schnitzel — Verified Season Food Cost
May (ramp-up): Food cost 36%
July (peak volume): Food cost 28%
Season blended: Food cost 33.7%
Eight points of food cost came off between May and July. Not because ingredients got cheaper — they did not. Because the systems tightened as volume rose: portioning locked in, prep sheets tuned to actual demand, waste driven down. The spreadsheet is what made that visible week to week. Without it, May's 36% would have just felt like "a slow start" instead of a number to attack.
That is the difference between watching food cost and running it. Watching it, you notice it is high. Running it on a weekly sheet, you see which category is high, you see whether last week's fix worked, and you make the next decision on evidence instead of mood.
Where Operators Get the Spreadsheet Wrong
Three mistakes turn a food cost spreadsheet into a comfortable lie. All three make the number look better than reality.
1. Costing by Invoice Instead of by Usage
Cost of goods sold is what you used, not what you bought. Skip the inventory count and just total your invoices, and a heavy purchasing week makes your food cost look terrible while a light one makes it look great — neither reflecting what actually happened on the plate. The inventory count is the non-negotiable part. It is also the part everyone wants to skip.
2. Ignoring Yield on the Recipe Tab
If your plate costs use raw purchase weights instead of usable, trimmed, cooked yields, every plate cost is understated — often by 15 to 30 percent on proteins. Your menu looks more profitable on paper than it is in the till. Yield is where recipe costing either becomes real or becomes decoration.
3. Never Comparing Theoretical to Actual
Plenty of operators calculate a food cost percentage and stop there. But a single percentage cannot tell you why. Without the theoretical-vs-actual comparison, you know you have a leak but not where. That comparison is the entire reason the spreadsheet is worth building. Skip it and you have a fuel gauge with no map.
When a Spreadsheet Stops Being Enough
A food cost spreadsheet will find your leak and help you close it. For most independents, that is the whole job, and they never need anything more expensive. Be honest with yourself before you buy software: the spreadsheet is not the constraint — the weekly discipline is, and software does not fix discipline.
Where the spreadsheet reaches its limit is menu-wide decisions. When you want to see every item plotted by profitability against popularity — which dishes to promote, reprice, or cut — a sheet gets clumsy. That is menu engineering, and it is worth a dedicated tool. When you get there, the 72-Hour Profit Sprint is the guided version of exactly this work: find the leak, cost the menu, and leave with the fixes prioritized — in a weekend, not a quarter.
But start with the sheet. Build the three tabs. Run them weekly. The operators who control food cost are not the ones with the best software. They are the ones who actually count the walk-in every Sunday.
Frequently Asked Questions
What Should a Restaurant Food Cost Spreadsheet Include?
A working food cost spreadsheet needs three linked tabs. A recipe costing tab that breaks every menu item into its ingredients, yield-adjusted, for a true plate cost. A weekly inventory tab that records opening count, purchases, and closing count so you calculate what you actually used, not what you bought. And a variance tab that compares theoretical food cost against actual food cost. The gap between those two numbers is where the money leaks.
What Is the Formula for Food Cost Percentage?
Food cost percentage equals cost of goods sold divided by food sales, times 100. Cost of goods sold is opening inventory plus purchases minus closing inventory. So the full formula is: ((Opening Inventory + Purchases − Closing Inventory) / Food Sales) x 100. A commonly cited target for a full-service independent is 28 to 35 percent, but your own trend week over week matters more than any generic benchmark.
Do I Need Food Cost Software or Is a Spreadsheet Enough?
A spreadsheet is enough to find the leak and control it, and it costs nothing to build. It forces you to touch the numbers by hand, which is where the understanding comes from. Software saves time once your volume is high and your menu changes often. Start with the spreadsheet. Move to software when the manual entry becomes the bottleneck — not before. Most independents never actually need the software to fix the problem.
