Written by: JJ Tan, Founder, Jelly
Key Takeaways
Here is what matters most for keeping your bar stock under control and your margins healthy:
- A 5% variance on £10k monthly wet sales costs around £6,000 a year in lost stock. See the worked example below.
- Build a master stock list with unique SKUs, consistent units, ABV data, and storage locations. This structure makes accurate weekly counts possible.
- Run a repeatable Tuesday-morning stocktake using scales, dipsticks, and the tenths method. Then reconcile straight away against the till Z-read.
- Calculate par levels from average weekly usage plus safety stock, review them monthly, and enforce FIFO rotation to cut waste and stockouts.
- When spreadsheets take more than five hours a week or variance stays above 3%, book a demo to see how Jelly automates bar stock control.
Why Bar Stock Control Matters
A 1% stock loss on wet sales costs a typical UK pub £3,000–£5,000 annually, yet many licensees only notice the problem when margins collapse. On a pub turning over £10,000 per month in bar sales, a 5% variance represents £500 in lost stock every month. Across a year, that adds up to £6,000 gone with nothing to show for it on the till.
UK operators face additional pressures that make tight stock control essential. Supplier price fluctuations from wholesalers such as Booker and Bestway can shift ingredient costs week to week, while VAT at 20% applies to all alcohol sales. Since August 2023, UK alcohol duty is calculated on litres of pure alcohol, with spirits exceeding 22% ABV taxed at £33.99 per LPA and beer at 3.5%–8.4% ABV taxed at £22.58 per LPA. These duty-inclusive purchase costs must appear accurately in your stock records or your margin analysis and VAT reporting will be wrong.
Normal bar inventory losses in UK pubs run at 2–4%, but losses above 5% signal systemic problems such as pouring inaccuracy, poor stock rotation, or weak operational controls. Stock control protects gross profit, not just bottle counts.
Build a Master Stock List That Matches Your Bar
Every reliable bar inventory management system starts with a master stock list. Without one, counts stay inconsistent and variance becomes impossible to track in a meaningful way. Build your list with the following structure:
- Categorise every product: spirits, beers (draught and packaged), wines, soft drinks, mixers, and syrups.
- Assign a unique code to each SKU to prevent duplication.
- Define a consistent unit of measure, such as litres for wine, bottles for spirits, and kegs for draught.
- Record ABV and pack size for every alcohol line. This supports duty tracking and, for draught products served from containers of at least 20 litres at VAT-registered premises, Draught Relief reduces the duty rate for qualifying beer and cider, so distinguishing draught from packaged lines has a direct financial benefit.
- Note storage location for each item so counts follow the physical layout of your cellar and bar.
A stocktake template should match the physical bar, with shelf order following the room and count units matching how staff count. This list becomes the foundation for every stocktake, par level calculation, and variance report you run.
Run a Weekly Stocktake You Can Repeat
Shaun McManus, a working pub licensee with over 15 years running a Marston’s pub, recommends a weekly stocktake on a quiet day at a fixed time, such as Tuesday morning at 9am before staff arrive. This timing keeps the count repeatable and avoids rushing the team. Consistency matters more than perfect precision, because the same method every week enables reliable variance tracking.
Follow these steps for each weekly count:
- Print or open your stock list, ordered by storage location.
- Count full bottles, sealed cases, and unopened backup stock first while the team is fresh. These items are objective and fast to count.
- For open spirit bottles, weigh each bottle using digital scales with a 5kg capacity and 1g accuracy (costing £15–£30). A full 70cl bottle of standard spirit typically weighs around 1.1–1.7kg, depending on the empty glass weight, liquid density, closure, and packaging. The empty bottle alone usually weighs 400–700g, which makes over-pouring immediately visible.
- For partial bottles where weighing is not practical, use the tenths estimation method. A bottle roughly 70% full is counted as 0.7, and a little less than half as 0.4.
- Use a dipstick for casks and partial kegs. A dipstick costs around £8 and takes 30 seconds per cask, which removes guesswork and catches temperature-driven loss quickly.
- Split the count by category among staff to speed up the process.
- Record counts immediately on your stock list to avoid transcription errors. Use a clipboard or tablet.
- Reconcile the count against the same-day till Z-read. A £20 discrepancy spotted on Tuesday is fixable. A £200 discrepancy discovered three weeks later rarely is.
Set Par Levels From Real Usage
A par level is the target quantity of a product you need on hand to cover usage between deliveries while avoiding cash tied up in slow-moving stock. The basic par level formula is (average weekly usage + safety stock) ÷ deliveries per period, which simplifies to average weekly usage plus safety stock when there is one delivery per period.
Consider a practical worked example. If your pub uses two cases of house gin per week and your Booker delivery arrives twice a week, your par level calculation runs as follows:
- Average weekly usage: 2 cases
- Delivery interval: 0.5 weeks (twice weekly)
- Safety factor: 1.5–2x to cover a late delivery or a spike night
- Par level: 2 × 0.5 × 2 = 2 cases on hand at any time
Par levels should be set to the quantity you actually want on hand, and the order quantity (the difference between par and on-hand) should be rounded up to the next purchasable order unit, rather than rounding the par level itself to a purchasable unit. Review par levels monthly and flex them for bank holidays, local events, and seasonal shifts. Many UK pubs see variance climb 0.5–1% from June through August as warm cellars degrade cask condition and increase gas loss, so summer par levels for cask ale and draught lager should be reviewed upward.
The golden rule of inventory: Count what you have, know what you should have, and investigate the difference.
Use FIFO and Organised Storage
FIFO, or First In, First Out, means older stock always moves before newer deliveries. In a UK pub, this matters most for cask ale, which has a short shelf life once tapped, and for wines stored by the glass. Poor stock rotation leading to date expiry is a common cause of variance in UK pubs.
Use these practical steps to enforce FIFO:
- Date-label every delivery when it arrives.
- Rotate stock physically when new orders come in. New bottles go to the back and older stock moves forward.
- Organise storage by category and in the same order as your stock list to speed up counts.
- For cask ale, follow brewery-recommended conditioning times and rotate taps so older casks are served first.
- Store wine at consistent temperatures between 10°C and 15°C to prevent premature spoilage.
Track Variance As Your Early Warning System
Variance is the difference between what your POS says you sold and what your physical stock count shows you actually used. It acts as an early warning system for shrinkage, over-pouring, and unlogged waste.
The formula for bar inventory variance is: Variance % = (Theoretical Stock – Actual Stock) ÷ Theoretical Stock × 100, where Theoretical Stock = Opening stock + Deliveries – Till sales – Recorded wastage.
Consider a simple example. Opening stock of 10 bottles of vodka, plus 6 delivered, minus 14 sold on the till, minus 0.5 logged as wastage equals a theoretical closing stock of 1.5 bottles. If your physical count shows 1 bottle, variance = (1.5 – 1) ÷ 1.5 × 100 = 33% on that line. That result deserves immediate investigation.
As a rule of thumb, keep overall variance under 1% where possible and watch for any upward drift. Track variance by line, such as spirits versus draught, rather than as a single headline figure, and review a monthly trend of four weekly numbers to see whether variance is climbing. When variance does climb, the cause often lies in human behaviour, which leads directly to staff accountability.
Staff Accountability and Pour Control
Over-pouring on spirits is the single biggest source of variance in most pubs. A free-poured 25ml spirit measure is typically 32–35ml in practice, which means a 28–40% over-pour. That over-pouring, together with measurement error, accounts for most of the 1–3% stock variance pubs see between EPOS sales and physical stock.
A simple waste log placed near the till makes waste visible and accountable. It should capture date, item, quantity, and reason such as spillage, over-pour, breakage, or comp. Frame pour control training as quality control rather than suspicion. Show staff the spirit usage report versus sales, and spot-check pours during quiet periods as part of service standard observation.
Visibility drives behaviour. Once staff know you are counting spirits by weight and dipping every cask, over-pouring usually stops quickly. With these accountability measures in place, the next step is refining your counting technique to keep variance low.
Count Liquor Inventory With Consistent Techniques
Accuracy in bar inventory management improves when you use the same counting techniques every week. Focus on these methods for liquor inventory:
- Weigh open bottles: Digital scales with 5kg capacity and 1g accuracy give a precise reading for every partial spirit bottle. Record the weight in grams weekly to calculate usage.
- Use the tenths method for estimation: Where weighing is impractical, estimate partial bottles in tenths. A bottle roughly 60% full is counted as 0.6.
- Use a jigger for verification: Periodically measure the contents of open bottles against the estimated weight to calibrate your team’s estimation accuracy.
- Use a dipstick for kegs and casks: Convert depth readings to litres using the manufacturer’s chart and record the same measurement point each week.
- Use a torch for dark bottles: A small flashlight makes it easier to read levels in dark glass bottles accurately.
- Count full bottles first: As noted in the weekly stocktake, full bottles are objective and fast. Counting them while the team is fresh reduces errors on the more subjective partial-bottle estimates.
Apply the 80/20 Rule to Your Bar Stock
The Pareto principle applied to bar stock control states that roughly 80% of your sales come from 20% of your products. In a typical UK pub, this usually means a handful of spirits, a core lager, and two or three wines drive the majority of wet sales revenue.
Setting par levels on your top-selling lines first captures most of the risk, because a small number of lines tie up most cash and cause most stockouts. If your top 10 spirits drive 80% of spirits revenue, ensure they are always accurately counted, correctly stored, and never allowed to fall below par on a Friday afternoon. Apply your most rigorous counting and variance tracking to these lines first, then extend the same discipline to slower movers. Once you have mastered these manual disciplines, you may notice where the process itself becomes the bottleneck, which is the point at which automation starts to make sense.
When Manual Control Should Give Way to Automation
Manual bar stock control, done consistently, protects your margins and reveals where money is leaking. At some point, though, spreadsheets start to slow you down instead of helping you.
- You spend more than 5 hours per week on stock-related admin.
- Variance is consistently above 3% and you cannot pinpoint the cause.
- You are expanding to multiple sites and need centralised visibility.
- Supplier price changes are eating margins before you can react.
- Your team avoids stocktakes because the process takes too long.
A bar stock spreadsheet only works if updated at least weekly, and fortnightly is acceptable if weekly is impossible. Most pubs do not maintain it, and the data becomes useless within about a month, usually by week six. When these warning signs appear, a purpose-built platform removes friction and turns a manual weekly routine into automated daily insight.
Jelly automates invoice scanning and gives real-time price alerts when supplier costs change. It also integrates with your POS to show live margins on every dish and drink line. Jelly users cut food costs by 3% on average in the first 3 months, and one operator improved gross profit from 65% to 72% within 12 weeks on approximately £500,000 in revenue. See how Jelly can save you 10–20 hours a month, and schedule a live walkthrough to see it in action.
Bar Inventory Spreadsheet: The Columns You Need
Before you move to automation, a well-structured spreadsheet gives you a solid starting point. Build your own in Excel or Google Sheets with the following columns, which all feed into the variance and par calculations you will run:
- Item name – the product as it appears on your supplier invoice
- Category – spirits, draught beer, packaged beer, wine, soft drinks, mixers
- Unit – bottle, keg, case, litre
- ABV and pack size – for duty tracking and Draught Relief eligibility
- Opening stock – physical count at the start of the period
- Deliveries – all invoiced stock received during the period
- Closing stock – physical count at the end of the period
- Theoretical usage – opening stock + deliveries – closing stock
- Actual usage (from POS) – till sales for the period
- Variance – theoretical minus actual, expressed as a percentage
- Par level – your calculated reorder target
- Notes – logged wastage, breakage, comps
While a spreadsheet gives you structure, it lacks real-time updates, automatic price alerts, and POS integration. It provides a starting point rather than a final system. For a deeper look at building a complete bar inventory setup, see our guides on Bar Stock Management UK: A Practical 90-Day Guide and Bar Inventory Cost Control: The Complete UK Pub Guide.
FAQ
What is the golden rule for inventory?
The golden rule of inventory is to count what you have, know what you should have, and investigate the difference. In practice, this means running a physical stocktake on a fixed schedule, calculating theoretical usage from your POS and delivery records, and treating any gap between the two as a signal that requires investigation rather than an acceptable rounding error.
How often should I do a stocktake in a UK pub or bar?
Most UK pubs should run a focused stocktake weekly, on the same day and at the same time each week. Weekly counts allow you to catch variance early, address discrepancies with staff while they are still fresh, and build a reliable trend over four weeks. High-volume bars or operations with known shrinkage problems may count high-value lines more frequently. A full quarterly stocktake acts as a sanity check on weekly counts but should not replace them.
What is a good variance percentage for a UK bar?
Under 1% variance on wet sales is excellent and reflects tight controls. Between 1% and 2% is acceptable but worth monitoring. Above 2% requires immediate investigation of cellar conditions, pour standards, and waste logging. Above 3% consistently indicates a systemic problem, whether that is over-pouring, poor stock rotation, unlogged waste, or a process breakdown, that needs urgent attention.
How do I calculate a par level for bar stock?
The standard formula is: Par Level = Average weekly usage × Delivery interval in weeks × Safety factor. For most bar products, a safety factor of 1.5–2x works well to cover late deliveries or unexpected demand spikes. Run the calculation over four to eight weeks of actual usage data for a reliable baseline, and separate normal trading weeks from bank holidays or events. Review par levels monthly and adjust for seasonal demand, because summer gin and tonic sales, for example, will require higher pars than January.
How can I speed up my weekly stocktake?
The most effective ways to reduce stocktake time are straightforward. Use digital scales to weigh open spirit bottles rather than estimating by eye. Use a dipstick for casks and partial kegs. Split the count by category among two or three staff members. Count full bottles first, as they are fast and objective. Use a stock list ordered by physical shelf location so the count follows the room. With these techniques, a well-prepared team can typically complete a weekly count in under an hour for a standard pub range.
Conclusion
Effective bar stock management comes down to six repeatable disciplines. Build a complete stock list, run a weekly stocktake on the same day every week, calculate par levels from actual usage data, rotate stock using FIFO, track variance against your POS, and hold staff accountable with a waste log and spot checks. Done consistently, this system protects your gross profit and makes the source of any loss visible within days rather than months.
Operators who recover the most margin are not running a fundamentally different bar. They measure the same things more consistently and investigate variance more specifically. Manual processes, done well, create a strong foundation. When the admin load grows beyond what a spreadsheet can sustain, the next step is automation. If you are ready to move beyond spreadsheets and give your team real-time visibility into stock, costs, and margins, schedule a chat with Jelly to see it in action.