Written by: JJ Tan, Founder, Jelly | Last updated: 24 August 2026
Key Takeaways for UK Restaurant Margins
- UK restaurants lose thousands each year to hidden margin erosion from supplier price creep, untracked waste and delayed invoice data.
- Accurate GP calculations must always strip VAT first, because using gross figures overstates margin by around 17 percentage points.
- The correct ex-VAT GP formula is ((Net Selling Price − Waste-Adjusted COGS) ÷ Net Selling Price) × 100, with a 5–10% spoilage allowance built into recipe costs.
- Delivery margins need separate targets. Typical 30% platform commissions reduce realistic GP to 35–40%, far below dine-in benchmarks of 65–70%.
- See live GP tracking in action and replace manual spreadsheets with automated margin updates the moment supplier prices change.
Why Ex-VAT GP Calculations Matter for £500k+ Restaurants
Every UK restaurant VAT-registered above the £90,000 taxable turnover threshold collects VAT on behalf of HMRC. That money never belongs to the business. Running GP calculations on VAT-inclusive revenue therefore overstates margin, by approximately 17 percentage points.
A concrete example shows the impact. £10,200 in gross food revenue with £2,890 food cost produces an apparent GP of 71.7% when calculated on the gross figure, but the correct GP on £8,500 net revenue is 66%. That 5.7-point gap separates a business that believes it is thriving from one that is quietly underfunded.
For operators at the £500k+ level, where a single percentage point of margin represents thousands of pounds annually, using gross figures creates a serious strategic blind spot.
The UK GP Margin Formula Using Ex-VAT Prices
Under VAT Notice 709/1, all food and drink consumed on UK restaurant premises is standard-rated at 20%. The correct formula strips that VAT before any margin calculation.
- Net Selling Price: Menu Price ÷ 1.20
- GP Margin %: ((Net Selling Price − COGS) ÷ Net Selling Price) × 100
COGS here means the full cost of ingredients as actually used, including a spoilage allowance (typically 5–10%) built into the recipe cost before the selling price is set. A dish priced at £18 on the menu has a net selling price of £15. If the recipe cost including a 7% waste allowance is £4.50, the GP margin is ((£15 − £4.50) ÷ £15) × 100, which equals 70%.
Four Practical Steps to Calculate GP Margin
- Strip VAT from the menu price. Divide the menu price by 1.20 to obtain net selling price. A £24 main course becomes £20 net. Simply subtracting 20% from the gross figure produces the wrong answer, so always divide by 1.20.
- Calculate portion cost with waste included. Sum all ingredient costs for the dish at current invoice prices, then adjust for waste. A target food cost combined with waste produces a higher actual food cost, and that difference compounds across the menu.
- Apply the GP formula. Use (Net Selling Price − Waste-Adjusted COGS) ÷ Net Selling Price × 100 to obtain the GP percentage for the dish.
- Compare your result with industry benchmarks. Use the channel-specific targets in the next section as a reference. A result below 60% on food signals that pricing, waste or supplier costs need immediate investigation.
2026 UK GP Margin Benchmarks by Channel
UK industry targets for 2026 set food GP at 65–70% and drinks GP at 65–75%, with a combined blended target of 63–68%. These ranges reflect what healthy UK independent restaurants achieve when they maintain disciplined cost control and regular margin reviews.
Delivery operates as a separate channel and requires its own targets. Deliveroo and Uber Eats charge 30% commission, leaving the restaurant with just 70p of every pound of delivery revenue before food cost, packaging or labour. A realistic delivery GP target after that commission sits at 35–40%, which is materially lower than dine-in. Any operator benchmarking delivery against dine-in GP targets compares incompatible numbers.
Combined GP on food that falls below 58–60% signals that food cost, waste or pricing requires urgent attention.
Waste Allowances and Portion Control That Protect GP
Most UK restaurant kitchens run 5–15% wastage from trim, spoilage and over-prep. If you only price the raw recipe, every bit of trim and spoilage comes straight out of your margin. The allowance needs to sit inside the recipe cost before the selling price is set, not as an afterthought.
Beyond building waste into pricing, you can reduce the waste itself through tighter inventory control. Regular stock checks against par levels can reduce food cost by 2–5 percentage points by catching over-ordering and spoilage before they compound. That improvement flows straight into GP without any menu repricing.
Typical restaurant waste varies by format. Anything above 10% points to purchasing, storage or portioning problems that need structural fixes, not just tighter counting.
Delivery GP Margin When Platforms Take 30% Commission
Delivery platforms such as Deliveroo and Uber Eats charge average commissions of 30%, which they deduct from order revenue before food costs, packaging or labour. This treatment makes commission a pre-cost revenue reduction, not a simple line-item expense, and your model needs to reflect that.
To keep the same gross-profit percentage after a 30% platform commission, UK restaurants must raise delivery-menu prices by approximately 43%. Many operators instead apply 15–25% mark-ups and accept lower margins. On a £22.50 delivery order at 30% commission, the restaurant retains £15.75 before any other cost is incurred.
Sushi Revolution uses Jelly to set separate target gross profits on dine-in and delivery menus, accounting for delivery commissions, which results in actual gross profits 2–3% higher on average. Jelly’s Delivery Menu Creation feature makes this straightforward. You duplicate an existing menu, apply the commission overhead, and the platform recalculates GP targets automatically.
See delivery margin automation in your own menu and schedule a quick walkthrough with the Jelly team.
How to Calculate GP Margin in Excel Manually
The manual Excel process for a single dish involves pulling the latest invoice price for every ingredient SKU, converting units, applying a waste percentage, summing the portion cost, dividing the menu price by 1.20, and running the GP formula. On average, this takes 28 minutes per dish. A menu of 30 items represents 14 hours of work, before you even consider that ingredient prices change with every new invoice.
The core Excel formula structure is:
- Net Selling Price:
=Menu_Price/1.2 - Waste-Adjusted COGS:
=Raw_Recipe_Cost*(1+Waste_Pct) - GP Margin %:
=((Net_Selling_Price-Adjusted_COGS)/Net_Selling_Price)*100
The structural problem with Excel comes from maintenance, not from the formula itself. Every supplier price change requires a manual update across every dish that uses that ingredient. Most operators discover the error weeks later, after the margin has already disappeared. A downloadable template can help with initial setup, but it cannot remove the ongoing data-entry burden or the delay between price change and operator awareness.
The Solution: Jelly for Live GP Margin Control
Jelly replaces the spreadsheet workflow entirely. Every invoice, captured by photo or forwarded by email, is scanned automatically, with every line item, SKU, quantity and price digitised without manual input. When a supplier raises the price of an ingredient, every dish that uses it updates in real time. The GP margin for every item on the menu stays current.
The Price Alert feature flags every price increase or decrease the moment a new invoice is processed, giving chefs and owners the hard data needed to negotiate credits, switch suppliers or reprice dishes before the margin impact compounds. To show the cumulative effect of those changes, the Flash Report delivers a daily, weekly or monthly view of GP margin calculated from actual invoice costs and live POS sales data.
That live POS data comes from Jelly’s native integration with Square, EPOS Now, Lightspeed and Toast. The platform pulls item-level sales data via real-time API the moment a transaction completes, and POS setup takes under five minutes. The Sales Mix report then shows which dishes are most popular and most profitable, which guides menu engineering decisions.
Operators using Jelly see an average GP improvement of 2 percentage points within the first three months. One operator improved gross profit from 65% to 72% within 12 weeks on approximately £500,000 in revenue. Populu lifted GP from 68% to 72% across 16 locations. Cairn Lodge Hotel cut food costs by 5% in a month. The Howard Arms reached 80% gross profit after their accountant had suggested 60% as the ceiling.
Jelly is priced at a flat £129 per month per location, with no per-user charges and no variable fees.
Get live GP margins running this week and let the Jelly team walk you through setup in under 30 minutes.
Frequently Asked Questions
How do you calculate GP for food?
GP for food is calculated on the ex-VAT selling price. First, divide the menu price by 1.20 to strip UK standard-rate VAT and obtain the net selling price. Then subtract the cost of ingredients used in the dish, including a waste allowance of 5–10%, from the net selling price. Divide that result by the net selling price and multiply by 100 to express it as a percentage. For example, a dish with a £15 net selling price and £4.50 waste-adjusted ingredient cost achieves a 70% food GP margin.
What is the formula for calculating the gross profit margin for a restaurant?
The standard formula is: GP Margin % = ((Net Revenue − Cost of Sales) ÷ Net Revenue) × 100. Net Revenue is total sales excluding VAT, obtained by dividing VAT-inclusive revenue by 1.20. Cost of Sales is calculated as Opening Stock + Purchases − Closing Stock, which automatically incorporates waste and spoilage through actual stock consumed. This formula applies at both the individual dish level and the whole-business level.
How do you calculate GP margin in Excel?
In Excel, set up three columns: Net Selling Price (menu price divided by 1.2), Waste-Adjusted COGS (raw recipe cost multiplied by 1 plus your waste percentage), and GP Margin % (net selling price minus adjusted COGS, divided by net selling price, multiplied by 100). The limitation of Excel is that ingredient prices must be updated manually every time a supplier invoice changes. As noted earlier, this manual process becomes unsustainable at scale. Jelly automates this entirely by scanning invoices and updating every dish cost in real time, which reduces the same task to minutes.
Is 70% GP good for a UK restaurant?
70% food GP is a strong result for a UK independent restaurant and sits near the upper end of typical 2026 targets. It corresponds to a food cost of 30%, which falls within the 28–35% benchmark for casual dining and food pubs. Whether 70% is sufficient depends on the operator’s labour costs, rent and overheads, because a restaurant achieving 70% food GP but carrying high fixed costs may still report a net margin of only 4–7%. Drinks GP targets usually run higher, at around 75–80%, and delivery GP targets run lower, at 35–40% after platform commission.
Conclusion: Protect GP by Replacing Manual Processes
The formula for GP margin stays simple, but the data behind it changes constantly. Volatile supplier prices, untracked waste, delivery commissions and slow invoice flows all undermine accuracy. Every day that passes without accurate, ex-VAT GP numbers allows margin erosion to continue unchecked.
Jelly turns invoice scanning and POS integration into live, accurate GP margins that update automatically, remain visible to owners and chefs, and become actionable the same day a price changes. No spreadsheets, no waiting for the accountant, and no flying blind.
Start protecting your margins today and connect with the Jelly team to see how automated GP tracking works in your operation.