Last updated: 2 May 2026
Running this problem at your pub?
Here's the system I use at The Teal Farm to fix it — real-time labour %, cash position, and VAT liability in one dashboard. 30-minute setup. £97 once, no monthly fees.
Get Pub Command Centre — £97 →No monthly fees. 30-day money-back guarantee. Built by a working pub landlord.
Most pub licensees discover stock variance the hard way—when their NSF audit reveals thousands of pounds missing between what the till recorded and what the cellar actually contained. Stock variance is the difference between the quantity of stock you should have based on sales records and the quantity you physically have in the cellar. You feel like you’re doing everything right, your staff seem reliable, yet every month the numbers don’t add up. The pubco’s BDM hints at your control systems being weak. Your profit margin looks healthy on paper but feels non-existent in reality. This article will walk you through exactly what stock variance is, why it matters more than you think, and the practical steps to identify and reduce it—without turning your pub into a stock-counting prison.
Key Takeaways
- Stock variance is the gap between what your till says you sold and what physically left your cellar, and most pubs lose 2-8% of stock value annually to variance.
- Uncontrolled stock variance directly cuts into gross profit and will be flagged during NSF audits and pubco compliance reviews.
- The most common sources of variance are free pours, spillage, staff breakages, outdated stock records, and inaccurate till inputs rather than theft.
- Reducing variance by just 1% can add £3,000–£8,000 to annual profit depending on your turnover, making it one of the fastest ROI improvements available.
What Stock Variance Actually Means
Stock variance is simply the difference between theoretical stock (what you should have based on sales) and actual stock (what you physically have when you count). When you pour a pint, your till records a sale. That pint should leave your cellar. But in reality, sometimes it doesn’t account perfectly—spillage happens, measures are over-poured, glassware breaks, stock expires. The gap between the number your system expects and the number you find when you count is variance.
Here’s a real example: you sell £4,000 of draught beer in a week according to your till. Your opening stock was 50 kegs. You received a delivery of 30 new kegs. By the math, you should have 80 kegs minus the equivalent of sales. But when you physically count, you only have 18 kegs left. That missing stock is your variance.
In tied pubs under Marston’s CRP or similar arrangements, stock variance isn’t just a financial problem—it’s a compliance issue. Your pubco tracks it. NSF audits specifically look for it. I passed my March 2026 NSF audit because my stock variance stayed below 2%, which is what the pubco expects. Above that threshold, you start getting questions from your BDM, and repeat failures can affect your lease renewal conversations.
Why Stock Variance Matters for Your Profit
Most new licensees think stock variance is a minor accounting issue. It’s not. Every percentage point of stock variance lost directly reduces your gross profit margin, which is already thin in UK pubs operating at 50-60% GP on wet sales.
Let me be blunt: if you’re turning over £200,000 a year in wet sales and your stock variance sits at 4%, you’re losing £8,000 annually. At 6% variance, that’s £12,000. That’s not money that “went missing”—that’s profit you never saw. It didn’t go to staff wages, rates, or your pocket. It evaporated.
When you use a pub profit margin calculator, variance is one of the silent killers that makes the projection feel too optimistic. You forecast a 56% gross profit, but you actually deliver 52% because of uncontrolled variance. Over a year, that gap compounds.
Beyond the direct money loss, stock variance triggers red flags during audits. Your NSF auditor will compare your theoretical consumption (sales ÷ bottle/keg cost) against your actual usage. Big variances attract scrutiny. Your pubco’s BDM will question your control systems. If you’re a prospective licensee evaluating a pub tenancy, high variance from the previous operator is a warning sign that the business has deeper problems than it looks on paper.
How to Calculate Your Stock Variance
You need three numbers: opening stock value, stock received, closing stock value. The formula is simple:
Variance % = [(Opening Stock + Stock Received − Closing Stock) − Cost of Sales] ÷ Cost of Sales × 100
Or more plainly: What you should have minus what you actually have, divided by what you sold, times 100.
In practice, here’s how it works week-to-week at Teal Farm:
- Monday opening: Cellar value £2,400 (from Friday count)
- Deliveries received: £1,800 in kegs, bottles, spirits
- Till sales recorded: £3,600 in wet sales (representing approx £1,800 cost of stock)
- Friday closing count: Cellar value £2,350
- Calculation: (£2,400 + £1,800 − £2,350) − £1,800 = £50 variance on £1,800 cost of sales = 2.8% variance
That 2.8% is within tolerance. Below 2% is excellent. Above 4% is a problem that needs investigating.
The challenge is accuracy. Your opening and closing stock values depend entirely on how carefully you count and how current your stock prices are. If you’re using prices from six months ago, your calculations are already wrong. If you’re estimating keg fills instead of counting, you’re introducing error.
This is where most pubs fail. They don’t have a reliable stock count process. They guess. They use outdated prices. They skip weeks and then try to reconcile a month’s variance at once—which is impossible to break down meaningfully. Setting up pub weekly accounts discipline is non-negotiable if you want to control variance.
Common Causes of Pub Stock Variance
Before you blame theft, understand this: in most pubs, the top causes of stock variance are completely preventable and have nothing to do with malice.
Free Pours and Over-Pours
This is the biggest single cause in community pubs. A regular customer orders a pint. Your bar staff knows them, likes them, occasionally gives them a slightly generous pour. Maybe not a whole pint more, but 50ml extra here, 75ml there. Over a week with 200 customers, that’s 5-10 litres of unmeasured alcohol going out. Over a month, that’s 20-40 litres. Multiply that by your cost per litre and you’ve got hundreds of pounds of variance before anyone’s stolen a thing.
The solution is ruthless consistency on measure discipline, not suspicion of your staff. I use optics on draught and enforced measures on spirits. It removes the guesswork and protects staff from accusations.
Spillage and Wastage
Kegs get tapped. Beer lines get cleared. Spirits get spilled during service. A shattered pint glass behind the bar. A bottle of wine that was opened Wednesday but not finished until Friday and then discarded. This is normal pub operations, not negligence. But if you’re not tracking it, it becomes variance.
Any pub serving 180 covers like Teal Farm will have 2-3% variance just from legitimate spillage and wastage. That’s expected. When your variance exceeds 3-4%, something else is wrong.
Outdated or Inaccurate Stock Records
You count the cellar on Friday but don’t update your system until Wednesday. Meanwhile, three deliveries have arrived and you haven’t entered them. Your till system and your physical cellar are running in different timezones. When you calculate variance, you’re comparing numbers that were never in sync to begin with.
This is the second-biggest culprit after free pours. Your stock records are stale. Your delivery notes aren’t entered promptly. Your till categories don’t match your cellar structure. The system thinks you have 20 kegs of Carlsberg but actually you have 18—and you won’t find out for another week.
Till Input Errors
Your EPOS system is only as good as the data going in. If your staff are pressing the wrong buttons, if you’re not using codes consistently, if someone rings “Lager” instead of “Carlsberg” or “House Wine” instead of “Pinot Grigio,” your till doesn’t know what actually left the cellar. Your variance calculation is instantly unreliable.
This is why pub EPOS configuration matters. When I evaluated systems for Teal Farm, I needed one that let me track specific products, not generic categories, because my variance control depends on knowing exactly which items moved.
Stock Shrinkage (Real Theft, Breakage, Spoilage)
Yes, sometimes stock goes missing because someone took it. Sometimes bottles break. Sometimes stock expires. But this usually only accounts for 0.5-1% of variance in a pub with reasonable security practices. If your variance is 6%, it’s not because of theft—it’s because of the four issues above.
Proven Ways to Reduce Stock Variance
I’ve brought variance down at Teal Farm from 3.2% when I took over (three years ago on my birthday, when I signed the Marston’s CRP agreement) to consistently under 2% now. Here’s what actually works.
Implement Rigid Stock Count Discipline
Count every Friday evening, same time, same person ideally. Record the count in real time—don’t estimate and write it down later. Use consistent pricing. Update your system the same day. If you miss a Friday, don’t try to retroactively calculate variance for that week. Start fresh.
Weekly counting is the single biggest factor in variance control because it isolates problems to a specific seven-day window where you can actually investigate what happened. Monthly counting means you’re trying to explain 30 days of accumulated errors.
Lock Down Your Measure System
Optics on all draught beer. Enforced measures on spirits. A house wine pour policy that’s non-negotiable. This removes discretion and removes the biggest source of variance. Yes, staff might grumble about “not being able to look after regulars,” but most staff actually appreciate clarity.
At Teal Farm, I use optics on Carlsberg, Guinness, and San Miguel. Spirits go through 25ml and 50ml measures. House wine is a 175ml or 250ml glass—nothing in between. Complimentary drinks (staff training tastings, etc.) are logged separately so they don’t create variance mystery.
Reconcile Till to Cellar Weekly
Every Friday, calculate what your till says you sold, work out what that should mean left the cellar, and count the actual cellar. Document the variance. If it’s over 3%, investigate that specific week. Did you have a big event? Did a keg go bad? Did someone do free pours? Find out while the week is fresh.
This is where pub stock take template discipline matters. Your template should include spaces for recording variances by product category so you can spot patterns. If lager variance is always high but spirit variance is tight, you know to look at your lager pour practices.
Train Staff on Stock Awareness
Most staff don’t know variance exists or why it matters. They think stock control is your problem, not theirs. If you explain that variance directly affects wages and the pub’s survival, they usually care more. Show them the numbers. “Last month we had 4% variance. That’s £500 we can’t pay in wages or invest back in the pub.”
Brief staff on what creates variance: spillage, over-pours, breakage. Tell them to report broken bottles so you can log them. Make it collaborative, not punitive.
Regular Stock Audits (Not Just Annual)
Don’t wait for your NSF audit or pubco inspection. Do a full cellar audit every quarter—count everything, reconcile against till records, find the gaps. This isn’t paranoia. It’s the difference between catching a small control problem and discovering a major one when your auditor arrives.
When your auditor shows up with clean data and consistent records, they trust your numbers. When they find scattered records and big unexplained variances, they assume the whole business is loose.
Setting Up a Monitoring System That Works
You don’t need expensive software, but you do need a system. I track stock variance using three tools: a simple pub daily sales log template to log till sales daily, a cellar count sheet updated every Friday, and a weekly variance spreadsheet that compares the two.
The key is that all three are in one place and the numbers flow into one calculation. If you’re jumping between your EPOS system, a spreadsheet, and a notebook, you’ll make errors.
The most effective way to monitor stock variance is to establish a weekly ritual where you calculate it the same day every week, using the same method, and document any variance above 2% with a specific reason. This creates accountability without creating paranoia.
Before you sign any pub tenancy agreement, ensure you understand what variance percentage your pubco expects. Ask the BDM directly: “What variance tolerance do you work with?” Most legitimate pubcos accept 2-3%. If they say “anything under 5% is fine,” that’s a red flag about their overall control standards.
If you’re taking on a tied pub, your variance history will affect future lease negotiations. Show consistent sub-2% variance and your pubco trusts your financial management. Show 5%+ variance and you’re signalling weak control to a BDM who already holds most of the power in your relationship.
The reality is this: stock variance is entirely within your control. Unlike rent, rates, or tied beer prices, you can directly influence it through discipline and systems. Every 1% reduction in variance adds £3,000–£8,000 to your bottom line depending on turnover. That’s a return on investment that beats almost any other pub improvement project.
If you’re currently running a pub with loose stock practices, implementing a proper variance control system will feel like work for the first month. By month three, it’s automatic. By year one, you’ll wonder why every pub doesn’t do this.
Frequently Asked Questions
What is an acceptable stock variance percentage for a pub?
Most pubcos accept 2-3% variance. Below 2% is excellent control. 3-4% is acceptable but signals you should investigate. Above 4% suggests loose practices. During NSF audits, variance above 3% typically triggers questions. Your specific tolerance depends on your pubco—ask your BDM what they expect before signing a tenancy.
How do you calculate stock variance in a pub?
Add your opening stock value to deliveries received, subtract your closing stock value, then subtract your recorded cost of sales. Divide the result by cost of sales and multiply by 100 for a percentage. Example: (£2,400 + £1,800 − £2,350) − £1,800 = £50 variance ÷ £1,800 sales = 2.8%. Weekly calculations isolate problems better than monthly ones.
What causes most stock variance in pubs?
Free pours and over-pours account for 40-50% of variance in most pubs, followed by outdated stock records (20-25%), spillage and breakage (15-20%), till input errors (10-15%), and actual theft or spoilage (5-10%). The top cause is almost never theft—it’s usually generous pouring for regular customers happening unconsciously over weeks.
Why does stock variance matter if I’m making profit?
Stock variance directly reduces your gross profit margin. If you’re losing 4% to variance on £200,000 annual turnover, that’s £8,000 in lost profit. Additionally, NSF audits and pubco BDMs specifically review variance as an indicator of control. High variance can affect lease renewals and your credibility in future business discussions.
When should you count stock to catch variance?
Weekly counts on the same day (ideally Friday evening after closing) are the best practice. This isolates variance to a specific seven-day window so you can investigate what happened during that week. Monthly counts make it impossible to track down the source of problems. During high-volume periods (match days, quiz nights), consider counting twice weekly to catch issues faster.
You now know what variance is eating and why it matters. But knowing your stock numbers and knowing whether you’re actually making money are two different things.
Your EPOS tells you what sold. Pub Command Centre tells you whether you made money—real-time labour %, VAT liability, cash position, and this is the bit no other system has: built-in cellar tracking so you can spot variance patterns before they become audit problems.
£97 once. No subscription. No monthly fees. 30-day money-back guarantee.
See how Pub Command Centre spots variance problems others miss
For more information, visit retail partner earnings calculator.
For more information, visit best pub EPOS systems guide.
Running your pub on gut feel?
The Pub Command Centre gives you wet GP%, cellar checks, staff cost and weekly P&L — from your phone, every shift. £97 once. No subscription.
See the Pub Command Centre →