Written by: JJ Tan, Founder, Jelly
Key Takeaways for Running a Profitable UK Pub Bar
- Weekly inventory tracking using four core formulas (Usage, COGS, Pour Cost %, GP%) protects your wet margins.
- Always work from ex-VAT costs and net beverage sales so your margin figures stay accurate and comparable.
- Category GP benchmarks differ: spirits typically target 72–78% GP, while draught beer usually sits between 58–65%.
- Manual spreadsheets stop being practical once weekly admin passes four hours or GP data trails trading by more than a week.
- Jelly automates invoice scanning, live GP reporting and price alerts, so you see margin changes as they happen, not at month-end.
The Four Core Pub Inventory Formulas Explained
Pub inventory control relies on four simple calculations. Inventory Usage = Opening Stock + Deliveries − Closing Stock. COGS = Opening Stock + Purchases − Closing Stock, all at cost price ex-VAT. Pour Cost % = COGS ÷ Net Beverage Sales × 100. GP% = (Net Sales − COGS) ÷ Net Sales × 100. Run these weekly to see exactly where your bar makes or loses margin.
See a live walkthrough of how Jelly automates these four formulas in real time.
Live Pub Inventory Calculator for Quick Margin Checks
Use this calculator to check your current margin position before committing to a full weekly stocktake routine. Enter your figures to see whether your GP sits above or below the industry benchmarks covered later in this guide. If you sit more than three percentage points below target, delayed or incomplete data is usually the problem, not your menu pricing. All values should be at cost price, excluding VAT.
[Embed interactive calculator here — fields: Opening Stock (£), Deliveries/Purchases (£), Closing Stock (£), Net Beverage Sales (£), VAT Rate (default 20%). Outputs: Usage (£), COGS (£), Pour Cost %, GP%.]
Cannot see the calculator? Ask a Jelly specialist to run the numbers with you on a short call.
Worked GP Example Using Current UK Spirit Prices
This example shows how the formulas work for a 70-cl bottle of spirits at £18.50 ex-VAT, served in 25-ml measures. Under the Finance Act 2026 (effective 1 February 2026), spirits above 22% ABV attract duty of £33.99 per litre of pure alcohol. A standard 40% ABV spirit therefore carries £33.99 × 0.40 = £13.60 duty per litre, or £9.52 per 70-cl bottle. All alcohol sold in UK pubs is charged at the standard 20% VAT rate with no exceptions.
Step-by-step for one week’s spirit line:
- Opening stock: 6 bottles × £18.50 = £111.00 (ex-VAT cost)
- Deliveries: 12 bottles × £18.50 = £222.00
- Closing stock: 4 bottles × £18.50 = £74.00
- Usage / COGS: £111.00 + £222.00 − £74.00 = £259.00
- Serves from usage: 14 bottles × 700 ml ÷ 25 ml = 392 serves
- Sell price per serve (ex-VAT): £3.50 (that is £4.20 including VAT)
- Net beverage sales: 392 × £3.50 = £1,372.00
- Pour Cost %: £259.00 ÷ £1,372.00 × 100 = 18.9%
- GP%: (£1,372.00 − £259.00) ÷ £1,372.00 × 100 = 81.1%
Use net (ex-VAT) sales figures in pour cost and GP calculations so your results stay consistent. Including VAT in the sales denominator distorts the result.
Gross Profit Targets for UK Pubs by Category
UK pub GP benchmarks differ by drink type, so you should compare each category against its own target. Industry guidance sets the following targets:
- Draught beer and cider: 58–65% GP, with 62% or higher considered well-run
- Spirits and liqueurs: 72–78% GP, with premium spirits often above 80%
- Wine and prosecco: 65–70% GP, with house wine by the glass typically 65–68%
- Soft drinks and mixers: usually the highest-margin category on the bar
Across all wet sales, the BBPA and BII provide guidance on overall wet GP, including blended pub gross margins when food is part of the mix. The bar industry as a whole targets gross profit margins of 70–80%. That blended target drops to net margins of around 10–15% once labour, rent and utilities are paid, so every GP percentage point you protect has a direct impact on profit.
If your numbers fall below these benchmarks, delayed or incomplete data is usually the root cause rather than poor pricing. Jelly’s Flash Report gives you a daily GP view by matching live invoice costs with POS sales, so you are not waiting for month-end accounts. View your own live GP dashboard in a 15-minute session.
Free Pub Inventory Sheet Template for Ongoing Tracking
Use a spreadsheet template when you need to track multiple product lines over several weeks instead of spot-checking a single category. A free downloadable Excel template mirrors the calculator fields above and adds structure for longer-term tracking. It includes columns for ex-VAT cost, current UK duty rates by product category, VAT, usage, COGS, pour cost and GP%.
The template covers:
- Opening stock, deliveries and closing stock per product line
- Automatic COGS calculation at ex-VAT cost price
- Pour cost % and GP% outputs per category
- A summary tab for weekly and monthly trend tracking
The template gives you a solid starting point for structured counts. When supplier prices change, which happens frequently, every affected formula needs manual updating. Jelly removes that manual work by scanning each invoice line and recalculating dish and drink costs as soon as a new price appears.
Simple Daily Routine for Bar Inventory Control
A short, consistent daily routine stops small variances turning into serious margin problems. Monitoring variance on wet sales is important as higher levels can mean a pub is losing money and may require action.
The recommended weekly routine:
- Monday (10 min): Count all optics, speed rails and open bottles. Record closing values from the previous week as this week’s opening stock.
- Daily (2 min): Log any deliveries received against the invoice. Note any wastage or spillage.
- Friday (10 min): Count closing stock. Enter figures into the calculator or template.
- Friday (5 min): Pull net sales from the POS for the week. Calculate COGS, pour cost and GP%.
- Friday (5 min): Compare results against benchmarks. Flag any line showing variance above 1%.
Sushi Revolution reduced their monthly stocktake from 2–3 hours to just 5–20 minutes after switching to Jelly’s inventory tools. The same time saving is available to any UK pub operator.
Applying the 80/20 Rule to Pub Stock
The 80/20 rule, or Pareto principle, states that roughly 80% of your revenue comes from 20% of your product lines. In a pub, a small group of high-velocity SKUs, such as top draught lines, house spirits and house wine, drives most sales and most margin risk.
Practical application:
- Identify the 20% of lines that generate 80% of wet sales using POS data
- Count those lines daily rather than weekly
- Negotiate supplier terms and volume discounts on those lines first
- Monitor price changes on those lines closely, because a 5p increase on a high-velocity line costs far more than the same increase on a slow mover
The difference between a 22% pour cost and a 28% pour cost on £500,000 of annual beverage sales equals £30,000 in lost profit. Jelly’s Price Alert feature flags every price movement on every line so high-velocity products never drift unnoticed.
When UK Pubs Should Move From Spreadsheets to Automation
Manual inventory management is slow and often produces decisions based on data that is already out of date. Digital inventory systems typically take 50–70% less time than manual methods, and specialized inventory systems can reduce costs by 2–3% by catching variances early.
The case for switching becomes clear at these thresholds:
- Manual stock counts and invoice entry consume more than 4 hours per week
- GP data arrives more than 7 days after the trading period ends
- Supplier price increases are discovered at month-end rather than on delivery
- Menu prices have not been reviewed since the last supplier price round
Jelly automates the full flow from invoice scanning to GP reporting. Operators save 10–20 hours of admin per month and see an average GP improvement of 2 percentage points within the first three months. The Howard Arms reached 80% gross profit after switching to Jelly, up from a projected 60%. Amber restaurant saves £3,000–£4,000 per month through tighter cost controls enabled by Jelly’s invoice automation and price alerts.
Jelly integrates directly with Xero for seamless accounts payable. It also connects with Square, Lightspeed, EPOS Now and Toast to pull item-level sales data in real time, so no manual POS exports are required.
At £129 per location per month, the platform usually pays for itself within the first week for any pub spending more than a few hours on manual stock admin. Calculate your potential time and GP gain with a short Jelly demo.
Frequently Asked Questions
What is the correct way to calculate pour cost percentage for a UK pub?
Pour cost percentage is calculated as COGS divided by net beverage sales, multiplied by 100. COGS equals opening stock plus purchases minus closing stock, all measured at cost price excluding VAT. Net beverage sales means the revenue figure from your POS excluding the VAT collected on behalf of HMRC. Using VAT-inclusive sales figures in the denominator will artificially deflate your pour cost and overstate your GP. A well-managed UK pub bar should target an overall pour cost of 18–24%, with spirits at 15–20% and draught beer at 20–25%.
How does UK alcohol duty affect my margin calculations?
Alcohol duty is a cost borne by the supplier and built into the ex-VAT price you pay on invoices. As shown in the worked example above, duty sits inside your invoice cost, so you do not need to calculate it separately for GP. Because you base COGS on actual invoice prices, the duty component is automatically captured. The key discipline is always working from ex-VAT invoice costs, not VAT-inclusive totals.
What is an acceptable inventory variance for a UK pub?
A variance of around 1% on wet sales is often considered normal and acceptable. Higher variance indicates a loss that requires investigation. Common causes include over-pouring, unrecorded spillage, line-cleaning losses on draught products and theft. Stock losses on wet sales can cost a typical UK pub several thousand pounds per year. Running weekly counts rather than monthly counts is an effective way to catch variance early, before small leaks compound into significant losses.
How long should a weekly pub stocktake take?
A manual weekly stocktake for a typical UK pub can take several hours depending on the size of the cellar, bar and kitchen. With a digital inventory tool, the count can be completed much faster because multiple staff can count simultaneously and results merge automatically. Jelly users have reported sharply reduced stocktake times for a full monthly count. The time saving also comes from removing manual data entry, formula checking and report building after a paper-based count.
Can Jelly handle multi-site pub inventory management?
Yes. Jelly is built for operators running or expanding to multiple sites. Each location has its own inventory, invoice scanning and GP reporting, while owners and finance managers can view consolidated performance across all sites from a single dashboard. Jelly’s flat-rate pricing structure means costs scale predictably as the estate grows, with no per-user fees or transaction charges. POS integrations with Square, Lightspeed, EPOS Now and Toast connect at the site level, delivering item-level sales data in real time so GP stays current regardless of how many venues you operate.