Alberto de Palacio

Free download

Free recipe costing template in Excel

The sheet I use to work out the cost of every dish in the restaurants I work with. Clean, with the formulas already in. Download it below.

Almost every template out there forgets about waste.

And waste is exactly what makes a dish look cheap on paper and cost you more in real life.

This one counts it.

What it tells you

Ten ingredients per dish. You fill in the cream cells and the rest works itself out. The formulas are protected so they don't get deleted by accident.

Recipe costing template in Excel filled in with an example burger: cost per portion of 3.11 euros and a food cost of 27.4%
This is how it looks with the example burger from the guide. Yours comes empty, ready for your dishes.

How to use it, in short

  1. Enter the dish and how many portions the recipe makes. If you cook a pot for ten, enter ten.
  2. Enter each ingredient with the total quantity for the recipe, in the same unit you buy it in.
  3. The purchase price from your latest invoice, excluding VAT.
  4. The waste: what you lose when cleaning, peeling or boning. If nothing is lost, leave it empty.
  5. Enter your food cost target and your menu price. The sheet does the rest.

Want to understand each step first?

It's all explained, with the full example and the seven mistakes that ruin a costing, in the recipe costing guide.

Host Brain

Want to automate your restaurant?

A team of AI agents watches your costs every day, and all you do is approve or dismiss.

Meet Host Brain