How To Calculate Recipe Costs Accurately for UK Menus

Written by: JJ Tan, Founder, Jelly

Key Takeaways For UK Menu Costing

• Recipe costing works as an ongoing process. Supplier prices change frequently and must refresh on every invoice to protect margin.
• Accurate costing relies on five inputs: current supplier invoices, exact recipe specs, portion sizes, measured yield data, and VAT-exclusive menu prices.
• Food cost percentage must always use the net (VAT-exclusive) selling price by dividing the menu price by 1.2.
• Yield calculations must apply preparation and cooking losses one after the other. Applying both to the original weight double-counts losses.
• Jelly automates invoice scanning, live dish costing, and price alerts so UK operators keep recipe costs accurate without manual spreadsheet updates.

See How Jelly Handles Your Recipe Costs

Before You Begin: The Inputs And Who Owns Them

Accurate recipe costing starts with five inputs in place before you touch a formula:

• Current supplier invoices with line-item prices and quantities
• Recipe specifications with exact quantities in consistent units
• Portion sizes for every dish
• Yield data measured for every ingredient with meaningful trim or cooking loss
• POS sales data and VAT-exclusive menu selling prices

Ownership matters because the inputs come from different people. The head chef owns recipe specifications and yield data. The owner or finance manager owns pricing decisions and margin targets. Supplier prices move constantly, so this becomes a recurring process with a monthly refresh at minimum, triggered on every supplier price change, rather than a one-off task at menu launch.

Share Your Current Costing Setup With Jelly

Why Accurate Recipe Costing Matters For UK Restaurants

Meaningful Vision’s same-item UK foodservice pricing data shows foodservice inflation running at 6.8% year on year in June 2026, compared with 1.7% ONS food and non-alcoholic beverage inflation. ONS food and non-alcoholic beverage inflation was 1.7% over the same period, making foodservice inflation roughly four times the retail-food rate. A cost card refreshed quarterly is structurally out of date before the next quarter begins. A dish that was profitable last week can be loss-making today. On a median pre-tax net profit margin of 2.8% for full-service restaurants, a few percentage points of food cost drift can swing an operator from healthy margin to break-even. When the accountant’s monthly report reveals the problem, the loss has already compounded for weeks.

The Four Core Formulas For Recipe Costing

Every dish cost calculation rests on four formulas, and each one builds on the previous step.

Ingredient cost = pack price ÷ pack quantity × quantity used

Batch (sub-recipe) cost = sum of all ingredient costs in the batch

Portion cost = batch cost ÷ number of portions yielded

Food cost % = portion cost ÷ net selling price × 100

The key point for UK operators is the base used for food cost percentage. Food cost percentage must use the net (VAT-exclusive) selling price, rather than the menu price the guest pays. HMRC VAT Notice 709/1 confirms that restaurant meals and food consumed on the premises are standard-rated for VAT, currently at 20%. To derive the VAT-exclusive price from a VAT-inclusive menu price, divide by 1.2. The Price Marking (Food and Drink Services) Order 2003 requires that displayed menu prices are VAT-inclusive, so the price the guest sees always includes VAT. Calculating food cost percentage against the inclusive price understates the true food cost and overstates margin. This error is the single most common accuracy problem in UK menu costing.

How To Calculate The Total Cost Of A Dish Step By Step

To apply the four formulas in order, follow these seven steps:

1. Standardise all units to grams or millilitres.
2. Record each ingredient’s as-purchased price from the latest invoice.
3. Apply yield to convert as-purchased weight to edible portion weight.
4. Cost sub-recipes and batch components first, before building the parent dish.
5. Sum all ingredient costs to get the plate cost.
6. Divide by the number of portions to get portion cost.
7. Divide by the net selling price (menu price ÷ 1.2) to get food cost %.

Step 2 goes stale fastest because every supplier price change breaks it until someone updates the numbers. Step 3 is skipped most often, which means the cost of any ingredient with real trim or cooking loss is understated from the moment the card is built. For a deeper look at automating these steps, see How to Calculate Recipe Costs Automatically.

Yield And Wastage: AP vs EP In Practice

As-purchased (AP) weight is the weight on the supplier invoice, such as the whole cut, whole fish or full case before any preparation. Edible portion (EP) weight is what remains after trim, bone, peel and unusable scrap are removed.

The standard formulas are:

Yield % = EP weight ÷ AP weight × 100

EP cost per kg = AP cost per kg ÷ yield % (expressed as a decimal)

Yield loss occurs at two separate stages and needs sequential treatment. Preparation yield covers trim, peel and butchery loss before any heat is applied. Cooking yield covers moisture loss and shrinkage during cooking. The correct method applies prep yield first to get the pre-cook weight, then applies cooking yield to that result. A protein with 80% prep yield and 75% cooking yield has a combined yield of 60% (0.80 × 0.75 = 0.60). Applying both percentages independently to the original AP weight double-counts the loss and produces a meaningless figure.

