Pub Stock Control System UK: The Real Numbers

Last updated: 9 April 2026

Most pub landlords discover £500 to £2,000 in hidden stock losses within their first week of proper inventory tracking. Not because they’re bad at business — because manual stock control is mathematically impossible to get right. You’re managing hundreds of SKUs across multiple locations, shifts, staff members, and till systems. Something always slips through. The question isn’t whether you’re losing money — it’s how much, and whether you can stop it.

Stock control is the single largest controllable loss centre in most pubs. Wastage, spillage, theft, inaccurate pour counts, missing bottles, staff drinks not rung through — it all adds up. I’ve spent 15 years watching pub owners fight with spreadsheets and manual counts, watching their margins compress, and watching them blame “the market” when the real problem was sitting in their stockroom, invisible.

A proper pub stock management system doesn’t just track what you have. It connects every sale, every delivery, every waste event, and every variance directly to cash flow. That’s the difference between guessing and knowing. In this guide, I’m going to show you exactly what a working pub stock control system looks like, why most pub owners get it wrong, and how to implement one that actually sticks.

What Is Stock Control, and Why Does It Matter?

Stock control is the system that connects every bottle you buy, every drink you sell, and every ounce of product that disappears, directly to your profit margin. It’s not just about counting bottles at the end of the month. It’s about knowing — in real time — whether your till transactions match your physical stock, whether your pour costs are accurate, whether staff are following procedures, and where money is leaking out.

In most UK pubs, stock control means one of three things: a stocktaker comes in once a month and counts everything (inaccurate, disruptive, and reactive), the manager does a manual count on a Friday night (inconsistent, time-consuming, and ignored), or there’s no system at all (chaos). None of these approaches connect your sales data to your inventory data. So you never actually know whether a missing bottle was a sale, a waste event, a spillage, or something else entirely.

Here’s the reality: the most effective way to control stock in a UK pub is to integrate your point-of-sale system directly with your inventory management so every transaction updates stock in real time, and variances are flagged automatically before they become losses. Without that integration, you’re flying blind.

Why does this matter? Because hospitality margins are thin. A typical pub runs at 25-35% gross profit on drinks. Lose 3-5% of your stock through untracked variance, and you’ve wiped out 10-20% of your profit. That’s not a rounding error. That’s the difference between your pub surviving and thriving.

The Problem With Manual Stock Management

I spent years running The Teal Farm with spreadsheets. Weekly stock counts, manual entry of delivery notes, trying to reconcile till transactions with physical counts. Here’s what I learned: it doesn’t work.

The problems are layered. First, manual counting is slow and inaccurate. You’re trying to count 300+ SKUs while the pub is running, or late at night when everyone’s tired. Mistakes compound. A bottle miscounted by 1 on Monday becomes a data point that throws off your entire week. By Friday, you’ve got no idea whether your variance is real or just accumulated counting errors.

Second, there’s a massive lag between when something happens and when you know about it. Stock count on Friday reveals variances from the previous week. You have no idea if the problem is from Monday or Thursday. You can’t pinpoint the cause. You can’t correct it. You move forward and hope it doesn’t happen again.

Third — and this is critical — manual systems don’t create accountability. If a bottle goes missing, nobody knows it’s missing until the count. By then, the evidence is gone. Was it staff theft? A spillage that wasn’t reported? A till error? An inaccurate delivery count? Without real-time data, you can’t tell. Staff know this. Losses continue.

Manual spreadsheet-based stock control systems require 15-20 hours of management time monthly and still fail to detect 30-40% of variances. You’re spending a full working week every month on data entry, reconciliation, and counting — and you’re still not getting accurate information. That’s not control. That’s friction.

The other problem nobody talks about: cash flow. When you don’t know your actual stock variance, you can’t forecast your cash requirements. You might think you need £5,000 of cash next week, but if you’ve been losing 4% of stock undetected, you actually need £5,300. VAT surprises, unexpected cash shortfalls, and inability to pay suppliers on time all stem from stock data that doesn’t match reality.

How Modern Stock Control Systems Actually Work

A proper stock control system in 2026 works in three integrated layers: capture, reconciliation, and action.

Layer 1: Real-Time Capture

Every transaction is captured at the point of sale. When a customer buys a pint of Guinness, that transaction records three things: revenue (what the till captured), product (Guinness), and quantity (1 pint). Simultaneously, that same transaction updates your inventory system — stock of Guinness decreases by 1 pint. No delay. No manual entry. No interpretation.

This sounds simple but it’s transformative. Your inventory is always aligned with what your till says you’ve sold. If there’s a variance, it’s immediately visible — not at the end of the month, but within hours.

Layer 2: Automatic Reconciliation

The system compares your recorded sales (from the till) against your theoretical stock (based on opening inventory, deliveries, and sales) and flags anything that doesn’t match. If the system says you should have 45 bottles of Stella left, but you count 42, that 3-bottle variance is flagged immediately. You know it happened. You know approximately when it happened. You can investigate while the information is fresh.

Most systems apply a tolerance threshold — typically 1-2% variance is considered normal and acceptable (spillage, evaporation, rounding). Anything beyond that triggers an alert. You decide whether to investigate, adjust for known waste events (bottles found broken in the morning), or drill deeper.

