Free pub stocktaking app: what you actually need

Last updated: 26 June 2026

Most free pub stocktaking apps are built for restaurants, not pubs, and they will cost you money the moment you actually try to use them. The problem isn’t the price tag — it’s that they don’t track what matters in a pub: open spirit bottles, cellar temperature, draught waste, and the specific measurements that catch losses before they become thousands of pounds. When I moved from a spreadsheet tangle to a proper count routine fifteen years ago, I realised the number that actually matters is wet gross profit by line, not a single headline stock figure. If you’re running a pub and losing 1% of wet sales to untracked variance — which most are — that’s quietly costing you between £3,000 and £5,000 every year. A weekly line check with the right tools catches it. This article tells you exactly what a stocktaking app needs to do, which free options genuinely work, and when paying for the right system actually saves money.

Why Free Pub Stocktaking Apps Usually Fail

Free pub stocktaking apps sound appealing until you realise they’ve been designed for a pizza restaurant or coffee chain, not a pub with a cellar, draught lines, and spirits. I’ve watched licensees try them. They look clean. They sync to your phone. Then you realise there’s nowhere to record cask dipstick readings, no field for cellar temperature, and no way to note that a spirit bottle was only three-quarters full at opening. The app just asks for a quantity and a unit price — which is useless when you’re counting wet goods.

The deeper problem is that free apps rarely connect to your EPOS or till data. That matters because most stock ‘theft’ is actually measurement error and forgotten wastage. A spirit that pours a free-pour 25ml measure is often actually 32–35ml. A cask that loses three pints to line cleaning waste looks like variance. A partial keg that rolled across the cellar and lost a litre to damage sits unreported. None of those show up as theft — but they all show up as stock loss. Without daily reconciliation against what your till says sold, you’ll never separate real loss from these invisible measurement gaps.

Free apps also typically store data on a phone or a generic cloud service, which raises questions about data safety that UK licensees increasingly need to answer. You’re recording purchase prices, stock levels, and financial performance — information your pubco, accountant, or auditor might ask to see. Most free apps weren’t built with UK data security in mind.

What a Real Stocktaking System Actually Needs

After fifteen years running stock across multiple Marston’s pubs, I can tell you exactly what separates a system that catches losses from one that just collects numbers:

• Cellar tracking: Fields for cask dips, barrel numbers, temperature logs, and line cleaning waste. This is where most pub profit leaks happen, and almost no free app includes it.
• Spirit bottle weights: A place to record the opening weight of every open spirit bottle, not just a quantity. This catches over-pouring immediately.
• Draught measurement: Ability to log pints sold by line against cask dips taken on the same day. This reconciliation is what turns guesswork into a number you can trust.
• Till reconciliation: A way to compare what your stocktake shows against what your EPOS says sold, recorded the same day. One-day-old data is still useful; week-old data is worthless.
• GP by line, not headline: Reports that show you profit on spirits separately from draught separately from bottled separately. A single “stock loss” figure hides where the real problems are.

The reason these features matter is not academic. The number that actually matters is wet gross profit by line, not a single headline stock figure. Spirits hide losses in over-pouring. Draught hides it in poor cellar temperature and bad line cleaning waste. When you see what each category is actually returning, you can fix the problem category instead of guessing.

Is a Spreadsheet Good Enough?

I hear this often: “I’ve been using Excel for ten years. Why change?”

Because Excel doesn’t reconcile against your till the same day. I know from experience. When I was running stock on spreadsheets at my pub, I could see opening balances and closing balances, but I couldn’t see whether the variance was real loss or just a partial keg I’d forgotten to note or a spirit bottle that had been open longer than I’d recorded. The weekly variance went from guesswork to a number I could trust within a fortnight only when I built a simple count routine around a dipstick and a set of scales, and recorded every number the same day it happened.

Spreadsheets also create one dangerous problem: they look complete but aren’t. You can input a stock figure without recording cellar temperature, without weighing the spirit bottle, without dipping the cask. The spreadsheet accepts the data anyway. A system designed for pub stocktaking will force you to complete the measurement — or at least warn you that data is missing.

A spreadsheet works if you’re obsessively disciplined. Most operators aren’t, because they’re doing thirty other things. A tool designed specifically for pub stock counting removes friction and catches the gaps that loose recording misses.

When to Buy Instead of Free

Here’s the blunt truth: if you’re losing 1% of wet sales to untracked variance — and most pubs are — you’re already paying £3,000–£5,000 per year for the privilege of not knowing where your money went. A system that costs £97 once and helps you catch and fix that loss will pay for itself within the first month.

The StockTap pub stock app costs £97 as a one-off purchase with no subscription, no monthly fees, and works on any device. It was built by a working pub landlord, not a software company trying to sell to restaurants. It includes cellar tracking, spirit bottle logging, draught measurement, and till reconciliation — the features free apps don’t have.

Most pubs that move from a messy spreadsheet or a free app to a disciplined weekly count routine using the right system claw back 1–2 gross profit points within a couple of months. That’s between £2,000 and £4,000 a year in recovered margin. The tool pays for itself in weeks.

The question isn’t whether you can afford to buy. It’s whether you can afford not to. SmartPubTools was built to answer the specific problems UK pub licensees face.

The Weekly Count Routine That Works

The counting method matters more than the app. I’ve seen licensees use the most sophisticated software available and still miss losses because they weren’t measuring correctly. Here’s the routine that actually works:

Monday to Sunday: Daily Recording

• Record cellar temperature first thing after opening.
• If a spirit bottle is opened that day, weigh it and record the weight. Not the quantity — the weight. A digital kitchen scale costs £15.
• Log any line cleaning waste or spillage by pint count.
• Note the till reading at close and record it in your system.

Weekly: The Full Count

• Dip every cask and partial keg. Record the date, barrel number, and dipstick reading.
• Weigh every open spirit bottle again. Compare to yesterday’s weight and last week’s opening weight.
• Count every bottle and crate of packaged goods.
• Record all figures the same day in a system that links back to your till data.

Same Day: Reconciliation

Reconcile against till data the same day. This is the step that separates real loss from measurement error. Your till says 200 pints of lager sold. Your cellar dips and cask records say you dispensed 198 pints. That’s a 2-pint variance, which is normal waste and line cleaning. Your till says 15 bottles of prosecco sold. You counted 14 full bottles and a three-quarter open one at the end of the week. The variance is real, and now you can investigate whether it’s over-pouring or a bottle that was damaged or a till ring error.

This routine takes a licensee or manager about 30 minutes once you’ve built the habit. It catches problems in the moment when they’re still fixable, not after a month of untracked losses.

Equipment You Actually Need

People often ask whether they need specialist equipment to stocktake properly. The answer is: very little, and almost all of it you already have.

• Dipstick: £8 from any catering supplier. Measures cask contents by depth. Non-negotiable.
• Digital scales: £15–20 from any supermarket. For weighing open spirit bottles. Accurate to 10g.
• Thermometer: £5. For cellar temperature. Keeps draught quality consistent.
• Crate board or pen and paper: For recording notes while you’re in the cellar. Don’t rely on memory.
• A system to record the numbers: This is where most free apps fall short. You need something that stores readings, links to till data, and lets you reconcile the same day.

Do not underestimate the value of recording the same day. A stocktake done on a Monday for the previous week’s trading is useless. The numbers are too old, the variance explanations too fuzzy, and the losses too embedded to recover. Record today’s readings today, and the variance is fresh enough to diagnose.