How to Prepare for a Stocktaker in 2026
Last updated: 26 June 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 publicans dread stocktake day because their records don’t match their cellar—and they have no idea why. A proper stocktake isn’t a surprise audit; it’s a financial checkpoint that either confirms your numbers are tight or exposes where you’re bleeding money. The difference between a chaotic stocktake and a clean one often comes down to preparation: clean records, accurate till reconciliation, a tidy cellar, and a tracking system you actually trust. When you prepare properly, the stocktaker’s visit becomes a validation of your control, not a crisis.
You’ll learn exactly what to do in the days and weeks before the stocktaker arrives, how to organise your cellar and spirits so the count runs smoothly, why your till data matters more than you think, and what common mistakes will expose you to variance surprises. Most importantly, you’ll understand that preparing for stocktake is preparing for profit—because the stocktaker’s job is to find out whether you made the margin you thought you did.
Key Takeaways
- A 1% stock loss on wet sales costs a typical pub £3,000–£5,000 a year, and most of that loss is caught during stocktake—so preparation prevents financial bleeding.
- Your till data and stock records must reconcile on the same day; if they don’t, the stocktaker will find the gap and it will be recorded against you.
- Spirits hidden in poor records account for more loss than anything else—weigh open bottles and log every optic adjustment before the stocktaker arrives.
- A tidy, organised cellar with clearly labelled stock and accurate partial keg/cask records cuts stocktake time in half and reduces counting errors.
Why Stocktake Preparation Matters More Than You Think
The most effective way to protect your pub margins is to reconcile your stock records against your till data before the stocktaker arrives. Most publicans think stocktake is something that happens to them—the brewery sends someone in, you close the bar for half a day, and you find out if you’re up or down. The truth is stocktake is a financial health check, and your preparation directly determines whether the results tell an accurate story or expose hidden problems.
A 1% stock loss on wet sales quietly costs a typical pub £3,000–£5,000 a year. Most pubs don’t know they’re losing that money until stocktake day—and by then it’s too late to trace where it went. What’s worse, if your records are messy when the stocktaker arrives, they’ll flag variance that might actually be measurement error or forgotten wastage, and that gets logged against your performance. The stocktaker’s job is to count what’s there and compare it to what you say you had. Your job is to make sure what you say you had is actually documented and reconcilable.
When I first took on my Marston’s pub, I was running stock on a tangle of spreadsheets and partial counts. I still had no idea where a 2.3% variance was coming from. I built a simple routine around a dipstick and a set of scales, and within a fortnight I had weekly variance numbers I could actually trust. The real number that matters isn’t a single headline stock figure—it’s wet GP by line. Spirits hide losses in over-pouring (a free-poured 25ml is often 32–35ml), draught hides it in poor cellar temperature and line cleaning waste, and most stock ‘theft’ is actually measurement error and forgotten wastage. That’s why preparation starts with knowing your baseline.
Get Your Till Records and Sales Data in Order
Your till is the source of truth for what should have left your cellar. Before the stocktaker arrives, reconcile your till data against your stock records for at least the last 7–10 days. This isn’t about being paranoid; it’s about understanding where the disconnect is before an external auditor finds it.
What to check
- Daily till close reports: Print or export your till summary for the last 10 days. Check that cash, card, and voids are recorded consistently. If your till reconciliation is sloppy, the stocktaker will assume your sales data is unreliable—and that means your stock variance looks worse than it actually is.
- Void and discount logs: Any drinks that came off the till but didn’t sell—training pours, staff drinks, comps, damage—need to be logged separately. If these aren’t recorded, they’ll show up as unaccounted stock loss during stocktake. Most publicans don’t log staff training pours, and the stocktaker will query every percentage point of variance.
- Till history by category: If your till can break down sales by category (draught, spirits, soft drinks, etc.), export that. This matters because you can reconcile it against your stock count by line. A draught line that sold £800 last week should correspond to a measurable drop in your cellar kegs. If it doesn’t, you have a problem—and you want to find it before the stocktaker does.
Reconciliation is the act of proving that what your till says sold matches what your stock count shows left the cellar. If they don’t match, the gap is your variance—and your job is to explain it with documented wastage, training, or error. If you can’t explain it, the stocktaker will record it as loss.
Most pubs that move from a messy spreadsheet to a disciplined count claw back 1–2 GP points within a couple of months. That’s not because you suddenly stop losing money; it’s because you start finding it on your own terms, not the stocktaker’s.
Clean and Organise Your Cellar
A clean cellar isn’t just good housekeeping—it’s the difference between a 45-minute stocktake and a 3-hour hunt for missing kegs. The stocktaker is working from a printout of what you told the brewery you have. If your cellar is disorganised, they’ll waste time searching, and you risk them miscounting or missing partial stock.
Preparation checklist
- Remove old, redundant, or non-current stock: Any kegs or casks from discontinued brands, old test products, or returns that haven’t been formally logged need to go. The stocktaker will ask what they are, and if you don’t have an answer, it creates variance. If it’s not on the invoice list, it shouldn’t be on the floor.
- Group stock by type and brand: All Carlsberg lagers together, all Guinness together, etc. This speeds up the count and reduces the chance of a miscounted line. The stocktaker will count faster and more accurately if they’re not hunting through a chaotic pile.
- Label partial kegs clearly: If you have a half-empty 50L Stella or a quarter-used cask, mark it visibly with the brand, date opened, and approximate contents (if you’ve measured it). This prevents the stocktaker from guessing, and it helps you track losses on open stock.
- Store spirits and small goods in one consistent location: Don’t have optics in three different cupboards. Keep all open spirits in one area, all sealed stock in another. This makes counting easier and helps you spot discrepancies yourself before the stocktaker arrives.
- Check cellar temperature and line cleanliness: A cellar that’s too warm will give poor pours and excess waste. Dirty lines will have residual beer that affects volume readings. These aren’t just quality issues—they’re cost issues that show up as variance during stocktake. If your cellar temperature is off or your lines are overdue for cleaning, schedule it before the stocktaker comes.
Prepare Your Spirit and Optic Records
Spirits are where most pubs leak money without realising it—and the stocktaker will examine them closely. If your optic records are vague or your open bottles aren’t measured, you’ll have unexplained variance that makes you look careless.
What to do before stocktake
- Weigh every open spirit bottle: Don’t guess. Use scales accurate to 50g. Record the weight. When the stocktaker weighs the same bottle, their weight should match yours (or be within measurement tolerance). If your recorded weight is way off their weight, it flags loss that you didn’t account for.
- Log all optic adjustments and changes: If you’ve changed an optic from 25ml to 35ml because the pump was slow, log the date and reason. If you’ve had to reset an optic, log it. These aren’t admissions of guilt; they’re proof that you’re tracking changes deliberately, not hiding them.
- Record any spirits transferred or decanted: If you’ve moved half a bottle of Jägermeister into an optic or taken a bottle off display, log it. It takes 30 seconds and prevents the stocktaker from flagging it as missing stock.
- Check spirit bottle condition: Any bottles with leaks, damage, or visible evaporation should be noted. Show the stocktaker a damaged bottle so they know to account for it. Don’t let them discover it during the count.
A StockTap pub stock app removes guesswork from spirit tracking. Instead of loose notes or a spreadsheet, you log weights and optic changes once and keep a running record. When the stocktaker weighs your spirits, you have documented baselines to compare against. It’s the difference between saying “I think the Vodka was about full” and showing a dated record that says “Vodka 750ml bottle: 687g recorded 18 June at 14:30.”
Reconcile Your Stock Count System Before the Stocktaker Arrives
The number that actually matters is wet GP by line, not a single headline stock figure. Before the stocktaker arrives, run your own count for at least one week using the same method the stocktaker will use. This gives you a baseline and helps you spot whether your counting method is creating variance.
Run a practice count
- Count draught kegs using a dipstick: Measure every keg or cask the same way every time. If you’re estimating 40%, measure it the same way the stocktaker will. Consistency matters more than precision—if you’re 2% off but consistent, the variance trend will tell you something. If you’re wildly inconsistent, the stocktaker can’t trust any of your numbers.
- Weigh spirits using the same scales: Use the same digital scales every time. Zero them the same way. If you switch scales or methods between your count and the stocktaker’s count, you’ll get false variance.
- Compare your count to your till data from the same period: If your till says you sold £1,200 of draught beer last week, your keg levels should have dropped by a measurable amount. If they haven’t, or if the drop is bigger than expected, you have a problem to investigate before the stocktaker formalises it.
If you find a 3% variance between your count and your till, investigate it now—not on stocktake day. It might be training pours you forgot to log. It might be a line that’s been pouring slow and losing beer to waste. It might be genuine over-pouring or a till error. But if you find it yourself and can explain it, the stocktaker will record it as a known variance, not an unexplained loss.
Common Preparation Mistakes That Cost You
I’ve seen publicans prepare for stocktake in ways that actually made their variance worse—usually because they didn’t understand that stocktake is a reconciliation exercise, not a recount.
Mistake 1: Changing your records to match what you think the count will be
Don’t do this. Don’t look at your cellar, guess the stock level, and then adjust your opening records to match your guess. The stocktaker will have your opening records from last stocktake. If your opening numbers don’t match, they’ll flag it. Prepare your cellar to match your records, not the other way around.
Mistake 2: Not logging staff drinks, training, or waste
Every drink that leaves your premises but doesn’t ring on the till needs to be logged—in writing, with a date. If you pour 10 training pints on stocktake week and don’t log them, your variance will be 10 pints worse. Most publicans lose more to unlogged training and staff drinks than to actual theft. Log them. It takes 30 seconds and protects your numbers.
Mistake 3: Assuming the brewery stocktaker will just do it for you
The stocktaker’s job is to count and reconcile. They’re not your accountant. If your cellar is a mess, your records are vague, or your till data is unreliable, they’ll count what’s there and flag everything that doesn’t match as variance. They won’t investigate. They won’t find your mistakes. They’ll record the gap and hand you the report. You need to do the investigation work yourself.
Mistake 4: Not reconciling till data with stock on the same day
If you count your stock on Tuesday but don’t check your till until Friday, you can’t reliably reconcile them. Sales, voids, and adjustments stack up. By Friday, you’ve forgotten what you sold Tuesday afternoon. Count your stock and reconcile your till on the same day, within a few hours. This is the only way to know whether the gap is real or just timing.
Mistake 5: Using a system you don’t understand or trust
SmartPubTools was built by a working pub landlord specifically because spreadsheets don’t scale—you end up with multiple sheets, formula errors, and no audit trail of changes. If you’re still using a spreadsheet for stock tracking, move to a system designed for pubs. The cost difference will pay for itself in the time you save and the errors you avoid. A stocktaker will take a disciplined digital record far more seriously than a handwritten note or a messy spreadsheet.
Frequently Asked Questions
How long before the stocktaker arrives should I prepare?
Start preparing at least 2–3 weeks before. Use the first week to reconcile your till and stock records. Use the second week to clean and organise your cellar and update your spirit weights. In the final week, run a practice count using your normal method. This gives you time to investigate any variances you find before the official count.
What if my records don’t match my cellar?
Investigate immediately. Check your till data against your stock count. Look for unlogged waste, training pours, or till errors. If you find a discrepancy you can’t explain, adjust your opening records to match what’s actually in the cellar, and log the adjustment with a date and reason. The stocktaker needs to see that you’ve reconciled it deliberately, not hidden it.
Do I need to measure every single bottle of spirits?
Yes—or at least every open bottle. Sealed spirits don’t usually vary. But an open Vodka bottle that’s been sitting behind the bar for a week can lose 20–30ml to evaporation and over-pouring. Weigh it, log it, and show the stocktaker your recorded weight. This prevents them from flagging it as loss.
What if the stocktaker finds a variance I didn’t catch?
Ask them to explain it. A professional stocktaker will walk you through their count method and show you where the gap is. Ask whether it could be measurement error, training pours you forgot, or a till discrepancy. If you can identify the cause, they’ll often adjust the variance accordingly. If you can’t, it gets recorded as loss—which is why preparation matters.
Can I use a spreadsheet for stocktake preparation?
You can, but it’s error-prone. Spreadsheets break formulas, allow accidental overwrites, and don’t provide an audit trail of changes. Most publicans who move from spreadsheets to a proper stock tracking system report fewer counting errors and faster reconciliation. The StockTap pub stock app is built specifically to handle weekly counts, weight tracking, and till reconciliation—it’s designed for the workflow you’re actually using, not generic stock management.
Stocktake preparation is stocktake defence—and defence starts with clean, auditable records.
£97 once. No subscription. No monthly fees. Works on any device.
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 →