Best liquor inventory app for pubs in 2026
Last updated: 26 June 2026
Most pubs are losing money silently through stock variance, and they have no idea which line is bleeding it. A 1% stock loss on wet sales quietly costs a typical pub £3,000–£5,000 a year, yet the majority of licensees are still counting on spreadsheets or worse—memory. You feel it as a margin miss month after month, but you can’t pinpoint where it’s actually happening. A proper StockTap pub stock app won’t just give you a stocktake number; it gives you the specific line loss, measured consistently, every single week. In this guide, I’ll walk you through what to actually look for in a liquor inventory system, what the common mistakes are, and why most pubs that move from a messy spreadsheet to a disciplined count process claw back 1–2 gross profit points within a couple of months.
Key Takeaways
- A 1% stock loss on wet sales costs a typical pub £3,000–£5,000 per year, and most pubs don’t catch it because they’re not counting weekly.
- Wet GP by line (measured for spirits, draught, and packaged separately) is the number that matters—not a single headline stock figure.
- Spirits hide losses through over-pouring (a free-poured 25ml is often 32–35ml), draught hides it in line waste and temperature control, and most ‘theft’ is actually forgotten wastage and measurement error.
- A working liquor inventory system requires a dipstick, scales, a till reconciliation, and discipline—not expensive hardware or complex software.
What actually matters in a liquor inventory app
The most effective way to catch stock losses is to measure wet gross profit by line every single week, using weight, volume, and till reconciliation together. Most licensees think they need a magic app that does the thinking for them. They don’t. What you need is a system that makes the counting fast, consistent, and tied directly to your till data on the same day.
I spent years running stock on a tangle of spreadsheets. I had one sheet for kegs, another for spirit bottles, a third for cans and bottles, and none of them talked to each other. At the end of month, I’d have a number—always different from what I expected—and no idea where it came from. I built a simple counting routine around a dipstick and a set of scales, and the weekly variance went from guesswork to a number I could trust within a fortnight.
Here’s what that routine looked like:
- Weigh every open spirit bottle and measure against the previous week’s weight
- Dip every cask and partial keg, record the depth in centimetres, and refer to a standard volume chart
- Count every sealed case and multi-pack physically
- Pull your till data for the same period—same day, never the next morning
- Work out the difference between stock you measured and what your till says you sold
That variance—the gap between measured stock loss and till sales—is where your losses live. If you sold £500 worth of spirits but your bottle weights say you only gave away £485 worth, you’ve got a £15 problem. Not huge—but multiply that across 52 weeks and you’re at £780 just in spirits, and you haven’t looked at draught or packaged yet.
An app that doesn’t connect your measurement to your till data is just making you feel busy. It’s a record-keeping system, not a loss-catching system. SmartPubTools builds that reconciliation into the workflow from the start.
Why wet GP by line beats a headline stock figure
The number that actually matters is wet gross profit by line (spirits, draught, packaged), not a single headline stock figure, because losses hide in different ways on each line.
Spirits hide losses in over-pouring. A free-poured 25ml measure is almost never 25ml—it’s usually 32–35ml, especially late on Friday nights when your bar staff are pouring by eye and the pump measures aren’t calibrated. That’s a 30% give-away. Over a week, one heavy-pouring bar person can cost you £40–£60 on spirits alone.
Draught hides losses in poor cellar temperature, bad line cleaning, and keg waste. If your cellar temperature creeps above 18°C, you lose volume to over-carbonation and wastage. If your beer lines aren’t cleaned fortnightly, you’re pouring 200–300ml of oxidised beer down the drain every shift. If you’re not tracking partial kegs properly, you write off whole kegs as waste when you should be getting three more pints out of them.
Packaged (cans, bottles, premixes) is the easiest line to count physically, but it’s where casual stock-outs happen—someone grabs a case for a private event and forgets to ring it, or a delivery arrives and you don’t reconcile it to your invoice before putting it on the shelf.
If you count stock once a month and get a headline number—”I’m down £800″—you have no idea where to look. Is it spirits over-pouring? Is it draught waste? Is it a delivery invoice error? Is it actual theft? You’re flying blind. But if you count weekly and split the result by line, you can see the pattern in two weeks. Spirit variance spiking on weekends? It’s the over-pouring. Draught variance creeping up? Check your cellar temperature and line clean dates. Packaged jumping around? Look at your delivery reconciliation process.
The five mistakes that hide losses
I’ve seen every variation of this. Here are the ones that cost the most money:
1. Counting on different days, different times
Your variance will be useless if you count spirits on Tuesday morning but kegs on Thursday afternoon. Partial kegs are dynamic—beer is still carbonating, temperature is changing, and you’re still selling from them. Count everything on the same day, first thing after the till close. Make it Tuesday morning, every Tuesday, no exceptions.
2. Not checking till data the same day
Counting your stock on Tuesday but pulling your till data on Wednesday morning means you’ve sold more beer on Tuesday evening that you’re not accounting for. By Friday, the mismatch is too large to reconcile. Pull till data the same day, same hour you finish counting.
3. Forgetting wastage and breakages
Most stock ‘theft’ is actually measurement error and forgotten wastage. A pint of draught spilled during cleaning, a bottle of wine that went off and was poured down the sink, a cask valve failure that lost 20 litres. If you’re not logging these at the time they happen, your variance will never match your till. Keep a simple wastage sheet on the wall. When something breaks or is poured away, write it down immediately with a till modifier.
4. Running stock across a pubco delivery day
If you’re counting on the same day your delivery arrives, you’ll either forget to include the new stock or include it twice. Count after you’ve logged the delivery against your invoice and put everything on the shelf. Or count the night before delivery arrives.
3. Relying on the brewery stocktaker to catch your losses
The brewery stocktaker comes monthly, sometimes less. By the time they arrive, you’ve had four weeks of losses stacking up, and you have no idea which week the damage started. Your margin is already gone. The brewery stocktaker is there to verify their stock and make sure you’re not undercounting for theft reasons—not to help you catch your own losses. They’re not on your side financially. You are.
How to build a routine that takes 20 minutes
The best inventory app is the one you’ll actually use. If it takes an hour, you’ll skip it when you’re busy. Here’s what a 20-minute routine looks like:
- Weigh spirits: Set your scales on the bar, weigh every open bottle, write the weight on a single sheet of paper. Compare to last week’s weights. Takes 5 minutes if you have 12–15 open bottles.
- Dip kegs and partials: Go to the cellar with a simple dipstick (a ruler works fine), note the depth of beer in each container, cross-reference to a volume chart. Takes 5–7 minutes for a typical 8–10 keg setup.
- Count sealed stock: Walk the shelves, count cases of cans, bottles, and premixes. Takes 3–5 minutes if it’s all tidied (which it should be).
- Pull till data and reconcile: Log into your EPOS, pull the total sales for the period, compare to your measured stock movement. Takes 2–3 minutes with a proper system.
Total time: 18–25 minutes. Do it every Tuesday morning, first thing, before service. Write the results down in your chosen app or spreadsheet. By week three, you’ll see patterns. By week eight, you’ll know where your losses are happening and what’s costing you money.
What to look for when choosing a system
You don’t need a £5,000-a-year cloud-based hospitality management system. You need something simple that does three things well:
It lets you record weight, volume, and count in one place
Spirits by weight, draught by dip, sealed stock by count. The app should have separate fields for each, because you’re measuring different things. If it tries to force everything into a single “quantity” field, it’s not designed for pub stock.
It ties directly to your till data
You should be able to paste in your till sales figure and compare it to your measured stock loss on the same screen. The variance should calculate automatically. If you’re manually working this out on a calculator, the app isn’t saving you time.
It separates wet from dry, and by line
Your spirits variance is a completely different number from your draught variance. The system should show you these separately so you can spot which line is the problem. A single headline stock figure is worthless.
It’s accessible from a phone or tablet, not just a desktop
You’re counting in the cellar or at the bar, not sitting at a desk. The app needs to work on the device you’re carrying, and it needs to work offline because cellars have no signal. You sync it back to your phone once you’re upstairs.
It keeps a running history so you can see trends
The app should show you your last four weeks of counts for each line, so you can see if variance is trending up (sign something’s wrong) or trending down (sign your fixes are working). Week-on-week comparison is how you spot problems early.
Answering the objections you have right now
“I don’t have time to stocktake every week.”
You’ll spend longer unpicking a £1,500 variance at month-end than you will doing 20 minutes of counting per week. A weekly count isn’t extra work—it’s work you’re already doing badly. It just moves it from “all at once at the end of the month while you’re stressed” to “little and often when you can spot problems early.”
“My spreadsheet works fine.”
Your spreadsheet works until you fat-finger a formula and lose two weeks of data, or you forget to update it for a delivery and your numbers are rubbish. A dedicated app automates the calculation, keeps a backup, and doesn’t let you accidentally delete rows. If your spreadsheet is working well, it means you’re disciplined enough that a proper system will make you 10 times better.
“Do I really need special equipment?”
You need a set of kitchen scales (£20) and a dipstick (£5, or use a ruler). That’s it. You don’t need temperature probes, flow monitors, or any other hardware. What you need is discipline and a system to write the numbers down consistently. The scales let you measure spirits accurately; the dipstick lets you measure volume accurately. Both are standard pub kit.
“Won’t the brewery stocktaker just do it?”
The brewery stocktaker comes once a month and tells you what you owe them. They’re not there to help you find your losses. If your cellar temperature has been wrong for three weeks, the stocktaker won’t tell you that—they’ll just count what’s there. By the time they arrive, you’ve already lost the money. You need weekly data that’s yours, not a monthly count that’s theirs.
“Is an app safer than a spreadsheet for my records?”
A dedicated app keeps automatic backups, doesn’t get corrupted if your computer crashes, and can be accessed from any device. A spreadsheet lives on one computer and relies on you remembering to back it up. From a data safety perspective, a proper app wins. From a compliance perspective, both are fine—Revenue just needs to see that you’re recording variance consistently. The app is safer and more auditable.
Frequently Asked Questions
How often should I stocktake my pub liquor?
Weekly is the standard for pubs that take margins seriously. A monthly count tells you too late where the loss happened. Weekly counts take 20–30 minutes and catch losses early enough to fix the problem. CAMRA guidance on pub operations recommends frequent stock control as best practice.
What’s a normal variance percentage for pub stock?
A well-run pub should see variance between 0.5% and 1.5% of wet sales. If you’re consistently above 2%, you have a process problem or a loss problem. Variance below 0.3% suggests you’re under-recording wastage. The goal isn’t zero variance—it’s consistent, explainable variance that you can defend to your area manager.
Can I use my EPOS system instead of a separate inventory app?
Most EPOS systems let you record stock counts, but they’re not designed for the measurement workflow pubs need. A dedicated app is faster because it’s built for dips, weights, and counts—not just quantity entry. Your EPOS is good for reconciliation; a proper inventory app is good for the actual count process.
How do I stop my staff over-pouring spirits?
Use calibrated measures (not free-pour) and check them monthly. A 25ml measure that’s actually 32ml is costing you 28% extra give-away. Recalibrate your pump measures quarterly. Use measured pourers on bottles if you’re using a spirits gun. Your variance report will show over-pouring immediately—if draught and packaged are fine but spirits variance is 2–3%, it’s a pouring discipline issue.
What should I do if my stocktake shows a big loss?
Don’t panic. First, check your till reconciliation—the loss might be a recording error or a missed delivery log. Second, look at the dates around the loss to see if wastage, breakages, or staff changes line up. Third, check your cellar temperature and line clean dates (draught loss). Only after ruling out process problems should you consider theft or under-recording. Always investigate weekly to catch these early.
You now know what a proper inventory routine looks like, but most pubs still run on guesswork because they lack the framework to make it consistent.
The StockTap pub stock app is built specifically for this workflow—it’s built by a working licensee who was tired of spreadsheets.
£97 once. No subscription. No monthly fees. Works on any device, records weight, volume, and count separately, ties to your till data, and shows you trends week-on-week so you can spot losses before they become disasters.