Recipe Costing Template: Free Downloadable Spreadsheet for Restaurants

A recipe costing template is a spreadsheet that records each ingredient, its purchase price, the quantity used, and its calculated line cost. It then sums the line costs into a recipe total and divides by the number of portions to give a cost per serving. The value is repeatability: cost every dish the same way, update a supplier price once in a central ingredient list, and every linked recipe recalculates automatically.

This guide includes a ready-to-use recipe costing template, the exact column structure, a row-by-row worked example, and a practical workflow for keeping ingredient costs current as supplier prices change.

Download the free recipe costing template:

• Google Sheets
• Microsoft Excel

The template includes a central ingredient price list, yield-adjusted unit costs, reusable recipe sheets, batch-cost calculations, cost per serving, target food cost, and a suggested starting selling price.

For the costing method behind the numbers—including unit conversions, yield factors, and the difference between batch cost and plate cost—read our complete guide to restaurant food costing and menu pricing and our step-by-step guide on how to calculate recipe cost.

Nommy’s free Recipe Cost Calculator runs the same arithmetic directly in your browser. Use the spreadsheet for maintaining a full recipe library and the calculator for quick, one-off costing checks.

What goes into a recipe costing template?

The template uses two layers: an Ingredients sheet that holds every ingredient’s current price, and individual Recipe sheets that pull the live cost from that central list. Update chicken on the Ingredients sheet and every recipe containing chicken recalculates—no need to chase the same ingredient across tabs.

The Ingredients sheet

One row per ingredient. Five columns capture the full audit trail:

Column	What it holds	Example
Ingredient	Name as it appears on the invoice	Chicken thigh
Purchase unit	The unit on the invoice	kg
Purchase price	Price per purchase unit	$9.50
Yield	Usable percentage after trim, waste, or cooking loss	90%
Usable unit cost	Purchase price ÷ yield	$10.56/kg

The Usable unit cost cell is a formula—=Purchase price / Yield—so a price or yield change flows through instantly. This is the single column every recipe sheet references.

A Recipe sheet

One row per ingredient in the dish. Five columns plus three summary fields:

Column / field	What it holds	Example
Ingredient	Name, typed to match the Ingredients sheet	Chicken thigh
Recipe quantity	Amount used in the full batch, in the purchase unit	1.80
Unit	The unit the quantity is expressed in	kg
Retrieved unit cost	Pulled from the Ingredients sheet via XLOOKUP	$10.56
Line cost	Recipe quantity × retrieved unit cost	$19.01
Recipe total	Sum of every line cost	$29.19
Portions	Number of servings the batch yields	10
Cost per serving	Recipe total ÷ portions	$2.92

The Retrieved unit cost cell uses XLOOKUP (or VLOOKUP on older Excel) to find the ingredient by name on the Ingredients sheet and return the current Usable unit cost. The line cost, recipe total, and cost per serving are all formulas, so the entire recipe recalculates the moment a supplier price changes upstream.

How to build a recipe costing template in a spreadsheet

You can build this in Google Sheets, Excel, or Numbers in under ten minutes. The structure below is the one most independent kitchens settle on because it survives a busy service and a new hire.

1. Create an Ingredients sheet first. This is the central price list. Put the column headers (Ingredient, Purchase unit, Purchase price, Yield, Usable unit cost) in row 1, and list every ingredient the kitchen buys below. Enter =C2/D2 in the Usable unit cost column so the formula fills down automatically.
2. Create one Recipe sheet per dish. Name the tab after the dish (Chicken Thigh Rice Bowl, not Recipe 1). Reserve row 1 for the recipe name, row 2 for Portions (enter the value in cell B2), and row 3 for the column headers (Ingredient, Recipe quantity, Unit, Retrieved unit cost, Line cost).
3. Pull the live cost into each ingredient row. In the Retrieved unit cost column, enter =XLOOKUP(A4, Ingredients!A:A, Ingredients!E:E)—this looks up the ingredient name in cell A4 against the Ingredients sheet and returns the current usable unit cost. On older Excel versions without XLOOKUP, use =VLOOKUP(A4, Ingredients!A:E, 5, FALSE).
4. Enter the formula for line cost in the first data row. In Google Sheets, enter =B4*D4 in cell E4—Recipe quantity (B) multiplied by Retrieved unit cost (D). Fill the formula down every ingredient row.
5. Sum the line costs into the recipe total. =SUM(E4:E20) assuming line costs live in column E.
6. Divide by portions. If the recipe total is in cell E21 and portions are in B2, cost per serving is =E21/$B$2. The $ signs lock the portions cell so the formula still works if you insert rows.
7. Lock the structure. Freeze the header rows, protect the formula cells, and leave only the data-entry cells editable. This stops a tired cook from overwriting a formula at 11pm.