Layer 3: Actionable Data

The system generates reports that show: variance by product, variance by shift, variance by staff member, variance trends over time, cost of variance in pounds sterling, and forecasted impact on monthly profit. This moves stock control from “how many bottles did we lose?” to “who is responsible, what cost us, and what do we do about it?”

This is where real control happens. A landlord can see that variance on Stella spikes during Tuesday shifts when a specific member of staff is pouring. That’s not an accusation — that’s data. You can retrain on pour accuracy, watch more closely, or make a staffing decision. With manual systems, you’d never see that pattern because you’re not tracking by shift and person.

Implementation: Getting Started Properly

Most pub landlords overthink this. They imagine a complicated technical installation and give up. The reality is simpler and faster than you think.

Step 1: Audit Your Current Data

Before you implement any system, you need a baseline. What’s your current variance? Spend two weeks doing manual stock counts every other day. Count the same products, same way, same time. You want to establish: what percentage of stock are you currently losing undetected? This becomes your benchmark. When you implement a proper system, you’ll see this number drop dramatically within 4-6 weeks.

Step 2: Choose a System With Till Integration

Your system must connect to your POS (point of sale) system. If it doesn’t, you’re back to manual entry. Your existing till — whether it’s an iPad-based system like Toast, a traditional system like Micros, or something custom — needs to feed into your inventory system automatically. This is non-negotiable.

Pub Command Centre handles this integration seamlessly. Setup takes 30 minutes. No formulas. No technical knowledge required. It connects to your till, pulls transaction data, reconciles it against your inventory records, and flags variances automatically. Most pub owners discover £500-£1,500 in hidden losses in the first week.

Step 3: Set Your Tolerance Thresholds

Decide what variance percentage is acceptable for each product category. Bottled beer might be 1% (more forgiving, harder to lose a bottle). Spirits might be 0.5% (easier to lose in pours, need tighter control). Draught beer might be 2% (normal head waste, acceptable loss). These thresholds tell the system what to flag as unusual and what to consider normal.

Step 4: Train Your Staff

Your staff needs to understand that stock accuracy is now visible. Not as a threat — as a responsibility. Make it clear: we’re tracking what we’re doing, we’re looking for losses, and we’re investigating variances. Staff who pour accurately, clean up spills, and report breakages are valued. Staff who cut corners or steal are identified quickly.

Train them on the non-negotiable procedures: report every spillage immediately, pour to consistent standards, ring every transaction through the till before serving, and count stock before and after each shift.

Step 5: Review Weekly, Not Monthly

Pull variance reports every Tuesday morning. Which products, shifts, or staff members are showing unusual patterns? Investigate immediately. A single conversation with a staff member about Thursday’s variance is more effective than a vague accusation three weeks later. Weekly reviews also let you celebrate accuracy — “we were dead accurate on Guinness this week, nice work everyone.”

The Metrics That Actually Matter

Not all stock data is equally useful. Here are the four metrics that actually move the needle.

1. Variance as Percentage of Sales

Raw variance (you’re missing 5 bottles) means nothing without context. Variance as a percentage of sales (you’re missing 1.3% of Stella sales) tells you whether the problem is growing, shrinking, or stable. Track this weekly. A 3% variance is concerning. A 5% variance is a crisis. A 0.5% variance is excellent.

2. Cost of Variance in Pounds Sterling

Stock variance should be measured and reported in pounds sterling, not just percentages, because percentages don’t motivate action but money does. “You’re losing 2% of stock” sounds abstract. “You’re losing £800 a month” gets immediate attention. Your board, your accountant, and your staff all understand the money metric instantly.

3. Variance Trend (Month-on-Month)

Is your variance improving or degrading? Graph it month-on-month. If it’s trending upward, you have a problem that’s getting worse. If it’s trending downward, your systems are working and your staff are responding to the visibility. This is the metric that tells you whether your control system is actually controlling anything.

4. Variance by Category and Product

Some products will always have higher variance — draught beer typically has more waste than bottled spirits. But within each category, identify the outliers. If Stella is at 2% variance but all other lagers are at 0.8%, something’s happening with Stella specifically (staff favouritism? Pour training issue? Supplier problem?). This data-driven focus is how you eliminate problems systematically instead of guessing.

Most pub landlords don’t track these metrics because they don’t have the data. That’s the problem with manual systems — you get counts but not context. A proper system gives you counts, context, trends, and money impact all in one view.

Stock control isn’t glamorous. It’s not going to win you awards. But it’s the foundation that every profitable pub operates on. The difference between a pub that makes money and a pub that’s always scrambling comes down to whether the owner knows where the money is going. With a proper system, you do. Without it, you’re guessing.

The real cost of stock loss isn’t just the lost product — it’s the lost cash flow, the delayed supplier payments, the VAT surprises, and the management time spent investigating mysteries that shouldn’t exist in the first place. A working stock control system solves all of that at once.

For more information, visit RankFlow free trial.

For more information, visit SmartPubTools.

For more information, visit RankFlow marketing tools.