Annual pub stocktaking review checklist

Last updated: 26 June 2026

Most pub operators think their annual stocktake is just a compliance box to tick for the brewery — but a 1% loss on wet sales quietly costs a typical pub £3,000–£5,000 a year, and your annual review is where you catch it. You’ve probably heard that your spreadsheet is “fine” and that weekly counts are “overkill,” but the operators clawing back 1–2 GP points within a couple of months are the ones doing both: a disciplined weekly routine and a proper annual audit that actually means something. This guide walks you through exactly what to review, what to measure, and what to fix before next year’s figures look the same as this year’s. You’ll learn the metrics that actually matter (hint: it’s not the headline stock number), the common blind spots that hide thousands in waste, and how to build a review process that sticks.

What Your Annual Review Actually Needs to Measure

The number that actually matters is wet GP by line, not a single headline stock figure. I spent years running stock on a tangle of spreadsheets and still losing track of partial kegs and spirit measures. The moment I started measuring GP per category — spirits, draught, cider, bottled — the picture became clear. One line was leaking, one had wastage creep, and one was just badly priced. A headline “stock variance of 2%” told me nothing. “Spirits at 94% GP instead of 97%” told me everything.

Your annual review needs to answer these specific questions:

• What is the actual wet GP by line (spirits, draught, cider, RTD, etc.)?
• How does each line compare to your target and to last year?
• Which lines got worse, and by how much?
• What is the total cost of that variance (in pounds, not percentages)?
• What changed in the business that explains it (new staff, new pumps, price increase, waste incident)?

If your EPOS doesn’t give you GP by category, you’re flying blind. SmartPubTools includes a cellar management screen that shows you exactly where the leak is — literally and numerically.

You also need to review what you actually measured during the year. If your “weekly counts” were actually monthly guesses, your annual audit won’t mean much because the trend data is rubbish. This is why the annual review is also a process audit: Did you actually do the counts? Were they consistent? Did you record them somewhere you can retrieve? Can you pull the weekly variance figures for the past 52 weeks?

Building the Weekly Foundation (So Annual Makes Sense)

A proper weekly line check catches stock loss before it becomes a year-long problem. Here’s what I learned: spirits hide losses in over-pouring (a free-poured 25ml is often 32–35ml), draught hides it in poor cellar temperature and bad line cleaning waste, and most “theft” is actually measurement error and forgotten wastage.

Your annual review is only valuable if it sits on top of 52 weeks of actual data. Here’s what a proper weekly count looks like:

• Weigh open spirit bottles (use the same scales every week — this is critical for consistency).
• Dip every cask and partial keg using a dipstick marked in litres.
• Record it the same day. Do not guess it the next day.
• Reconcile against till data the same day. If till says you sold 20 pints of Guinness and the keg went down 18 pints, that’s a 2-pint variance — you’ve found it immediately and can investigate the line, the temperature, or whether the till rang through correctly.

When I built a simple count routine around a dipstick and a set of scales, the weekly variance went from guesswork to a number I could trust within a fortnight. Within two months, I could see which weeks had spillage (cellar flood? bad line cleaning?), which had input errors (till rang wrong), and which had actual drift.

The StockTap pub stock app was built by someone who actually does this. It stores the weekly data in a way you can retrieve it, shows you the trend, and flags which lines moved unexpectedly. That makes your annual review meaningful — you’re not looking at a year of mystery; you’re looking at 52 data points.

Running Your Annual Stocktake Audit

Your annual audit should happen after a quiet trading day or a Monday morning. Not Friday at 5pm when you’re knackered and distracted. You need headspace and a day when stock movement is minimal (so you’re not trying to count while deliveries are coming in).

The physical count itself is straightforward but tedious:

• Empty the cellar (use stock for training drinks, staff meals, or a staff party — don’t waste it).
• Count every cask, partial keg, and bottle.
• Use a dip stick for kegs; weigh spirits on calibrated scales.
• Record everything on paper first, then input to your system.
• Do it twice — once by you, once by someone else (or the same person a week later). Discrepancies often mean the first count was wrong.

The key decision: Do you do a full physical count, or just a reconciliation count? A full count takes 4–6 hours depending on size and is the gold standard. A reconciliation count (weigh/dip all open bottles and kegs, count sealed stock by till receipt) takes 2 hours and is accurate if your weekly counts were solid. Most pubs I know do a quick physical of sealed bottles and a full reconciliation of everything open. Do not skip the open bottles — that’s where the loss is.

