PubStockTake Review 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 licensees never find out until the brewery accountant points it out at year-end. You can’t manage what you don’t measure, and the pub industry is full of landlords running stock on spreadsheets so tangled they can’t tell the difference between a line leak and forgotten wastage. That’s what a pubstocktake review is really about—not paperwork, but having the numbers tight enough that you know where your money actually went. In this article, I’ll tell you exactly what works for weekly stock control, what’s a waste of time, and how to spot real losses versus measurement error. I’ve done this in my own pub for over a decade, and I’ve also watched dozens of other operators get it wrong. Read on if you want to know what actually moves the needle on your bottom line.

Why Weekly Stocktake Actually Matters

A weekly line check is the only reliable way to spot stock losses before they cost you serious money. Most pubs run a full stocktake once a month or once a quarter, and by then you’ve already lost the plot. A cask that’s been leaking for three weeks, a spirit line that’s been over-poured by 5ml every shift, a pump that’s pouring short but hitting the till correctly—none of these show up on a quarterly audit. They just compound.

When I first took over my Marston’s pub, I ran stock on a tangle of spreadsheets. Partial kegs lived in a notebook, spirits went down on a loose tally sheet, and I had no real idea whether the numbers at the end of the month matched reality. Stock variances were often 3–4%, which I thought was normal. Then I built a simple weekly count routine: I dip every cask and partial keg on the same day every week, weigh every open spirit bottle, and reconcile it against till data the same morning. Within a fortnight, my weekly variance dropped to under 0.5%, and I realised I’d been bleeding stock at a rate I couldn’t see.

The point isn’t perfect accuracy—it’s early warning. SmartPubTools exists because I got tired of watching other licensees learn this lesson the hard way. A loss of 0.5% you catch in week two is far cheaper than discovering 2% missing at your annual stocktake.

The Five Biggest Stocktaking Mistakes Pubs Make

1. Counting Once a Quarter Instead of Weekly

By the time a quarterly stocktake rolls around, you’ve had twelve weeks to lose track. A single line that’s pouring 5% over standard, multiplied across eighty shifts, adds up to thirty-odd pints gone. You’ll never trace where they went. Weekly counts mean you catch drifts within seven days and fix them before they become habits.

2. Treating Stock Loss as “Theft” When It’s Actually Waste

Most stock that walks out the door leaves in a pint glass, not a thief’s pocket. Over-pouring (especially with free-pour spirits, where a 25ml measure often turns into 32–35ml), line cleaning waste, barrel couplers that leak, and spillage during cask swaps account for far more loss than deliberate pilferage. If you’re not weighing spirit bottles and checking pour sizes, you won’t catch it. A proper audit of your pour technique—measured against till data—often reveals 2–3% of sales going out as unmeasured pours in the first week alone.

3. Not Reconciling Stock Against Till Data

You can have perfect stock counts and still lose money if your till isn’t ringing the right price or the right item. Every stocktake needs a reconciliation: stock you’ve counted plus stock sold (from till) should equal opening stock plus deliveries. If it doesn’t balance, the gap tells you where the problem lives—till or cellar.

4. Measuring Draught by Eye Instead of With a Dipstick

A cask that “looks half full” could be 45% or 55% depending on the angle, the light, and your mood that morning. A proper dipstick gives you the centimetre depth, which converts to a standard volume. The difference between guessing and measuring usually amounts to 2–3% variance per cask. Across a ten-cask cellar, that’s significant error every single week.

5. Running Stock on a Spreadsheet You Don’t Update Immediately

I’ve watched licensees keep “up-to-date” stocksheets that were actually three days old. By then, a kegged line has already hidden new losses. A weekly count only works if you reconcile it the same day you do the count, while the memory of how the cellar looked is fresh and you can ask staff why a particular line is down on last week.

What Equipment You Actually Need (And What You Don’t)

The Essentials

