Free Food & Beverage Cost Control Excel Spreadsheets
Why food and beverage cost control matters for restaurant profitability
Food cost and pour cost are two of the biggest levers on restaurant profitability, and both drift silently if nobody's tracking them recipe by recipe. A menu price that looked fine when you set it can quietly become unprofitable after a few supplier price increases if you're not re-costing dishes.
Most operators either guess at plate cost or rely on a single blended food-cost percentage from the P&L, which tells you something went wrong but not which dish caused it. Recipe-level costing is what lets you find the specific item that's bleeding margin.
What's inside the free food & beverage cost control spreadsheet
The workbook has two tabs. Recipe Costing is where you log ingredient lines — one row per ingredient per recipe, with quantity used, unit cost, and a yield percentage for the usable portion after trim or waste. Each line's cost calculates automatically, and a running recipe cost accumulates via SUMIFS as you add ingredients under the same recipe name.
Menu Margins is where you bring that plate cost together with what you charge. You copy the finished recipe cost over manually as the plate or pour cost, enter the menu price and a target cost percentage, and the sheet calculates the actual cost % and flags the dish as On target or OVER.
How to calculate recipe cost and target food cost %
Recipe cost per ingredient is quantity used times unit cost, divided by the yield percentage — so a $2 pound of tomatoes with a 90% yield after trimming costs more per usable pound than the raw price suggests. Add every ingredient in a recipe under the same recipe name and the sheet totals them into a running recipe cost.
Once you know the recipe's total cost, divide by your menu price to get actual cost percentage, and compare it to your target — typically 28-35% for food. If actual is under target, you're on track; if it's over, either the recipe needs re-costing or the menu price needs to move.
Tracking beverage cost separately from food cost
Beverages work through the same two tabs: cost each drink's pour(s) as ingredient lines in Recipe Costing, then bring the finished pour cost into Menu Margins with its own row, marked as Beverage instead of Food. That keeps beverage pour cost — typically targeted at 18-24% — visible separately from food cost rather than blended into one number.
Because both dishes and drinks flow through the same Menu Margins table, you get one dashboard showing every item's cost % side by side, whether it's a plate or a pour.
Spotting cost variance before it hurts your margin
The Status column in Menu Margins flags any dish or drink where actual cost percentage exceeds its target, so you can scan the sheet and immediately see what's over instead of recalculating every item by hand. The summary also shows how many items are currently flagged OVER and your average cost % across the whole list.
Because the plate cost is a manual copy from the finished recipe cost — not a live link — you do need to re-copy it after a recipe's ingredient costs change, which keeps the workflow simple but means it's on you to refresh Menu Margins after a supplier price update.
How to use it
- In Recipe Costing, add one row per ingredient per recipe with quantity used, unit cost, and yield %.
- Let the running recipe cost accumulate automatically as you add ingredients under the same recipe name.
- In Menu Margins, copy the finished recipe cost as the plate or pour cost, then enter menu price and target cost %.
- Scan the Status column for any dish or drink flagged OVER and adjust portioning, sourcing, or price.
Download the free Free Food & Beverage Cost Control Excel Spreadsheets
No spam — template updates and new free templates only. Unsubscribe anytime.
Inventory Tracker — Small Business
Once your recipes are costed, the paid Inventory Tracker ($14) keeps the ingredient side under control: stock levels, low-stock reorder flags and weighted-average cost per item feeding straight into your next recipe costing pass.
See the full versionFrequently asked questions
Can I use this in Google Sheets?
Yes. Upload the downloaded file to Google Drive, then open it and choose File > Save as Google Sheets. All the calculations keep working.
Is this spreadsheet really free?
Yes. You give an email address to download it, and then it's yours to use with no further cost.
Does the plate cost update automatically when I change a recipe?
The recipe's running cost in Recipe Costing updates automatically. The plate cost in Menu Margins is a manual copy from that number, so you need to re-copy it after you edit a recipe's ingredients.
How is this different from a general restaurant budget template?
A restaurant P&L or budget template tracks overall sales and expenses at a high level. This spreadsheet costs individual recipes and drinks down to the ingredient line — it's for controlling food cost dish by dish, not for the full P&L. See restaurant-budget-template-excel for the higher-level budget view.
What food cost % should I be targeting?
Industry benchmarks run 28-35% of menu price for food and 18-24% for beverage pour cost, though your ideal target depends on your concept and labor model.
Can I track more than one location in this file?
The free version is one workbook for your recipes and menu. For multi-location cost tracking or inventory-level detail, see the paid Inventory Tracker.