A recipe costing template is a spreadsheet that turns supplier invoices into one number you can actually price against: what a single portion of a dish costs you to make. Three steps get you there: convert each invoice price to the unit your recipe uses, adjust for what you lose to trim and shrink, then divide by the number of portions the batch produces.
The reason most costing sheets give wrong answers is that they skip the middle step. A case price divided by a case weight looks like a cost per pound, but you do not serve the whole pound. Bones, peel, trim and cooking loss come off first, and the number you actually need is what the usable pound costs. Getting that right typically moves a dish’s cost by 10% to 40% on anything that needs breaking down, which is the difference between a menu you think is profitable and one that is.
This walks through the columns the sheet needs, the two formulas that do the real work, a dish costed end to end, and where to get a template rather than building one. Once it exists, it feeds everything else. It is the measurement step behind the whole set of levers for reducing food costs without cheapening the plate, because you cannot tell which dish is the problem until all of them are costed.
Key Takeaways
The core formula is cost per portion = total recipe cost ÷ portions produced. The work is entirely in getting total recipe cost right.
Use edible portion cost, not the invoice price: EP cost = AP cost ÷ yield %. A protein bought at $10/lb with a 70% yield really costs $14.29 per usable pound (Culinary Math, Open Washington Pressbooks, retrieved 2026-09-29).
Add a Q factor of roughly 5% to 10% of raw plate cost for the bread, condiments, garnish and disposables no recipe lists.
A usable template needs eight columns per ingredient. Fewer than that and you are estimating; more and nobody maintains it.
Free spreadsheet templates are adequate for a single-site operation. Paid software earns its place when live invoice prices need to flow in automatically.
Lower your delivery costs by 23%
How we reduce costs:
- No delivery vehicle expenses
- Optimized local routes
- Pay-per-delivery model
- Average 23% delivery cost reduction
What a recipe costing template needs to contain
Eight columns per ingredient row, then three summary rows at the bottom. That is the whole specification.
| Column | What goes in it | Why it exists |
|---|---|---|
| Ingredient | The item as your supplier lists it, including grade or cut | So the cost ties back to a specific invoice line |
| Purchase unit | The unit you buy in: case, 40 lb box, 5 L tin | Invoices price this, recipes never use it |
| Purchase cost | What you paid for that unit, most recent invoice | The input everything else derives from |
| Cost per base unit | Purchase cost ÷ quantity in the unit, in grams, ml or each | Puts every ingredient on one comparable scale |
| Yield % | Percentage of the raw item that reaches a plate | The step most sheets omit |
| EP cost per unit | Cost per base unit ÷ yield % | The true cost of what you actually serve |
| Recipe quantity | How much the recipe uses, in the same base unit | Must match the unit above or the maths breaks |
| Line cost | Recipe quantity × EP cost per unit | The ingredient’s contribution to the dish |
The three summary rows are total ingredient cost (sum of line costs), Q factor, and cost per portion. If your sheet has a food cost percentage and target price row as well, good, but those are outputs of pricing decisions, not part of costing.
One discipline makes or breaks this: pick a single base unit per ingredient type and never mix. Grams for solids, millilitres for liquids, each for countable items. Half the broken costing sheets in existence are broken because one row is in ounces and the row above it is in grams.
Step 1: Convert every invoice price into a cost per recipe unit
Start from the invoice, not from memory or a supplier catalogue. The price you were charged last week is the only price that is true.
Take the purchase cost and divide by the total quantity in that purchase unit, expressed in your base unit. A 4-litre tin of oil at $38 is 4,000 ml, so $0.0095 per ml. A 40-pound case of chicken at $112 is 18,144 grams, so $0.00617 per gram. The numbers are ugly and that is fine; the spreadsheet carries the decimals, you never read them.
Three traps live here:
-
Pack weight versus drained weight. Canned goods are priced on gross weight and used on drained weight. Cost against what comes out of the tin.
-
Case count changes. Suppliers quietly change pack sizes. A case that went from 24 to 20 units at the same price is a 20% increase that shows up nowhere on your order guide.
-
Prices that have moved since you last looked. This is the column that goes stale fastest, and some of the movement comes from outside your supply chain entirely, because import tariffs and duties land on the invoice as a higher landed cost with no line item explaining them. If a costed dish suddenly looks wrong, this is the first column to re-check.
Date every price cell. A costing sheet with no dates is a sheet nobody trusts within six months.
Step 2: Adjust for yield using edible portion cost
This is the step that separates a real cost from a guess, and it is one division.
Edible portion cost equals as-purchased cost divided by yield percentage. Yield percentage is the share of the raw item that survives trimming, peeling, boning and cooking. A chicken breast bought at $4.50 per pound with an 85% yield has an EP cost of $5.29 per pound, and $5.29 is the figure the recipe should use (Culinary Math, Open Washington Pressbooks, retrieved 2026-09-29). Cost it at $4.50 and every dish containing it is understated.
The effect scales with how much you throw away. At 70% yield, a $10 pound is really $14.29. At 50%, typical of whole fish and some root vegetables, it is $20. Standard yield tables exist and are a reasonable starting point, but your own numbers beat them because yield depends on your supplier’s spec and your cook’s knife. Weigh in and weigh out once per major ingredient, write the percentage down, and revisit it annually or when you change suppliers.
Ingredients that need no adjustment get 100%: flour, sugar, oil, anything that goes in as bought. Do not leave the cell blank, because a blank reads as zero and zero breaks the division.
Step 3: Divide by portions, then add a Q factor
Sum the line costs for the total recipe cost, then divide by the number of portions the batch actually produces. Not the number it should produce, but the number it does, after the inevitable short portion at the end of the pan.
Then add the Q factor: an allowance of roughly 5% to 10% of raw plate cost covering everything the recipe does not list. Bread and butter, condiments, the garnish, oil for the pan, disposables and packaging. In a full-service setting this allowance can reach a few dollars per cover, and leaving it out is why costed menus consistently look better on paper than in the accounts.
For businesses that deliver their own orders, the Q factor is where packaging belongs and it is not small. Containers, lids, cutlery, bags, labels and any insulation or ice pack ride on every delivered order but appear in no recipe. Cost them into the Q factor for delivered items separately from the dine-in figure, because the two are different numbers and a blended one hides which channel is actually earning.
A dish costed end to end
Roast chicken with potatoes and greens, batch of 10 portions.
| Ingredient | Purchase | Cost/base unit | Yield % | EP cost | Recipe qty | Line cost |
|---|---|---|---|---|---|---|
| Whole chicken | 40 lb case, $112 | $0.00617/g | 68% | $0.00907/g | 2,000 g | $18.14 |
| Potatoes | 25 lb sack, $14 | $0.00123/g | 81% | $0.00152/g | 3,000 g | $4.56 |
| Greens | 5 lb box, $16 | $0.00705/g | 74% | $0.00953/g | 1,200 g | $11.44 |
| Olive oil | 4 L tin, $38 | $0.0095/ml | 100% | $0.0095/ml | 200 ml | $1.90 |
| Butter | 1 kg, $8.40 | $0.0084/g | 100% | $0.0084/g | 150 g | $1.26 |
| Aromatics, herbs, salt | mixed | n/a | 100% | n/a | n/a | $2.80 |
| Total recipe cost | $40.10 | |||||
| Cost per portion (÷10) | $4.01 | |||||
| Q factor at 8% | $0.32 | |||||
| Plate cost | $4.33 |
Illustrative figures, using the EP cost method above. Substitute your own invoice prices and measured yields.
Notice what the yield column did. Costed on purchase price alone, the chicken line would have read $12.34 and the whole dish $3.44 a portion, 20% under. Price a menu off that and you would believe you were running a food cost you are not.
Where to get a recipe costing template
Building one from scratch takes an afternoon and teaches you where the numbers come from, which is worth something. Downloading one gets you to the same place by lunch. Either is fine; what matters is that the sheet has a yield column.
-
Free spreadsheet templates. Spreadsheet123’s recipe cost calculator is offered in Excel (.xls and .xlsx), Google Sheets and OpenOffice Calc formats, splits ingredients into primary centre-of-plate items and secondary bulk items, and returns cost margin and profit per serving once you enter a proposed price (Spreadsheet123, retrieved 2026-09-29). Several other publishers offer comparable free Excel and Google Sheets downloads.
-
Template marketplaces and form builders. Jotform, Etsy sellers and spreadsheet-focused blogs all list recipe costing sheets, free and paid. Quality varies considerably, so check for a yield column and for editable formulas rather than locked cells before committing your data to one.
-
Culinary-education worksheets. Open textbooks such as Open Washington’s culinary math chapters and the Culinary Institute of America’s published kitchen-calculations material set out the same costing card structure used in professional training, which is useful if you want to understand the method rather than just fill boxes.
-
Costing and inventory software. Worth it when you have several sites, frequent price changes, or want invoice prices flowing in without retyping. For a single kitchen, a spreadsheet you actually update beats software you stop logging into.
Whichever route you take, check three things before you trust it: that yield or EP cost appears somewhere, that the ingredient units are yours to set rather than fixed, and that you can see the formulas. A sheet whose maths you cannot inspect is a sheet you cannot debug when a number looks wrong.
The mistakes that make a costed recipe wrong
Almost every bad costing sheet fails in one of five ways:
-
No yield adjustment. Covered above, and easily the most expensive of the five.
-
Mismatched units. Recipe in ounces, cost per gram. The result is out by a factor of 28 and looks plausible enough to survive.
-
Stale prices. A sheet costed eighteen months ago is describing a market that no longer exists, particularly on proteins and oils.
-
Batch yield assumed rather than counted. If the recipe says 10 portions and the pan honestly gives 9, every portion is 11% more expensive than the sheet claims.
-
No Q factor. Garnish, condiments and packaging are real money and they appear in no recipe.
A sixth, subtler one: costing only the dishes you suspect. The value of the exercise is the comparison across the whole menu, because the dishes that turn out to be unprofitable are rarely the ones anybody guessed.
When to re-cost
Re-cost a dish whenever an ingredient making up a meaningful share of its cost moves, whenever you change supplier or spec, and whenever the pack size changes. In practice that means reviewing the price column monthly and re-running affected dishes, rather than re-costing the whole menu on a calendar.
Two situations demand it immediately. A duty or tariff change on anything imported, because it arrives as a straight increase in landed cost with no negotiation available. And a switch to a new distributor, because the same nominal spec from a different supplier often yields differently: the invoice price can fall while your EP cost rises.
Frequently asked questions
How do you calculate cost per serving?
Total recipe cost divided by the number of portions the batch produces, then add the Q factor. Total recipe cost is the sum of each ingredient’s recipe quantity multiplied by its edible portion cost, so yield adjustment has to happen before the division, not after.
What is the difference between recipe cost and plate cost?
Recipe cost is the ingredients in the dish. Plate cost adds everything else that leaves the kitchen with it: garnish, bread, condiments, sauce, disposables and packaging, usually as a Q factor of 5% to 10% of raw cost. Plate cost is the number to price against.
Do free recipe costing templates work well enough?
For a single location, yes. A free Excel or Google Sheets template with a yield column does the same arithmetic as paid software. The advantage of paid tools is automation, meaning live supplier prices and inventory links, not better maths.
How is yield percentage worked out?
Weigh the item as purchased, prepare it as you normally would, then weigh what is usable. Divide the second number by the first. A 5,000 g case that produces 3,400 g of usable product has a 68% yield. Do this once per major ingredient and record it in the sheet permanently.
Does a recipe costing template set your prices?
No. It tells you what a portion costs, which is the floor. What you charge depends on your market, your format and what the dish is worth to a guest, and that is a separate decision made on top of an accurate cost, never instead of one.
Putting it to work
Cost your five highest-volume dishes this week, with a measured yield on every ingredient that needs breaking down. Five dishes is enough to see the pattern, and the pattern is usually that one is much better than anyone thought and one is losing money quietly.
Then extend to the full menu, date every price cell, and set a monthly reminder to refresh the price column. The sheet is only as good as its most recent invoice, and once it is current, every other cost decision you make stops being a guess.
