Best Pub Stocktaking Software in 2026

Last updated: 26 June 2026

A 1% stock loss on wet sales quietly costs a typical pub £3,000–£5,000 a year, and most publicans don’t even know it’s happening. You’re not being robbed. You’re bleeding money through measurement error, over-pouring, poor cellar hygiene, and forgotten wastage — and a spreadsheet will never catch it because you’re not checking the same way twice. The best pub stocktaking software isn’t about fancy dashboards or cloud sync. It’s about forcing you to count the same way every single week, so your variance becomes a number you can actually trust and act on. This article will show you exactly what to look for, which systems work for real pub operations, and how to implement a stocktake routine that actually sticks.

What Actually Matters in Pub Stocktaking

The most effective way to prevent stock loss in a pub is to weigh open spirit bottles, dip every cask and partial keg, and reconcile against till data the same day, because this is the only method that catches measurement error before it becomes real loss. I spent years running stock on a tangle of spreadsheets and still losing track of partial kegs and spirit measures. The turning point came when I built a simple count routine around a dipstick and a set of scales, and within a fortnight my weekly variance went from guesswork to a number I could trust.

Here’s what I learned: spirits hide losses in over-pouring (a free-poured 25ml is often 32–35ml in reality). Draught hides it in poor cellar temperature, bad line cleaning waste, and the dregs you pour out when you change a cask. Most stock ‘theft’ isn’t theft at all — it’s measurement error and forgotten wastage. Once I started weighing open bottles and matching that against till rings, the loss stopped being mysterious and started being preventable.

The software doesn’t do the counting for you. You do. What the software does is make sure you count the same way every week, that you log it in the same place, and that you can see the pattern. That’s the difference between noise and signal.

Why Your Spreadsheet Isn’t Working

If you’re still using a spreadsheet to manage stock, you’ve probably noticed a few things: you can’t remember where you last updated it, your bar staff don’t log stock as they use it (because there’s no friction to doing it), and when you sit down to do the monthly count, the numbers don’t line up. That’s not laziness. That’s a system problem.

Spreadsheets have no built-in consistency. One week you measure spirit in bottles, the next week you estimate. One week you dip the ale casks, the next week you assume they haven’t changed much. One week you log draught waste, the next week you forget. By the time you’ve done this for a month, your variance is so noisy that you can’t tell if you’re actually losing stock or just counting badly.

A proper stocktaking system forces a method, not optional data entry. The StockTap pub stock app works by building a repeatable count sheet with pre-set fields for each line — cask depth, spirit weight, till variance, waste notes — so you’re forced to check the same things the same way every time. Your staff know what to do. You know what was counted. The variance becomes real.

Most pubs that move from a messy spreadsheet to a disciplined count routine claw back 1–2 GP points within a couple of months, just by catching the measurement errors and forgotten wastage they were leaking before.

How to Choose the Right Software

There are three types of stocktaking tools available to pubs right now: integrated EPOS systems (like Epos Now or Toast) that add stocktake as an afterthought module, dedicated inventory apps that sync with your cellar, and simple paper or spreadsheet-based systems dressed up as ‘apps’.

Here’s what to actually look for:

• Offline capability. If your WiFi drops during a line check, your system should not fail. Most pubs’ cellars have patchy signal. Your stocktake tool must work without it.
• Speed. A line check should take 20 minutes, not 45. If the interface slows you down, it won’t get done consistently.
• Till reconciliation. Your stocktake software must talk to your till records, because the variance between what sold and what was used is where the real number lives.
• No subscription. Monthly fees add up, and most subscription tools are overloaded with features you don’t need. A simple one-off tool that does one thing properly will outlive three subscriptions.
• Built by someone who actually runs a pub. If the developer has never stood in a cellar at 6am checking a broken line, they won’t understand what you need.

The SmartPubTools team built a tool specifically for this: no subscription, offline-ready, and designed around the actual stocktake method that works in a pub. Before you pick any software, make sure it lets you count the way you actually work — not the way software designers think you should work.