• A proper dipstick. Not a ruler, not your finger. A calibrated dipstick that gives you depth in centimetres. These cost £15–£30 and are the single best investment in cellar accuracy. A cask dipstick paired with a standard volume chart (which the cask manufacturer provides) removes guesswork.
• A set of scales. Digital scales for weighing open spirit bottles. A 700ml bottle of vodka weighs about 900g full, so a 15% loss (105g) is obvious in seconds. This catches over-pouring and slow leaks that your eye will never spot.
• A notebook or simple counting app. Write down your readings as you go. Don’t trust memory. The StockTap pub stock app does this for you, but even a physical notebook is better than improvisation.
• Access to till data. You need to know what the till says was sold on the day you’re counting. This is the reconciliation check that separates real losses from measurement error.

What You Don’t Need

You don’t need a temperature logger in the cellar (though if your temperature is wrong, you’ll see it in the variance). You don’t need a flow meter on every line. You don’t need specialist software that costs £200 a month. You need discipline and consistency, measured with cheap, reliable tools.

The most common mistake I see is licensees buying expensive kit to avoid the boring work of actually doing the count properly. A £400 system that you use twice is worse than a £30 dipstick you use every week.

Weekly Line Checks vs Brewery Stocktakes

The brewery will do a stocktake at some point—usually quarterly or annually. This is valuable, but it’s not a substitute for weekly line checks. Here’s why: the brewery is checking their stock (how much of their product you owe them money for), not your profit. A brewery stocktake finds discrepancies of 2–3%, which gets charged back to you as a deficiency. By the time they audit, you’ve already lost three months of margin.

A brewery stocktake tells you what you owe them. A weekly line check tells you whether you’re making money. You need both, but they serve completely different purposes. The brewery’s count is a legal reconciliation. Your weekly check is an early-warning system.

I’ve also seen breweries charge licensees for stock variance that was actually caused by poor cellar hygiene—a line that wasn’t cleaned properly and wasted product during the clean. If you’re doing weekly checks, you catch that loss immediately and can fix the procedure before it becomes a pattern.

Spreadsheets vs Apps: What’s Really More Reliable

This comes up all the time: “My spreadsheet works fine.” Usually it doesn’t. Here’s what typically happens with spreadsheets:

• You build a complex workbook with multiple sheets, linking cells, and formulas.
• Someone (often you, tired, at 11 p.m.) accidentally overwrites a formula.
• For two weeks you don’t notice because the file still looks sensible.
• Your reconciliation suddenly doesn’t balance, and you have no idea why or when it broke.
• You spend three hours debugging a spreadsheet instead of running the pub.

An app designed specifically for pub counting is more reliable for one simple reason: it has fewer places to break. You enter a dip reading, it converts it to a volume, it stores the result. No formulas you can accidentally overwrite, no linked cells that break in a chain reaction, no risk of someone saving over the wrong version.

The secondary argument in favour of an app is visibility. With a spreadsheet stored on your office computer, only you see it. With an app accessible on any phone or tablet, your bar manager or head cellarman can check the previous week’s numbers before they order stock. They can see the variance trend without waiting for you to send them a file.

That said, a reliable spreadsheet—simple, with no complex formulas—is better than no system at all. The real test is this: can you look at your count data from three weeks ago in under ten seconds? If the answer is no, your system is too complicated.

The One Metric That Actually Matters

Here’s what most pubs get wrong: they obsess over a single stock variance percentage for the whole business. “Our stock was 2% down.” That number is nearly useless because it hides everything. Your draught might be perfect but spirits are leaking. Your beer might be fine but your house wines are being over-poured.

The metric that actually predicts profit is wet gross profit by line. Not a headline variance for the pub, but the cost of goods sold as a percentage of revenue for each product category. Spirits, draught beer, bottled beer, soft drinks, and wine should each have a target GP% based on your pricing and cost. When one of them drifts, that’s your early warning.

Here’s a practical example from my own pub. My standard draught beer was running at 68% GP, which is solid. But when I started weekly checks, I noticed one line was consistently showing higher variance than the others. I reconciled it against till data and found the till was ringing the price correctly, but the stock was disappearing faster than the till showed sales. That pointed me to a line that was pouring short—the pump was faulty. I’d been losing margin on every pint poured on that line, and I’d have never found it without weekly checks and line-level reconciliation.

That’s the real value of proper stocktaking: not catching the occasional theft, but finding the slow bleeds—the leaky couplers, the faulty pumps, the forgotten waste, the over-pours that have become habit. These things cost you more than a dishonest bar staff member ever will.