Once you’ve got the physical count, calculate the variance: Actual stock value minus expected stock value (calculated from last year’s closing stock + purchases – sales, all from till and invoice data).

How to Analyse Variance and Find the Real Losses

Now comes the detective work. A variance of ±2% is normal and acceptable; anything above 3% needs explanation, and anything above 5% means you have a real problem.

Variance above 3% should trigger a line-by-line review, not a blanket “must be theft” conversation. Here’s what I check:

• Spirits: Run the numbers backwards. If you sold £10,000 of spirits at 100% till, you should have 100 bottles gone. Did you actually count 100? Or is the till ringing wrong, or are your measures off?
• Draught: Pull the till reports for any unusually large transactions (void/refund keys pressed a lot?). Check cellar temperature logs — warm cellars waste 10–15% of a keg through line cleaning and purging. Bad line cleaning is the single biggest hidden cost in draught.
• Waste/spillage: Ask your staff if they remember any major incidents (dropped kegs, broken bottles, overfills). Check if anyone recorded waste on the till (most pubs don’t, which means waste is hidden in variance).
• Delivery/invoice errors: Did a supplier deliver short? Did an invoice get entered twice? Check against delivery notes.
• Promotional stock: Did you do a big promotion where you gave away pints or bottles? That’s variance too — you need to account for it in your expected number.

Once you’ve found the reason, document it. “2% variance, mostly draught loss due to hot cellar in August (cooler fitted September 3rd)” is a control you can monitor. “2% variance, probably theft” is a guess and a trap.

Building Your Control Action Plan

Your annual review is useless unless it leads to a control you actually implement. Here’s how to structure this so it sticks:

1. Identify the single biggest loss category. Is it draught line waste, over-pouring in spirits, wastage that’s not being recorded, or measurement error? Pick one. Don’t try to fix everything at once.

2. Quantify the cost. If draught is 4% variance and you pour £15,000 a year of draught, that’s £600 a year just sitting in the drain or the waste pipe. That’s a cellar temperature fix, new pipes, or a line cleaning routine. That’s worth paying for.

3. Assign ownership and a timeframe. “I will check cellar temperature daily starting Monday” or “I will implement a staff training on spirit measures starting next week” beats “we need to be more careful.”

4. Build it into the weekly routine. If your action is “daily cellar temperature check,” add it to your weekly count day. If it’s “record all waste on the till,” train the staff and add it to the till menu. If it’s “weekly line inspection,” give the cellarman 30 minutes every Monday to do it properly.

5. Review it quarterly. Don’t wait until next year. Check in after 13 weeks (one quarter) — did the variance improve? If not, the control didn’t work and you need a different approach.

Five Common Annual Review Mistakes

Mistake 1: Doing the audit without a weekly count system in place. If you only count once a year, you have no trend, no early warning system, and no way to know when the problem started. Your annual figure tells you the total damage, but not how to prevent it next year. Start the weekly routine now, even if you only do it monthly for the first few weeks. Build to weekly.

Mistake 2: Comparing this year to last year without adjusting for price changes. If you raised prices 5% or your supplier raised them 10%, your stock cost went up but your GP might look fine. Use cost price, not selling price, for variance analysis.

Mistake 3: Letting the brewery’s stocktaker do your audit for you. The brewery stocktaker is there to verify you’ve paid for what you received, not to audit your business or catch your losses. They will not tell you where the loss is — they’ll just tell you if you owe money. Do your own audit first, then let them verify.

Mistake 4: Not recording the weekly counts anywhere retrievable. If your counts live in a notebook or a messy spreadsheet that you can’t sort by date or line, you can’t do meaningful analysis. Use a tool that stores the data and lets you pull it by week, by line, and by variance. A spreadsheet works if you’re disciplined; most people aren’t. That’s why StockTap pub stock app exists.

Mistake 5: Blaming staff without looking at systems first. Before you accuse someone of theft, ask whether the till is ringing correctly, whether the scales are calibrated, whether the cellar is the right temperature, and whether waste is being recorded. Most stock loss is system failure, not human dishonesty. Fix the system first; then, if variance stays high, you have a different conversation.