Skip to main content
ChefExpenses LogoChefExpenses

Free recipe costing template for Excel

A ready-to-use spreadsheet that works out what every dish really costs. Enter your ingredients and purchase prices once, then build each recipe by picking them from a list. The formulas give you trim waste, cost per portion, food cost percentage, gross profit and a suggested menu price. Direct download, with no sign-up and no email gate. And when you're ready to leave spreadsheets behind, upload it to ChefExpenses as it is.

Excel · 65 KB · also opens in Google Sheets, Numbers and LibreOffice

What's in the spreadsheet

  • An “Ingredients” sheet: your product list with supplier, purchase format, price and % edible. It works out the price per kg, litre, lb or unit for you.
  • Three “Recipe” sheets with 25 lines each: pick the ingredient from a dropdown and the quantity in g, kg, oz, lb, ml, l, fl oz, cup or units; the sheet converts between units.
  • Trim/waste and gross quantity on every line, so you see how much to pull from the walk-in — not just what reaches the plate.
  • A results block: total cost, cost per portion, price ex. tax, food cost %, gross profit, ratio and suggested menu price.
  • A fully worked example (pan-seared salmon with vegetables) and a “How to use it” sheet with every step and formula.
  • Ready to move into ChefExpenses: the “Ingredients” sheet uses the app's import format.

How to use it

  1. On the “Ingredients” sheet, list each product with its supplier, the format you buy it in (5 kg, 1 gal, 30 units) and the price of that format excluding tax — straight from your supplier invoice.
  2. Add the % edible: what you keep after trimming, peeling or boning. Salmon loin, 70%; a whole fish, 50–60%.
  3. On a “Recipe” sheet, enter the dish and its portions, pick each ingredient from the list and type the net quantity used, in whatever unit you like.
  4. Fill in your menu price, the tax included in it and your target food cost. Everything else calculates itself.

From the template to ChefExpenses without retyping

The template's “Ingredients” sheet uses the same format as the ChefExpenses importer. The work you put into the spreadsheet isn't lost: upload it as it is and carry on in the app.

  1. Create your free account and your restaurant.
  2. Open “Import data” and upload the same template file, unchanged.
  3. Check the summary: how many ingredients are new, how many you already had and which rows have an error. Click “Import” and your ingredients, suppliers and prices come in at once.
  4. Build each recipe once by picking those ingredients. From then on, costs keep themselves up to date.

The recipe sheets stay in your spreadsheet: what gets imported is your ingredients, with their supplier and price.

What you get in the app

  • Change an ingredient's price and every recipe that uses it recosts itself, no hunting through sheets.
  • Price history per supplier: see what a dish cost you three months ago.
  • Sub-recipes (stocks, sauces, doughs) inside other recipes, with their cost carried through.
  • Allergens and calories from official data, plus PDF and Excel recipe cards.
  • Food cost and menu engineering across the whole menu.
  • Your team works on the same data, each with their own permissions.
Create your free account

The formulas behind it

These are the standard recipe costing formulas used in professional kitchens. They live in the cells, so you can inspect or tweak them:

Gross quantity
net quantity / % edible
Line cost
gross quantity × purchase price (in the recipe unit)
Cost per portion
sum of line costs / portions
Price ex. tax
menu price / (1 + tax %)
Food cost %
cost per portion / price ex. tax
Gross profit
price ex. tax − cost per portion
Suggested price
cost per portion / target food cost × (1 + tax %)

Worked example: pan-seared salmon with vegetables (4 portions)

Four portions need 720 g of trimmed salmon loin. The loin is 70% edible (30% goes on skin, pin bones and trim), so the gross quantity is 720 / 0.70 = 1,029 g. At 18 per kg, that line costs 18.51.

Add the vegetables, olive oil, lemon and seasoning and the recipe comes to 21.03 — 5.26 per portion. Selling it at 24.00 including 20% VAT gives 20.00 ex. tax, so food cost is 26.3% and gross profit is 14.74 per plate.

With a 30% target, the sheet suggests a menu price of 21.03 including tax — so this dish has room to spare. If your menu prices exclude sales tax (as in most of the US), just set the tax rate to 0%.

Where spreadsheets stop scaling

A template is great for a handful of dishes. It breaks down when a supplier changes a price: every sheet that uses that ingredient has to be found and updated by hand. Add sub-recipes (stocks, sauces, doughs) used inside other dishes and a team editing the same file, and formulas get overwritten and nobody knows which version is current.

Frequently asked questions

Is the recipe costing template really free?
Yes. It's a direct download with no sign-up and no email required. Use it, change it and share it with your team.
Does it work in Google Sheets or Numbers?
Yes. It's a standard .xlsx file using basic functions (IF, IFERROR, INDEX, MATCH, SUM), so it opens in Excel, Google Sheets, Numbers and LibreOffice with the calculations intact.
How do I work out the % edible?
Weigh the product before and after prepping it: % edible = trimmed weight / gross weight × 100, and trim waste is the rest. As a rough guide, leafy greens keep 80–90%, whole fish 50–60% and bone-in meat 65–75%.
What food cost percentage should I aim for?
Most restaurants target 25–35% of the price excluding tax. Above 35%, a dish leaves little room to cover labour, rent and overheads.
Can I move my spreadsheet recipes into ChefExpenses?
Yes. The template's “Ingredients” sheet uses the ChefExpenses import format: create your account, open Import data and upload the same file. Your ingredients, suppliers and prices come in at once. You build each recipe once, and from then on costs update automatically whenever a price changes.