Written by: JJ Tan, Founder, Jelly
Key Takeaways for UK Bar Operators
- UK pubs, bars and boutique hotels lose margin through delayed supplier price data, over-pouring and invisible shrinkage that can cost £3,000–£5,000 annually.
- Legal compliance requires stamped 25 ml or 35 ml spirit measures, with target pour costs of 18–24% and overall drinks GP of 65–75%.
- Automated invoice capture and real-time POS integration replace monthly spreadsheets with daily variance reports and instant price alerts.
- A structured 90-day rollout that starts with invoice automation, then adds POS integration and weekly variance tracking, delivers a consistent two-percentage-point GP improvement.
- Operators ready to replace manual stock processes with daily margin visibility can book a demo with Jelly today.
The Problem: Manual Bar Stock Processes Erode Margin
Manual bar stock processes create three compounding risks. First, delayed data means that when reports arrive monthly from an accountant, a supplier price increase that landed in week one has already eroded four weeks of margin before anyone can act. Second, compliance exposure occurs because a free-poured 25 ml spirit measure is typically 32–35 ml in practice, creating a 27% overpour that contributes to £3,000–£5,000 in annual wet-sales stock loss for a typical UK pub. Third, invisible shrinkage appears because drinks shrinkage in UK pubs typically runs at 4–6%, recoverable only when weekly variance alerts make stock leaks visible before they compound.
These three risks share a common root cause: manual processes that cannot keep pace with daily operations. Automated invoice-to-inventory workflows eliminate all three risks. Ingredient costs update the moment a new invoice arrives, variance reports surface daily rather than monthly, and compliance logging becomes a byproduct of normal operations rather than a separate administrative task.
Book a demo, schedule a chat to see how Jelly delivers daily margin visibility from day one.
UK Legal Measures and Practical Pour-Cost Targets
Under the Weights and Measures Act 1985 and the Measuring Equipment (Intoxicating Liquor) Regulations 1983, all intoxicating liquor measuring equipment used for trade on licensed premises in Great Britain must be stamped before use. Breaches can result in fines, and a 2026 Fair Measure Initiative in South Lanarkshire found that three out of ten visited licensed premises served short measures of spirits.
| Category | Legal Measure | Glassware / Equipment Requirement | Target Pour Cost (UK) |
|---|---|---|---|
| Spirits (gin, rum, vodka, whisky) | 25 ml or 35 ml (or exact multiples) | Stamped optic, jigger or metering device, UKCA/CE-marked capacity measure | 18–24% |
| Draught beer & cider | Prescribed quantities under the 1988 Order | Stamped flowmeter or UKCA/CE-marked stamped glass with staff verification of fill | typically 20–26%, with variations based on venue type |
| Wine by the glass | 125 ml or 175 ml (prescribed) | UKCA/CE-marked capacity measure or stamped metering device | 18–24% |
| Cocktails | Spirit components must be measured in 25 ml or 35 ml increments | Stamped jigger for each spirit component | 18–24% |
UK pubs and restaurants should target an overall drinks gross-profit percentage of 65–75%; a figure below 60% indicates incorrect pricing or undeclared stock losses. All calculations must use ex-VAT selling prices, because many drinks sold in UK licensed premises are subject to 20% VAT.
How Modern EPOS Transformed Bar Stock Management
UK hospitality EPOS has evolved from a simple till replacement into a connected system that links transactions, stock control, staff logins and reporting in one platform, replacing disconnected spreadsheets and end-of-week reporting with automatic reconciliation and real-time sales data. Real-time EPOS stock integration removes the need for manual stock adjustments and end-of-day corrections, reducing counting errors and the administrative burden on pub operators.
Single-site operators gain immediate margin visibility without needing a dedicated back-office team. Multi-site operators gain proactive management through a centralised dashboard that enables real-time spotting of labour or stock variances across venues, moving oversight from reactive weekly reports to immediate intervention. Jelly integrations with Square, Lightspeed, EPOS Now and Toast bring this capability to operators at any stage of growth, with setup taking under five minutes per site.
Sushi Revolution reduced their monthly stocktake from 2–3 hours to 5–20 minutes after implementing Jelly. This result shows the practical difference between spreadsheet-based and automated workflows.
Four Decision Pillars When Choosing a Stock System
Operators evaluating bar stock management systems can use four decision pillars before committing.
- Cost vs control. Spreadsheets carry no software cost but generate hidden costs through errors, delayed decisions and management time. Jelly charges a flat £129 per site per month with no per-user fees, which keeps the cost of control predictable.
- Speed vs accuracy. Manual counts are slow and error-prone. Automated invoice scanning captures every line item, including quantity, SKU, price and tax, without manual data entry. This process produces accurate cost data the same day an invoice arrives.
- Manual vs automated. Legacy systems and spreadsheets require staff to enter data consistently to produce useful reports. Jelly automation removes reliance on team discipline. Invoice data flows in via email or photo, and POS sales data flows in via real-time API, so reports stay current.
- Single-site vs multi-site. A system that works for one site must also scale. Jelly’s centralised dashboard gives operators visibility across all locations from a single login, with per-site GP figures updated daily.
Readiness Checklist Before You Start
Clear roles, simple routines and clean data create a smooth Jelly rollout.
People
- One owner or manager designated as the Jelly account lead, responsible for decisions and follow-up.
- Bar and kitchen staff briefed on the invoice photo capture process so every delivery enters the system.
- Admin access to the POS system confirmed, allowing a quick connection during week two.
Process
- Supplier invoice delivery method confirmed, either email or paper, so the capture workflow is consistent.
- Ullage logging procedure defined with reason codes for spills, breakage, wrong pours and guest returns.
- Weekly variance review scheduled in the management calendar, with a named owner for the meeting.
Data quality
- Current menu items listed with target GP percentage per category.
- Legal spirit measure size, 25 ml or 35 ml, confirmed and displayed at point of sale.
- Ex-VAT selling prices confirmed for all drinks categories.
Supplier coordination
- Suppliers notified to send invoices to the Jelly-dedicated email address.
- Existing supplier credit notes and price change history gathered for baseline comparison.
Phased Implementation: Your First 90 Days With Jelly
A structured 90-day rollout produces consistent results without overwhelming the team.
Week 1 — Invoice automation. Direct all supplier invoices to Jelly’s dedicated email address or photograph paper invoices into the app. Jelly scans every line item automatically. Price Alert notifications activate immediately and flag any supplier price movement from the first processed invoice.
Week 2 — POS integration. Connect your POS system via Jelly’s Integrations tab. The process takes about five minutes. Open Jelly, click Integrations, sign in to the POS, grant permissions and select which categories to sync. Lightspeed, Square, EPOS Now and Toast all follow the same flow. Once connected, item-level sales data flows into Jelly in real time, and the Flash Report begins calculating daily gross-profit margin automatically.
Week 3 — Live variance reporting. With invoice costs and POS sales both live, the variance between theoretical and actual stock becomes visible. Ullage should be reviewed during closeout while memory is fresh, and weekly ullage totals compared against inventory variance by product so unexplained loss can be investigated before details go cold. Jelly’s recipe costing tool, the Cookbook, allows bar managers to build drink recipes from scanned invoice ingredients. This approach keeps theoretical cost calculations current as supplier prices change.
Days 30–90 — Margin improvement. With a full month of live data, operators can see which products underperform against their target pour-cost benchmark, which suppliers have increased prices without notification and which menu items require repricing. Sushi Revolution achieved gross profits 2–3% higher on average by using Jelly to set separate target GP percentages for dine-in and delivery menus. Jelly customers consistently reach the two-percentage-point GP improvement mark within this window.
Book a demo, schedule a chat and get your 90-day implementation plan in place this week.
Common Pitfalls to Avoid in Bar Stock Control
- Inconsistent data capture. Real-time ullage logging produces usable data, whereas logging at the end of the week from memory turns events vague and prevents connecting losses to specific products, shifts or recurring causes. This principle, that data captured immediately is more accurate than data reconstructed later, applies equally to invoice capture. A single missed invoice creates a gap in cost data that distorts variance reports.
- Delayed reporting cycles. Monthly reports are structurally too slow for bar operations. By the time a monthly P&L arrives, four weeks of margin erosion from a supplier price increase or a persistent overpour are already locked in. Daily Flash Reports remove this lag.
- Over-reliance on spreadsheets. Spreadsheets require manual updates to remain accurate. When ingredient prices change, and drinks represent around 60–70% of total revenue in UK pubs, a spreadsheet-based cost model becomes stale the moment a new invoice arrives. Automated systems update costs without human intervention.
Best-Practice Traits of Effective Bar Stock Management
Effective bar stock management shares four traits regardless of venue size or format.
- Simplicity. Systems that require extensive manual input are abandoned under service pressure. Jelly invoice capture via photo or email and its five-minute POS setup fit the operational reality of a busy bar.
- Timeliness. The admin time reduction described earlier, from several hours monthly to under two hours, shows how timeliness becomes a structural feature rather than a manual achievement. Daily GP visibility replaces the monthly reporting cycle.
- Visibility. EPOS stock integration gives operators a clear view of what is selling, what is running low and where wastage may be occurring. Jelly’s Sales Mix report adds the profitability dimension and shows which products are both popular and margin-positive.
- Repeatability. A system that produces consistent results across weeks and sites is more valuable than one that needs periodic manual correction. Jelly’s automated invoice-to-inventory workflow runs continuously and produces the same quality of data on a Tuesday in January as on a Saturday in August.
The two-percentage-point gross-profit improvement that Jelly customers achieve within 90 days is not a one-time event. It is the natural outcome of applying these four traits consistently, with supplier price alerts enabling ongoing negotiation and live dish costing preventing margin drift as ingredient costs change.
Frequently Asked Questions
Is there a free bar stock template for UK pubs and bars?
Free spreadsheet templates for bar stock management are widely available and can provide a useful starting point for operators who have never tracked inventory formally. A functional template should include columns for product name, unit of measure, opening stock, deliveries received, closing stock, theoretical usage, actual usage and variance. The limitation of any free template is that it requires manual updates every time a supplier price changes, every time a new invoice arrives and every time a stocktake is completed. For a venue processing multiple supplier invoices each week, the maintenance burden quickly exceeds the time saved by avoiding a paid system. Jelly replaces the template entirely by automating invoice capture, cost updates and variance calculation, while remaining accessible at a flat £129 per site per month.
What is the difference between using Excel and dedicated bar stock management software?
Excel gives operators full control over their own data structure but requires manual data entry for every invoice, every price change and every stocktake. Errors compound silently, because a mistyped unit price or a missed invoice produces variance figures that look plausible but are wrong. Dedicated software like Jelly automates the data capture layer, so the figures in the system reflect actual supplier prices rather than the last time someone updated a cell. The practical difference is that Excel-based cost models are typically one to four weeks out of date, while Jelly cost models update the moment a new invoice is processed. For operators managing multiple suppliers and multiple sites, the accuracy gap between the two approaches translates directly into margin decisions made on incorrect data.
Are UK bars legally required to log ullage?
There is no specific statutory requirement under UK licensing law that mandates a formal ullage log. However, ullage logging is strongly recommended for two operational reasons. First, it separates known, documented stock loss, such as spills, breakage, line cleaning, wrong pours and guest returns, from unexplained variance, which is the category that indicates theft, systematic overpours or compliance failures. Without a log, all loss appears as unexplained variance, which makes it impossible to distinguish a legitimate spill from a persistent overpour. Second, a documented ullage record provides evidence during Trading Standards inspections and licence reviews that the operator has active controls in place. Best practice is to log ullage in real time during or immediately after service using defined reason codes, and to review weekly totals against inventory variance before details become difficult to recall.
What is a typical stock shrinkage rate for UK bars, and how does it affect gross profit?
As noted earlier, drinks shrinkage in UK pubs, covering waste, spillage and unrecorded pours, typically runs at 4–6% of throughput. A 1% loss on wet sales can cost a typical pub between £3,000 and £5,000 annually, the same range mentioned earlier when discussing overpour impact. The gross-profit impact is direct, because shrinkage increases the cost of goods sold without generating any corresponding revenue. Reducing shrinkage through consistent ullage logging, measured pours and weekly variance tracking can recover several thousand pounds annually at a single site. Jelly variance reporting makes shrinkage visible on a weekly basis and enables operators to investigate and address the cause before it compounds across a full quarter.
How quickly can a UK pub or bar expect to see gross-profit improvement after implementing Jelly?
Most Jelly customers see meaningful gross-profit improvement within the first 90 days. The initial gains typically come from two sources, supplier price alerts that surface unnotified price increases and enable credit note recovery, and live dish or drink costing that identifies products whose margins have drifted below target. The two-percentage-point average GP improvement mentioned in the implementation timeline reflects the cumulative effect of these actions applied consistently across the full 90-day period. Operators who connect their POS system in week two and begin weekly variance reviews in week three tend to reach this outcome fastest, because they have both the cost data and the sales data needed to make accurate margin calculations from early in the implementation.
Next Steps for UK Bar Stock Management
Bar stock management in UK pubs, bars and boutique hotels no longer rewards manual effort. The compliance requirements are precise, the margin benchmarks are well-established and the technology to automate the workflow between invoices, inventory and real-time GP reporting is available at a flat, predictable cost. The operators who protect and grow their gross profit in the next 90 days will be those who move from spreadsheets to automated systems before the next round of supplier price increases arrives.
Jelly is built for exactly this transition. Invoice automation goes live within 24 hours, POS integration takes five minutes and daily margin visibility starts in week one, all at £129 per site per month with no hidden fees.
Book a demo, schedule a chat and see your bar’s margin potential in a live walkthrough.