GP Margin Calculator for UK Pub Menus: Complete Guide 2026

Written by: JJ Tan

Key Takeaways

1. Manual GP calculations take around 28 minutes per dish during 5.7% UK food inflation. This makes profitability tough for pubs targeting 65-75% food margins and 70-80% drink margins.
2. Follow a clear 5-step process: gather ex-VAT invoice costs, build recipes with quantities, calculate portion costs, set ex-VAT selling prices, then apply the GP formula for accurate margins.
3. UK pub benchmarks show food at 65-75% GP, often eroding to 60% due to inflation. Drinks sit at 70-80%, and wine at 75-85%. Use menu engineering to promote Stars and remove Dogs.
4. Excel templates automate formulas, but still need manual updates. Common mistakes include using VAT-inclusive prices, relying on outdated costs, and ignoring wastage, so add 5-10% to cover it.
5. Jelly replaces manual work with automated invoice scanning, real-time GP tracking, and typical 2% margin boosts, saving 10-20 hours each month. Book a demo today.

Manual GP Margin Calculation for Pub Menus: 5 Clear Steps

Step 1: Gather Ingredient Costs from Invoices (Ex-VAT)

Start with accurate ingredient costs from supplier invoices, using prices that exclude VAT. UK pubs reclaim VAT on purchases, so net prices give a true picture of food cost. Record each ingredient’s unit price, pack size, and delivery date to track price changes over time.

Step 2: Build Each Dish Recipe with Exact Quantities

Write down precise ingredient quantities for every menu item, including portion sizes and preparation details. Add a wastage allowance of around 5-10% to cover trimming, spoilage, and mistakes. Convert supplier pack sizes into recipe portions using consistent units such as grams, millilitres, or pieces.

Step 3: Calculate the Total Cost per Portion

Multiply each ingredient quantity by its unit cost, then add all ingredient costs to find the total cost per portion. Add labour costs for complex or time-consuming preparations where relevant. Include cooking losses for proteins and vegetables so the cost reflects what reaches the plate.

Step 4: Work Out the Selling Price Ex-VAT

Convert menu prices to VAT-exclusive amounts with a simple formula: Selling Price Ex-VAT = Menu Price ÷ 1.2. A £15 menu item becomes £12.50 excluding VAT, which you then use in your GP calculations.

Step 5: Apply the GP Formula to Check Profitability

Use this formula to calculate GP percentage: (Selling Price Ex-VAT – Total Cost) ÷ Selling Price Ex-VAT × 100. This shows the true profitability of each dish without VAT distorting the margin.

Excel tools can handle these calculations with formulas and basic automation. They still rely on manual price updates and do not connect in real time to supplier invoices or POS systems.

UK Pub GP Benchmarks and Practical Menu Engineering Tips

UK pub GP benchmarks differ across food and drink categories. Casual dining venues often run 30-35% COGS, which equals 65-70% GP margins.

Menu engineering groups dishes into four types: Stars, Puzzles, Plowhorses, and Dogs. Stars combine high profit with high popularity, so highlight them on menus and brief staff to recommend them. Puzzles deliver strong profit but low popularity, so improve descriptions, placement, and upselling to increase orders.

Plowhorses sell well but earn low profit, so adjust prices or recipes to lift margins without losing volume. Dogs perform poorly on both profit and popularity, so remove them from the menu and free space for better performers.

VAT exclusion remains essential for accurate GP calculations. Including VAT inflates revenue figures and distorts margins by about 16.7%, which creates misleading profitability reports and weak pricing decisions.

Manual and Excel GP Calculators vs Jelly: Automation for Busy Pubs

Manual GP calculations rely on static data, suffer from human error, and consume valuable time. Spreadsheet systems often take around 28 minutes per dish, while Jelly completes automated costing in about 3 minutes. Supplier price changes can slip through unnoticed for weeks, which quietly erodes margins without the operator realising.