Measure real yields rather than copying reference figures. Weigh a sample batch before and after preparation, then again after cooking. Record the method, the supplier and the person trimming. Re-test whenever the supplier, the cut specification or the prep cook changes, because two cooks breaking down the same case of chicken can come out five yield points apart. Carry a modest waste buffer as a separate line item rather than inflating yield figures so the yield data stays clean and the buffer remains visible.

Sub-Recipes And Batch Components For Accurate Cards

Sauces, stocks, doughs and marinades should be costed as their own batch first. Divide the total ingredient cost by the measured finished output, then treat the result as a single ingredient line in every parent dish that uses the batch. This approach improves both accuracy and maintainability.

Costing a sub-recipe at ingredient level inside every parent dish creates two problems. It doubles the work and inflates the complexity of every dish card. It also drifts fastest. When butter rises in price, that increase only reaches the dishes that use the sauce if the sauce is costed as its own sub-recipe with a live price. If the sauce sits buried as a generic allowance inside each parent dish, the price change never propagates. For a practical template to structure this correctly, see the Recipe Costing Spreadsheet Template.

UK Worked Example: VAT And GP On Net Sales

This example costs a pan-roasted chicken breast dish and shows how much margin the VAT trap hides. All figures use current invoice prices and correct VAT treatment.

• Chicken breast (AP): £8.00/kg. Prep yield 85%, cooking yield 80%. Combined yield: 68%. EP cost: £8.00 ÷ 0.68 = £11.76/kg. Portion (180g cooked): £11.76 × 0.18 = £2.12
• Roasting jus (sub-recipe, costed separately): batch cost £12.00 ÷ 20 portions = £0.60 per portion = £0.60
• Potato gratin (sub-recipe): batch cost £9.00 ÷ 15 portions = £0.60 per portion = £0.60
• Seasonal greens (EP, 80g): £3.50/kg × 0.08 = £0.28
• Oil, seasoning, garnish allowance: £0.15
• Total portion cost: £3.75

Menu price (VAT-inclusive, as displayed to the guest): £18.00

Net selling price (VAT-exclusive): £18.00 ÷ 1.2 = £15.00

Food cost % on net price: £3.75 ÷ £15.00 × 100 = 25.0%

GP % on net price: 75.0%

The VAT trap appears when food cost % is calculated against the VAT-inclusive menu price of £18.00. The result becomes £3.75 ÷ £18.00 × 100 = 20.8%, which understates the true food cost by 4.2 percentage points and overstates margin by the same amount. On a dish selling 80 covers a week, that misstatement compounds into a material and invisible margin leak. HMRC VAT Notice 701/14 sets out which food ingredients are zero-rated and which are standard-rated, which affects the VAT treatment of ingredient purchases and input tax recovery, so keeping VAT treatment explicit in every cost card matters.

Keeping Recipe Costs Accurate Over Time

This section determines whether your costing becomes a useful management tool or an expensive fiction. Three mechanisms drive cost drift in most operations:

1. Price drift. UK restaurant prices rose 8.2% year on year in February 2026, while retail food inflation remained at 3.3%, a gap of nearly five percentage points. Supplier prices change with every delivery, and a cost remains accurate only as of its last invoice. Applying a general inflation assumption to a spreadsheet cannot replace invoice-level price capture.
2. Invoice-driven price refresh. The cost of every dish containing an ingredient should update the moment a new invoice line item lands. A recipe library maintained by hand drifts stale within weeks, and the longer prices go unreconciled the wider the gap grows between theoretical and actual cost of goods sold. In a multi-site operation, the same ingredient can carry a different expected price at every site, which makes any group-level food cost report a blend of accurate and stale numbers.
3. Theoretical vs actual reconciliation. Compare what recipes say should have been used against what stock and purchases show was actually used. The gap between theoretical food cost and actual food cost is where the business leaks. It captures unrecorded waste, over-portioning, yield assumptions that no longer reflect reality, and recipe prices that have not been updated after a supplier change.

Each of those three mechanisms becomes a manual task in a spreadsheet, which is why they fail in practice. Jelly is the recommended solution for keeping recipe costs accurate for restaurant menus because it automates the entire flow from invoice to live dish cost and removes the manual recalculation cycle that causes spreadsheet drift. The mechanisms are:

• Automated invoice scanning that digitises every line item, including quantity, SKU, price and tax, from a photo or a dedicated email address. This removes manual data entry.
• Price Alert that flags every ingredient price increase or decrease by supplier and gives operators concrete evidence to negotiate credits or switch suppliers.
• Live dish costing in the Cookbook. Chefs build dishes by clicking ingredients already populated from scanned invoices, and unit conversions and yield maths are handled automatically. What previously took 28 minutes to cost in a spreadsheet takes 3 minutes in Jelly.
• POS integration with integration partners such as Square, EPOS Now, Toast and Lightspeed. Item-level sales data flows into Jelly so GP and sales mix stay live without manual exports.
• One-click push of digitised invoices to Xero, which reduces bookkeeping time by 90%.

