Free GP Calculator for UK Restaurant Food Cost Analysis

Written by: JJ Tan

Key Takeaways

1. UK hospitality faces margin erosion in 2026, with hotel food GP at 20–27.7% and targets of 65–75% for food and 75–80% for beverages.
2. Manual GP calculation takes 28 minutes per dish, relies on static data, and misses real-time supplier price fluctuations such as Nestlé’s 2.8–3.8% hikes.
3. GP formula: ((Selling Price ex-VAT – Cost ex-VAT) ÷ Selling Price ex-VAT) × 100, with VAT-inclusive prices converted by dividing by 1.20.
4. Jelly automates invoice scanning, live dish costing in 3 minutes, price alerts, and POS-linked sales mix analysis, saving 10–20 hours weekly.
5. Operators using Jelly achieve around 2% higher GP margins and strong ROI; book a demo with Jelly for real-time GP tracking.

Interactive GP Margin Calculator

Food Cost (£ inc VAT):

Selling Price (£ inc VAT):

Target GP %:

Calculate GP Margin

Results will show: GP Margin %, Food Cost %, and whether you are hitting your target.

Get real-time GP tracking with Jelly – book a demo

The Problem: Supplier Price Fluctuations Crushing UK Hospitality Margins

UK restaurants, pubs, and hotels face severe margin erosion in 2026. Food and beverage margins in London hotels have dropped to just 20%, while provincial hotels achieve 27.7%, nearly 10 percentage points below pre-COVID levels. Overall UK hotel profitability has declined by 4%, ranking third from bottom in Europe as labour costs rise and revenues stay flat.

The manual approach to food costing compounds these challenges. Calculating a single dish cost takes an average of 28 minutes in spreadsheets, and operators lose 10–20 hours weekly on manual data entry and price checking. This delay hides critical supplier price increases such as Nestlé’s 2.8–3.8% price increases across categories in 2025 until it is too late to protect margins.

GP calculation sits at the heart of margin control for UK hospitality. The formula is: ((Selling Price ex-VAT – Cost ex-VAT) ÷ Selling Price ex-VAT) × 100. Convert VAT-inclusive prices to net amounts by dividing the gross price by 1.20. A £12 dish (inc VAT) with £3.70 food cost (inc VAT) equals £10 net selling price and £3.08 net cost, which delivers a 69.2% GP margin.

Manual methods fail because they rely on static data that ignores real-time supplier fluctuations, often contain calculation errors, and overlook factors such as waste percentages and sales mix weighting. Book a demo to see how automation fixes these structural problems.

Manual GP Calculation Steps And Their Limitations

Manual GP calculation follows a simple sequence. First, convert all VAT-inclusive prices to net amounts by dividing by 1.20. Second, apply the formula ((Net Selling Price – Net Food Cost) ÷ Net Selling Price) × 100. Third, compare the result against target margins of 70–75% for food items.

This manual process contains critical flaws. Static data means yesterday’s calculations do not reflect today’s supplier prices. Month-end COGS calculations reveal product profitability only after the fact, which delays visibility into margin erosion from ingredient cost fluctuations. Manual recipe management treats formulas as fixed documents that require constant updates, and teams rarely keep them current.

The time investment also becomes unsustainable. Manual costing takes 28 minutes per dish, while Jelly’s automated system cuts this to 3 minutes through invoice scanning and real-time price updates. COGS calculations in spreadsheets are prone to errors because of many moving parts such as inventory valuation, which leads to misstated profitability.

2026 GP Benchmarks For UK Food And Drink

Clear GP benchmarks help operators judge performance quickly. Food items should achieve 65–70% GP in pubs and 70–75% in restaurants, while beverages typically deliver 75–80% margins. The old “30/30/30/10” rule of 30% food cost, 30% labour, 30% overheads, and 10% profit no longer reflects current operating conditions.

Well-run UK pubs achieve 10–15% net profit margins in 2026, although results vary by location and management quality. Hotels face particular pressure, with profit margins falling to 34.5% in 2025, a 3.6% decline from 2024.

The benchmark targets for 2026 are:

1. Food GP: 70–75% for restaurants, 65–70% for pubs
2. Beverage GP: 75–80% across most segments
3. Net profit: 10–15% for pubs, 20–35% for hotels, although hotel margins continue to decline

These targets become realistic only when teams track costs in real time and react quickly to supplier price changes, instead of relying on monthly reconciliation that exposes problems weeks later.

How Jelly Automates GP For UK Hospitality Teams

Jelly transforms food cost analysis for growing UK restaurants, pubs, and hotels with annual revenue above £500k. The platform automates the workflow from invoice capture through to real-time dish costing, which removes manual calculation errors and delays.

Core features include:

