Written by: JJ Tan, Founder, Jelly
Key Takeaways for UK Pub Margins
- Rising beer duty and supplier costs in 2026 make manual gross profit calculations slow, inaccurate, and damaging to margins.
- Accurate GP removes 20% VAT from selling prices and applies a wastage factor, typically 5–6% for draught and 3% for spirits.
- Industry benchmarks show draught beer GP targets of 58–65%, with cocktails and spirits often reaching 72–78% or higher with tight portion control.
- Manual spreadsheets can consume 10–20 hours weekly and delay price updates, while Jelly scans invoices and connects to POS systems for real-time margin visibility.
- See Jelly’s live GP calculator in action by booking a demo.
The Problem: Manual GP Calculations Are Eroding Pub Profit
Wet-led UK pubs could make just 3p profit for every £1 spent on a pint in 2026, down from 5p in 2025 and 7p in 2024. Wholesale food and drink costs account for an estimated 41% of revenue, with wages at 31%, so even small calculation errors quickly wipe out profit.
From 1 February 2026, UK alcohol duty rises in line with 3.66% RPI inflation, adding 38 pence to a bottle of gin and 14 pence to a bottle of red wine. These increases hit supplier invoices immediately. A pub relying on manual spreadsheets may not recost its menu for days or weeks, so every pint and cocktail sold at the old price quietly gives away margin.
Jelly customers who move from spreadsheets to automated invoice scanning report an average 2-percentage-point improvement in gross profit margins within the first three months. One operator improved GP from 65% to 72% within 12 weeks on approximately £500,000 in revenue. The root cause of that gap is almost always delayed data, not poor buying decisions.
Pub Gross Profit Calculator with Wastage Included
An accurate pub GP calculation removes VAT from the selling price first, then deducts the cost of goods including a realistic wastage allowance. This approach reflects the true cost of every pint or serve.
The five-step process follows a clear logic from selling price to final GP percentage.
- Start with the customer-facing selling price, which includes VAT.
- Remove 20% VAT to find the net selling price using Net Price = Selling Price ÷ 1.20. The UK standard VAT rate of 20% applies to alcoholic drinks sold in pubs.
- Find the cost of goods sold (COGS) per unit from the latest supplier invoice, so the cost reflects current prices.
- Apply a wastage adjustment to COGS. A standard 5% wastage factor for draught products covers ullage, line cleaning, and spillage, so Adjusted COGS = COGS × 1.05.
- Calculate GP% using GP% = ((Net Price − Adjusted COGS) ÷ Net Price) × 100, which shows the margin after VAT and wastage.
Worked example: craft lager pint (11% ABV)
- Selling price (VAT-inclusive): £6.00
- Net selling price (÷ 1.20): £5.00
- COGS per pint (from invoice): £1.60
- Adjusted COGS with 5% wastage (× 1.05): £1.68
- GP%: ((£5.00 − £1.68) ÷ £5.00) × 100 = 66.4%
A well-run UK pub cellar should target 62%+ gross profit on draught beer and cider, with the broader industry benchmark sitting at 58–65% for this category. The 66.4% result in this example sits comfortably within target because the calculation includes wastage. Without the 5% adjustment, the same calculation returns 68%, which overstates the real margin.
Cocktail GP Calculator for High-Margin Serves
Cocktails and spirits usually carry higher margin targets than draught products. UK pub industry benchmarks place spirits and liqueurs at 72–78% GP, with premium spirits capable of exceeding 80% when free-pour accuracy is controlled.
Worked example: house gin and tonic
- Selling price (VAT-inclusive): £9.00
- Net selling price (÷ 1.20): £7.50
- COGS: gin 25ml at £0.55 + tonic £0.30 = £0.85
- Adjusted COGS with 3% spirits wastage (× 1.03): £0.88
- GP%: ((£7.50 − £0.88) ÷ £7.50) × 100 = 88.3%
This calculation stays simple for a two-ingredient serve. A cocktail with eight ingredients across three suppliers, each updating prices at different times, quickly overwhelms a manual spreadsheet. Jelly pulls every line item from forwarded supplier invoices automatically, so cocktail costs update as soon as a new invoice arrives and no one retypes data.
Beer Profit Margin Benchmarks for UK Pubs
Beer remains the highest-volume category for most UK pubs and the most margin-compressed in 2026. For pubs charging an average of £5.01 for a pint, the modelled profit equates to £0.12 per pint after all operating costs.
Category benchmarks for UK pubs reflect different levels of wastage, demand, and perceived value.
- Draught beer and cider: 58–65% GP target, matching the benchmark established earlier.
- Bottled beer: typically higher than draught because there is no ullage or line-cleaning wastage.
- Wine and prosecco: 65–70% GP, with house wine by the glass usually around 65–68%.
- Soft drinks and mixers: 75–82% GP, often the highest-margin category and frequently under-priced.
Worked example: cask ale pint
- Selling price (VAT-inclusive): £5.40
- Net selling price (÷ 1.20): £4.50
- COGS per pint: £1.45
- Adjusted COGS with 6% cask wastage (× 1.06): £1.54
- GP%: ((£4.50 − £1.54) ÷ £4.50) × 100 = 65.8%
ONS data shows a pint of bitter rose 4% in the year to October 2025, so a COGS figure from six months ago already misstates reality. Recalculating every time a supplier invoice changes creates the core inefficiency that Jelly removes.
Why Excel Breaks Down for Multi-Site Pub Groups
Spreadsheets require someone to enter every invoice line, update every recipe cost, and recalculate every GP figure by hand. At scale, that process consumes 10–20 hours per week, generates no revenue, and introduces transcription errors that distort the margins operators are trying to protect.
| Metric | Manual / Spreadsheet | Jelly Automated | Source |
|---|---|---|---|
| Weekly admin time | 10–20 hours | Reduced by 2–5 hours on POS data alone | Jelly customer data |
| Time to cost one menu item | ~28 minutes | ~3 minutes | Jelly platform benchmarks |
| GP margin improvement (first 3 months) | Baseline | +2 percentage points on average | Jelly customer data |
| Supplier price change visibility | Days to weeks (next manual check) | Same week via Price Alert | Jelly Price Alert feature |
The Price Alert feature becomes especially valuable in 2026. UK pubs face simultaneous cost increases from alcohol duty, wages, business rates, national insurance, and energy, so supplier price creep can arrive from several directions at once. Jelly flags every individual line-item price change as soon as a new invoice is processed, which gives operators clear evidence to negotiate credits or switch suppliers within the same week, not the same month.
How Jelly Turns GP Calculations into Live Margin Control
Jelly replaces the manual five-step GP calculation with an automated workflow that runs continuously in the background and keeps every figure current.
- Invoice capture: Forward supplier invoices to a dedicated Jelly email address or photograph them in the app. Jelly scans every line item, including quantity, SKU, price, and tax, without manual typing.
- Live ingredient costs: Each scanned ingredient updates in real time across all recipes that use it, so one invoice refreshes costs everywhere.
- Recipe and wastage costing: Build dishes and drinks in Jelly’s Cookbook by clicking on already-scanned ingredients. Wastage percentages apply automatically. Sushi Revolution reduced its monthly stocktake from 2–3 hours to 5–20 minutes using Jelly’s inventory features.
- POS integration: Connect your POS system in around five minutes. Jelly pulls item-level sales data in real time and calculates live GP against actual ingredient costs.
- Flash and Price Alert reports: Daily GP margin reports appear automatically. Price Alert highlights every supplier increase or decrease, with the supplier name and exact amount, so operators can respond in the same week. Sushi Revolution uses Jelly to set separate GP targets for dine-in and delivery menus, achieving actual gross profits 2–3% higher on average.
Ruth Seggie, Owner of The Howard Arms, summarises the outcome: “Our accountant said we’d be lucky to hit 60% gross profit. After using Jelly, we reached 80%. Now I sleep better knowing my costs are under control and can react instantly, not weeks later.”
Ready to see similar control in your own sites? Book a demo to see how Jelly connects to your POS in under five minutes.
Frequently Asked Questions
What is a GP calculator for UK pubs and how does it work?
A GP calculator for UK pubs computes the gross profit percentage on any drink or food item by comparing the net selling price, after VAT removal, against the cost of goods sold. For alcoholic drinks, the standard UK VAT rate of 20% must be removed from the customer-facing price before any GP calculation. A complete pub GP calculator also applies a wastage factor, typically 5–6% for draught products and 3% for spirits, to reflect ullage, line cleaning, and spillage. The resulting formula is GP% = ((Net Selling Price − Adjusted COGS) ÷ Net Selling Price) × 100. Jelly runs this calculation continuously by scanning supplier invoices and integrating with your POS, so the figure reflects current prices rather than last month’s data.
What GP target should I use for a cocktail GP calculator?
Industry benchmarks for spirits typically range from 72–78%, as discussed earlier, with tight portion control pushing premium products above 80%. Cocktails usually sit within or above this range depending on recipe complexity and ingredient costs. When building a cocktail GP calculator, cost each ingredient at its invoice price per unit of measure and apply a wastage allowance to cover over-pouring or spillage. Compare the net selling price, with VAT removed, against the total adjusted ingredient cost. Jelly’s Cookbook feature handles unit conversions and wastage maths automatically once ingredients are populated from scanned invoices, cutting the time to cost a cocktail from around 28 minutes to approximately 3 minutes.
How do I calculate gross profit on drinks accurately?
Accurate gross profit calculation on drinks needs three inputs: the VAT-exclusive selling price, the true cost of goods sold per unit, and a realistic wastage adjustment. Common manual errors include using the VAT-inclusive price as the revenue figure, which overstates GP, relying on an outdated COGS from a previous invoice, which understates cost, and omitting wastage entirely, which inflates margins on draught products. The correct process divides the selling price by 1.20 to remove VAT, multiplies the COGS by a wastage factor, such as 1.05 for draught and 1.03 for spirits, then applies the standard GP formula. For multi-site pubs or operations with many SKUs, repeating this for every product after each supplier invoice becomes unmanageable, so Jelly handles the process automatically and updates GP figures as soon as a new invoice is processed.
Conclusion: Turn GP Data into Daily Margin Protection
Accurate gross profit data now functions as a daily operational requirement in 2026, not a weekly or monthly report. With beer duty rising, supplier costs volatile, and net profit per pint measured in pence, a GP figure that is even one week out of date exposes the business to hidden losses. The five-step calculator in this article gives any pub operator a correct, VAT-removed, wastage-adjusted starting point. Jelly applies that same calculation automatically and continuously across every drink and dish on the menu, without spreadsheets, manual entry, or waiting for an accountant’s monthly report.
Stuart Noble, Head Chef at Cairn Lodge Hotel, put it directly: “Price hikes were crushing our margins — I felt helpless. With Jelly, every dish cost is up-to-date at my fingertips. We slashed food costs by 5% in a month.”
Start protecting your margins today and see Jelly in action.
