A recipe costing sheet does two jobs. In the kitchen, it makes sure the dish served on a Tuesday night matches the one served at Saturday lunch: same quantities, same method, same plating. In the office, it gives you the food cost of each portion, and therefore the gross profit. The first job ages well. The second does not: a sheet costed with the prices of the day it was written still tells you, six months later, what the dish cost back then.

Here is what a recipe costing sheet should contain, how to cost a recipe without the usual mistakes, and a free Excel template to get you started.

Download the recipe costing sheet (Excel) — free, no sign-up, with a worked example and the formulas already in place.

What goes into a recipe costing sheet

There is no official format; every kitchen has its own. A good sheet still answers the same questions.

SectionContentWhat it is for
IdentificationDish name, category, number of portionsFind the sheet, bring the cost back to one portion
IngredientsProduct, net quantity, unitReproduce the dish and order the right amount
Purchase pricesPrice per kilo, litre or each, and its dateCost the recipe
WastePeeling, trimming, cooking loss, as a %Go from the net quantity to the quantity you buy
MethodSteps, timings, equipment, plating, photoConsistency in the kitchen, training
AllergensIngredients concernedInform guests
ResultCost per portion, selling price excl. VAT, food cost %, GPSet the price and track profitability

One section is often missing: the date of the prices. Yet it is what tells you whether the cost on the sheet still means anything.

How to cost a recipe, step by step

1. Start from the net quantity, then add waste the right way

The net quantity is what actually goes into the recipe: 150 g of trimmed sea bass fillet per plate. The gross quantity is what you have to buy to get it. Waste sits between the two, and that is where the most common mistake creeps in.

A 35% waste on leeks means 35% of the weight you buy ends up in the bin at prep. To get 1.2 kg net, you need to buy 1.2 ÷ (1 − 0.35) = 1.846 kg. The reflex “1.2 kg plus 35%” gives 1.62 kg: you are 0.23 kg short, and the line cost is understated by about 12%. The template applies the right formula: gross quantity = net quantity ÷ (1 − waste). Some kitchens call this a 65% yield; it is the same calculation.

If you already record gross quantities, simply leave waste at zero.

When choosing between pack sizes or preparations, also compare your suppliers’ cost per usable kilo.

2. Express every price in the recipe’s unit

The wholesaler bills by the case, the recipe counts in kilos. Wine is bought by the case, the sauce uses 20 cl. Each price must be brought back to the unit of the quantity you enter (kilo, litre, each), or the multiplication means nothing. That is exactly the work that breaks down when descriptions and pack sizes differ from one supplier to the next, as we explained in invoice OCR and line item extraction.

3. Add up, then divide by the number of portions

Each line cost is the gross quantity times the unit price. Their sum is the recipe cost, which you divide by the number of portions.

4. Compare the cost with the selling price excluding VAT

Food cost % is always calculated on the selling price excluding VAT: cost per portion ÷ net selling price. For a menu price that includes VAT, divide it by (1 + VAT rate) first. GP % is the other side of the same coin: 100% minus food cost %. The formula and its variants are covered in how to calculate food cost.

Example: a completed costing sheet

Here is the example included in the template: sea bass fillet with leeks and beurre blanc, for 10 portions. The figures are hypothetical and carry no currency.

IngredientNet quantityPurchase price per unitWasteGross quantityLine cost
Sea bass fillet1.5 kg22.00 / kg10%1.667 kg36.67
Leeks1.2 kg2.40 / kg35%1.846 kg4.43
Unsalted butter0.25 kg9.00 / kg—0.25 kg2.25
Shallots0.1 kg4.00 / kg15%0.118 kg0.47
White wine0.2 L6.00 / L—0.2 L1.20
Single cream0.1 L5.00 / L—0.1 L0.50
Recipe total45.52

That is 4.55 per portion. Sold at 16.00 excluding VAT, the dish runs at a 28.4% food cost, a 71.6% GP, and leaves 11.45 of gross profit on every plate.

Why a costing sheet goes stale

Take the same dish three months later. Sea bass is now invoiced at 25.30 per kilo instead of 22.00, up 15%. Nothing else has changed. The cost per portion rises to 5.10, food cost to 31.9%, GP drops to 68.1%, and gross profit falls to 10.90 per plate. The sheet still says 28.4%.

Several causes add up:

  • Prices move without warning. A few per cent on a key product goes unnoticed, then another. That is the mechanism described in price drift.
  • Suppliers and pack sizes change. A new wholesaler, a new case size, a substitute product during a shortage: the price on the sheet no longer matches anything.
  • Sheets are scattered. One file per chef, per site, sometimes a laminated copy on the pass. Nobody knows which one is current.
  • Practice drifts from the sheet. Generous portions, more trim than planned: theoretical cost parts ways with actual cost. We cover how to measure that gap in actual vs theoretical food cost.

Updating prices by hand is manageable for a handful of sheets. With a full menu, several sites and hundreds of invoices a month, the update stops happening, and the number on the sheet becomes decorative.

Spreadsheet or software: when to switch

Excel costing sheetCosting sheet linked to purchases
Set-upImmediate, freeLink ingredients to purchased products
Ingredient pricesTyped in by hand, dated if someone remembersLatest prices actually paid, with every invoice
New supplier or pack sizeRework sheet by sheetAbsorbed by unit harmonisation
Menu overviewOne file per recipeAll recipes in one place
Alert when a margin slipsNoneAt-risk dishes flagged before month-end

The spreadsheet is the right tool to get started, formalise a recipe or train a team. It reaches its limits once the question is no longer “what does this dish cost?” but “what does it cost today, and which dishes are losing margin?”.

Recipe costing at real prices with Eqolux

Eqolux reads your invoices and delivery notes line by line and turns them into the price actually paid for each product. The Menu Engineering module builds on that data:

  • Recipe sheets costed at the prices you actually paid. Ingredients are linked to purchased products: a new invoice arrives, the recipe’s food cost updates.
  • The exact food cost, dish by dish, with no prices to retype and no spreadsheet to maintain.
  • At-risk dishes flagged in time. When an ingredient drifts, dishes whose margin is eroding surface before the month-end close.
  • Menu decisions based on facts. Cross margin with popularity to decide what to push, rework or retire: the idea behind the menu engineering matrix.

Key takeaways

  • A recipe costing sheet both reproduces a dish and gives you its food cost.
  • Waste applies to what you buy: gross quantity = net quantity ÷ (1 − waste), not net quantity plus waste.
  • Food cost % and GP % are always calculated on the selling price excluding VAT.
  • A sheet is only as accurate as the date of its prices: without updates, it understates cost as soon as prices rise.
  • The Excel template is enough to get started; linking sheets to invoices keeps them accurate.

Are your recipe costs still current? Download the template, explore Eqolux menu engineering or book a demo to see your recipes costed at your own prices.