Written by: JJ Tan, Founder, Jelly
Key Takeaways for Square-Using UK Pubs
- Accurate bar inventory tracking prevents thousands of pounds in annual stock loss from over-pouring and delayed reconciliation.
- Mapping legal UK pour sizes (25 ml / 35 ml spirits, 125 ml / 175 ml wine) into Jelly recipes creates reliable usage benchmarks.
- Daily stocktakes reconciled against Square sales data shrink the gap between error and discovery to 24 hours and protect margins.
- Weekly variance below 2% and steady monthly gross-profit improvement confirm that the workflow is working.
- Connect Square to Jelly in under five minutes and start mapping pours with a guided demo.
Why Tight Bar Inventory Control Protects Your Pub’s Margin
Stock loss on wet sales can cost a typical UK pub several thousand pounds a year, and most of that loss does not come from theft. Over-pouring spirits and incorrect cellar temperatures both contribute to stock variance in UK pubs. Across a busy multi-site operation, those small errors compound into 3–5% monthly variance, which removes margin before any monthly report surfaces it.
For venues turning over £500,000 or more and expanding to additional sites, delayed margin data becomes a structural problem. A connected sales and inventory system highlights which items sell at particular times, where waste is rising, and which promotions actually increase margin. A spreadsheet updated once a month cannot provide that level of visibility.
Step-by-Step Square Bar Inventory Setup for UK Pubs
The margin leaks described above all stem from a weak connection between what the till records and what the cellar actually holds. The seven steps below combine Square’s native sales data with Jelly’s automation layer to close that gap and create a repeatable, low-admin inventory workflow.
- Confirm Square admin access. Open Square Dashboard, navigate to Team, and verify the account has item and inventory permissions. Without admin access, neither Square’s recipe features nor Jelly’s integration can be activated.
- Map standard pours to Jelly recipes. In Jelly’s Kitchen section, build a recipe for each spirit, wine, and draught line using ingredients already populated from scanned invoices. Jelly handles all unit conversions automatically, replacing the tedious manual costing work that previously lived in spreadsheets. Set spirits and wine at the legal specified quantities, and kegs at their full yield in pints.
- Set par levels and reorder alerts. Calculate PAR level as usage during the coverage window plus a buffer, and set the reorder point as usage during lead time plus buffer. For example, if your house vodka moves six bottles per week with a two-day lead time, a par of eight and a reorder point of four gives enough stock to cover a full week plus a small buffer. That same setup also triggers reorders early enough to avoid stockouts. Because supplier prices can shift between orders, Jelly’s Price Alert feature flags cost movements on each new invoice so reorder decisions reflect current prices rather than last month’s invoice.
- Run a daily stocktake. Use the reconciliation formula: opening balance + deliveries received − POS sales = book balance. Then compare that figure to the physical count to calculate variance. Populating outbound quantities from POS sales data and inbound quantities from supplier invoices creates a daily reconciliation loop. This daily reconciliation approach, highlighted in the key takeaways, ensures errors surface within 24 hours rather than compounding for weeks. Jelly pulls Square sales automatically, so the outbound column is already populated.
- Calculate weekly variance. Variance = (opening stock + purchases − closing stock) − theoretical usage from Square sales. A well-run bar holds variance between actual and theoretical pour cost to 2% or less. Example: if theoretical usage for a week is £4,000 in spirits and actual usage is £4,180, variance is £180 or 4.5%. That result is a clear signal to investigate pour sizes or wastage logging.
- Push invoices into Xero. Jelly digitises every supplier invoice via photo or email and pushes line-item data directly into Xero with one click. Cloud-based systems that connect directly to accounting platforms such as Xero automate bookkeeping and eliminate manual sales data entry. Removing this manual process typically saves 10–20 hours of admin per month.
- Review the Flash Report for live GP. Jelly’s Flash Report combines Square sales data with invoice costs to display gross profit margin daily, weekly, or monthly. One operator improved gross profit after using Jelly to set separate GP targets for dine-in and delivery menus. The Flash Report gives bar operators the same visibility without any manual calculation.
Price Alert in action
Jelly flags every supplier price movement the moment a new invoice is scanned. If a spirits supplier increases a bottle price by £1.20, the Price Alert appears immediately. That alert gives the operator concrete data to negotiate a credit note or switch supplier before the margin impact compounds across hundreds of pours.
Variance calculation example
Opening stock: £6,000. Purchases: £2,500. Closing stock: £5,800. Actual usage: £2,700. Theoretical usage from Square sales: £2,600. Variance: £100 (3.8%). Target: below £52 (2%). Action: review pour sizes and wastage log.
Time saved per week
Connecting Square to Jelly automates 2–5 hours of weekly work to generate real-time margins and sales mix data. Monthly stocktakes then run much more quickly because the underlying data already stays current.
Walk through this seven-step workflow with a Jelly specialist by scheduling your demo.
Common Bar Inventory Mistakes and Quick Fixes
Over-pouring. UK pubs must use a single standard spirit measure of either 25 ml or 35 ml, and inconsistent or non-standard pouring can contribute to stock variance. When you map these exact legal pour sizes into Jelly recipes, the system can calculate how much stock should have been used based on Square sales and create a theoretical usage benchmark. That benchmark makes over-pouring visible in the weekly variance report rather than invisible until a quarterly stocktake.
Forgotten wastage. Without a dedicated waste workflow, inventory numbers and food cost reporting remain incomplete, which prevents clean reconciliation of actual usage against theoretical usage. Logging every spillage, line-clean loss, and returned drink as a wastage entry in Jelly keeps the variance calculation honest.
Delayed reconciliation. Reconciling till data days after the trading period allows errors to compound before anyone investigates. A disciplined weekly stock count routine that reconciles against till data the same day helps pubs protect their margins. Jelly’s automated invoice capture and real-time Square sync remove the manual steps that usually cause delays.
How to Measure Bar Inventory Success
Two metrics define whether the workflow is performing. Weekly variance should fall to 2% or less of beverage sales within the first month of consistent daily stocktakes. Monthly gross profit should improve within the first quarter.
Amber restaurant in East London saves £3,000–£4,000 per month through Jelly’s automated invoice processing, price change alerts, and real-time recipe costing. For a bar operation, the same levers, including pour mapping, variance tracking, and supplier price alerts, apply directly to wet sales margins.
Review par levels monthly and after any menu change, seasonal shift, or supplier delay. Small corrections each week can protect margins without creating extra stress for staff.
Advanced Jelly Tips for Square Bar Setups
Split-keg transfers. When a keg is shared between two bar stations or two sites, log the transfer as an internal movement in Jelly so each location’s variance calculation remains accurate. Keg par levels should be set in keg units and adjusted for line-cleaning downtime and event-driven spikes.
Multi-site roll-out. Centralised visibility from a connected platform enables owners of growing multi-site hospitality businesses to compare sales, menus, stock movement, and staff activity across locations. Jelly supports multiple sites on a flat-rate per-location model, so the same Square integration and recipe library can be replicated across new venues without rebuilding from scratch.
Delivery menu costing. Jelly’s Delivery Menu Creation tool duplicates existing bar menu items and factors in delivery commission overheads, typically 25–30%, so GP targets for delivery orders are set separately from dine-in. Setting separate target gross profits on dine-in and delivery menus resulted in actual gross profits 4–9 points higher on average.
Native Square Features vs Integrated Square + Jelly Workflow
Square is a powerful POS platform and a reliable foundation for bar sales data. The table below shows what Square handles natively and what an integrated workflow with Jelly adds on top. The two systems work together rather than competing.
| Feature | Native Square | Integrated Workflow (Square + Jelly) |
|---|---|---|
| Item-level sales data | Yes, real-time transaction data per menu item | Yes, Square sales ping Jelly on each transaction for instant cost and margin calculation |
| 25 ml / 50 ml pour tracking | Beta recipe feature | Full pour-level recipe mapping in Jelly with automatic unit conversion and live GP per serve |
| Wastage tracking | Custom adjustment reasons (e.g. Spoilage, Production Waste) added July 2026, no recipe-level depletion | Wastage logged against Jelly recipes and deducted from theoretical usage in variance calculation |
| Supplier invoice capture | Not available natively | Automated via photo or email, every line item digitised and pushed to Xero |
| Daily gross-profit visibility | COGS reports available after manual recipe setup, beta feature and subject to change | Flash Report combines Square sales with live invoice costs for daily, weekly, or monthly GP view |
| Supplier price alerts | Not available natively | Jelly Price Alert flags every price movement per ingredient per supplier on each new invoice |
| Xero integration | Separate Square–Xero connector required | One-click push of digitised invoices from Jelly directly into Xero |
FAQ
Does Square track individual pours?
Square’s native recipe feature can decrement ingredient stock when a menu item is sold, but it is a beta feature available only on Square for Restaurants Plus or Premium plans. For a bar tracking 25 ml spirits pours, 50 ml wine pours, and cocktail components as reusable recipe logic, Square’s native tools have limitations. Jelly fills this gap by mapping each pour size as a recipe ingredient, calculating theoretical usage from Square sales data, and surfacing variance against physical counts without any manual formula work.
How often should a bar do a stocktake?
A daily count on high-value or fast-moving lines, such as spirits, premium draught lines, and wine, is the most effective way to catch errors quickly. A full weekly stocktake reconciled against Square sales data the same day is the minimum recommended frequency for a pub or bar with meaningful wet sales. Monthly full counts are standard for slower-moving stock. The key principle remains simple: the shorter the gap between an error occurring and its discovery, the less margin is lost before corrective action is taken. Jelly’s automated Square sync means the outbound column of any stocktake template is already populated from POS sales, which reduces the manual effort of a daily or weekly count significantly.
What is an acceptable variance for a bar?
The 2% variance threshold mentioned in Step 5 is the industry benchmark for well-run operations. Variance above the acceptable band, typically 1–3% for food and 3–5% for liquor, consistently indicates a systemic issue such as over-pouring, unlogged wastage, or delayed reconciliation rather than deliberate theft. As noted earlier, even small improvements in variance, for example from 4% to 2%, represent meaningful annual savings on a busy wet sales operation. Jelly’s weekly variance report compares actual usage, calculated as opening stock + purchases − closing stock, against theoretical usage from Square sales, which makes the gap visible and actionable every week.
Can the system handle split-keg transfers between sites or bar stations?
Yes. When a keg is shared between two locations or two service areas, the transfer is logged in Jelly as an internal stock movement. This approach ensures that each site’s inventory count and variance calculation reflects only the stock it actually consumed, rather than inflating one location’s usage and deflating another’s. Keg par levels are set in keg units within Jelly and can be adjusted independently per site to account for different throughput, line-cleaning schedules, and event calendars. For multi-site operators rolling out from a single Square account to several venues, Jelly supports each location separately on a flat per-site fee.