Written by: JJ Tan, Founder, Jelly | Last updated: 19 October 2026
Key Takeaways
- Bar stock control works when managers follow a consistent daily-to-monthly counting cadence instead of a single Monday scramble.
- UK measures law, cellar discipline and delivery checks feed directly into variance calculations and must stay consistent every week.
- PAR levels, pour-cost tracking and dead-stock removal keep stock aligned with real sales and protect margin.
- Well-run UK pubs target 2–3% variance on wet stock, and anything above 4–5% needs investigation that week.
- Jelly automates invoice capture, real-time cost updates and POS integration so operators can focus on the routine instead of manual entry.
What Does Bar Stock Mean?
Bar stock is the drinks inventory a bar holds, such as spirits, mixers, kegs, casks, wine and garnishes. Operators measure and value this stock so they can reconcile what was bought, what was sold and what remains. The difference between expected and actual stock is variance, and tight variance control protects gross profit margin.
How To Manage Bar Stock: The Seven Steps
- Set up a count sheet that matches your bar layout and storage order.
- Run the count with a clear cadence: daily high-value checks, a weekly full count when closed, and a monthly full bar stocktake.
- Apply UK measures and licensing discipline as a stock-control lever.
- Manage the cellar and draught stock, including cask and keg yield, line cleaning, temperature and rotation.
- Set PAR levels and order quantities from actual usage and supplier lead times.
- Calculate pour cost and variance, then investigate overpours, spillage, comps and breakages.
- Clear dead stock and run a structured monthly review.
Step 1 — Set Up The Count Sheet To Match The Bar Layout
Start by structuring the bar stocktake sheet by physical location and storage order: back bar, speed rail, cellar, keg store, fridge and dry store. Matching row order to the physical counting route can cut counting time by around 20% compared with an alphabetical or supplier-sorted list.
Give each row these columns: item, unit size, full units, open-bottle weight or volume, PAR, received, ending full, ending partial, conversion factor, calculated ending in full equivalents, unit cost, usage cost, sales, pour cost, variance and notes. State the partial-bottle convention in the sheet header, such as tenths, quarters or weight, and apply it consistently across every count.
Use a few simple rules to prevent the most common errors.
- Lock the sheet structure and add new SKUs only at the bottom of their category.
- Standardise unit sizes, because a 1-litre and a 700ml bottle of the same spirit need a conversion factor.
- Use consistent item naming. Inconsistent naming, such as the same vodka listed four different ways, sends counts to the wrong place and corrupts variance calculations.
- Keep the layout stable between counts unless the bar has physically changed, and retrain the team when it does.
For a free UK-formatted starting point, see the Bar Stock Control Spreadsheet: Free UK Template And Guide.
Step 2 — Run The Count With A Daily, Weekly And Monthly Cadence
Bar inventory management works best as a steady weekly routine instead of a monthly scramble. Count on the same day, use the same method, and compare physical stock with recorded sales. Use this cadence.
- Daily: Check high-value spirits and premium lines at shift change, and record breakages and comps as they happen.
- Weekly: Run a full bar stocktake when the bar is closed, counting every line and weighing open bottles. A tired manager counting at 2 a.m. may estimate partial bottles differently from someone counting the next morning, so count before service.
- Monthly: Complete a full stocktake reconciled to purchases and sales for variance and gross profit.
Weighing open bottles accurately. Zero the scale with an empty bottle of the same product to establish the tare weight. Weigh the open bottle, subtract the tare, then convert the net weight to millilitres using that product’s specific gravity. The Weights and Measures Act 1985 fixes the pound at 0.45359237 kilogram and the ounce at 1/16 pound, so each product needs its own density factor. Store tare weights in the count sheet and use the same scale every week.
Partial kegs and casks. Weigh or dip, then record as a percentage of full yield. Two measurement traps matter here. Tare weights on “identical” 50-litre kegs vary by close to a kilo between suppliers, roughly two pints of apparent stock, so weigh a genuinely empty keg from each supplier, mark the tare on it in marker, and re-weigh quarterly as steel kegs get dinged and repainted. For casks, dip sticks assume the cask lies on a stillage at a specific angle, and tipping the cask slightly can throw a firkin reading off by half a gallon or more before a single pint is poured. Check the stillage with a spirit level before dipping.
Use the same person for the count where possible, and ask a second person to verify costly bottles. Weekly cycle counts of high-value and high-volume draught lines are the minimum, and some busy sites spot-check best sellers twice a week.
See How Jelly Keeps Your Variance Live
Step 3 — Use UK Measures And Licensing As A Stock-Control Lever
Once the count runs on a fixed cadence, the numbers only mean something when every pour is measured the same way. Measure discipline feeds directly into every variance and pour-cost calculation.
The Weights and Measures (Various Foods) (Amendment) Order 1990 (SI 1990/1550) added 25ml to the prescribed quantities for gin, rum, vodka and whisky sold for consumption on licensed premises, and removed imperial spirit measures from 1 January 1995. The Weights and Measures (Intoxicating Liquor) Order 1994 (SI 1994/1883) then added 35ml as a second permitted metric quantity. A UK bar must choose one measure and operate it consistently.
The arithmetic matters. A 25ml measure yields 40 standard pours from a litre, and a 35ml measure yields approximately 28.6. A 5ml over-pour on every spirit serve consumes an extra 200ml across 40 serves, eight additional 25ml pours from a litre, and shows up as variance even when every sale is rung correctly.
The variance trap is equally important. Calculating a 25ml sale as 35ml overstates theoretical consumption, and calculating a 35ml sale as 25ml understates expected usage and can falsely suggest over-pouring or theft. Sales data must distinguish 25ml and 35ml serves, and the venue’s chosen measure must stay consistent across menu, price list, till buttons and staff procedure.
The Home Office’s revised section 182 guidance under the Licensing Act 2003 (September 2026) requires that customers be made aware that smaller spirit measures are available, through menus, price lists or other printed material displayed prominently, and that staff notify customers when no quantity is specified. Annex 1C mandatory premises licence conditions also require beer or cider to be available in half-pint measures and still wine in a glass in 125ml measures.
Step 4 — Control Cellar And Draught Stock
Draught stock is where most unexplained bar variance originates, and generic bar inventory guides rarely cover it in enough depth. UK draught beer is regulated as an open food, which brings the cellar, dispense lines and wash hand basin provision within standard food hygiene obligations. The UK National Occupational Standards repository includes a dedicated Drinks Dispense Systems suite (19 standards) and a Stock and Despatch in Food and Drink Operations suite, which set the technical competence expected of cellar and bar staff.
Keg and cask sizes and sellable yield. A standard UK keg holds 50 litres (88 pints), and a 30-litre keg holds 52.8 pints. UK cask sizes are imperial: a pin is 4.5 gallons, a firkin is 9 gallons (72 pints), and a kilderkin is 18 gallons (144 pints). Plan on sellable yield, which reflects reality. An 88-pint keg realistically yields 84–86 sellable pints once fob at changeover, the drip tray, beer standing in the line and cloudy pints are accounted for, and a firkin plans in the mid-60s because of sediment and pull-through.
Line cleaning as planned wastage. A full beer line clean at least every seven days is the UK industry standard. A 10-metre run of 3/8-inch python holds about 1.25 pints, and each line costs 2–3 pints per clean, roughly 15 pints a week for six lines cleaned weekly. Log every clean as planned operational wastage so it never shows up as unexplained variance. Line cleaning waste carries its alcohol duty down the drain, about 50p a pint on a 4.5% beer at 2026 HMRC rates, and that duty is never claimable.
Stillage discipline. Check the stillage with a spirit level, dip the same cask before and after moving it, and re-check the dip stick against a known-level stillage whenever the cellar layout changes. Cask settling and venting time creates a rotation constraint. A freshly racked cask needs time to drop bright before service, so rotation planning must account for settling time as well as shelf space.
Step 5 — Set PAR Levels And Order Quantities From Real Usage
A PAR (periodic automatic replenishment) level is the fixed quantity of an item a bar wants on the shelf immediately after a scheduled delivery. PAR is distinct from a reorder point, because PAR is a fixed top-up target tied to a delivery schedule, while a reorder point triggers an order whenever stock falls to a set level regardless of the day.
Two formulas cover most UK bar situations.
- Fixed delivery schedule: PAR = (average usage per period + safety stock) ÷ deliveries per period.
- Variable lead times: PAR = (average daily usage × lead time) + safety stock.
Calculate usage over four to eight recent periods rather than a single week, because weather, private events, holidays and menu pushes distort short windows. Start safety stock at 20–30% of weekly usage and adjust per item, because fast movers, hard-to-substitute products and unreliable vendors justify more buffer.
Order quantity always follows one rule: PAR level minus current stock minus stock on order, adjusted for forecast demand and delivery frequency. Always calculate this figure so any staff member covering the count arrives at the same number a trained manager would.
Delivery-day discipline. Check deliveries against the order and invoice line by line, and record short deliveries and price changes immediately. Keep ordered, received, invoiced and credited quantities as separate records, because vendors short-ship, substitute brands, split deliveries and apply credits, and collapsing these into one field turns receiving errors into apparent inventory variance. Store in rotation order (FIFO) with new stock behind old.
Step 6 — Calculate Pour Cost And Variance
Start with a simple formula: opening stock plus purchases minus closing stock equals stock used. Compare that figure with sales multiplied by recipe to get variance. Divide usage cost by sales and multiply by 100 for pour cost percentage. The formula is: pour cost % = cost of goods sold ÷ sales revenue × 100.
Variance equals actual usage minus theoretical usage, where theoretical usage is sales multiplied by recipe. Before assuming loss, confirm purchases were entered correctly and check recipes and pour sizes on high-volume cocktails, then compare variance by shift, category and product and look for repeat variance on the same item across weeks.
In practice, much of what managers blame on pouring comes from till button mapping. Common mapping failures include bottles rung as pints when busy, promotional buttons that do not specify products, house doubles set up as singles after a menu change, and a catch-all “misc drink” button taking hundreds of pounds a month.
Worked example in UK measures. A 1-litre bottle of spirit at 25ml yields 40 pours. If 38 are rung and the bottle is empty, the two missing pours are variance, so check the measure, the free-pour practice and the till buttons before assuming theft. On draught, on £1,500 a week of draught sales, an unexplained 3% loss is £45 a week, about £2,340 a year.
Benchmarks. Many well-run wet-led pubs aim for 2–3% variance on wet stock, below 2% reflects tight control, and above 4–5% needs investigating that week rather than at the next quarterly review. Track pour cost by category first, such as beer, wine and spirits, before drilling into brands.
Track Your Pour Cost Live With Jelly
Step 7 — Clear Dead Stock And Run The Monthly Review
Start by cross-checking lines with no sales in 30, 60 or 90 days against POS menu reporting and shelf movement. Once you know what is dead, clear it through special menus, staff training, supplier returns or write-off. Then remove discontinued products from the active count list so managers do not reorder them out of habit, and lower PARs on the slow movers that remain.
The monthly review meeting should follow a clear agenda.
- Review variance by item ranked by cash impact first, because a small percentage on a premium tequila can cost more than a large percentage on a cheap mixer.
- Check pour cost trend by category.
- Walk through dead stock and slow movers.
- Confirm supplier price changes identified since the last review.
- Log stockouts and emergency buys.
- Assign one clear action per major issue.
For a structured 90-day programme to build on this routine, see the Bar Stock Management UK: A Practical 90-Day Guide.
Where Jelly Fits: Bar Stock Control Software Vs Spreadsheet
Once the monthly review produces consistent variance numbers, the focus shifts from how to count to how to keep the numbers current without manual entry. Excel and Google Sheets are a legitimate starting point. A single wet-led pub with around 120 lines counting monthly and spot-checking weekly can run on a spreadsheet and a two-minute sales export. Prove the manual routine first.
When the routine holds and the bottleneck shifts to invoice entry, cost updates and margin reporting, Jelly is the upgrade within the bar inventory management software category. It is the first choice for UK bar operators for these specific reasons.
- Flat £129/month per location with no per-user charges, so the price stays published and predictable.
- Value in the first week. Price alerts and spending insights are live as soon as suppliers send invoices to a dedicated email address, or within 24 hours of photographing invoices into the app. Unlike platforms that take months to configure, Jelly onboards and generates initial value immediately.
- Native real-time POS integrations with Square, Lightspeed, EPOS Now and Toast, delivering item-level sales data the moment a transaction completes. POS setup takes approximately five minutes. POS-to-dish linking only surfaces items sold since the integration was connected, which keeps mapping clean and free of legacy menu clutter.
- Xero integration with Sage coming soon, which reduces bookkeeping time by 90%.
- Documented UK operator results: Amber saving £3,000–£4,000 per month, Populu lifting gross profit from 68% to 72% across 16 locations, and Jelly users cutting food costs by 3% on average in the first three months.
Three other platforms appear in bar inventory software comparisons and are worth understanding accurately.
Bar Patrol is a weighing-led app with genuine recipe-costing strength for cocktail lists, but it bills in USD, so UK operators pay card foreign-exchange fees and see the effective cost fluctuate month to month. It counts in fluid ounces to 1/100th rather than 25ml and 35ml. It provides no UK VAT handling or ex-VAT gross-profit convention, and POS sales must be exported and uploaded rather than syncing live. For a UK operator whose stocktaker and accountant work in ex-VAT gross profit and pints, Bar Patrol’s reports answer a different question.
WISK is a mature, full-featured platform with strong variance reporting and 50+ POS integrations, but pricing is quote-based rather than published, and its B2B complexity limits adoption among smaller venues. No documented UK measures, cask or cellar support has been found in its published materials, so UK operators must treat these as due-diligence questions before committing.
Sculpture Hospitality combines an app with consultant-led audits, with a Self Service tier published and Shared and Full Service tiers quoted per location. Its published materials do not document UK measures, cask handling, cellar controls or EPOS integrations, so UK operators should raise these as direct questions during any evaluation.
For a fuller comparison of bar inventory software options, see Bar Inventory Management Software: Stop Losing Margin and Bar Inventory Spreadsheet Alternative: Why UK Pubs Switch.
Compare Jelly To Your Current Setup
Frequently Asked Questions
What Are The Four Types Of Inventory Control?
The four main types are periodic review, perpetual tracking, just-in-time and ABC analysis. Periodic review means counting at fixed intervals. Perpetual tracking means continuous real-time updates. Just-in-time focuses on ordering only as needed to minimise holding stock. ABC analysis prioritises control effort by item value. Most UK bars blend periodic weekly counts with ABC prioritisation, and they focus tightest control on high-value spirits and draught lines.
What Is The 80/20 Rule In Inventory?
The 80/20 rule, or Pareto principle, holds that roughly 20% of stock items account for around 80% of usage value or revenue. In a bar context, a small number of lines such as house spirits, draught lager and house wine drive the majority of cost and margin. These items deserve the tightest counting discipline, the most accurate PAR levels and the most frequent variance review.
How Do I Calculate My Bar Inventory?
Use a simple flow. Opening stock plus purchases received minus closing stock equals actual usage. Compare actual usage with theoretical usage, which is the number of drinks recorded in the POS multiplied by the recipe pour size, to calculate variance. Divide usage cost by sales revenue and multiply by 100 for pour cost percentage. Run this calculation weekly on draught lines and monthly across all categories.
How Do I Set PAR Levels For A Bar?
Use the same formulas covered earlier, then keep them live. For a fixed delivery schedule, use PAR = (average usage per period + safety stock) ÷ deliveries per period. For variable lead times, use PAR = (average daily usage × lead time) + safety stock. Build usage from four to eight recent periods, start safety stock at 20–30% of weekly usage, and adjust per item. Review PAR levels monthly and after menu changes or significant events.
How Do I Reduce Dead Stock In A Bar?
Start with a regular dead-stock report from the POS. Identify lines with no sales in 30, 60 or 90 days, then choose a route for each item, such as special menus, staff training, supplier returns or write-off. Remove discontinued products from the active count list so they are not reordered by habit, and lower PAR levels on slow movers. Revisit the dead stock list at every monthly meeting and assign one action per item.
How Do I Weigh Open Bottles For Stock?
Follow a consistent weighing routine that supports the weekly count. Weigh an empty bottle of the same product to establish the tare weight, then weigh the open bottle and subtract the tare. Convert the net weight to millilitres using that product’s specific gravity, because each spirit has a different density. Store tare weights in the count sheet, use the same digital scale every week, and apply this method to all high-value spirits where small variances carry significant cost.
How Do I Manage Cellar And Cask Stock?
Focus on yield, wastage and rotation. Plan on sellable yield instead of nominal volume, keep line cleaning logged as planned wastage, and check stillage level before dipping casks. Mark the tare weight on each empty keg and re-weigh periodically. Use the draught variance benchmarks from the main guide as your reference, and treat any figure above that range as a prompt for a cellar walk and a line-by-line check.
How Do I Do A Bar Stocktake?
Run the stocktake when the bar is closed and follow the physical layout of the bar from back bar to cellar to keg store. Weigh open bottles using tare weights, dip or weigh partial kegs, and record everything in a locked count sheet. Use the same person and the same method each week. Reconcile the count to purchases and POS sales to calculate usage, variance and pour cost, then investigate anything above the 4–5% threshold covered earlier that week, not at the next quarterly review.
How Do I Calculate Pour Cost And Variance?
Use two linked calculations. Pour cost % equals cost of goods sold divided by sales revenue, multiplied by 100. Variance equals actual usage minus theoretical usage, where theoretical usage is POS sales multiplied by recipe pour size. Investigate the gap by checking till button mapping first, then overpours, unlogged spillage, comps and breakages. Track pour cost by category before drilling into individual brands.
Conclusion: Build The Routine, Then Automate It
Bar stock control often fails in UK venues because the routine is unstructured and the tools are built for a different market. A sequenced daily-to-monthly cadence, with UK measures law built in, cellar and cask discipline applied, and delivery-day control enforced, protects margin and makes variance explainable instead of mysterious.
Start with the count sheet and the cadence from this guide, then prove the manual routine over four to eight weeks. Once the numbers are consistent and the bottleneck shifts to invoice entry, cost updates and margin reporting, the case for software becomes clear.
Jelly is the best bar stock management software for UK bar operators because it automates invoice capture, keeps costs and margins live, and integrates with the POS systems UK bars already use at a flat £129/month per location. For a deeper look at cost control across the full bar operation, see the Bar Inventory Cost Control: The Complete UK Pub Guide.
Start Your Bar Stock Control Demo
