Written by: JJ Tan, Founder, Jelly

Key Takeaways for UK Menu Margins

  • UK operators must divide VAT-inclusive menu prices by 1.2 before calculating food cost % and GP margin to avoid overstating profitability.
  • Accurate recipe costing depends on yield percentages, batch yields, and waste factors. Ignoring these understates portion costs, especially on proteins and fresh produce.
  • Free calculators and spreadsheet templates work for small, stable menus under 20–25 items. They become unreliable once supplier prices fluctuate or menus grow.
  • Free tools do not provide live supplier price updates, whole-menu GP dashboards, or POS-linked sales mix analysis, which limits their value for multi-site or high-volume operators.
  • Jelly automates invoice scanning, price alerts, Flash Reports, and menu engineering so operators see accurate, real-time margins without heavy manual admin.

See how Jelly automates your recipe costing

The Free Recipe Costing Calculator For UK Restaurant Menu Margins: The 2026 Ranking

The tools below are ordered by their practical usefulness for UK operators: VAT handling and batch yield support carry the most weight, because those inputs most often break menu margins. Spreadsheet templates appear at the end of the list as genuinely free options for operators who prefer a local file over a browser tool. The ranking that follows shows which free tools handle UK VAT and batch yields correctly, and where each one falls short.

  1. PrepSheet – a UK-built recipe costing tool, created by a working UK chef, that outputs batch cost, cost per portion, a suggested menu price at a target GP (with a 20% VAT assumption shown on the illustrative menu price), and scales recipes to any batch yield, designed for UK hospitality operators.
  2. TablePort – provides a GP calculator that strips VAT from menu prices before calculating food GP%, with a worked UK example and a GP-to-price lookup table covering four target GP levels.
  3. CaterCost – a UK-focused recipe costing and event pricing tool, built by Crocker Digital Ltd for UK micro-caterers and small event caterers, that calculates per-head event costs and scales recipes from an original yield to any guest count; the full product is launching later this year, with free calculators available now.
  4. MenuGo – operated by the UK-based company Ambicube Limited, offers a free browser-based Recipe Scaler & Cost Calculator with ingredient-level cost entry and a whole-menu cost view.
  5. Reciprofity – a recipe costing and scaling tool that offers automated yield calculations and integrated Book of Yields data for tracking shrinkage of ingredients and prep recipes (sub-recipes).
  6. FoxEra – a cloud-based recipe management tool that costs recipes from real supplier prices, re-costs every dish when a supplier price moves, and reports food cost percentage against the venue’s own target.
  7. Google Sheets / Excel Templates – free spreadsheet templates (see the dedicated section below) offer full local control, VAT column configuration, and batch yield rows for operators who prefer a file-based workflow over a browser tool.

Compare these free tools to Jelly’s automated costing

How to Calculate Food Cost Percentage with UK VAT

This worked example walks through the full VAT calculation that every UK operator must get right. It uses a £14 VAT-inclusive menu price, a £3.50 ingredient cost, and the standard 20% UK VAT rate. Use it to sanity-check the output of any free calculator before trusting it with your menu margins.

  1. Strip VAT from the menu price: Sales ex VAT = £14 ÷ 1.2 = £11.67.
  2. Calculate food cost %: Food cost % = £3.50 ÷ £11.67 = 30%.
  3. Calculate food GP: Food GP = £11.67 − £3.50 = £8.17, which is a food GP margin of 70%.

If a calculator divides £3.50 by the £14 VAT-inclusive price instead, it returns 25% food cost, a four-point error that makes every dish look more profitable than it is. This mistake is the most common pricing error UK operators make when first costing recipes. For a business turning £600,000 in VAT-inclusive revenue, the distortion amounts to approximately £100,000 in reported revenue.

How Batch Yields and Waste Factors Change Portion Cost

Batch yield and waste factor are the two inputs free calculators most often handle incorrectly. A batch producing 22 usable portions instead of an assumed 24 understates portion cost by approximately 9%. Waste compounds this. WRAP estimates that for every £1 spent on food, around 18 pence is wasted in UK restaurants, split across spoilage, preparation, and plate waste.

The correct formula for effective ingredient cost per portion is: as-purchased cost ÷ yield %. A chicken thigh bought at £3.50 per pound with a 70% usable yield after trim and cooking actually costs £5.00 per usable pound, 43% higher than the invoice price. Applying a 5% waste factor on top of that raises the effective cost further. Any calculator that costs ingredients at as-purchased weight produces a systematically optimistic margin on every dish that uses a protein, fresh produce, or a sauce with a sub-recipe.

Free Recipe Costing Calculator Versus Spreadsheet Template: Choosing What Fits