Jelly scans invoices automatically, updates live dish costs, and sends price alerts when supplier rates change. It connects with POS systems such as Square and ePOSnow to match sales data with costs. The platform provides Sales Mix analysis for menu engineering, Flash Reports for daily GP tracking, and one-click accounting integration with Xero.

Customers typically see gross margin increases of around 2 percentage points in the first three months. This improvement comes from automated insights, faster reactions to price changes, and real-time margin tracking across the menu.

Competitive platforms like MarketMan usually focus on larger multi-site operations. Many legacy systems also need dedicated office teams to maintain data. Jelly’s £129 per location pricing includes one-week onboarding and delivers quick wins through price alerts and clear spending insights.

Pubs that want to remove manual GP headaches can move to automation quickly. Book a demo, schedule a chat and see how a 2 percentage point uplift in GP can transform your pub’s profit.

Pub GP Success: Pro Tips, Common Pitfalls, and Quick Fixes

Build 5-10% wastage into every food cost calculation to cover preparation losses, spoilage, and portion variation. Use standardised serving tools and clear training, so staff serve consistent portions and protect margins.

Negotiate with suppliers using real data on price increases rather than guesswork. Track ingredient prices over three to six months, then use those trends and volume commitments to secure better rates.

Watch for three common pitfalls: including VAT in cost calculations, relying on old ingredient prices, and ignoring seasonal price swings. Strong performance usually includes holding 70% or higher GP margins, spotting 5% price increases within 24 hours, and cutting admin time by at least 15 hours each week.

FAQs: GP Margin Calculator for Pub Menus

What is the average pub GP margin in the UK for 2026?

Food GP margins typically target 65-75%, although inflation has pushed many pubs down to about 60% on average. Drinks often maintain 70-80% margins because ingredients cost less and waste stays lower. Wine and premium spirits can reach 75-85% margins through careful pricing and premium positioning.

How do I create a GP calculator in Excel for my pub?

Create an Excel sheet with columns for ingredient names, quantities, unit costs, and total cost per portion. Use formulas to multiply quantities by unit costs and sum them for each dish. Add formulas to calculate GP percentages from cost and selling price.

Include VAT conversion formulas so you can switch between ex-VAT and inc-VAT prices. Keep in mind that every price change still needs manual updates, which takes time and increases the risk of errors compared with automated tools.

Why do drinks have higher GP margins than food?

Drinks usually earn higher margins because recipes are simpler, preparation is faster, and waste is minimal. Alcoholic drinks also benefit from strong brands and customer willingness to pay more for perceived quality. Food requires more labour, involves spoilage risk, and suffers from portion inconsistencies, which all reduce GP.

How do I calculate menu prices from target GP margins?

Use this formula for menu pricing: Menu Price = (Ingredient Cost ÷ (1 – Target GP%)) × 1.2 to include VAT. A dish that costs £3.50 and targets 70% GP needs £11.67 ex-VAT or £14 including VAT. Adjust the final price for your market position and competitor set while still protecting your target margin.

What is the biggest mistake in pub GP calculations?

The biggest mistake often comes from mixing VAT treatments. Including VAT in cost calculations while excluding it from revenue figures creates false margin compression. Always treat VAT consistently across both costs and sales.

Another major issue comes from using outdated ingredient prices and ignoring portion control. These problems can distort GP calculations by 10-15% and hide serious profit leaks.

Conclusion: Use Jelly to Take Control of Pub Menu GP

Manual GP margin calculations can drain 28 minutes per dish while constant supplier price changes quietly cut into profit. Jelly turns that manual workload into automated insight, with real-time dish costing, instant price alerts, and menu engineering tools that typically lift gross margins by around 2 percentage points and save 10-20 admin hours every month.

Move away from spreadsheet battles and focus on running a more profitable pub with smart automation. Book a GP margin calculator demo for your pub menu, schedule a chat today, and see how leading UK pubs protect margins in 2026’s challenging market.