Written by: JJ Tan, Founder, Jelly | Last updated: 10 September 2026
Key Takeaways
- Real-time GP margin calculators replace static spreadsheets by linking live supplier invoices to POS sales data, so dish margins update instantly when ingredient prices change.
- UK operators must always strip 20% VAT from menu prices before calculating GP, using the net selling price as the denominator to avoid overstating profitability.
- Accurate GP calculations require including wastage, packaging costs, and delivery platform commissions that most spreadsheets omit.
- Menu engineering becomes actionable when dishes are classified by live GP margin and sales volume, enabling targeted re-pricing, recipe changes, or removal of underperforming items.
- Jelly automates the entire workflow from invoice scanning to live dish margins and See how Jelly helps UK operators protect margins in real time.
The Problem: Static Spreadsheets Cannot Keep Up With Live Supplier Prices
Costing a single menu item in a spreadsheet takes around 28 minutes. With multiple suppliers adjusting prices weekly, a dish that was profitable on Monday can be losing money by Friday, and nobody in the kitchen sees it until the accountant’s monthly report lands. By then, the damage has already compounded across hundreds of covers.
This is a margin-control problem rather than a maths problem. The formula for GP margin is straightforward. The real challenge is keeping the inputs current. A spreadsheet retains the old ingredient cost until someone manually re-enters it, so a recipe becomes wrong the moment a supplier changes a price, and 70% of recipes carry an outdated cost after a single supplier price change, because one price movement affects every recipe using that ingredient unless each is manually recosted the same day.
The lag compounds further because wastage, packaging, and delivery platform commissions are usually missing from the sheet entirely. Many UK kitchens run wastage without building it into pricing, and delivery platforms such as Deliveroo and Uber Eats charge average commissions of 30%, a cost that rarely appears on a static recipe card.
Real-Time GP Margin And The Core Formula
Real-time GP margin tracks live menu profitability by linking automated supplier invoices with POS sales data, so every dish margin updates the moment an ingredient price changes. It behaves as a continuous feed from invoice to dish cost to sales mix rather than a one-off snapshot.
The formula is:
GP margin % = (Net selling price − dish cost) ÷ Net selling price × 100
In the UK, consumer-facing menu and website prices must be VAT-inclusive under the CMA’s price transparency guidance (CMA209), which requires the total price presented to consumers to include tax such as VAT. The VAT-exclusive selling price must therefore always be used as the denominator. The VAT was never the restaurant’s to keep.
Net selling price = Menu price ÷ 1.20
A £12.00 VAT-inclusive menu item becomes £10.00 net after stripping 20% VAT (£12.00 ÷ 1.20). Calculating GP on the £12.00 gross figure overstates margin and treats tax as revenue, a common error that distorts profitability.
How To Calculate GP Margin For A Restaurant Menu Item
To calculate GP margin accurately, you need to strip VAT from the menu price, total every ingredient cost from invoice line items, apply wastage, add packaging and delivery commission where relevant, and then divide gross profit by the net selling price. The full workflow is as follows.
- Take the menu price and strip 20% VAT by dividing by 1.20.
- Add up every ingredient cost from invoice line items, including unit conversions.
- Apply a wastage percentage to ingredient costs.
- Add packaging and delivery commission where relevant.
- Subtract total dish cost from net selling price.
- Divide by net selling price and multiply by 100.
Worked example – chicken main: Menu price £16.50 including VAT. Net selling price: £16.50 ÷ 1.20 = £13.75. Ingredient costs from invoices: £4.10. Wastage at 8%: £4.10 × 0.08 = £0.33. Total dish cost: £4.43. GP = (£13.75 − £4.43) ÷ £13.75 × 100 = 67.8%.
Real-Time GP Vs Spreadsheet Costing
The operational difference between a static spreadsheet and an automated real-time workflow is a margin-protection gap. Spreadsheet-based recipe costing is static: it reflects the prices entered when the sheet was built, not the prices currently being paid. Jelly replaces the 28-minute spreadsheet costing process with around 3 minutes per menu item. The table below summarises the key differences between manual spreadsheet costing and an automated real-time workflow.
| Attribute | Manual Spreadsheet Costing | Automated Real-Time Workflow |
|---|---|---|
| Time per dish | ~28 minutes | ~3 minutes |
| Update frequency | Manual, typically monthly | Every invoice, in real time |
| Margin visibility | Stale between updates | Live red/green indicator |
A static GP margin calculator cannot protect margins when supplier prices move mid-month. Salmon rising from £10/kg to £13/kg while menu prices stay fixed drops a dish’s GP from 72% to 64%, and nobody sees it until the spreadsheet is manually updated, if it ever is.
What Is A Good GP Margin For A UK Restaurant?
UK benchmarks are 65–72% for food and 75–80% for beverages, with a blended target of around 70% across the whole menu for healthy independents. UK pubs and bars average 68–72% overall, with wet-led pubs hitting 75–80% on drinks.
When a dish falls below target, the options are clear. You can re-price the dish, re-engineer the recipe to reduce ingredient cost, switch to an alternative supplier, or remove the dish from the menu. Menu engineering, promoting high-margin items and reviewing anything below 60% GP, often achieves as much as price rises alone with less risk of customer pushback.
The average UK restaurant net profit margin sits at 3–5%. This illustrates why gross margin discipline matters so acutely. A restaurant with 65% gross margin often reports only 4–7% net margin, because the fixed cost base of rent, labour, and utilities remains unchanged when revenue drops. A 50% GP is not inherently too much; context determines whether it is viable. However, a menu averaging 60% GP can be busy every night and still lose money once labour, rent, and overheads are applied. The 30/30/30 rule is a restaurant budgeting benchmark that allocates roughly 30% of revenue to food cost, 30% to all-in labour cost, and 30% to overhead and operating expenses, leaving approximately 10% as net profit. It acts as a starting-point sanity check rather than a target, since average restaurant profit margins typically run between 3% and 9%.
Understanding these benchmarks is essential, but they are only meaningful if your GP calculations are accurate. A critical first step is handling VAT correctly.
How To Handle VAT In Menu GP Calculations
UK menu prices include 20% VAT, so GP must always be calculated on the VAT-exclusive selling price. UK profit margins are always calculated on revenue and costs exclusive of VAT, because VAT collected from customers and paid to HMRC passes through the business and is neither income nor expense.
To strip VAT: Net price = Menu price ÷ 1.20. A £15.00 menu item has a net selling price of £12.50. The £2.50 belongs to HMRC rather than the restaurant.
The common mistake is calculating GP on the gross menu price. On a dish with £4.00 ingredient cost selling at £15.00 gross, using the gross figure gives an apparent GP of 73.3%. Using the correct net price of £12.50 gives 68.0%, a 5.3 percentage point overstatement that makes a marginal dish look healthy. Operators who calculate GP on the VAT-inclusive sticker price treat tax as revenue and distort profitability.
Factor Wastage, Packaging, And Delivery Commissions Into Live GP
Three costs materially affect per-dish profitability and often go missing from GP margin calculators: wastage, packaging, and delivery platform commissions.
Wastage from trim, spoilage, and over-prep frequently goes unpriced in many kitchens. Applying an 8% wastage factor to £4.10 of ingredient costs adds £0.33 to the true dish cost, enough to shift a borderline dish from profitable to loss-making at scale.
Packaging costs for most UK takeaway food run £0.20–£0.80 per order, and should be costed per dish rather than absorbed as a vague overhead. UK delivery platform commissions run 25–35% of the order total for Uber Eats, Deliveroo, and Just Eat.
Delivery worked example: A dish with a £13.75 net selling price and £4.43 total dish cost achieves 67.8% GP on dine-in. Sold through a delivery platform charging 30% commission, the effective net revenue drops to £9.63 (£13.75 × 0.70). GP on delivery = (£9.63 − £4.43) ÷ £9.63 = 54.0%, a 13.8 percentage point collapse that makes the dish unprofitable against a 65% target.
The solution is a separate delivery menu with prices set to protect margin after commission. Sushi Revolution uses Jelly to set separate target gross profits on dine-in and delivery menus, accounting for 30% delivery commissions, resulting in actual gross profits 2–3% higher on average. Jelly’s delivery menu creation duplicates existing menu items and factors in delivery commission overheads, so operators build a delivery-specific price that protects margin without manually recalculating every dish.
Connecting POS Sales Mix To GP For Menu Engineering
Menu engineering classifies every dish by two dimensions: profitability, based on live GP margin, and popularity, based on sales volume from POS data. The four categories are:
- Stars – high margin, high popularity. Protect and promote.
- Puzzles – high margin, low popularity. Reposition on the menu or support with staff upsell scripts.
- Ploughhorses – low margin, high popularity. Re-engineer the recipe, negotiate supplier costs, or add a premium variant.
- Dogs – low margin, low popularity. Remove or replace.
A well-engineered menu can increase gross profit by 10–15% without adding a single new customer. A UK example: a popular lamb shank (ploughhorse) selling 60 covers per week at 58% GP is a candidate for recipe re-engineering or a £1.50 price increase. A pan-fried sea bass (puzzle) achieving 74% GP but selling only 12 covers per week needs repositioning, such as a featured special or a staff recommendation prompt, before it is considered for removal.
To apply this classification, you need accurate sales data. POS systems are complementary tools that feed item-level sales data into this workflow. Jelly integrates natively with leading systems via real-time API, with POS setup taking approximately five minutes across all supported systems. The moment a transaction completes, item-level sales data flows into Jelly’s Sales Mix report, classifying dishes by profitability and popularity without any manual export.
The Solution: Jelly Automates The Full Loop From Invoice To Live Dish Margin
Jelly is the real time GP margin calculator built for UK restaurant, pub, and boutique hotel operators. It automates the full loop. Invoice scanning captures every line item automatically. Recipe costing in the Kitchen section builds dishes by clicking ingredients already populated from invoices. POS integration brings in item-level sales, so GP margins update in real time the moment a supplier price changes or a transaction completes.
- Automated invoice scanning via email or photo
- Live dish costing with red and green margin indicators
- Price Alert for every supplier price increase or decrease
- Flash Report for daily, weekly, or monthly GP margin
- Sales Mix menu engineering
- One-click accounting integration with Xero
Jelly onboards and generates initial value in the first week. Customers’ gross margins increase on average by 2 percentage points in the first 3 months.
Amber, a Mediterranean restaurant in East London run by Chef-Owner Murat Kilic, saves £3,000–£4,000 per month using Jelly, approximately 68× ROI. “Jelly keeps my business alive,” Murat says. One operator improved gross profit from 65% to 72% within 12 weeks on approximately £500,000 in revenue after connecting their POS to Jelly’s Sales Mix workflow.
See how Jelly automates your invoice-to-margin workflow – book a demo.
Common Mistakes That Overstate Margins
Several errors consistently inflate reported GP and mask the true profitability of a menu:
- Omitting VAT: Calculating GP on the £16.50 gross menu price instead of the £13.75 net price overstates margin by several percentage points on every dish.
- Using stale recipe costs: A signature dish using minced beef at $6.20/kg shows a spreadsheet cost of $3.85, but when the supplier raises the price to $7.10/kg the true cost becomes $4.12, a 7% gap that quietly leaks margin.
- Ignoring wastage: A sheet that omits 8% prep wastage understates the true plate cost on every dish that uses that ingredient.
- Forgetting packaging and delivery commissions: The delivery worked example above shows how a healthy dine-in GP can collapse once commission and packaging are included.
- Not updating dish costs when supplier prices change: Supplier price creep, an ingredient rising gradually while menu prices stay fixed, is one of the three silent causes of GP erosion in UK restaurants.
Frequently Asked Questions
What Is The Formula For Calculating GP Margin For A Restaurant?
GP margin % = (Net selling price − dish cost) ÷ Net selling price × 100. Net selling price is always the VAT-exclusive figure, so for a standard-rated UK menu item, divide the menu price by 1.20 before applying the formula. Dish cost includes all ingredient costs from invoice line items, plus wastage, packaging, and delivery commission where applicable. Jelly automates every input in this formula, so the margin figure updates in real time rather than requiring manual recalculation.
What Is The Average Profit Margin For Restaurants In The UK?
UK restaurants typically achieve a gross profit margin of 65–72% on food and 75–80% on beverages, but net profit margins, after labour, rent, utilities, and overheads, average only 3–5%. The gap between gross and net is the largest of any UK sector, which is why gross margin discipline matters so acutely. Operators running below 65% GP on food should audit ingredient costs, wastage, and menu pricing before assuming the problem is revenue.
Is A 50% Profit Margin Too Much?
In the context of gross profit margin, 50% sits below the UK benchmark for food-led operations and usually signals a problem with food cost, menu pricing, or both. A 50% GP means half of every pound of net revenue is consumed by ingredient costs alone, leaving insufficient margin to cover labour, rent, and overheads at typical UK rates. In the context of net profit margin, 50% would be exceptional, as the UK restaurant sector average is 3–5% net. The two figures measure different things and should not be conflated.
What Is The 30/30/30 Rule?
The 30/30/30 rule is a planning heuristic for UK restaurant operators: target approximately 30% of revenue on food and beverage cost, 30% on labour, and 30% on fixed overheads including rent, rates, and utilities, leaving around 10% for net profit. It acts as a starting framework rather than a precise benchmark, because actual ratios vary significantly by concept, location, and service model. Operators using Jelly’s Flash Report can track each cost line against their own targets daily rather than waiting for a monthly P&L.
Conclusion: Move From Static Spreadsheets To Live GP Visibility
A spreadsheet is a snapshot, while your supplier prices are a moving target. Every week that passes without live margin visibility is a week where a price increase, a wastage spike, or a delivery commission quietly erodes GP that nobody will see until month-end or later.
The correct formula is simple. Stripping VAT, applying wastage, factoring packaging and delivery commissions, and connecting POS sales mix to live GP creates the full workflow. The problem has never been the maths. It has always been keeping the inputs current across multiple suppliers, multiple dishes, and multiple sites in real time.
Jelly automates the full loop from invoice line item to live dish margin. Operators onboard in the first week, see margin indicators turn green within days of catching their first price alert, and add an average of 2 percentage points to gross margin within 3 months. “Jelly keeps my business alive,” says Murat Kilic of Amber restaurant, saving £3,000–£4,000 per month.
Ready to replace your spreadsheet? Start your Jelly trial or book a demo today.