A browser-based calculator and a spreadsheet template solve the same problem in different ways. A calculator is faster for one-off checks: enter ingredients, then see a cost per portion and food cost % in under three minutes. A template is more flexible for ongoing menu management. It holds an ingredient library, supports batch yield rows, and can include a VAT column that separates ex-VAT selling price from the menu price customers see.

The trade-off is maintenance. A free browser-based calculator stores no data. When the browser closes, the data is gone, and there is no history or easy way to share a recipe cost with a colleague. A free recipe costing calculator UK Excel template persists locally, but every supplier price change must be re-keyed manually into every affected recipe.

A free spreadsheet or template works well for menus under 20–25 items with relatively stable prices; recipe costing software starts to pay off at 30+ items, frequent price swings, or multiple locations. Single-site operators with a stable seasonal menu are well served by a template. Multi-site operators, or those with volatile ingredient costs, see the manual update burden grow faster than the menu.

Food Costing Template Google Sheets Free: Essential Features

A genuinely useful free Google Sheets food costing template needs specific columns and rows to produce reliable UK margins:

  • Pack-Size-to-Unit-Cost Conversion – the template must divide pack cost by pack size to derive a cost per gram, ml, or unit, rather than asking the user to calculate this manually before entry.
  • Yield Percentage per Ingredient – a column that converts as-purchased cost into edible-portion cost, so trim, bone, and cooking loss appear in the portion cost rather than disappearing.
  • Batch Yield (Number of Portions) – an explicit, editable portion count that divides total batch cost into a realistic cost per portion.
  • Waste Factor – a percentage applied to ingredient costs to account for spoilage and preparation waste beyond yield.
  • VAT-Aware Selling Price Column – the suggested selling price should be labelled ex VAT, with a separate cell showing the VAT-inclusive menu price (ex-VAT price × 1.2 for standard-rated items).

The most common failure points in free templates are VAT landing in the wrong column, pack-size-to-unit conversion errors, unhandled yield and sub-recipes, and price staleness where the sheet is correct on day one but wrong by month three because nobody re-keys invoice prices. The UKSheets free Excel recipe costing template handles pack-size conversion, wastage, batch yield, and outputs a suggested selling price ex VAT, but produces no VAT-inclusive menu price and supports only one main ingredient lookup per recipe via VLOOKUP. The Mise free recipe and menu costing spreadsheet applies per-ingredient yield automatically and includes a menu-level view showing food cost % and GP per dish, with capacity for 60 ingredients and 30 menu items, though it has no built-in UK VAT workflow and needs manual configuration of a VAT column.

Even the best free templates have hard limits. The next section outlines the three capabilities that sit beyond any free tool.

What Free Recipe Costing Calculators Cannot Do

Free tools handle static recipe costing adequately. Three capabilities sit structurally beyond them:

  • Live Supplier Price Changes – when a supplier raises the price of a key ingredient, a free calculator or spreadsheet reflects that change only after the operator manually re-enters every affected recipe. Industry studies find kitchens run 3–5% between theoretical and actual food cost. Stale recipe costs are a major contributor to that gap. A recipe costed six months ago is, in the words of one former chain CFO, “fiction.”
  • Whole-Menu GP Dashboards – a free calculator shows the cost of one dish at a time. It cannot show which dishes drag down overall menu GP, which protect it, or how a supplier price change ripples across the full menu simultaneously.
  • POS-Linked Sales Mix – without POS-linked sales, a recipe costing tool can only show theoretical dish cost; it cannot calculate actual cost of goods or identify which products damage margin at volume. Menu engineering, which classifies dishes as Stars, Plowhorses, Puzzles, or Dogs, requires both profitability and sales volume data. Free tools do not provide that combination.

For a deeper look at what automated recipe costing unlocks, see Jelly’s articles on free recipe costing software for UK operators and how to calculate recipe costs automatically.

See Jelly in action for your sites

When To Move Beyond Free: Jelly for Growing UK Operators

Jelly suits UK restaurants, pubs, and boutique hotels that have outgrown the spreadsheet stage. Typical users run £500k+ annual revenue, often expand to 2–5 sites, and need accurate, live margin data without spending 10–20 hours a week on manual admin.

The platform’s core capabilities address the three gaps that free tools cannot fill:

  • Automated Invoice Scanning via email or photo, so every line item is digitised and ingredient costs update without manual re-entry.
  • Price Alert to flag supplier price increases or decreases based on scanned invoices, giving operators evidence to negotiate credits or switch suppliers before the margin impact compounds.
  • Flash Report for a daily gross profit margin view calculated from invoices and POS sales, so operators see their actual GP without waiting for a monthly accountant’s report.
  • Menu Engineering (Sales Mix) via POS integration, so Jelly shows which dishes are most popular and most profitable, enabling data-driven menu decisions.
  • Xero Integration with one-click push of digitised invoices into Xero, reducing bookkeeping time by 90%.

