Start free

Home › Blog › Articles

Free recipe costing template in Excel: download it and adapt it to your kitchen

A ready-to-use recipe costing template, with a breakdown by ingredient and VAT, and how to extend it with an hourly cost and a percentage analysis. And if you would rather not fill anything in, Recipok builds the costing from the name of the recipe.

✓ Reviewed on November 19, 2026 Reading time: 5 min By the Recipok team
Free · no sign-up

Recipe costing template in Excel

Cost per ingredient and recipe total, with VAT included to reach the selling price. Opens in Excel or Google Sheets.

XLSEscandallo-costes-ingredientes-simplificado-con-iva-1.xlsx
Costing with VAT and breakdown by ingredient (template in Spanish)
Download the template ↓
Faster

Your costing done in a minute

Type the name of the recipe. Recipok suggests ingredients, quantities and market prices; you enter your supplier's prices and see the cost per portion and per kilo straight away.

Cost my recipe for free

Three recipes without signing up · No card

What a recipe costing is for

Without a costing, your selling price is a gamble. With one, it is a decision. Knowing what each item costs you lets you:

  • Set prices on solid ground, from the margin you want and not from the shop next door's price. Many businesses lose money by cutting prices without knowing their costs.
  • Spot the recipes that leave no margin and decide whether to raise their price, reformulate them or take them off the menu.
  • Decide whether to make or buy a semi-finished product.
  • React to price rises in raw materials before they eat the month's margin.

If this is your first one, start with what a recipe costing is and come back here for the template.

The template: costing with VAT and breakdown by ingredient

It is a simple, fully working template designed for workshops and kitchens: one row per ingredient with its quantity and price, the cost of each line, the recipe total and VAT to reach the final price. In a few minutes you have the costing of a recipe.

It works as it is for restaurants, catering, pastry shops, bakeries and central kitchens. If your business is different, swap "ingredient" for "raw material", "piece" or "unit": the calculation is the same.

How to fill it in, step by step

  1. Enter the ingredients with the gross quantity. The one you buy and weigh before cleaning or peeling, because that is what you pay for.
  2. Enter the purchase price per kilo, litre or unit. The one on your last invoice. If your business reclaims VAT on purchases, use the price excluding VAT: VAT only comes in at the end, in the retail price.
  3. Do not forget the small things. Salt, yeast, greasing oil, baking paper, the box or the packaging. One by one they are nothing; together they can be several points of margin.
  4. Enter how many portions or units it makes. The total cost divided by the portions gives you the cost per portion.
  5. Compare it with your selling price. The raw material cost divided by the price excluding VAT is your food cost. In restaurants, a common benchmark is not to go above 30-35%.

An example: a 12-portion cheesecake

ItemQuantityPriceCost
Cream cheese600 g€8.50/kg€5.10
Cream200 g€4.20/kg€0.84
Sugar180 g€1.10/kg€0.20
Eggs4 units€0.25/unit€1.00
Biscuits150 g€3.60/kg€0.54
Butter60 g€9.00/kg€0.54
Box1 unit€0.35/unit€0.35
Raw materials€8.57
Labour25 min€18.00/h€7.50
Overheads25 min€6.00/h€2.50
Total cost€18.57

The cheesecake costs €18.57, that is, €1.55 per portion. If you sell it whole at €32 excluding VAT, raw materials account for 27% of the price and you have €13.43 left to cover everything else and make money. Notice that labour weighs almost as much as the ingredients: a costing of raw materials alone falls well short. The prices are examples: always use your own.

Has the price of butter gone up?In Recipok you change the price once and every costing that uses it is recalculated, with an alert telling you which recipes have lost margin.
Start free

Waste: the mistake that eats the most margin

If you buy 1 kg of strawberries at €6 and, after hulling them and discarding the bruised ones, you are left with 850 g, the kilo you actually use does not cost €6 but 6 ÷ 0.85 = €7.06. Add a yield column to the template (the percentage you use) and divide the price by it. The same goes for meat that is trimmed, fish that is filleted or vegetables that are peeled.

Water lost in the oven does not change the cost of the recipe, but it does change the cost per kilo of the finished product: divide the total cost by what it weighs coming out of the oven, not by what the dough weighed.

How to extend the template for your business

With an hourly production cost

If your team's work weighs heavily (viennoiserie, fine pastry, production kitchens), add a labour row: minutes of work in the recipe × cost per minute. The hourly cost comes from what you pay each month in wages and employer's social contributions for the production team, divided by the hours they work. Count only hands-on minutes (weighing, mixing, shaping, decorating), not baking or resting time.

Do the same with fixed costs: rent, electricity, gas, water, insurance and equipment depreciation. Add them up per month, divide them by the production hours and apply them per minute, as in the cheesecake example.

With a percentage analysis and a chart

Add a column with the share of each line in the total cost and a bar chart. At a glance you will see which ingredient drives the cost: it is almost always two or three. Those are the ones worth negotiating with the supplier, watching on the invoice and weighing carefully in the workshop.

If you want to learn the full method, with every step, you will find it in how to cost a recipe. And if you would rather start from recipes already costed, take a look at our ready-made kitchen costings to download.

When Excel falls short

A template goes out of date the moment the price of flour goes up. If every price change forces you to go through recipe by recipe, the costing stops being up to date just when you need it most.

Excel templateRecipok
PriceFree, foreverFree up to 12 recipes
If an ingredient goes upYou open every recipe that uses itThey are all recalculated, including those that use it inside a semi-finished product
Purchase pricesYou copy them from the invoiceUpdated from the supplier's price list or invoice
Labour and fixed costsFormulas by handYou set them up once and they are spread per minute
Cost historyNoDaily history and alerts for recipes that get more expensive
Technical sheet and labelSeparateThey come from the same recipe

See how recipe costing in Recipok works, or read about it in the help: how the cost of a recipe is calculated and selling price and margins. And while you are on the numbers, work out how much margin you could gain with up-to-date costings:

How much margin are you losing?Work out in a minute what you would win back each year with up-to-date costing.
Calculate my savings

Frequently asked questions

What exactly is a recipe costing?
It is the calculation of what it costs you to produce an item: raw materials with their waste, your team's time and a share of the premises' fixed costs. It tells you whether a recipe makes money and lets you set the price on solid ground.
Is the template really free?
Yes. It is an Excel file you download directly, with no form, no sign-up and no need to leave your email. You can use it and modify it in your business.
Does it work for a bakery or only for restaurants?
For any business that produces food: restaurants, catering, pastry shops, bakeries, butcher's shops or central kitchens. Where it says "ingredient" you can read "raw material", "piece" or "unit".
How do I include waste in the costing?
Divide the purchase price by the yield. If you pay €10 a kilo and use 800 g, the usable kilo costs you €12.50: 25% more than the invoice says.
How often should it be updated?
Every time the price of an ingredient that weighs heavily in the recipe changes. In a business with dozens of items that is almost every month, and it is what makes keeping it in Excel such a chore.

Keep reading

Costings that recalculate themselves when your prices change

Start free with 12 recipes. No card.