Liquor inventory management for pubs

Last updated: 26 June 2026

Most pubs lose money on stock without realising it’s happening. A 1% variance on wet sales—barely noticeable month-to-month—quietly costs a typical pub £3,000 to £5,000 a year. That’s not theft. It’s measurement error, over-pouring, temperature waste, and forgotten spillage adding up faster than anyone notices. You probably already suspect you’re leaking stock somewhere. The problem is that until you actually count, you don’t know where or how much.

After 15 years running a Marston’s pub and watching other licensees struggle with the same problem, I’ve learned that liquor inventory management isn’t complicated—but it does require discipline and the right routine. Most pubs that move from a messy spreadsheet to a proper weekly count claw back 1–2 GP points within a couple of months, simply because they start measuring what was always going missing.

This article covers how to set up a liquor inventory management system that actually works, why weekly line checks matter more than annual stocktakes, and the specific equipment and process you need to catch losses before they become thousands of pounds.

Why Liquor Inventory Management Matters to Your Margin

The most effective way to protect your wet GP is to count your stock weekly and reconcile it against till data the same day. Most pub managers treat inventory management as a compliance exercise—something the brewery stocktaker does annually or something left to an admin spreadsheet that nobody updates. That’s the wrong way round.

Your EPOS tells you what sold. But it doesn’t tell you whether you made money on that sale. A £5 pint that should yield £2.50 gross profit can quietly become £2.10 if your cellar temperature is 2°C too warm, your lines haven’t been cleaned properly, or your staff are free-pouring spirits at 32ml instead of 25ml. Across a week, that’s easily £100–£200 vanishing with no trace.

When I switched from guesswork to a disciplined weekly count, the number that moved most wasn’t the headline stock figure—it was the variance on individual lines. I discovered I was losing more on cask ale than I realised (mostly temperature and line cleaning waste), more on spirits than should be possible (measurement error and over-pouring), and more on bottled beer than my suppliers’ delivery notes suggested (rotation and damage issues I wasn’t tracking).

That’s why liquor inventory management has to be specific and granular. You need to know your wet GP by line, not just your headline stock number. And the only way to know that is to count it yourself, regularly, and cross-check it against what your till says you sold.

Weekly Line Checks vs. Annual Stocktakes

Let me be direct: if you’re only stocktaking once a year, you’re flying blind for 51 weeks. By the time you find the loss, it’s too late to trace the cause, fix the process, or recover the margin.

Annual stocktakes work for compliance and pubco audits, but they don’t work for you. A 2% variance over 12 months sounds like a rounding error, but spread across a year, it’s invisible. You can’t work backward from an annual count to find out whether the loss happened in January or October, or whether it was the draught or the spirits, or whether it was waste or theft. You just have a number that doesn’t match.

Weekly line checks give you three critical things an annual stocktake can never provide: speed, specificity, and the ability to act.

• Speed: A proper weekly count takes 20–30 minutes. You do it the same day every week, reconcile it against the till immediately, and any variance jumps out.
• Specificity: You count by line (Guinness, Peroni, Absolut Vodka, etc.), so you know exactly where the loss is occurring.
• Action: If Guinness variance is running +2% three weeks in a row, you know there’s a cellar issue—temperature, line cleaning, or pouring technique. You can fix it. An annual count just tells you the answer after you’ve wasted 12 months.

Most pubs that move from an annual-only approach to weekly checks catch a variance pattern within the first month. Temperature problems show up immediately. Over-pouring trends become obvious. You start to see which staff member’s shifts correlate with higher waste. That’s intelligence you can use.

The Process: What to Count and How

Set a fixed day and time each week. I do mine every Monday morning before service, with a checklist and a simple notebook. Here’s what you count:

Casks and Kegs

Every cask and partial keg gets dipped. A dipstick (usually supplied free by your brewery) goes into the bung hole, and you read the level in pints. Record it against the line name and date. If you have a partial keg, mark the date you broached it and the level. This catches temperature waste, cleaning waste, and pouring errors immediately.

Bottled Beer and Cider

Count by brand and size. Do a physical count, not an estimate. It’s quick and reveals rotation issues—if you’re holding more stock than you need, capital’s tied up and bottles age. If you’re holding less, you’re running out and losing sales.

Spirits and Liqueurs

