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.
Costing with VAT and breakdown by ingredient (template in Spanish)
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 freeThree 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
- Enter the ingredients with the gross quantity. The one you buy and weigh before cleaning or peeling, because that is what you pay for.
- 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.
- 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.
- Enter how many portions or units it makes. The total cost divided by the portions gives you the cost per portion.
- 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
| Item | Quantity | Price | Cost |
|---|---|---|---|
| Cream cheese | 600 g | €8.50/kg | €5.10 |
| Cream | 200 g | €4.20/kg | €0.84 |
| Sugar | 180 g | €1.10/kg | €0.20 |
| Eggs | 4 units | €0.25/unit | €1.00 |
| Biscuits | 150 g | €3.60/kg | €0.54 |
| Butter | 60 g | €9.00/kg | €0.54 |
| Box | 1 unit | €0.35/unit | €0.35 |
| Raw materials | €8.57 | ||
| Labour | 25 min | €18.00/h | €7.50 |
| Overheads | 25 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.
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 template | Recipok | |
|---|---|---|
| Price | Free, forever | Free up to 12 recipes |
| If an ingredient goes up | You open every recipe that uses it | They are all recalculated, including those that use it inside a semi-finished product |
| Purchase prices | You copy them from the invoice | Updated from the supplier's price list or invoice |
| Labour and fixed costs | Formulas by hand | You set them up once and they are spread per minute |
| Cost history | No | Daily history and alerts for recipes that get more expensive |
| Technical sheet and label | Separate | They 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: