Bar shrinkage calculator: what it is and why it matters


Bar shrinkage calculator: what it is and why it matters

Written by Shaun McManus
Working pub licensee, 15+ years running a Marston’s pub

Last updated: 26 June 2026

Most pub landlords don’t realise that a silent 1% loss on wet sales quietly costs a typical pub £3,000–£5,000 a year. You’re doing the same work, pulling the same pints, and losing thousands to waste, over-pouring, and measurement error—without ever seeing it on your P&L until the stock report arrives from the brewer. A bar shrinkage calculator isn’t a fancy piece of kit; it’s a system that turns vague guesswork into a number you can act on. In this guide, I’ll show you what shrinkage actually is, how to measure it properly, and exactly how to claw back those lost pounds in a matter of weeks.

Key Takeaways

  • A bar shrinkage calculator is a system for measuring the difference between what you should have sold and what you actually have in stock.
  • Most stock loss is not theft—it is measurement error, over-pouring, poor cellar temperature, and forgotten wastage.
  • A 1% stock loss costs a typical pub £3,000–£5,000 annually, but a proper weekly line check catches it and recovers 1–2 GP points within weeks.
  • You need a dipstick for casks, scales for spirits, and a till reconciliation done the same day—not a spreadsheet formula.

What is bar shrinkage and why does it happen?

Bar shrinkage is the gap between the stock you should have based on till sales and the stock you actually have when you count. If your till says you sold 50 pints of bitter and the cask shows you’ve lost 55 pints, you’ve got 5 pints of shrinkage to account for. That’s either waste, over-pouring, theft, or measurement error—but it’s definitely costing you margin.

The reason shrinkage happens in pubs is different from other businesses. You’re not running a factory with precise input and output. You’re running something more like a daily game of dominoes: a cask comes in, you estimate its contents by eye or weight, you pour for a fortnight, the temperature in your cellar drifts, someone forgets to log a spillage, a visiting customer’s round gets over-poured, a line gets left unpurged, and suddenly your stock count doesn’t match your till. None of that is necessarily dishonest. But it’s all real money.

The number that actually matters is wet GP by line, not a single headline stock figure. Spirits hide losses in over-pouring (a free-poured 25ml is often 32–35ml in practice), draught hides it in poor cellar temperature and bad line cleaning waste, and most stock ‘theft’ is actually measurement error and forgotten wastage. Until you see the loss by category—spirits versus draught, kegs versus bottles—you’re flying blind.

How to calculate bar shrinkage

A bar shrinkage calculator works on one simple formula: Opening Stock + Purchases − Closing Stock = Usage. Then you compare Usage to what your till says you sold. The gap is shrinkage.

In practice:

  • Count your opening stock on Monday morning (or whatever your stocktake day is). Weigh open spirit bottles, dip every cask and partial keg, note every bottle count by line.
  • Log all purchases that week—kegs delivered, bottles bought, spirit cases opened.
  • Count your closing stock at the same time the following week. Same method: scales, dipstick, line-by-line.
  • Pull your till sales for that week, filtered by category (draught, spirits, bottled, cider).
  • Do the maths: (Opening + Purchases) − Closing = What You Should Have Used. Then compare to what till says you sold.

If your till says you sold £800 in draught but your stock count shows you’ve used 95 pints when 90 pints would be right, you’ve got 5 pints of shrinkage—roughly £15–£20 depending on your average selling price. That’s a weekly find. Do that every week for a year and you’ve recovered hundreds in margin.

The critical move is reconciling till data to stock the same day you count. Don’t wait until Thursday to see what happened on Monday. The longer the gap, the harder it is to remember where a loss came from or whether it was genuine.

Where the real losses hide

In my 15 years running a Marston’s pub, I’ve found the same three places where stock quietly disappears, and none of them are obvious from a spreadsheet.

Spirits and over-pouring

A standard measure is 25ml or 35ml depending on your pour policy. But a free-poured measure—especially when it’s busy, or when a newer team member is pouring—tends to land at 32–35ml. Multiply that by 50 spirits a day, six days a week, and you’re giving away 15–20 measures a week nobody paid for. That’s a margin loss of £30–£50 per week, or £1,500–£2,500 per year, just from drift in pouring accuracy.

The fix: weigh open spirit bottles every Monday morning. If a bottle of vodka should weigh 700g and it weighs 650g, you know exactly how many measures you’ve given away. No guessing.

Draught and cellar conditions

A cask that sits at 16°C will pour differently—and waste differently—than one at 12°C. Bad line cleaning leaves sediment and foam waste. A leaky coupler drips a pint or two over a week without anyone noticing. A line left unpurged overnight loses carbonation and has to be dumped.

These aren’t disasters. They’re the normal cost of running a cellar. But if you don’t measure them, they add up to 2–3% shrinkage on your draught portfolio, which on a typical 40-cask rotation is worth £2,000–£3,000 a year.

The fix: dip every cask at the same time every week. Log the temperature. Check couplers and lines for weeping. Purge lines properly. You can’t eliminate cellar waste, but you can measure it and reduce it.

Forgotten wastage

A bottle of wine breaks. Someone spills a pint. A guest sends a pint back and you pour it away. A sample is given to a visiting brewer rep. These are real costs, but because they happen ad hoc, they almost never get logged. Six months later you’re left with a 2% variance you can’t explain.

The fix: keep a small notebook or phone note of every wastage event. Date, line, quantity, reason. At your weekly count, reconcile these notes against your shrinkage figure. You’ll be surprised how much of that gap disappears when you’ve actually recorded what happened.

Why a weekly line check is the only thing that works

I was running stock on a tangle of spreadsheets and still losing track of partial kegs and spirit measures. I didn’t know whether my losses were in spirits, draught, or bottled stock. I couldn’t see whether the problem was this week or had been building for months. I built a simple count routine around a dipstick and a set of scales, and the weekly variance went from guesswork to a number I could trust within a fortnight.

A weekly line check is the difference between knowing your position and guessing. Monthly stocktakes miss the detail. Quarterly stocktakes are useless—by the time you see the loss, you can’t remember where it came from. But a weekly count of 15–20 minutes gives you real-time control and tells you instantly if something has gone wrong on a particular line or in a particular category.

Most pubs that move from a messy spreadsheet to a disciplined weekly count claw back 1–2 gross profit (GP) points within a couple of months. That’s not new sales. That’s just recovering margin you were already making but bleeding away through invisible waste and measurement error.

The discipline is the valuable bit, not the calculator itself. Once you know you’re going to count every Monday, your team starts being more careful about wastage. You start noticing which line has drifted. You start spotting patterns—like spirit shrinkage going up during a particular shift or draught shrinkage climbing in summer when temperature rises.

What tools you actually need

You don’t need software. You don’t need a subscription. You need:

  • A dipstick (£3–£5 from any brewery) to measure cask depth and convert to pints remaining.
  • A set of scales (digital kitchen scales, £10–£20) to weigh open spirit bottles.
  • A notebook or simple sheet to log counts and notes. Spreadsheet is fine; a printed template is better.
  • Till data extracted the same day as your count, broken down by category.
  • A simple reconciliation rule: Opening + Purchases − Closing = Usage. Compare to till. Note the gap.

That’s it. You don’t need a calculator that does fancy forecasting. You don’t need AI. You don’t need cloud sync. You need accuracy and consistency, which come from doing the same routine every week at the same time, the same way.

If you want to move beyond a spreadsheet and bring your data together in one place, StockTap pub stock app is built around this exact method—dip, weigh, till reconcile, spot the gap. It’s not a replace-your-brain tool. It’s a way of logging what you’ve already counted so you can see patterns and trends without re-entering numbers into five different places.

Your action plan: from spreadsheet to control

Week 1: Establish your baseline

Do a full physical count of everything—every cask, every spirit bottle, every case of bottles. Get your opening position right. Extract your till sales for the past month and work backwards to see what your shrinkage has actually been. Most licensees are shocked by the number when they first see it properly calculated.

Week 2: Do your first proper weekly count

Same time, same place, same method. Dip every cask, weigh every open spirit, count cases. Pull till data immediately. Do the maths. Log any wastage that happened that week. You’ll probably see a variance—don’t panic. You’re just establishing what normal looks like.

Week 3–4: Look for patterns

By week three or four, you’ll start seeing which lines are tight and which are drifting. You might notice spirits going missing but draught holding steady—that tells you to focus on pouring accuracy and bottle weights. Or draught shrinking but spirits fine—that’s a cellar temperature or line cleaning issue. You can’t see these patterns in a monthly stocktake.

Month 2 onwards: Tighten control

Once you know where your losses are, you can act on them. Talk to your team about the lines that are drifting. Check that cellar thermometer. Weigh that bottle of rum again. Most of the time, you’ll find the loss disappears as soon as you shine a light on it.

Frequently Asked Questions

I don’t have time for a weekly stocktake. How long does a bar shrinkage calculator actually take?

A proper line check takes 15–20 minutes if you’re disciplined. You’re not re-counting every bottle; you’re dipping casks, weighing open spirits, and noting till sales for one week. Less time than you spend chasing invoices. If you can’t find 20 minutes a week, you can’t afford to lose £3,000–£5,000 a year either.

Can I use my existing spreadsheet as a bar shrinkage calculator?

Yes, but most licensees find that spreadsheets are slow, error-prone, and scattered across multiple files. Your till data lives in one place, your cask counts in another, your spirit weights in a third. By the time you reconcile them, you’ve forgotten what happened on Tuesday. A structured routine—even on paper—beats a spreadsheet because it forces you to do the same thing the same way every week.

Is my brewery stocktaker not doing this for me already?

No. Your brewery stocktaker comes in, does a full physical count once a quarter or half-year, and reconciles it against their own records—not yours. They’re checking whether they made money on the kegs they supplied you. They’re not telling you where your losses are or helping you control them week to week. That’s your job. Weekly line checks give you the visibility your brewer never will.

What’s the difference between a bar shrinkage calculator and actual stocktake software?

A calculator or simple tracking system tells you what your shrinkage is each week. Software like SmartPubTools adds context—it shows you trends over time, flags lines that are drifting, stores your data so you can look back, and makes sure you’re not forgetting any category. Software saves you from re-entering the same numbers into five different places. But the maths is the same: Opening + Purchases − Closing = Usage, then compare to till.

Should I be worried if my shrinkage is 2% or higher?

Yes. Anything over 1% is costing you serious money. 2% shrinkage on a typical £30,000 annual draught portfolio is £600 gone. On spirits, it’s often worse because a few percentage points in over-pouring adds up fast. The moment you see a line consistently above 1.5% shrinkage, you’ve found your problem area. Tighten that line—better scales, better training, better cellar temperature—and you’ll recover the money within weeks.

A spreadsheet won’t show you where your losses are hiding or help you recover them fast enough.

£97 once. No subscription. No monthly fees. Works on any device.

StockTap is built for weekly line checks. Log your dip, weights, and till data in one place. Spot shrinkage trends instantly. Recover 1–2 GP points in weeks, not months.




Leave a Reply

Your email address will not be published. Required fields are marked *