This is where most pubs lose the most money, and most of them never notice. Weigh every open spirit bottle on a set of kitchen scales accurate to 5g. A standard 25ml measure of spirit weighs roughly 20g (spirit is less dense than water). Record the weight next to the bottle name. Do this every week. The scales cost £15; the data is worth thousands.

Why weight instead of just visual inspection? Because a free-poured 25ml is often 32–35ml. Over a week, across 10 bottles, that’s easily 20–30 measures of unrecorded pour. No till ring, no record, no warning light. Just gone.

Reconciliation

On the same day, pull your till data for the previous week. Compare what you counted against what you sold. Your theoretical stock should be: opening stock + deliveries − sales. If actual stock is less than theoretical, you have a variance. If it’s close (within 0.5%), you’re doing well. If it’s running 1%+, something’s wrong.

Record the variance by line in a simple spreadsheet or notebook. Over time, patterns emerge. That’s your signal to act.

Equipment You Actually Need

You don’t need fancy software or specialist kit to do this properly. I started with a dipstick (free from the brewery), a set of digital kitchen scales (£15), and a notebook. That’s genuinely all you need.

• Dipstick: Request one free from your brewery if you don’t have one. It’s a simple graduated stick that measures cask depth in pints.
• Kitchen scales: Digital, accurate to 5g, less than £20. Weigh spirits weekly.
• Notebook or spreadsheet: Record the date, line name, and reading. You need a record you can review week-on-week.
• EPOS till data: Export your sales by category daily so you can reconcile immediately.

The StockTap pub stock app automates this process if you want to move beyond paper, but the fundamentals don’t change. Count, record, reconcile, review. Everything else is just a container for that process.

The Mistakes That Cost You Money

After 15 years, I’ve seen every way a pub can mess up inventory management. These are the ones that actually hurt:

Counting at Random Times

If you count Thursday one week, Tuesday the next, and Saturday the week after, you’re measuring different things. One week might include a busy weekend, the next might include a quiet one. You can’t see trends. Pick a fixed day and stick to it. I do Monday mornings so the weekend is always included in the previous count.

Not Weighing Spirits

Visual inspection of a spirit bottle is worthless. A 70cl bottle of vodka that looks three-quarters full might actually be two-thirds full. The difference is easily £15–£20 of unaccounted pour. Weigh them. It takes five minutes per bottle and catches the most expensive losses.

Not Recording Deliveries and Waste

Your opening stock + deliveries − sales = theoretical closing stock. If you don’t record deliveries properly, every reconciliation is wrong. Same with waste. If you spill a bottle, write it down. If you have to bin a keg because the line’s infected, record it. Otherwise, your variance figures are garbage.

Assuming the Brewery Stocktaker Will Catch It

The brewery stocktaker’s job is to verify that your opening stock matches their delivery notes and their invoice, not to manage your margins. They’ll do an annual count for audit purposes, but they’re not tracking your week-to-week losses. That’s your job. And by the time the brewery audit comes around, any loss they find is already 12 months old and unrecoverable.

Not Reconciling Till Data

Your EPOS data is the other half of the equation. If your till says you sold £200 of spirit and your dip count shows you lost 30 measures, something’s wrong—either your till read is wrong, your count is wrong, or there’s actual loss. You can’t know which unless you compare them the same day. Most losses aren’t obvious when they’re spread across a week; they’re obvious when you check them immediately.

Moving Beyond the Spreadsheet

When I first started counting properly, I used a simple Excel spreadsheet. It worked. I recorded each week’s count, calculated variances, and reviewed them monthly. Within a fortnight, I had enough data to see patterns.

The problem with a spreadsheet is that it’s easy to leave blank cells, easy to forget to fill it in weekly, and easy to use it passively—recording data but never actually reviewing it. You end up with a month of counts that nobody’s acted on. SmartPubTools built StockTap as a purpose-built alternative because a spreadsheet works, but it requires discipline and doesn’t force the weekly routine.

If you move to a dedicated app, look for one that:

• Lets you record dips, weights, and bottle counts in the same place you record till data and deliveries.
• Calculates variance automatically so you can spot trends instantly.
• Works on any device (phone, tablet, computer) so you can do the count on the floor.
• Doesn’t require a subscription or ongoing fees—you pay once and own it.

The core insight is this: a system is only as good as the routine it enforces. Whether you use paper, Excel, or an app, the value comes from counting weekly, recording consistently, and reviewing the variance data. The tool is secondary.

Frequently Asked Questions