Written by: JJ Tan, Founder, Jelly | Last updated: 22 June 2026
Key Takeaways for 2026 UK Hospitality Margins
- UK hospitality operators still lose hours each week to manual spreadsheets that cannot keep up with daily supplier price changes.
- Accurate GP calculations must always strip VAT from both selling price and ingredient cost before applying the standard formula.
- Building a 5–15% waste buffer into ingredient costs produces more honest GP figures than using raw invoice prices alone.
- Delivery commissions of around 30% require separate menu pricing, as they can reduce GP by 10 percentage points or more compared with dine-in.
- Jelly automates invoice scanning, recipe updates and daily GP reporting, saving 10–20 hours per month and typically lifting margins by two points within 90 days. See how Jelly handles this automatically in a 15-minute walkthrough.
How to Calculate GP in a Restaurant
The standard gross profit margin formula used across UK hospitality is:
GP% = (Selling Price ex-VAT − Cost Price ex-VAT) ÷ Selling Price ex-VAT × 100
Example: a dish sold at £18 ex-VAT with a £6 ingredient cost = (£18 − £6) ÷ £18 × 100 = 67% GP.
VAT must be stripped from both selling price and cost price before the calculation runs, because UK hospitality businesses treat VAT as a pass-through tax collected on sales and remitted to HMRC, not as an operating cost that affects your margin. To see why this matters, a £120 customer bill equals £100 net revenue and £20 VAT. That £20 never enters your GP calculation because it was never yours to keep. For GP margin analysis, revenue is always measured on a net-of-VAT basis before it is compared with the cost of food and drink inputs.
GP Targets and Waste Buffers for Food and Beverage in 2026
Typical 2026 UK GP targets sit higher for beverages than for food, and beverage waste buffers also run about 5 percentage points higher. This pattern reflects spillage, over-pouring and breakage that rarely affect solid ingredients. The table below shows 2026 UK targets alongside recommended waste buffers to build into your cost price before calculating GP.
| Category | GP% Target | Waste Buffer to Add to Cost | Source |
|---|---|---|---|
| Food (casual dining) | 60–70% | 5–10% | Gotenzo / Winnow |
| Food (fine dining / QSR) | 70%+ | 5–10% | Gotenzo / Winnow |
| Beverage | 75–85% | 10–15% | Zenchef / Winnow |
Commercial kitchens waste between 4–12% of all food purchased before analytics tools are introduced. This level of waste explains why building a buffer into cost price produces a more honest GP figure than using raw invoice costs alone.
Step-by-Step GP Adjustments for Waste, VAT and Delivery
Step 1 — Strip VAT from the selling price. Divide the VAT-inclusive menu price by 1.20 to get the net figure. A £15 menu price becomes £12.50 ex-VAT.
Step 2 — Apply a waste buffer to ingredient cost. Multiply the raw ingredient cost by 1.05–1.10 for food and 1.10–1.15 for beverages. A £3.00 raw food cost becomes £3.15–£3.30 after buffering. Winnow describes the buffer as an operational safety margin applied to projected usage rather than a fixed statutory percentage.
Step 3 — Run the GP formula. (£12.50 − £3.30) ÷ £12.50 × 100 = 73.6% GP.
Step 4 — Adjust for delivery commissions. Delivery platforms such as Deliveroo and UberEats charge average commissions of 30%, which must be deducted from the net selling price before calculating delivery-menu GP. On a £12.50 net selling price, a 30% commission leaves £8.75 effective revenue. The same £3.30 buffered cost now produces a GP of (£8.75 − £3.30) ÷ £8.75 × 100 = 62.3%. That figure sits well below your dine-in target, so delivery menus require separate pricing.
Food & Beverage GP Calculator: Excel Walkthrough
These formulas drop straight into a spreadsheet and give you a working GP calculator for each dish. Column references assume: A = dish name, B = VAT-inclusive selling price, C = raw ingredient cost, D = waste buffer %.
- Net selling price (E2):
=B2/1.2 - Buffered cost (F2):
=C2*(1+D2) - GP% (G2):
=(E2-F2)/E2*100 - Delivery GP% (H2) at 30% commission:
=((E2*0.7)-F2)/(E2*0.7)*100
For multi-site use, duplicate the sheet per location and use a summary tab with =AVERAGE(Sheet1!G2,Sheet2!G2) to aggregate GP by dish across sites.
The manual process works for a while, then ingredient prices change and the workload spikes. At 28 minutes per dish, repricing a 40-item menu after a supplier increase takes nearly 19 hours. Jelly removes that manual burden completely. Invoices arrive by email or photo, and every line-item price updates automatically across every recipe that uses that ingredient. What takes 28 minutes in a spreadsheet takes three minutes in Jelly’s Kitchen section. The Flash Report then shows daily GP by dish and category, and the Price Alert feature flags every supplier price movement the same week it happens. Chefs receive the data they need to negotiate credits before margin is lost.
Spreadsheet GP vs Automated GP Workflow
The Excel formulas above work for single-site operations with stable supplier pricing and modest menu changes. Once your business runs multiple sites, faces frequent price changes, or handles high invoice volume, the manual approach turns into a bottleneck. A manual spreadsheet workflow requires a team member to download invoices, enter line items, update recipe cards, and re-run GP calculations, and this work scales directly with supplier count and menu complexity. Errors compound over time, and a missed price update on a key ingredient can silently erode GP across every dish that uses it for weeks before anyone notices.
Jelly’s automated workflow captures invoices the moment they arrive, updates ingredient costs in real time, and surfaces GP changes on a daily Flash Report, all without manual data entry. The entire platform costs a flat £129 per site per month with no per-user fees. Most operators see meaningful value within the first week of onboarding.
At Amber, a Mediterranean restaurant in East London, Chef-Owner Murat Kilic saves £3,000–£4,000 per month through faster reactions to price changes, supplier credits secured via Price Alert data, and tighter menu controls, delivering approximately 68× ROI. Sushi Revolution used Jelly to set separate target GP figures for dine-in and delivery menus, accounting for 30% platform commissions, and achieved gross profits 2–3% higher on average. Those gains supported the opening of a second restaurant. Across Jelly’s customer base, operators consistently see GP improve by two percentage points within the first three months.
Why Manual Methods Break at Multi-Site or Multi-Supplier Scale
A single-site operator managing three suppliers can maintain a spreadsheet with discipline. Once you add a second site, two more suppliers, and a delivery menu, the spreadsheet starts to work against you. Version control breaks down, one site’s recipe costs diverge from another’s, and management loses a single source of truth to act on.
Jelly is built for exactly this inflection point. All sites share one platform, invoices from every supplier feed into a single ingredient database, and management can view GP by dish, by category, and by site from one dashboard without waiting for a monthly accountant report. Jelly integrates natively with Square, EPOS Now, Lightspeed, and Toast through real-time API connections, so sales data flows into GP calculations the moment a transaction completes. Connecting any supported POS takes approximately five minutes. For operators already running on these systems, Jelly sits alongside them and adds the cost and margin layer that POS systems alone do not provide.
Running more than one site? See how Jelly gives you one dashboard for every location’s GP data.
Frequently Asked Questions
Does Jelly handle mixed VAT rates?
Yes. Jelly calculates GP on a VAT-exclusive basis throughout, so dishes subject to different VAT treatments, for example hot food at 20% versus cold takeaway food at 0%, are handled correctly. The platform strips VAT from selling prices before calculating margins, which keeps your GP figures comparable and HMRC-compliant.
Can I still use my existing POS?
Jelly integrates natively with Square, EPOS Now, Lightspeed, and Toast. Connecting any of these takes around five minutes. For operators on other systems, Jelly continues to deliver invoice automation, recipe costing, and Price Alert functionality independently of POS data, with additional POS integrations planned.
How quickly will I see margin improvement?
Most operators gain actionable Price Alert data within 24 hours of photographing their first invoices, or as soon as suppliers begin sending invoices to a dedicated Jelly email address. Measurable GP improvement, typically two percentage points, is consistently reported within the first three months. Stuart Noble, Head Chef at Cairn Lodge Hotel, cut food costs by 5% within a single month.
Is the calculator suitable for pubs as well as restaurants?
The GP formula and targets apply equally to pubs. Beverage GP targets of 75–85% are standard across licensed premises, and the waste buffer adjustments for drinks, set at 10–15%, account for spillage and over-pouring. Jelly’s platform handles food and beverage costing in the same workflow, so it suits pub kitchens and bars that manage both categories simultaneously.
Conclusion: Protect Your Margins in 2026
Manual spreadsheets cannot keep pace with daily supplier price changes, multi-site complexity, or the margin pressure of delivery commissions. The GP formula is straightforward, expressed as (Selling Price ex-VAT − Cost Price ex-VAT) ÷ Selling Price ex-VAT × 100, but maintaining accurate inputs across dozens of ingredients, multiple suppliers, and changing menus is where operators lose margin points and hours every week. Jelly automates the entire flow from invoice to dish cost to daily GP report, at a flat £129 per site per month, with value delivered in the first week. Operators consistently lift GP by two percentage points within 90 days.