Most restaurant owners don't know what their dishes actually cost to make — and that's where profit disappears. This Excel template fixes that. Enter your prices once, and every recipe updates automatically. Forever.
Most restaurant owners don't know what their dishes actually cost to make — and that's where profit disappears. Guesswork, outdated spreadsheets, and disconnected price lists mean you're pricing dishes blind.
This template fixes that in one afternoon.
150 ingredient rows with automatic Cost Per Gram conversion. Works with grams, kg, litres, oz, lb — any unit. Change a price once, every recipe recalculates instantly.
Each block holds 12 ingredient rows with live-linked dropdowns, plus 8 sub-recipe component slots. Full cost breakdown, food cost %, and variance on every dish.
Build sauces, stocks, doughs and bases once. Set a batch yield and get your cost per gram. Drop that sub-recipe into any dish — cost flows through automatically.
The thing that makes this different. A sub-recipe can live inside another recipe. Update the sauce, every dish that uses it updates too. Zero double entry.
Every recipe block has a dedicated photo zone. Add an image of each dish directly in the spreadsheet — ideal for staff training, menu presentations, and handovers.
Already have supplier lists in Excel? Import them in minutes using Copy & Paste, Power Query, or live file linking. Full step-by-step instructions included.
Go to the Inventory sheet. Enter your ingredient names, brands, pack sizes, unit sizes and costs. Cost Per Gram and Total Value calculate automatically. This is the foundation — everything else builds on top of it.
Head to Sub-Recipes. Name your base recipe — a stock, a sauce, a marinade. Set your batch yield. Select ingredients from the dropdown and enter quantities. The cost per gram of your finished batch calculates automatically and becomes available in every catering recipe.
In Catering Recipes, name your dish and set portion count. Add raw ingredients in the top section and drop in sub-recipes as components below. Enter your menu price and instantly see gross profit, food cost percentage, and variance from your target.
When your beef supplier raises prices, update one cell in Inventory. Every recipe that contains beef — directly or through a sub-recipe — recalculates in seconds. No formulas to fix. No sheets to hunt through. Just accurate numbers, always.
"I spent two years managing food costs in a notebook and a prayer. This template paid for itself the first week — I found three dishes I was selling at a loss."
— Gavin, General Manager · McVeigh's Pub
For restaurants that want it handled completely — we take your supplier invoices, cost every dish, build your sub-recipes, and deliver a fully loaded, ready-to-use Mise en Profit file in 5 business days. Then we walk you through it together.
Limited availability — 2 clients taken per month.
✦ Instant download after purchase · No subscription · Use forever
Join restaurant owners and chefs getting practical food cost advice, template updates and early access to new tools — delivered to your inbox, never more than once a month.
No spam. No sharing. Unsubscribe any time.