Free GP Calculator for Restaurant Menu Pricing

GP Margin Calculator for Restaurant Menu Pricing Tools

Written by: JJ Tan, Founder, Jelly | Last updated: 22 June 2026

Key Takeaways for UK Restaurant Margins

  • UK food prices have risen sharply, driving 2–5% monthly GP losses for restaurants that still rely on manual spreadsheets.
  • Manual menu costing takes 28 minutes per dish, creating 10–20 hours of admin each month and hiding real-time margin erosion.
  • Gross profit margin uses the formula (Net Menu Price – Net Ingredient Cost) ÷ Net Menu Price × 100, always stripping VAT first.
  • Healthy UK restaurant GP targets sit between 65–75% for food and 70–85% for drinks, while delivery commissions can drop margins to 40% or below without separate pricing.
  • Book a demo with Jelly to automate invoice scanning, live costing and real-time margin visibility, recover hours of admin and lift GP by an average of 2 percentage points.

How Gross Profit Margin Works in a Restaurant

Gross profit margin shows how much revenue remains after you deduct only the direct cost of goods sold such as ingredients, beverages and packaging. It is calculated as (Selling Price – COGS) ÷ Selling Price × 100. Labour, rent, utilities and delivery commissions sit outside this figure and affect net profit instead.

Net-of-VAT formula (use this for internal costing):
GP% = ((Net Menu Price – Net Ingredient Cost) ÷ Net Menu Price) × 100

If you need to check a customer-facing price that includes VAT, remove the VAT first by dividing by 1.20, then apply the same logic.

VAT-inclusive formula:
GP% = (((VAT-Inclusive Price ÷ 1.20) – Net Ingredient Cost) ÷ (VAT-Inclusive Price ÷ 1.20)) × 100

UK restaurants should always strip VAT before calculating GP. A dish priced at £18 inclusive of 20% VAT has a net selling price of £15. If ingredient cost is £4.50, GP = (£15 – £4.50) ÷ £15 × 100 = 70%. Sage illustrates the same principle: an £18 main with £6 COGS yields 67% gross profit margin on the net figure.

Delivery commission should sit in your internal model as an additional direct cost. A dish with a £15 net price, £4.50 ingredient cost and a 30% delivery commission (£4.50) leaves an adjusted GP of (£15 – £4.50 – £4.50) ÷ £15 × 100 = 40%. This example shows clearly why delivery menus need separate pricing.

Applying GP Calculations When Prices Keep Moving

Once you understand the formula, the challenge becomes keeping it accurate as supplier prices move. In practice, the numbers behind GP change constantly while spreadsheets lag behind. Tenzo confirms the same net-of-VAT approach, yet the calculation quickly loses relevance when ingredient costs shift.

Olive oil prices, for example, showed mixed weekly movements of up to 10.66% recently. A change of that size can move a dish from 70% GP to below 60% overnight if no one updates the costing sheet. Britain’s significant import dependency and just-in-time logistics transmit global price shocks to UK food costs faster and with less cushioning than comparable economies. The gap between a supplier invoice and a spreadsheet update becomes a direct margin liability.

GP Targets That Work for UK Restaurants

Single-site and small multi-site UK operators often aim for a food GP between 65–75% and a drink GP between 70–85%, depending on format. Syrve’s 2026 guide discusses tight restaurant profit margins but does not report the specific gross-profit ranges of 60–70 % for full-service restaurants, 70–80 % for bars and pubs, or 65–85 % for cafés. Tenzo highlights the need to review pricing, portion control and supplier costs for UK quick-service restaurants if margins fall consistently below 60%.

These benchmarks assume net-of-VAT calculations and exclude delivery commissions. Third-party delivery commissions in the UK typically range from 15% to 35% per order. A dish that hits 70% GP on a dine-in cover can fall to 40% or below on a delivery platform without a separate, commission-adjusted menu price. Sushi Revolution uses Jelly to set separate target GPs on dine-in and delivery menus, accounting for 30% delivery commissions, and achieves actual gross profits 2–3% higher on average as a result.

Using Excel for GP Margin and Where It Breaks Down

Excel can calculate GP margin by placing net selling price in one column, net ingredient cost in another and applying the formula =(A2-B2)/A2 formatted as a percentage. The structural weakness sits in the data feeding that formula rather than in the formula itself. Every supplier invoice needs manual entry, every price change needs a manual update and every dish requires a fresh calculation.

At 28 minutes per dish, a menu of 30 items represents 14 hours of work before you can make a single strategic decision. That workload repeats whenever suppliers change prices. The result is a constant lag between real costs and the figures in your spreadsheet.

Migrating from Excel to Jelly takes about five minutes per POS connection. Suppliers send invoices to a dedicated Jelly email address or the team photographs them on arrival. Jelly scans every line item automatically, updates ingredient costs in real time and recalculates every dish margin without manual input. Operators consistently recover 10–20 hours of monthly admin and see GP improve by an average of 2 percentage points within the first quarter.

How Jelly Automates GP, Pricing and Margin Control