1. Invoice Scanning: Automatic line-item digitisation from photos or emails, with direct Xero integration.
2. Live Dish Costing: Three-minute recipe building using scanned ingredient prices, with automatic unit conversions.
3. Price Alerts: Instant notifications when suppliers increase or decrease prices.
4. Flash Reports: Daily, weekly, or monthly GP margin summaries for quick reviews.
5. Sales Mix Analysis: POS integration with systems such as Square and ePOSnow for menu engineering insights.

These features deliver measurable results. Jelly saves operators 10–20 hours each month and increases GP margins by around 2 percentage points. Amber restaurant in East London saves £3–4k monthly and reports a 68x ROI from Jelly’s automated system.

Customer testimonials show the impact in real kitchens and dining rooms.

“Price hikes were crushing our margins, and I felt helpless. With Jelly, every dish cost is up to date at my fingertips. We slashed food costs by 5% in a month, and it changed how we run the kitchen.” – Stuart Noble, Head Chef, Cairn Lodge Hotel

“Our accountant said we would be lucky to hit 60% gross profit. After using Jelly, we reached 80%. I sleep better knowing my costs are under control.” – Ruth Seggie, Owner, The Howard Arms

Book a demo to see how Jelly’s automated GP margin calculator reshapes your food cost analysis.

Menu Engineering, Sales Mix, And Risks Of Free GP Tools

Sales mix analysis weights GP margins by dish volume and reveals which menu items drive real profit. An 80% GP dish that sells 5 portions a week contributes less profit than a 65% GP dish that sells 50 portions. Jelly’s POS integration automatically calculates weighted GP across the full menu.

Free calculators and manual methods create dangerous blind spots. Manual inventory management struggles with fluctuating food prices from dynamic suppliers, which leads to waste, overstocking, and financial strain. Static tools cannot reflect weekly ingredient price changes, variations in portion sizes between prep staff, or seasonal shifts in waste percentages.

Time lag forms the core pitfall. By the time manual calculations expose margin erosion, suppliers may have implemented several price increases, competitors may have adjusted their pricing, and customer expectations may have moved on. Jelly removes this lag through automated, real-time tracking.

FAQ: GP Margins And Food Costing In UK Hospitality

How do you work out food cost GP in the UK?

Calculate GP using the formula: ((Selling Price ex-VAT – Food Cost ex-VAT) ÷ Selling Price ex-VAT) × 100. Convert VAT-inclusive prices to net by dividing by 1.20. For example, a £12 selling price (inc VAT) becomes £10 net, and a £3.60 food cost (inc VAT) becomes £3 net, which results in 70% GP. Jelly automates this calculation across all menu items using real-time ingredient pricing.

What is the average GP for UK restaurants in 2026?

Target GP margins sit at 70–75% for food and 75–80% for beverages in restaurants. Pubs typically achieve 65–70% food GP and 75–80% drink GP. Hotels face heavy pressure with F&B margins at 20% in London and 27.7% in provincial locations. Net profit margins range from 10–15% for well-run pubs to 20–35% for hotels, although hotel profitability continues to fall because of labour cost pressures.

How does drink GP calculation work for pubs?

Drink GP uses the same formula as food: ((Net Selling Price – Net Cost) ÷ Net Selling Price) × 100. Aim for 75–80% GP on alcoholic beverages. Pubs benefit from higher drink margins than food margins, which makes beverage sales crucial for overall profitability. Jelly integrates with POS systems to track both food and drink GP in real time and supports confident pricing decisions.

Why choose an app over Excel for food costing?

Excel creates static calculations that ignore real-time supplier price changes, which leads to outdated cost information and margin erosion. Manual entry takes 28 minutes per dish, compared with 3 minutes using automated systems. Apps such as Jelly provide live ingredient pricing, automatic VAT handling, POS integration for sales mix analysis, and typically increase GP margins by around 2 percentage points through better accuracy and faster reactions.

What food cost percentage should UK restaurants target?

Target a 25–30% food cost percentage, which translates to a 70–75% GP margin. This benchmark reflects UK-specific factors such as 20% VAT, higher labour costs, and supplier price volatility. Focus on GP margin rather than food cost percentage, because food cost alone can mislead when selling prices vary widely across menu items.

Conclusion: Protect Margins And Grow With Jelly

Manual GP margin calculators and Excel spreadsheets no longer support UK hospitality operators facing volatile supplier pricing and compressed margins. Tighter food margins from inflation and rising ingredient costs require real-time data for price changes and menu planning.

Jelly gives growing restaurants, pubs, and hotels the control and efficiency they need. Automated invoice scanning, real-time dish costing, and POS integration remove 10–20 hours of weekly admin while increasing GP margins by around 2 percentage points. The platform pays for itself through stronger supplier negotiations, lower waste, and smarter menu pricing.

Outdated spreadsheets keep operators flying blind. Join successful venues such as Amber restaurant, which saves £3–4k monthly with a 68x ROI, and The Howard Arms, which now achieves 80% GP margins once thought impossible.

Get real-time GP tracking with Jelly – book a demo and shift your food cost analysis from reactive guesswork to proactive profit protection.