Written by: JJ Tan, Founder, Jelly
Key Takeaways For UK Recipe Costing
- A recipe costing spreadsheet needs four components: a master ingredient list, recipe sheets, a menu pricing tab, and consistent VAT treatment to deliver accurate GP margins.
- Unit cost must always be calculated by formula (Pack Price ÷ Pack Size) to keep costs accurate as supplier prices change.
- Separate raw ingredient data from recipe calculations across four tabs so a single price update flows correctly through every dish.
- UK kitchens must handle VAT consistently, either all VAT-exclusive or all VAT-inclusive, because mixing the two shifts food cost percentage by roughly 20%.
- Jelly scans invoices, updates ingredient costs in real time, and calculates live dish GP margins without manual data entry.
See Live Recipe Costing In Jelly
What To Prepare Before Building Your Sheet
Gather your paperwork and recipe data before you open Excel.
- Supplier invoices or price lists showing pack sizes and pack prices in £
- A list of ingredients with pack sizes (e.g., 5 kg beef chuck, 2.5 kg pastry, 500 ml ale)
- Recipe quantities in metric units (grams, millilitres, each)
- A note on whether your supplier prices are VAT-inclusive or VAT-exclusive
Most single-site UK kitchens can build this in one sitting, although large menus take longer. The head chef or owner usually owns the spreadsheet, and finance advises on VAT treatment. Expect ongoing manual updates as supplier prices change. Recipe costing spreadsheets typically fail around three months after being built, because re-keying ingredient prices from a fortnight of invoices is nobody’s idea of a Tuesday.
Why Accurate Recipe Costing Transforms GP
A working Excel recipe costing spreadsheet gives clear visibility of dish-level GP margins, highlights supplier price creep early, and backs menu pricing decisions with real numbers. Operators undertaking a thorough recipe costing exercise for the first time consistently identify GP improvements of 3–8 percentage points achievable without changing the menu or suppliers. On a £500,000-turnover business, a 5 percentage point improvement in food GP is worth £25,000.
Talk To Jelly About Automating Your Costing
Essential Columns For A Recipe Costing Spreadsheet
The table below maps every column you need, grouped by function. Input columns such as ingredient name, pack size, and pack price feed calculated columns such as unit cost, line cost, food cost percentage, and GP margin. Every calculated column depends on an input column, which keeps the sheet accurate when prices change. Unit cost must be a formula cell. If anyone types a number into it by hand, the sheet is already drifting.
| Column Header | Purpose |
|---|---|
| Ingredient Name | Identifies the item (e.g., Beef Chuck, Plain Flour) |
| Pack Size | The quantity purchased, with unit (e.g., 5 kg, 2.5 kg, 500 ml) |
| Pack Price (£) | The price paid for the pack, excluding or including VAT, applied consistently |
| Unit | The unit used in recipes (g, ml, each) |
| Unit Cost (£ per g/ml/each) | Calculated: Pack Price ÷ (Pack Size × 1000) for kg-to-g or litre-to-ml conversions |
| Recipe Quantity | The amount used in the recipe, in g, ml, or each |
| Ingredient Line Cost (£) | Calculated: Unit Cost × Recipe Quantity |
| Waste/Yield Factor (%) | The percentage lost to trim, peel, or cooking |
| Adjusted Ingredient Cost (£) | Calculated: Ingredient Line Cost ÷ (1 − Waste %) |
| Total Recipe Cost (£) | Sum of all adjusted ingredient costs |
| Number Of Portions | How many servings the recipe yields |
| Cost Per Portion (£) | Calculated: Total Recipe Cost ÷ Number of Portions |
| Selling Price (£) | The menu price, VAT-inclusive or exclusive, applied consistently |
| Food Cost % | Calculated: (Cost Per Portion ÷ Selling Price) × 100 |
| GP Margin (%) | Calculated: ((Selling Price − Cost Per Portion) ÷ Selling Price) × 100 |
Step-By-Step: Making A Costing Sheet In Excel
Step 1: Set Up Your Tab Structure
Start by creating four tabs that separate inputs from calculations.
- Ingredients List – A master list of every ingredient with pack size, pack price, and unit cost
- Recipe Costing – One sheet per dish or a structured table linking to the Ingredients List
- Menu Pricing – Selling prices, food cost percentage, and GP margin per dish
- Notes & Allergens – Supplier notes, allergen data, and VAT treatment
This structure prevents errors. A single change to a pack price in the Ingredients List flows through to every dish that uses that ingredient. A sub-recipe costed on one tab and referenced by four dishes on other tabs is fine until somebody inserts a row on the sub-recipe tab, at which point four dishes become wrong at once, in the same direction, invisibly. Protect formula cells and only edit intended input cells.
Step 2: Build The Ingredients List Tab
Enter ingredient data with pack size in the largest unit (kg, litres) and recipe quantity in the smallest unit (g, ml). Store pack size and pack unit in two separate cells. “2.27kg” typed as text is a label; 2.27 in one cell and kg in the next is data that can be divided by.
For unit cost per gram when Pack Size is in B2 (in kg) and Pack Price is in C2 (£):
=C2/(B2*1000)
For unit cost per millilitre when Pack Size is in B2 (in litres) and Pack Price is in C2 (£):
=C2/(B2*1000)
For items sold by each (eggs, burger buns), use a direct division:
=C2/B2
Add a Supplier column and a Price Date column. The supplier column identifies whose price moved when a line changes, and the price date turns “I think that is about right” into a checkable fact.
Step 3: Build The Recipe Costing Tab
Link recipe quantities to the Ingredients List using VLOOKUP or direct cell references so every recipe pulls the latest unit cost.
Ingredient Line Cost:
=Unit Cost * Recipe Quantity
Adjusted Ingredient Cost (with waste/yield):
=Ingredient Line Cost / (1 - Waste %)
Total Recipe Cost:
=SUM(Adjusted Ingredient Cost range)
A waste allowance of typically 5–10% (depending on the ingredient and how it is prepared) should be added to the raw dish cost to arrive at the actual food cost per portion. A 10% trim loss on meat means the true cost is higher than the raw pack price suggests.
Step 4: Calculate Cost Per Portion And Food Cost %
Cost Per Portion:
=Total Recipe Cost / Number of Portions
Food Cost %:
=(Cost Per Portion / Selling Price) * 100
GP Margin %:
=((Selling Price - Cost Per Portion) / Selling Price) * 100
Step 5: Calculate Ideal Selling Price
Use your target food cost percentage to suggest a starting selling price.
Ideal Selling Price:
=Cost Per Portion / Target Food Cost %
For example, if target food cost is 30%:
=Cost Per Portion / 0.30
This figure gives a baseline. UK food cost percentage benchmarks by restaurant type are: gastropubs 30–35%, fine dining 26–32%, fast casual 28–33%, and cafés/coffee shops 20–28%. Market positioning and VAT still shape the final menu price.
Step 6: Handle VAT Correctly
Menu prices in the UK are legally required to be VAT-inclusive, so the price printed on the menu is what the customer pays. Food cost percentage calculations must compare like with like, using either all VAT-exclusive figures or all VAT-inclusive figures.
If pack prices are VAT-inclusive, convert them to VAT-exclusive before entry:
=VAT-Inclusive Price / 1.20
Comparing a VAT-inclusive selling price against net ingredient costs flatters food cost percentage by roughly a fifth on standard-rated sales. It is the single most common costing error in UK kitchens. For full HMRC guidance on VAT treatment for catering, see HMRC Notice 709/1. For VAT registration threshold guidance, see HMRC’s when-to-register page.
Step 7: Build The Menu Pricing Tab
The Menu Pricing tab turns your costing work into a decision tool. Pull Cost Per Portion from the Recipe Costing tab, then enter your selling price. Excel then calculates Food Cost percentage and GP Margin percentage automatically. Set conditional formatting to flag any dish where GP margin drops below your target, because that red flag turns the spreadsheet from a record into a warning system.
See Your Menu Margins In A Jelly Demo
Converting Pack Sizes To Unit Costs In Excel
UK supplier pack formats rarely match recipe units, so every ingredient needs a clean unit conversion before the cost means anything. Bacon comes in a 2.27 kg pack, flour in a 16 kg sack, milk in 2-litre bottles six to a crate, ciabatta by the case of 24, and oil by the 5-litre drum.
Convert price per kg to price per gram:
=C2/1000
Convert price per litre to price per ml:
=C2/1000
Follow one rule for consistency. Store pack size in the largest unit (kg, litres) and recipe quantity in the smallest unit (g, ml), then use the ×1000 conversion in the unit cost formula. No recipe sheet then needs to repeat the conversion. For items sold by each (eggs, burger buns), use the pack price divided by pack quantity with no extra conversion.
Worked UK Example: Costing A Steak And Ale Pie
This example shows the full calculation chain for three ingredients. Watch how each unit cost comes from pack price and pack size, then multiplies by recipe quantity to give a line cost.
| Ingredient | Pack Size | Pack Price | Unit Cost | Recipe Qty | Line Cost |
|---|---|---|---|---|---|
| Beef Chuck | 5 kg | £32.50 | £0.0065/g | 200 g | £1.30 |
| Ale | 500 ml | £2.20 | £0.44 per 100ml | 100 ml | £0.44 |
| Pastry | 2.5 kg | £8.75 | £0.0035/g (i.e. £0.35 per 100 g, or £3.50 per kg) | 80 g | £0.28 |
Beef Chuck unit cost:
=32.50/(5*1000) = £0.0065 per g
Beef Chuck line cost:
=0.0065*200 = £1.30
Ale unit cost:
=2.20/500 = £0.0044 per ml
Ale line cost:
=0.0044*100 = £0.44
Pastry unit cost:
=8.75/2500 = £0.0035 per g
Pastry line cost:
=0.0035*80 = £0.28
Total Recipe Cost (three ingredients shown, plus remaining ingredients summed):
=SUM(Line Cost range)
Cost Per Portion (for 10 portions):
=Total Recipe Cost / 10
Selling Price: £14.50
Food Cost %:
=(Cost Per Portion / 14.50) * 100
GP Margin %:
=((14.50 - Cost Per Portion) / 14.50) * 100
That example works cleanly because every input stays consistent. In real kitchens, small inconsistencies and shortcuts create errors that hide inside the formulas.
Common Mistakes In Excel Recipe Costing Spreadsheets
- Inconsistent VAT Basis – Mixing VAT-inclusive and VAT-exclusive costs causes inflated or deflated food cost percentages. Be consistent throughout. Getting VAT treatment backwards is the most common pricing mistake UK operators new to costing make.
- Missing Waste Or Yield – A 10% trim loss on meat means the true cost is higher than the raw pack price suggests. Use Adjusted Cost = Line Cost ÷ (1 − Waste %).
- Mixed Measurement Units – Mixing up kilograms and grams skews the calculated cost a hundredfold. Store pack size in kg or litres and recipe quantity in g or ml.
- Out-Of-Date Pack Prices – A spreadsheet will happily report a healthy margin built on last quarter’s figures, with no warning that the underlying data is stale.
- Hard-Coded Ingredient Costs – Typing ingredient costs directly into recipe sheets makes updates slow and error-prone. Always link to the Ingredients List tab.
How To Measure Success
Success means every dish shows a cost per portion, a food cost percentage, and a GP margin that all trace back to the Ingredients List. That list acts as the single source of truth for pack prices. When a supplier price changes, you update one cell and every affected dish recalculates. That speed is the real win: less time on manual costing, faster reaction to price changes, and clearer margin visibility across the menu.
When Excel Stops Working (And What To Do Next)
A static Excel recipe costing spreadsheet becomes stale as soon as a supplier changes a price. Every ingredient price change requires a manual update across every recipe that uses that ingredient. Sub-recipes that feed multiple dishes are especially fragile, because one error propagates everywhere at once. The manual update burden, including checking invoices, re-entering pack prices, and recalculating every dish, is the reason most spreadsheets fall out of use within weeks.
Jelly removes that manual burden. Jelly automates invoice scanning, updates ingredient costs in real time, and calculates live dish GP margins without manual data entry. It integrates with POS systems including Square, EPOS Now, Lightspeed, and Toast to bring in sales data and show which dishes are most profitable. What used to take 28 minutes to cost a single menu item now takes 3 minutes.
| Attribute | Excel Spreadsheet | Jelly |
|---|---|---|
| Price Updates | Manual re-entry from invoices | Automatic via invoice scanning |
| Margin Visibility | Static until manually updated | Real-time, updated with every invoice |
| POS Integration | None | Square, EPOS Now, Lightspeed, Toast |
| Time To Cost A Dish | 28 minutes average | 3 minutes average |
Sources: Jelly customer data, 2026.
For a deeper look at why spreadsheets break at scale, see: Recipe Costing Spreadsheet: Why Spreadsheets Break At Scale.
Explore Jelly For Your Kitchen
Frequently Asked Questions
Can I Use Google Sheets Instead Of Excel For Recipe Costing?
Google Sheets works well for most small kitchens. Core functions such as VLOOKUP and SUM work identically in Google Sheets and Excel, as do the standard arithmetic operators. However, roughly 20–30% of formulas have subtle syntax differences, missing equivalents, or behavioural quirks. Excel offers richer conditional formatting and handles larger datasets, while Google Sheets updates shared files faster when several people edit at once. For a single-site kitchen with a manageable number of recipes, Google Sheets is a practical alternative, especially when multiple people need simultaneous access.
How Often Should I Update Pack Prices In My Recipe Costing Spreadsheet?
Update prices every time a supplier invoice shows a change. This requirement is the core limitation of manual spreadsheets because there is no visual difference between a price entered last week and one entered in March. Best practice is to check critical, high-volatility ingredients weekly and run a full ingredient list review at least once a quarter. A dish costed eighteen months ago might be running at a materially higher food cost percentage today. Supplier prices change quarterly or more frequently, but recipe costings are rarely updated at the same pace.
Should I Include VAT In My Recipe Costing Spreadsheet?
Use one consistent VAT basis across the sheet and match selling prices to that basis. For VAT-registered UK businesses, input VAT on standard-rated purchases is reclaimable, so net (VAT-exclusive) figures usually form the right basis for ingredient costing. For non-VAT-registered businesses, gross (VAT-inclusive) figures represent the true cost because the VAT cannot be reclaimed. UK menu prices must be displayed VAT-inclusive by law, so when calculating food cost percentage against a menu selling price, divide the VAT-inclusive price by 1.20 to get the VAT-exclusive figure before running the calculation.
How Do I Handle Recipe Yield And Waste?
Use a waste or yield factor column and divide ingredient line cost by (1 − waste %). For example, a 10% trim loss means Adjusted Cost = Line Cost ÷ 0.90. Yield testing compares purchased weight to usable weight after trim, bone, peel, drain, and cooking loss. Focus tests on items where loss is meaningful and the ingredient is expensive, such as whole proteins, whole fish, produce with heavy trim, and anything that shrinks noticeably in the pan. Re-run yield tests whenever an input changes, such as a new supplier, a different cut specification, or a seasonal change in produce size.
What Food Cost Percentage Should I Target?
Target ranges depend on your concept and menu. UK full-service restaurants should generally target a food GP of 65–70%, which corresponds to a food cost percentage of 30–35%. Gastropubs typically work in the 30–35% food cost range, fine dining 26–32%, and cafés and coffee shops 20–28%. The spreadsheet shows your actual figure so you can adjust based on your own P&L and prime cost targets. Prime cost, meaning food plus labour combined, should stay under 60–65% of revenue to support long-term solvency, so if labour runs high, the food cost ceiling needs to sit lower.
Check Your Targets With A Jelly Specialist
Conclusion: When To Move Beyond Excel
A well-built Excel recipe costing spreadsheet gives clarity and control over dish-level margins. The column structure, tab structure, core formulas, unit conversion logic, VAT treatment, and the worked steak and ale pie example above give you everything needed to build your own version tonight.
The value of that sheet depends on keeping it current. Growing UK kitchens often move to automated solutions like Jelly when manual updates become unsustainable, when supplier price volatility outpaces the ability to re-key invoices, and when live margins are needed instead of last month’s snapshot. For further reading on building a pub-specific version of this spreadsheet, see Pub Menu Recipe Costing Spreadsheet: Build One Tonight.
See How Jelly Handles Recipe Costing For You
