What is pub stock variance and why it costs you money

Last updated: 26 June 2026

Most pub licensees have no idea what their actual stock variance is, and that’s exactly what they’re losing money on. You can sell the same number of pints this week as last week, hit your till targets, and still come up short on stock — and the difference isn’t always theft. It’s measurement error, over-pouring, line waste, and forgotten spillage adding up to a number that quietly costs a typical pub £3,000 to £5,000 a year. A 1% loss on wet sales is the industry norm; most pubs I know are closer to 2–3%. The good news is that pub stock variance isn’t inevitable — it’s just invisible until you decide to measure it properly.

What Is Pub Stock Variance?

Stock variance is the difference between what your till says you sold and what your physical count shows you actually have in the cellar and behind the bar. If your till recorded £500 in beer sales last week, but your stock count shows you’re short by £50, you have a £50 variance — and that money is gone.

In hospitality accounting, variance is normal. Every business accepts some small loss — breakage, spillage, a measure that goes down the drain. But in a pub, variance adds up fast because you’re dealing with fractions of measures (a 25ml spirit, a half-pint of bitter) and partial kegs that sit in a cold cellar for days.

The tricky part is this: variance doesn’t tell you what went wrong. It just tells you that something did. You could be over-pouring without realising it. Your cellar temperature could be causing wastage on cask ales. Your bar staff might be ringing up the wrong product code. Or yes, someone could be stealing. Until you dig into the numbers by line — spirits separately from draught, cider separately from lager — you’re flying blind.

Why Stock Variance Happens in Pubs

I’ve been running my Marston’s pub for 15 years, and I can tell you the real sources of stock variance are not what most landlords think they are. When I first built a proper counting routine, I expected to find evidence of till fraud or staff theft. Instead, I found three culprits that cost me far more than anything deliberate.

Over-Pouring on Spirits

A free-poured 25ml spirit is routinely 32–35ml in reality. If you’re training your bar staff by eye instead of using a jigger or measure, you’re giving away margin on every single spirit sale. A busy Friday night with 200 spirit serves at 8ml over-pour is £30–£50 gone before you even clock it. Most pub staff aren’t trying to be generous — they’re just pouring what looks and feels right to their hand.

Cellar Temperature and Line Waste

If your cellar is sitting at 16°C instead of 12–14°C, cask ales start degrading. You’re losing volume to gas escape and oxidation. Bad line cleaning — or lines cleaned too infrequently — causes wastage when you’re pulling through stale product. A cask that sits in a warm cellar for three weeks loses more than the brewery’s tolerance allows. That loss shows up in variance.

Measurement Error and Forgotten Spillage

Most stock “theft” in pubs is actually measurement error and forgotten wastage that nobody bothers to log. A spirit bottle gets knocked over and half of it goes down the drain — but nobody rings it as wastage. A keg develops a slow leak and loses a litre over the course of a week. A partial barrel of bitter gets written off after three weeks, but by then the variance number is already baked into your accounts. These small incidents, repeated across 20+ product lines, become your 2–3% loss.

Till Data Inaccuracy

If your EPOS is misconfigured, or staff are ringing the wrong product codes, your till tells you that you sold one thing but your cellar shows another. A guest orders a pint of bitter and the staff member rings it as a pint of lager. Variance grows. If your till isn’t integrated with your stock counts, you won’t know until the end of the week.

How to Measure and Track Variance

Measuring variance properly requires three things: accurate stock data, accurate till data, and a consistent counting method. Most pubs fail on all three.

Step 1: Know Your Opening Stock

You need a baseline. If you don’t know what you physically have on a given day, you can’t measure what changed. This means dipping every cask and partial keg with a proper dipstick, weighing open spirit bottles (not guessing by the label), and counting closed bottles. One of the most common mistakes I see is licensees counting by “bottles” without checking what’s actually inside them. A half-finished bottle of vodka that’s been sitting behind the bar for a month counts for something, but it’s not a full unit.

Step 2: Record Till Sales by Line

Your EPOS must be able to report what you sold, broken down by product category. You need to know how many pints of bitter, how many 175ml glasses of wine, how many 25ml vodkas, how many pints of Foster’s you rang that day or week. Most pubs’ EPOS can do this, but the data lives in a report nobody bothers to pull.

Step 3: Reconcile Against Closing Stock

At the end of your counting period — I recommend weekly, not monthly — count again. Dip the kegs, weigh the spirits, count the bottles. Then compare:

• Opening stock (Monday dip) + deliveries (what came in) − closing stock (Friday dip) = what should have sold
• What your till says you sold = your actual sales figure
• Difference = variance

If your till says you sold 40 pints of bitter and your stock count says you used 43 pints of bitter, you have a 3-pint variance (or roughly £7.50 at £2.50 per pint). That’s a variance rate of 7.5% on that line for the week. Do that every week and you have a solid number to track.