Jelly serves UK restaurants, pubs and boutique hotels with £500k or more in annual revenue that have outgrown spreadsheets. The platform scans every invoice line item such as quantity, SKU, price and tax from a photo or email, then pushes clean figures directly to Xero. Manual data entry disappears from the workflow.

The Price Alert feature flags every supplier price increase or decrease on the same day it appears on an invoice. Head chefs receive hard data that supports negotiations for credits or supplier switches before margin damage compounds. One operator, Stuart Noble at Cairn Lodge Hotel, cut food costs by 5% within a month of activating price alerts. Another, Murat Kilic at Amber restaurant, saves £3,000–£4,000 per month through faster reactions to price swings and tighter menu controls.

The Flash Report provides a daily, weekly or monthly GP view based on scanned invoice costs and live POS sales data. Jelly integrates natively with leading POS systems such as Square, EPOS Now, Lightspeed and Toast through real-time APIs, and POS setup usually takes under five minutes. 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, showing the impact at scale.

The Delivery Menu feature lets operators duplicate existing dishes and factor in platform commissions to build a separately priced, profitable delivery menu. This approach mirrors the method that delivered Sushi Revolution’s 2–3% GP uplift. Operators who adopt this structure also recover the 10–20 hours of monthly admin described earlier and see GP improve by an average of 2 percentage points within the first quarter.

Jelly charges a flat £129 per site per month with no per-user fees and delivers initial value within the first week of onboarding.

See your live dish margins in the first week by booking a demo and replacing manual spreadsheets with automated costing.

Frequently Asked Questions

What GP targets should UK restaurants, pubs and hotels use?

UK gross profit margin benchmarks vary by format. Full-service restaurants typically target 65–70%, quick-service restaurants 70–75%, cafés and coffee shops 65–85%, fine dining 65–70%, and bars and pubs 70–80%, with the higher end driven by alcoholic beverage markups. Boutique hotels with food and beverage operations usually align with full-service restaurant benchmarks for their kitchen output. Anything consistently below 60% should trigger an immediate review of menu pricing, portion sizes and supplier costs. These figures assume net-of-VAT calculations and exclude delivery platform commissions, which you should model separately for any dishes sold through third-party channels.

How should UK restaurants handle VAT in GP calculations?

UK restaurants should always strip VAT before calculating gross profit margin. Supplier invoices usually show net and VAT amounts separately, so ingredient costs should come from the net, ex-VAT figure. For menu prices, divide the VAT-inclusive price by 1.20 for standard-rated items to obtain the net selling price before applying the GP formula. Using VAT-inclusive figures on either side of the calculation inflates the GP percentage artificially.

Zero-rated items such as cold takeaway food do not need adjustment on the selling price, although supplier costs should still be taken net of any recoverable input VAT. Jelly’s invoice scanning captures VAT at line-item level automatically so the figures feeding dish cost calculations stay net and accurate.

How do delivery commissions affect restaurant GP in practice?

In standard accounting, delivery commissions sit outside COGS and do not reduce gross profit margin, although they reduce net profit. For operational decisions, treating commissions as a direct cost against each delivery sale gives a clearer picture of channel profitability. UK delivery platforms typically charge 15–35% commission per order, and additional variable costs such as packaging and order-management systems erode margins further.

A dish achieving 70% GP on a dine-in cover can fall to 40% or below on a delivery platform at a 30% commission rate. The practical fix is a separate delivery menu with prices set to reach the same target GP after commission. Jelly’s Delivery Menu feature automates this calculation and lets operators duplicate dishes and apply commission overheads directly within the platform.

What data shows the cost of manual spreadsheet menu costing?

Manual spreadsheet costing takes an average of 28 minutes per dish, so a 30-item menu requires about 14 hours of work before any margin analysis becomes available. That figure resets every time a supplier price changes. Across a month, operators typically spend 10–20 hours on manual data entry, price checking and invoice reconciliation.

The deeper issue is lag. By the time a spreadsheet is updated and reviewed, the price change that triggered the exercise may already have eroded GP for several weeks. Jelly users remove this lag entirely. Invoice scanning updates ingredient costs on the same day a delivery arrives, dish margins recalculate automatically and the Price Alert feature surfaces supplier changes in real time. The result is an average of 10–20 hours of monthly admin recovered and a 2 percentage point GP improvement within the first quarter of use.

Conclusion: Replace Manual GP Processes with Jelly

UK food inflation, delivery platform commissions and manual spreadsheet workflows erode restaurant GP at the same time. Each factor is manageable on its own, yet together they can create a 2–5% monthly margin loss that compounds quietly until it becomes a structural problem.

Jelly addresses all three pressure points. Automated invoice scanning removes manual data entry. Live dish costing and the Price Alert feature surface supplier changes on the same day they occur. POS integration delivers real-time sales mix and margin data without extra admin, while the Delivery Menu tool ensures every channel is priced to hit its target GP after commissions. Xero integration then keeps the accounts payable process clean and accurate.

At a flat £129 per site per month with no per-user fees and a one-week time-to-value, Jelly becomes a low-effort upgrade from Excel that often pays for itself in the first month.

Take control of your margins with a Jelly walkthrough and see how automated costing replaces manual spreadsheets in days.