What is a stocktake? It's a count of every bottle, keg, can and case you hold on a given day, valued at what you paid for it. In a pub the count is then set against your opening stock, your deliveries and your till sales, and that one sum tells you what your drink really cost, your real GP, and whether anything went missing in between.
That's it. The count is the bit everyone pictures, someone in the cellar with a clipboard, but the count on its own is just a list. The stocktake is what you do with the list.
Most explanations online are written for warehouses and online shops, which is why they talk about SKUs and fulfilment. A pub is different. Half your stock is liquid in part-used bottles and kegs you can't see into, your sales go through a till in measures, and some of it is legitimately lost to line cleaning and head on a pint. So here's what a stocktake means behind a bar.
The one sum a stocktake boils down to
Every stocktake report, however many pages it runs to, is this:
Opening stock + deliveries − closing stock = what the stock you used cost you.
Your opening stock is last time's closing count. Your deliveries come off the invoices. Your closing stock is today's count. Whatever's not there any more was either sold, poured away, given away, or went somewhere it shouldn't have.
Then two comparisons:
- Against your sales, that cost gives you your real gross profit. Not the GP your price list promises. The one you achieved.
- Against what the till took, it gives you the variance. Every line you used should have been sold at your selling price. Add that up, compare it with the till, and the gap is the surplus or deficit at the bottom of the report.
A worked example, one month in a small wet-led pub
| Line | Amount |
|---|---|
| Opening stock at cost (last month's closing count) | £6,000 |
| Plus deliveries at cost (from the invoices) | £3,200 |
| Minus closing stock at cost (today's count) | £5,800 |
| Cost of the stock used | £3,400 |
| Till sales for the month | £10,400 |
| Achieved GP: (£10,400 − £3,400) ÷ £10,400 | 67.3% |
| What the stock used should have taken at your selling prices | £10,452 |
| Variance: £10,400 − £10,452 | −£52, about −0.5% |
That −£52 is the number people get nervous about. On that month it's inside what most pub companies treat as normal, which is roughly plus or minus half a per cent of sales. It's still worth looking at which lines it came from, because a flat total can hide a spirits problem behind a draught surplus. My guide to what counts as an acceptable variance goes through why, with five real audit results.
Notice the stocktake needs three things before anyone counts a bottle: last time's closing figure, every invoice for the period, and the till sales by product. If any of those is missing, the count can be perfect and the result still be wrong. A lot of "bad stocktakes" turn out to be a missing invoice or a delivery that landed after the count, not a missing bottle. Delivery timing catches a lot of people.
What a pub stocktake actually counts
| Stock | How it's counted | Where it goes wrong |
|---|---|---|
| Packaged: bottles, cans, sealed spirits, wine | Counted as units or cases | Stock in three places, cases counted twice |
| Open spirits and wine | Weighed on a scale, or estimated in tenths by eye | Tenths by eye are nearly always generous |
| Draught kegs | Weighed, or worked out from a calibrated meter or dip | Wrong keg size set up, so every reading is off |
| Cask ale | Dipped with a calibrated dipstick | Wrong cask size or a stick for a different cask |
| Food (dry stock) | A separate count, often by weight | Prep and waste nobody wrote down |
Wet and dry stock are usually separate stocktakes, priced separately by stocktakers. Wet stock vs dry stock explains the split, and the kitchen side is in how to do a food stocktake. If part bottles are what slows you down, how to weigh spirits for a stocktake has the grams for the common bottles.
Five things people mean by "a stocktake"
| Kind of count | Who does it | What it's for | How often |
|---|---|---|---|
| Full stocktake | You, or an independent stocktaker | GP and variance for the period | Monthly to quarterly |
| Spot check | You or a manager | Catching a problem on your top lines early | Weekly, 15 to 20 minutes |
| Stock audit | A stocktaker working for the pub company or brewery | Checking a tenant's stock against deliveries, sometimes leading to a chargeback | Set by the agreement |
| Stock valuation | A stocktaker, usually for both sides | Putting a price on the stock when a pub changes hands | On the day of handover |
| Year-end stock count | You or your accountant | The closing stock figure for your accounts | Once a year, at your year end |
The audit is the one that bites, because someone else holds the numbers. Stock audit vs stocktake and what to expect from a pubco stock audit cover it. The valuation is in taking over a pub, and the year-end count in stock valuation for year-end accounts.
What a stocktake costs
An independent stocktaker charges by the visit. Published rates run from about £125 a visit on a monthly contract at InnStock to £190 for a half day and £320 plus VAT for a full day at Roslyns. Food is usually extra. Over a year of monthly wet stocktakes that's roughly £1,500 to £3,840, and my stocktaker cost guide has the full rate cards.
Doing it yourself costs time instead. A full count on a typical pub takes 75 to 90 minutes once your products and prices are set up, and the first ever count takes far longer because you're building the list. How long does a stocktake take breaks those minutes down line by line.
The test I'd use: can you say what you're short of?
Here's the thing a stocktake should give you that a till report never will. At the end of it you should be able to name the line. Not "we're 1% down", but "we're short about six singles of the house vodka and a couple of pints of the guest ale". If your stocktake can't get you to that, it isn't finished. A percentage is something to worry about. A line is something you can do something about: a till button, a line clean that wasn't logged, a measure, a delivery that never came.
That's also why counting more often beats counting harder. A shortage you find in week two is a habit you can fix. The same shortage found three months later is just a bill. How often should you do a stocktake has the rhythm I'd use.
If you want to try one yourself this week, my free stock take template has the sum built in, and how to do a stocktake walks through the count from cellar to fridges.
Common questions
What is a stocktake?
A stocktake is a count of all the stock a business holds on a given day, valued at cost. In a pub it's then set against the opening stock, the deliveries and the till sales for the period, which shows what the stock used cost you, your real gross profit and any variance between what should be there and what is.
What is the stocktake formula?
Opening stock plus deliveries minus closing stock equals the cost of the stock you used. Compare that with your sales and you get your gross profit. Compare what you should have taken for the stock used with what the till actually took and you get the variance, the surplus or deficit on the stocktake report.
What is the difference between a stocktake and a stock audit?
In a pub the two words often mean the same visit. Where they differ, a stocktake is your own count for your own figures, and an audit is a count done for someone else, usually a pub company or brewery checking a tenant's stock against what it delivered. My stock audit vs stocktake guide covers the difference in detail.
How often should a pub do a stocktake?
Most pubs do a full stocktake monthly or every four to six weeks, with a short spot check on the top-selling lines in between. Quarterly is the minimum many stocktakers recommend, but by then a problem has had three months to grow.
How much does a stocktake cost?
Published rates from independent stocktakers run from about £125 a visit on a monthly contract to £320 plus VAT for a full day. Doing it yourself costs your time, usually 75 to 90 minutes for a full count once your product list is set up.
Sources
- Published stocktaker rates (InnStock from £125 a visit monthly, Roslyns £190 half day and £320 plus VAT full day) and the £1,500 to £3,840 annual range: my pub stocktaker cost guide, which links each firm's published prices.
- Variance within roughly ±0.5% of sales treated as normal by most pub companies, and the BBPA 95% liquid head-of-beer guidance: my acceptable variance guide, citing BBPA guidance on head of beer via Cask Marque.
- Full count timings of 75 to 90 minutes and weekly spot checks of 15 to 20 minutes: my stocktake timings guide.
- The worked month is an illustration with round numbers, not a real pub's figures. The formula is the standard opening-plus-purchases-minus-closing cost of sales calculation; the "name the line" test is my own method.