Bar stocktaking software that actually works
Last updated: 26 June 2026
A 1% stock loss on wet sales quietly costs a typical pub between £3,000 and £5,000 a year, and most licensees never spot it until the year-end stock check. You’re not being robbed—you’re bleeding money through measurement error, over-pouring, wastage you forgot to record, and cellar temperature drift that nobody noticed. Bar stocktaking software isn’t a luxury. It’s the difference between clawing back 1–2 gross profit points within a couple of months or watching that leak carry on into next year.
I spent seven years running stock on a tangle of spreadsheets and partial keg records scattered across three notebooks and a whiteboard in my cellar. My weekly variance was guesswork. Then I built a simple count routine with a dipstick, a set of scales, and a proper recording method—and within a fortnight my numbers went from meaningless to something I could actually trust and act on. That’s when I realised the real problem wasn’t complexity. It was discipline and visibility. Bar stocktaking software solves that.
In this article you’ll learn why your spreadsheet is failing you, which bar stocktaking software actually saves time (not adds to it), how to set up a weekly count that catches losses before they become big ones, and what to look for if you’re choosing a tool. By the end you’ll know exactly whether you need software or whether you just need a better routine.
Key Takeaways
- A 1% stock loss on wet sales costs a typical pub £3,000–£5,000 yearly, and spreadsheets rarely catch it until year-end.
- The most effective way to spot bar stock losses is through weekly dips, scales, and till reconciliation on the same day—not annual counts.
- Spirits hide losses in over-pouring (a free-poured 25ml is often 32–35ml), draught hides it in temperature and line waste, and most ‘theft’ is actually measurement error.
- Bar stocktaking software works best when it’s simple enough to use every week without adding time to your shift.
Why spreadsheets fail at bar stocktaking
Spreadsheets work fine until they don’t. You can record opening stock, closing stock, additions, wastage notes—all in one tidy cell. Then you start adding another venue, or a second bar, or someone uses a different naming convention for Guinness (sometimes “Guinness Draught”, sometimes “Guin”, sometimes just “G”). Your formula breaks. You copy the formula down wrong. Someone edits a cell and doesn’t update the summary. By week three you’re not confident in your own numbers.
More importantly: a spreadsheet doesn’t know what your till says you sold. You can record that you had 10 cases of Peroni on Monday and 6 cases on Friday. But if your EPOS says you sold 3.2 cases, where did the other 0.8 go? With a spreadsheet, you shrug and move on. With proper software, that variance jumps out at you immediately, and you can investigate it the same week—not six months later at year-end audit when it’s too late to remember what happened.
The other reason spreadsheets fail: they’re not auditable. If someone’s stealing, or if you’re over-pouring without knowing it, a spreadsheet looks the same whether you’re losing 0.5% or 5%. There’s no flag, no trend line, no alert. You just have a number that seems roughly right and a nagging feeling that something’s off.
What bar stocktaking software actually does
Bar stocktaking software works by capturing your physical stock count, comparing it to what your till says should be there, and showing you the variance the same day. That’s it. Anything more complex is trying to solve a problem you haven’t got.
The best bar stocktaking software does three things:
- Records the count consistently. Same format every week, same fields, no confusion. You dip every cask, weigh every open spirit bottle, scan the register, and log it in seconds.
- Connects to your till data. It pulls what you sold from your EPOS without you having to type it in manually. Fewer data entry errors, faster reconciliation.
- Flags variances instantly. If physical stock doesn’t match till data, you see it immediately—not at year-end. You investigate the same week while memory is fresh.
Some software adds features like temperature logging, line cleaning records, or staff shift tracking. That’s fine if you want it. But don’t let feature creep distract you. The core job is variance detection. Everything else is bonus.
How to build a weekly count system that works
You don’t need fancy software to start. You need discipline. I ran a successful weekly count for two months on a clipboard, a dipstick, and a notebook before I ever touched an app. Here’s the system:
Step 1: Pick a fixed day and time. I do mine Monday morning at 6am before the bar opens. Same time every week. No exceptions. This is non-negotiable—if you skip it one week, you skip it three weeks, and suddenly it’s dead.
Step 2: Measure draught stock by dipping every cask and partial keg. A dip tells you what percentage of the cask is full. Multiply that by the cask size and you have your stock figure. Write it down. Don’t estimate. Don’t assume the cask is as full as it looked on Thursday. Dip it.
Step 3: Weigh every open spirit bottle. A full 70cl bottle of standard spirit weighs about 750g. An empty bottle weighs about 400g. A spirit bottle that weighs 550g is roughly 50% full. If you need precision, use a kitchen scale. It costs £15 and it’ll save you a grand a year in the first month alone.
Step 4: Record sealed stock as-is. Sealed bottles are sealed—you count them. Sealed cases are counted. No variance possible until it’s open.
Step 5: Reconcile against till data the same day. Pull your EPOS report for the same period. Compare physical stock + sales versus opening stock. Any variance over 2% needs investigation.
That’s it. Thirty minutes a week. If you’re spending more than forty minutes, you’re over-complicating it.
Where losses actually hide in a bar
Most stock ‘theft’ is not actually theft. It’s measurement error, forgotten wastage, and over-pouring that nobody tracks.
Spirits hide losses in over-pouring. A free-poured 25ml measure is often actually 32–35ml. That’s a 30% variance on every single pour. Over a week, across three spirits, that’s easily a £40 loss nobody notices. It’s not deliberate—it’s just how free pouring works. Measure it once and you’ll see it immediately. Solution: use optics. They cost £8 a pop and they pay for themselves in a week.
Draught hides losses in cellar temperature and bad line cleaning waste. If your cellar is 20°C instead of 13°C, you’re losing half a pint per pint to foam and waste. That’s 50% variance on your pour count. If your CO2 regulator is creeping up, you’re over-pressurising casks and pouring foam. If your lines aren’t cleaned properly, you’re losing a litre a day to slop and spoilage. These aren’t individual pints being nicked. They’re systemic leaks. A weekly dip catches them because the variance becomes impossible to ignore.
Forgotten wastage is the big one. Someone drops a bottle. It spills during service. A cask goes bad and you have to throw it away. You bin a tray of draught because the lines were filthy. All of it should be recorded as wastage. None of it ever is. By Thursday you’ve forgotten what broke on Monday. A weekly count + wastage log forces you to reconcile those forgetting errors before they compound.
The number that actually matters is wet GP by line, not a single headline stock figure. You might be running overall stock variance of 1.2%, which looks fine. But if your gin variance is 4% and your Guinness is 0.1%, something specific is wrong with gin service—over-pouring, theft, or a faulty optic. You won’t see that pattern in a spreadsheet unless you’re manually calculating it. Software shows it in a line graph.
What to look for in bar stocktaking software
Bar stocktaking software should serve one purpose: make your weekly count faster and your variance reporting clearer. If it does those two things, everything else is optional. Here’s what to evaluate:
1. Does it connect to your till? If you have to manually type in your sales figures, the software isn’t saving you time—it’s creating another data entry step. Any software worth using should pull EPOS data directly (or allow a one-click CSV import). StockTap pub stock app pulls from most major tills. Check that yours is on the list.
2. Can you use it from any device? You’ll want to use it on your phone during the count (so you can log stock as you move through the cellar), but also on a laptop or tablet when reconciling. Cloud-based software that syncs across devices saves you from standing in a cold cellar copying numbers.
3. Does it show variance by line? You need to see which products are losing stock fastest, not just a headline number. If your variance report doesn’t break down by product and by week, you can’t spot trends or investigate specific problems.
4. Is it simple enough to use every week? If the software has so many fields and options that your count takes 90 minutes instead of 30, you’ll skip it. Over-engineered software is worse than no software at all. The best bar stocktaking software gets out of your way.
5. Does it have a cellar management screen? This is a differentiator. Most pub software has sales and accounts. Almost none of it has actual cellar data—temperatures, line logs, cask rotation, partial keg tracking. That’s where SmartPubTools is different. If you’re choosing software, ask whether it actually manages your cellar or whether it just records sales.
Common objections answered
Objection 1: I don’t have time for a weekly stocktake.
You have time to lose £3,000–£5,000 a year? Because that’s what’s happening right now. A proper weekly count takes thirty minutes. That’s 26 hours a year to save thousands. If you genuinely can’t find thirty minutes on a Monday morning, your staffing model is broken and no software will fix it. But most people can find thirty minutes. They choose not to because it feels admin-heavy. It stops feeling admin-heavy once you’re pulling back 1–2 GP points.
Objection 2: My spreadsheet works fine.
Your spreadsheet works fine until it doesn’t. It works fine for high-level numbers. It fails at variance detection, trend spotting, and product-level analysis. It also fails the moment someone edits a cell wrong or uses a different naming convention. And it definitely fails at telling you whether you’re losing money on draught versus spirits versus spirits. If you want to know wet GP by line—which is the only number that actually matters for decision-making—a spreadsheet is going to cost you more time than software.
Objection 3: Do I really need special equipment?
You need a dipstick (£3), a set of kitchen scales (£15), and a notebook (£1). That’s it. If you’re using free-pour measures on spirits, add eight optics at £8 each (£64). Total investment: under £100. A single 1% stock loss is worth £3,000–£5,000. You break even in the first week. The rest is pure profit.
Objection 4: Won’t the brewery stocktaker just do it?
The brewery stocktaker comes once or twice a year. They do a full audit of casks and kegs in stock. They don’t do a weekly reconciliation against your till. They don’t spot that you’re losing 2% on your premix mixer or that your Guinness line is over-pouring by 15%. They catch big, obvious problems. They miss the small, recurring problems that compound into thousands of pounds. You have to do your own weekly count. The brewery can’t do it for you.
Objection 5: Is an app safer than a spreadsheet for my records?
A properly built app (hosted on secure servers, with automatic backups, and access controls) is significantly safer than a spreadsheet on your laptop or a shared drive. Your stocktake data is financial evidence. If you’re audited, your records need to be reliable and traceable. A spreadsheet that lives on your desktop and gets emailed around to various staff members is not traceable. Cloud-based software with user logs is. Choose software that keeps audit trails and backups by default.
The real problem bar stocktaking solves
Bar stocktaking software doesn’t make money. Your business makes money. What bar stocktaking software does is stop money leaking away unnoticed. It turns a vague feeling that something’s off into a concrete number you can act on. It takes a variance that might be 1% or might be 5% (and you genuinely don’t know) and tells you exactly what it is, which product it’s happening in, and whether it’s trending up or down.
Most pubs that move from guesswork to a disciplined weekly count claw back 1–2 gross profit points within a couple of months. That’s £15,000–£30,000 a year for a typical £250,000 turnover pub. The software pays for itself in the first week. Everything after that is pure recovery.
The only question is whether you’re going to keep losing that money, or whether you’re going to spend thirty minutes a week and find it.
Frequently Asked Questions
How often should I stocktake a bar?
Weekly is the industry standard and the minimum to catch losses before they compound. A weekly count takes thirty minutes and flags variances immediately. Monthly is too infrequent—you’ll miss trends and won’t be able to investigate problems while memory is fresh. Annual stocktakes are for auditors, not for running the business.
What percentage stock variance is acceptable?
Anything over 2% variance in a week needs investigation. Most well-run bars achieve 0.5–1% variance when they’re measuring properly (dipping casks, weighing spirits, reconciling against till data the same day). If your variance is consistently above 3%, you have a specific problem—over-pouring, theft, waste, or measurement error—that needs fixing immediately.
Should I use bar stocktaking software or a spreadsheet?
Use software if you want variance alerts by product line, automatic till integration, and trend reporting. Use a spreadsheet if you enjoy data entry errors and wondering why your numbers don’t match your till. In practice, software saves time and catches problems that spreadsheets miss. The best bar stocktaking software costs less than your weekly variance loss.
Can bar stocktaking software prevent theft?
It can’t prevent theft, but it will detect it fast. Theft usually shows as unusually high variance on specific products—bottles that go missing but don’t match till records. A weekly count flags this within days. Annual counts hide it for eleven months. If theft is happening, software makes it visible. What you do about it is up to you.
What’s the cost of a 1% stock loss in a bar?
A 1% loss on wet sales (usually the biggest part of bar revenue) costs a typical pub £3,000–£5,000 per year. For a £250,000 turnover venue with 60% wet sales (£150,000), 1% loss is £1,500. Most pubs lose more than 1% without realising it. Better counting often reveals losses of 2–3%, which compounds to £6,000–£15,000 yearly until you fix it.
Weekly stocktaking is the only way to catch losses before they cost you thousands. But it only works if you have the right tool and the right routine.
£97 once. No subscription. No monthly fees. Works on any device.