Free tool

Free Excel recipe costing template

A ready-to-use spreadsheet with yield loss formulas, cost per portion, and selling price, plus a reference yield loss table and a mini guide. Designed for chefs, business owners, and hospitality students who need reliable recipe costing without building formulas from scratch.

Download the free template

1 .xlsx file · 3 sheets: Costing with formulas, Yield table and a guided cover · 11 KB

This template costs one recipe today; Miselup keeps it live and, from Mise Pro, links it to purchasing, inventory and daily P&L. Create your account

See it inside

The real product, not a mockup

Explore the catalog, recipe costing, HACCP controls and traceability in Miselup.

Your business at a glance

A dashboard with your activity, costs and alerts in one screen.
Ingredient catalogue

1,200+ ingredients with cost, units and allergens.
Ingredient sheet

Price per unit, allergens, conversions and supplier.
Sub-recipes

Nested sub-recipes that recost themselves when a price changes.
Final preparations

Dishes, drinks, desserts or trays: everything you sell, ready to cost.
Food-cost to the cent

Cost, waste and margin of the final preparation in real time.
Export to professional PDF

Technical sheet and food-cost ready to print or send.
Techniques

Your library of techniques, with photos and steps.
Equipment & tableware

Your production space's tools and equipment inventory.
Controls in the portal

Configured controls, reading status and access to the form. Documentary records needing attachments are entered in management.
Measurement and corrective action

Product core-temperature recording and corrective action for deviations; this recording type is available in Mise Pro HACCP.
Your business at a glance

A dashboard with your activity, costs and alerts in one screen.
Ingredient catalogue

1,200+ ingredients with cost, units and allergens.
Ingredient sheet

Price per unit, allergens, conversions and supplier.
Sub-recipes

Nested sub-recipes that recost themselves when a price changes.
Final preparations

Dishes, drinks, desserts or trays: everything you sell, ready to cost.
Food-cost to the cent

Cost, waste and margin of the final preparation in real time.
Export to professional PDF

Technical sheet and food-cost ready to print or send.
Techniques

Your library of techniques, with photos and steps.
Equipment & tableware

Your production space's tools and equipment inventory.
Controls in the portal

Configured controls, reading status and access to the form. Documentary records needing attachments are entered in management.
Measurement and corrective action

Product core-temperature recording and corrective action for deviations; this recording type is available in Mise Pro HACCP.
Your business at a glance

A dashboard with your activity, costs and alerts in one screen.
Ingredient catalogue

1,200+ ingredients with cost, units and allergens.
Ingredient sheet

Price per unit, allergens, conversions and supplier.
Sub-recipes

Nested sub-recipes that recost themselves when a price changes.
Final preparations

Dishes, drinks, desserts or trays: everything you sell, ready to cost.
Food-cost to the cent

Cost, waste and margin of the final preparation in real time.
Export to professional PDF

Technical sheet and food-cost ready to print or send.
Techniques

Your library of techniques, with photos and steps.
Equipment & tableware

Your production space's tools and equipment inventory.
Controls in the portal

Configured controls, reading status and access to the form. Documentary records needing attachments are entered in management.
Measurement and corrective action

Product core-temperature recording and corrective action for deviations; this recording type is available in Mise Pro HACCP.

Calculating recipe costs manually is slow and prone to errors that inflate food cost or throw margins off. This Excel recipe costing template automates all the calculations for a final preparation: from yield loss to the selling price including VAT. It's designed for chefs, small business owners, food trucks, and hospitality students who need a reliable, fast, and hassle-free tool to control their costs from day one.

Inside the downloadable file you'll find three elements: the 'Recipe Costing' sheet with live formulas that link net quantity, % yield loss, gross quantity, cost per ingredient, total cost, cost per portion, food cost %, and suggested selling price (10% VAT included); a table with reference yield losses for around 20 common ingredients (vegetables, meats, fish); and a mini usage guide. The honest limitation: this template is a static file that you'll need to replicate for each recipe; if you want to connect spec sheets, costs and margins with purchasing, stock and daily P&L, Miselup brings kitchen and business management together according to your plan.

How to use it

How to use the template

Download and open the file

You'll receive an Excel file compatible with any version. Open it and enable macros if prompted (it doesn't need them, but it's a standard warning).

Fill in ingredients and quantities

On the 'Recipe Costing' sheet, enter each ingredient, its net quantity per portion, and the estimated % yield loss. The template automatically calculates the gross quantity and cost.

Adjust prices and review the selling price

Enter the purchase price per unit and the number of portions. You'll instantly get the total cost, cost per portion, food cost %, and suggested selling price with 10% VAT.

Benchmarks

What the template calculates for you

Gross quantity per ingredient

From the net quantity and % yield loss, you get the quantity you actually need to purchase.

Total recipe cost

Automatic sum of the cost of all ingredients based on gross quantities and purchase prices.

Cost per portion and food cost

Divides the total cost by the number of portions and calculates the percentage it represents of the selling price.

Suggested selling price with VAT

Applies the desired margin (food cost of 25-35%) and adds 10% VAT to obtain an indicative selling price to the public.

FAQ

Frequently asked questions

Free Excel recipe costing template

How is yield loss calculated in an Excel recipe costing template?

The template applies the formula: gross quantity = net quantity / (1 - % yield loss/100). You just need to enter the estimated percentage for each ingredient and the calculation is done automatically. The included reference table helps you assign realistic values based on the product type.

Is this Excel recipe costing template suitable for any hospitality business?

Yes, it's designed to be versatile. It works for a tapas bar as well as a fine dining restaurant, since you can adapt the ingredients, yield losses, and number of portions. Just keep in mind that it's a static file: each final preparation needs its own sheet.

Can I modify the formulas in the Excel recipe costing template?

You can adjust the input cells (ingredients, prices, yield losses) without any problem. The formulas are protected to prevent accidental deletion, but if you need to customize them, you can unprotect the sheet with the password provided in the mini guide.

Does the Excel recipe costing template include VAT in the selling price?

Yes, the suggested selling price is calculated by applying the margin on the total cost and adding 10% VAT. You get an indicative final price ready for the menu, although you should always validate it with your tax advisor.

What is the difference between this Excel recipe costing template and Miselup software?

The template costs a single recipe at a time. Miselup connects recipes, spec sheets, costs and allergens with business management: updated supplier prices and costings; purchasing, inventory and daily P&L in Mise Pro; the HACCP suite in Mise Pro HACCP. All in one system, according to your plan.

Ready to sell with clear margins?

Get costs and margins under control from day one and run your business on real numbers. From €19 a month; Mise Pro adds purchasing, inventory and daily P&L.

Create your account Talk to us