Jelly integrates natively with Square, EPOS Now, Toast, and Lightspeed via real-time API. POS setup takes approximately five minutes across all four systems. These integrations deliver item-level sales data the moment a transaction completes, feeding the Flash Report and Sales Mix analysis automatically.

The results operators report are consistent. According to the manifesto, Jelly saves 10–20 hours of admin per month. It adds 2 percentage points to gross margins on average in the first three months and cuts food costs by 3% on average in the same period. One operator improved gross profit from 65% to 72% within 12 weeks on approximately £500,000 in revenue. Murat Kilic, Chef-Owner of Amber in East London, saves £3,000–£4,000 per month and says: “Jelly keeps my business alive.” Stuart Noble, Head Chef at Cairn Lodge Hotel, cut food costs by 5% in a month after gaining real-time dish cost visibility.

Jelly charges a flat £129/month per location. There are no variable charges per user or feature, and onboarding delivers initial value in the first week.

Talk to Jelly about your margins

Frequently Asked Questions

What Is a Good Food GP Margin for a UK Restaurant?

A food GP margin of 65–72% is the commonly cited UK benchmark, equivalent to a food cost of 28–35% of food sales. These figures are indicative rather than universal. A fine dining operation with premium ingredients may sit closer to 65%, while a well-run casual dining kitchen with tight portion control can reach 70–72%. The right target is the one that covers labour, rent, and other fixed costs and leaves a net profit. A healthy food GP does not guarantee overall profitability if other cost lines sit too high.

Is a Free Recipe Costing Calculator Accurate Enough for a UK Menu?

A free calculator is accurate enough for a static, single-dish cost check, provided it handles VAT correctly, applies yield percentages to ingredient costs, and divides total batch cost by actual portion count. Most free tools fail on at least one of these three inputs. Yield is the most common failure after VAT: costing ingredients at as-purchased weight rather than edible-portion weight systematically understates portion cost, particularly on proteins and fresh produce. As noted in the Key Takeaways, free tools work for smaller, stable menus and become unreliable as menus and price volatility grow.

Does a Free Recipe Costing Calculator Handle UK VAT?

Some tools handle VAT correctly and many do not. The test is straightforward: check that the calculator divides the VAT-inclusive menu price by 1.2 before calculating food cost % and food GP. If the tool uses the sticker price directly as the revenue figure, its output is wrong for any standard-rated UK menu item. Cold takeaway food is zero-rated under HMRC guidance, so for those items the menu price is the net price and no VAT adjustment is needed. Hot food eaten in, hot takeaway, and alcohol are all standard-rated at 20%. Non-VAT-registered operators do not strip VAT from menu prices. For any VAT-registered operator selling standard-rated food, the division by 1.2 is essential.

When Should a UK Restaurant Move Beyond a Free Recipe Costing Calculator?

Three operational triggers show that a free tool has reached its limit. First, supplier prices change frequently enough that manually updating every affected recipe becomes a meaningful time cost, and there is a real risk of missing an update and running a dish at an unknown margin. Second, the operator needs a whole-menu GP view rather than dish-by-dish cost checks. Understanding which dishes protect overall margin and which erode it requires a dashboard that a free calculator cannot provide. Third, POS sales data is available and the operator wants to combine it with recipe costs to see actual cost of goods, identify high-volume low-margin dishes, and make data-driven menu engineering decisions. At that point, the gap between what a free tool can show and what the business needs to manage margins accurately becomes structural.

Conclusion: Getting UK VAT and Menu Margin Maths Right

The VAT calculation sits at the foundation of every UK food GP figure. A free recipe costing calculator that skips the division by 1.2 produces margins that look healthy on screen but do not reflect the revenue the business keeps. The same principle applies to batch yields and waste factors. Costing at as-purchased weight rather than edible-portion weight understates portion cost on every dish that involves trim, bone, or cooking loss.

Before trusting any free calculator’s output, run a three-step sanity check. Divide the menu price by 1.2, divide ingredient cost by the result, and confirm the food cost % sits in the 28–35% range for a standard UK operation. If the tool’s output matches, it handles VAT correctly. If it does not, the tool produces optimistic margins that will not survive contact with a real P&L.

Operators past the spreadsheet stage, running £500k+ in annual revenue, managing multiple sites, or dealing with frequent supplier price changes face a heavy manual maintenance burden with free tools. Jelly automates the invoice-to-margin workflow so that every price change, every dish cost, and every day’s GP stays visible without the admin overhead.

See how Jelly protects your menu margins