Building a Weekly Line Check Routine

Stocktaking works best as a weekly discipline, not a monthly monster. Most pubs can do a full line check in 20–25 minutes if the method is tight and the software doesn’t get in the way. Here’s a routine that works:

Monday morning, 6am (before opening), 20 minutes total:

• Log each cask: depth reading with a dipstick, temperature, cask age (how many days it’s been on).
• Weigh each open spirit bottle. Log the weight. Compare to the same bottle last week.
• Check ale lines: any cleaning waste, any pour-offs, any issues.
• Log draught waste — what went down the drain this week.
• Grab till data from yesterday and add it to the sheet (e.g., 47 pints of lager sold, 23 measures of vodka rung).
• Calculate the variance: what you had last week plus what sold minus what you have now = loss or gain.

If the variance is within 1–2%, you’re fine. If it’s higher, investigate that line. Maybe the measure is heavy-poured. Maybe the cask leaked. Maybe the till ring is wrong. Find it before it becomes a recurring leak.

The reason this works is repetition. After four weeks, you’ll spot patterns. You’ll know which lines bleed, which staff over-pour, which casks run faster than they should. That’s not possible with a monthly stocktake.

Essential Equipment (and What You Don’t Need)

You don’t need much. This is the mistake that kills most stocktake initiatives — people buy a cellar thermometer, a fancy hydrometer, a digital scale, and three apps, then never use any of it because the setup is too complicated.

Here’s what you actually need:

• A dipstick (£2 from any homebrew shop). You’ll measure cask depth in centimetres. That’s it.
• A small set of digital kitchen scales (£10–15). You’ll weigh open spirit bottles to 10g accuracy.
• A thermometer for your cellar (preferably a min/max wireless one, £20–30, so you catch temperature swings that waste beer).
• A phone or tablet with the stocktake app on it. That’s your count sheet.

You don’t need: hydrometers, refractometers, gravity meters, or any other exotic equipment. You don’t need a scale that reads to 1g — 10g is fine. You don’t need a cloud-based system with real-time reporting dashboards. You need something that lets you count quickly and compare week-on-week.

The brewery stocktaker will arrive quarterly or half-yearly with their own gear and method. That’s their audit. Your weekly check is your early warning system. Two different purposes. Both matter.

Addressing the Common Objections

I don’t have time to stocktake every week.

A proper line check takes 20 minutes. If you can’t find 20 minutes on a Monday morning before opening, you can find £3,000–£5,000 that you’re leaking instead. Most pubs do it on the same day and time every week — that’s the discipline that makes it stick. Do it once, the time becomes invisible.

My spreadsheet works fine.

No it doesn’t. You might think it does because you don’t have anything to compare it to. The moment you switch to a system that forces consistency, you’ll spot stock movements you’ve been missing. Your variance will drop by 30–50%, guaranteed. That’s not promise; that’s what happens when you actually count the same thing twice in the same way.

Do I really need special equipment?

A dipstick and some scales, yes. Anything else, probably not. The equipment isn’t the bottleneck. Consistency is. SmartPubTools has guidance on exactly what to buy and where to get it cheap. You’re looking at £30 total.

Won’t the brewery stocktaker just do it?

The brewery stocktaker is your external audit. They arrive quarterly or half-yearly, they check a sample, and they verify the balance sheet. By then, if there’s a problem, it’s too late to fix. Your weekly line check catches the problem in the first week, so you can act. Different purpose. You need both.

Is an app safer than a spreadsheet for my records?

Yes, because it forces a consistent method and it’s harder to lose. A spreadsheet can be accidentally deleted or overwritten. A proper app keeps a log of every count you’ve ever done. You can see patterns year-on-year. For tax purposes, that audit trail is actually valuable — if you’re ever asked to justify a stock figure or a variance claim, you have seven weeks of consistent data to show, not a spreadsheet someone edited last Tuesday.