Skip to content

Free recipe costing template for Excel

An Excel spreadsheet with the formulas built in: fill in the yellow cells with your ingredients, their prices and their waste, and it works out the cost per portion and the suggested menu price.

  • “Costing” sheet: up to 25 ingredients with their quantity, purchase price and waste, and the cost of each one worked out.
  • Recipe cost, cost per portion, suggested price excluding and including VAT, and the gross profit per portion.
  • “Waste” sheet: from the weight as bought and the trimmed weight, the waste % and what a trimmed kilo costs you.
  • A filled-in example (mushroom risotto, with made-up figures) so you can see how it works before entering your own dishes.
Download the template (.xlsx)

Free, with no sign-up. Works in Excel, LibreOffice and Google Sheets.

How to use it

  1. Enter the name of the dish, the portions it makes, the VAT and the food cost you're aiming for.
  2. On each row, enter the ingredient, the quantity the recipe uses (in grams, millilitres or units), its purchase price excluding VAT, whether that price is per kg, L or unit, and its waste in %.
  3. The columns that aren't yellow work themselves out. You don't need to touch any formula.

If you don't know a product's waste, measure it with the yield calculator. And if you want to understand every figure, we explain it in the recipe costing guide.

When a spreadsheet stops being enough

A template works for a handful of dishes. Once you have a full menu and several suppliers, every invoice changes prices and you have to go through the sheets one by one. In Scandallo you take a photo of the invoice and the costings of all your dishes update themselves, with an alert when something goes up.

Start cooking with clear numbers

Start for free, no card needed. As soon as you scan your first invoice, you'll see what each dish really costs. Try the basics and upgrade when you want more.

No minimum term · Cancel any time