Jelly charges a flat £129 per month per location with no variable charges per user or feature. It delivers initial value in the first week because price alerts and spending insights go live as soon as suppliers begin sending invoices to a dedicated address or the kitchen photographs the first delivery. The outcome is accuracy maintained automatically rather than recalculated manually.

See Your Live Dish Costs In Jelly

Common Mistakes And Troubleshooting Tips

• Costing against VAT-inclusive prices. Cause: using the menu price directly in the food cost % formula. Fix: always divide the menu price by 1.2 to get the net selling price before calculating food cost %.
• Double-counting prep and cooking yield. Cause: applying both yield percentages to the original AP weight. Fix: apply prep yield first, then apply cooking yield to the resulting pre-cook weight.
• Forgetting to refresh costs after a supplier price change. Cause: manual spreadsheet maintenance with no trigger for updates. Fix: implement invoice-driven costing so prices update automatically on every delivery.
• Costing sub-recipes at ingredient level inside parent dishes. Cause: no separate sub-recipe cost card. Fix: cost every sauce, stock and batch component as its own recipe first, then link it as a single line in parent dishes.
• Guessing yields instead of measuring them. Cause: using reference book figures without testing. Fix: weigh a sample batch before and after prep and cooking, then re-test when the supplier or cut changes.
• One person holding the spreadsheet. Cause: no shared system. Fix: move to a platform where costs are traceable to a dated invoice line and visible to both kitchen and management.

How To Measure Success And Plan Next Steps

Recipe costing works correctly when every dish cost is traceable to a dated invoice line, food cost % is calculated on the net selling price after removing VAT, and a refresh cycle runs at least monthly or on every supplier price change. Directional indicators of progress include time spent on costing admin per week, the number of dishes with costs older than the last invoice cycle, and the size of the theoretical-vs-actual gap by category.

Practical next steps are straightforward. Set a costing review cadence and assign ownership. Measure yields on your top ten sellers using the weigh-before-and-after method. Move from manual spreadsheet maintenance to automated invoice-driven costing. For a broader view of the methodology, see How To Calculate Recipe Costing Accurately: A UK Guide.

Talk Through Your Menu With Jelly

Frequently Asked Questions

Can I Use Google Sheets To Calculate The Cost Of A Recipe?

The right spreadsheet structure can calculate recipe costs accurately. A well-structured sheet with an ingredient tab (supplier, pack price, pack quantity, unit cost), a sub-recipe tab (batch cost, portion count, cost per portion), and a dish tab (ingredient lines, yield columns, portion cost, net selling price, food cost %) will produce sound results. The limitation sits in maintenance. Every supplier price change requires a manual update, and any ingredient used across multiple dishes or sub-recipes must be corrected in every location it appears. A price-refresh column with a date field helps track staleness, but it does not remove the manual work. Spreadsheets work as a starting point and then become a liability as the menu grows or sites are added.

What Is The Formula For Calculating Menu Pricing?

The standard formula is: net selling price = portion cost ÷ target food cost %. For example, a portion cost of £4.50 at a 30% target food cost produces a net selling price of £15.00. To get the VAT-inclusive menu price displayed to the guest, multiply by 1.2: £15.00 × 1.2 = £18.00. This formula gives a pricing floor, which is the point below which a dish stops covering its food cost. Market positioning, competitor pricing and perceived value all influence the final decision above that floor.

How Often Should I Update Recipe Costs?

Recipe costs should update on every supplier price change, and at minimum monthly. As the inflation gap above shows, a quarterly refresh is structurally out of date before the next review arrives. High-volatility ingredients such as proteins, dairy, oils and seasonal produce should be prioritised because a price movement on a high-cost, high-volume ingredient affects every dish that uses it. The most reliable trigger is the invoice itself. When a new delivery price lands, every dish containing that ingredient should recost automatically.

What Is The Difference Between Theoretical And Actual Food Cost?

Theoretical food cost is what recipes say should have been spent, given the sales mix and current recipe costs. Actual food cost is what was spent, calculated from opening inventory plus purchases minus closing inventory, divided by food sales. The gap between the two captures the four causes listed earlier: unrecorded waste, over-portioning, stale yield assumptions and unrefreshed recipe prices. A gap under roughly 2 percentage points is normal operational noise. A persistent gap above 4 points warrants investigation by category, starting with proteins and dairy, before attributing the variance to kitchen behaviour.

Conclusion: Turn Recipe Costing Into A Reliable System

The calculation of recipe costs takes minutes when the inputs are correct. Accuracy comes from the process: every cost traceable to a dated invoice line, food cost % calculated on net sales after removing VAT, and a refresh cycle that runs on every price change rather than once a quarter. Control, clarity and repeatability come from a system that keeps the numbers current without manual intervention, not from a better spreadsheet.

See How Jelly Can Run Your Costing System