The Weekly Line Check: Your First Defence

I’ve tested monthly counts, quarterly counts, and spreadsheet-based tracking systems. The only method that actually catches variance before it becomes a real problem is a disciplined weekly line check — usually done on a Sunday or Monday when the pub is quiet.

When I moved from a messy tangle of spreadsheets and partial records to a simple routine — dip every cask, weigh every open spirit bottle, count the closed stock, then reconcile against till data the same day — my weekly variance dropped from pure guesswork to a number I could trust within a fortnight. I wasn’t doing anything different operationally. I was just measuring properly.

What You Need for a Weekly Check

• A dipstick (£15–£30, lasts for years) — the only reliable way to measure cask depth
• A set of scales (digital kitchen scales work fine, £20–£40) — for spirit bottles and opened containers
• A record system — pen and paper, a spreadsheet, or better yet, a tool built for the job
• Your till reports pulled same-day — sales by product line

The StockTap pub stock app was built by a working landlord who got sick of spreadsheets. It automates the dip-and-weigh recording and compares it against your till data the same day, so you can see variance by line immediately. But honestly, if you don’t have the tool yet, a notebook and a calculator will do the job. The discipline matters more than the software.

Why Weekly, Not Monthly?

Monthly stocktakes are too late. By the time you count at the end of the month, you have 28 days of measurement error, spillage, and drift baked into your numbers. A staff member left four weeks ago and you’re still accounting for losses from their shift. If you count weekly, you spot a variance trend within two weeks. If something breaks — a bad keg delivery, a cellar temperature spike, a till glitch — you know about it before it costs you £500.

Common Objections and How to Answer Them

“I don’t have time for a weekly stocktake.”

A proper weekly line check takes 45 minutes to an hour, once a week. That’s the time cost. If that 45 minutes catches you a 2% loss instead of letting it become a 3% loss, you’re saving yourself £2,000–£3,000 a year. The return on that time is enormous. Most licensees waste more time chasing problems they don’t understand because they’re not measuring.

“My spreadsheet works fine.”

Does it catch variance by line? Can you pull last week’s data and this week’s data side by side and spot trends? If you’re managing stock on a spreadsheet with 20+ product lines, you’re managing cognitive load that scales with complexity. Every time you add a new product, the spreadsheet gets harder to maintain. A proper system that’s built for the job — with your till data integrated — will catch errors faster and give you better data. But the real question is: what’s your actual variance right now? If you don’t know, your spreadsheet isn’t working as well as you think.

“Do I really need special equipment?”

You need a dipstick and scales. That’s £50–£80 total. If you’re running a pub on a budget and you skip these, you’re flying blind on your biggest cost line. You wouldn’t run a till without a till. Don’t run a cellar without a dipstick. The brewery’s stocktaker will use them during their visit — why shouldn’t you?

“Won’t the brewery stocktaker just do it?”

The brewery stocktaker comes once a quarter or once a year. They dip your kegs, they note the variance, and then they leave. If there’s a problem, you don’t find out about it until the next brewery visit. Even worse, you don’t own the data — the brewery does. If you want real-time visibility into what’s happening in your cellar and behind your bar, you have to measure it yourself. Weekly.

“Is an app safer than a spreadsheet for my records?”

A purpose-built SmartPubTools app stores your data in the cloud with backups and access controls. A spreadsheet sits on one device and one person’s laptop. If that device fails or that person leaves, you’ve lost your data. An app also makes it harder to accidentally delete columns or make calculation errors. From a data security and auditability standpoint, an app is safer. But more importantly, an app that’s integrated with your till data catches errors automatically. A spreadsheet requires manual data entry, which is where most errors happen.

Tightening Your Numbers: Real Results

Here’s what actually happens when you move from no measurement to disciplined weekly variance tracking. Most pubs that shift from a messy spreadsheet routine — or no routine at all — to a real weekly line check see variance tighten by 1–2 gross profit percentage points within a couple of months.

That’s not because theft suddenly stops. It’s because you start catching over-pouring, cellar temperature issues, till errors, and spillage as they happen, rather than six months later when the year-end stocktake reveals a disaster. You change your systems incrementally based on actual data. If your draught beer variance is 8% but your spirits variance is 2%, you know the problem is in the cellar or the line cleaning, not the till. You fix the cellar temperature. You find the leak in the line. You move the needle.

In my own pub, once I built a simple count routine around a dipstick, a set of scales, and a commitment to reconcile against till data the same day, my weekly variance went from a number I couldn’t trust at all to a number that was stable and trackable within a fortnight. Six months later, I was clawing back 2 GP points and I understood exactly why. My beer line was running at 14°C instead of 12°C — a £30 cellar thermostat fixed it. My draught bitter variance dropped from 6% to 2%. My spirits variance was actually 1.5% because I’d retrained my staff to use a jigger instead of pouring free. That’s not magic. That’s data.