That is the entire template. No macros, no add-ons, no paid software—just a central price list, linked recipe sheets, and the discipline to fill them in.

A worked example: Chicken Thigh Rice Bowl (10 portions)

Here is the template filled in for a 10-portion batch, using the same ingredient set as the master guide. The Retrieved unit cost column is pulled from the Ingredients sheet via XLOOKUP; the Line cost column multiplies recipe quantity by that retrieved cost.

Ingredient	Recipe quantity	Unit	Retrieved unit cost	Line cost
Chicken thigh	1.80	kg	$10.56/kg	$19.01
Rice	1.00	kg	$2.67/kg	$2.67
Mixed vegetables	0.80	kg	$4.17/kg	$3.34
Sauce	0.30	L	$8.89/L	$2.67
Oil, garnish, seasoning	—	—	—	$1.50
Recipe total				$29.19
Portions				10
Cost per serving				$2.92

Read the result: at a 30% target food cost, the formula produces a starting selling price of $2.92 ÷ 0.30 = $9.73, rounded to $9.75. The final menu price should also account for labor, overhead, packaging, channel fees, and local market expectations—food cost is a floor, not a target. Run the same template for every dish on the menu and you have a defensible starting price for each one instead of a guess.

This simplified example applies yield to chicken thigh (90% usable after trimming) but uses purchase cost directly for the other ingredients. Items with significant trimming, waste, or cooking loss—think fish fillets, trimmed produce, or braised cuts—should be adjusted using a yield percentage on the Ingredients sheet before their cost flows into a recipe.

Get the free recipe costing spreadsheet

Use the completed template instead of building the workbook from scratch:

• Google Sheets
• Microsoft Excel

Update an ingredient price once in the central price list, and every recipe linked to that ingredient recalculates automatically.

The three template mistakes that lose money

A template is only as good as the data inside it. Three errors show up in almost every kitchen that switches from intuition to a spreadsheet:

• Mixing units in the same column. Flour entered as grams in one row and kilograms in the next silently inflates or deflates the line cost by 1,000×. Standardize on the purchase unit for every row, and convert recipe quantities before they go in. The Unit column exists to make this visible at a glance.
• Leaving out pantry staples. Oil, salt, stock, and garnishes look trivial per dish but compound across 200 covers a day. A 15ml drizzle of oil at $8/L is $0.12 per plate—ignore small items like that across a full menu and the gap between theoretical and actual food cost widens quietly. For example, if a key ingredient like flour rises sharply and the old invoice price stays in the Ingredients sheet, every recipe containing it will be understated.
• Forgetting to update supplier prices. A template set up in January and never refreshed can drift well into unreliable territory within months. Tie the price column to invoice day, not to memory, and the template stays honest.

How to keep the template current

A costing template goes stale the moment a supplier invoice changes. The workflow that keeps it live is the same one that catches price drift before it eats margin:

• Update on invoice day. When the weekly delivery arrives, paste the new prices into the Ingredients sheet—once per ingredient. Every linked recipe recalculates automatically, so five minutes of data entry re-prices the entire menu.
• Flag lines that move more than 10%. Conditional-format the Purchase price column on the Ingredients sheet to highlight cells that jumped double digits since the last entry. Those are the ingredients that need a menu price review, not just a costing update.
• Re-portion after a menu launch. Two weeks after new items go live, weigh the actual plates leaving the pass and update Recipe quantity to match. Actual portions often drift from the original recipe specification—usually upward.
• Re-cost quarterly at minimum. Even with invoice-day updates, run a full template audit once a quarter—pull the top three supplier invoices, verify every price and yield, and re-check food cost percentage on every item.

Once the numbers are set, the downstream price change is trivial. A live digital menu updates the displayed price in seconds—no reprint, no QR code swap, no table card reorder. The work is in the costing, not the publishing.

When to use a template vs the Recipe Cost Calculator

A spreadsheet template and the Recipe Cost Calculator do the same math; they suit different moments.

• Use the template for the full menu—every dish on one workbook, prices updated once in the Ingredients sheet, a printable record you can hand to an accountant or a new chef.
• Use the calculator for one-off checks—a supplier just raised the price of chicken by 22%, and you need to know in 30 seconds whether the dish is still inside target food cost.

Most operators run both: the recipe costing template as the source of truth, the calculator for the quick question between services.

A costing template is the cheapest margin insurance a kitchen can buy—ten minutes to set up, five minutes a week to maintain, and the difference between a menu priced on numbers and a menu priced on hope.

Use Nommy's free Recipe Cost Calculator to check individual dishes, then publish updated prices to your digital menu without reprinting.