Pub Stock Take: Template, Method and How to Stop Losses
By mise · Updated 7 October 2026
Quick answer: a pub stock take counts every line in the cellar and behind the bar (kegs by weight, bottles in tenths), then compares usage with sales to give a yield or stock result. Most pubs aim for a result within ±1–2%.
In a pub, a few pints poured short or given away every night add up to thousands a year. The stock take is how you see it — with the free pub stock take template, or by scanning, without waiting for pub stocktakers near you to have a slot.
How to do it
- Count the cellar: full kegs, part kegs (by weight), cases.
- Count the bar: bottles in tenths, fridges, mixers.
- Record deliveries and transfers since the last stock take.
- Compare usage with till sales: the gap is your loss.
Pub stock take sheet (what to record per line)
| Line | Opening stock | Deliveries | Closing stock | Usage | Sold (till) | Difference |
|---|---|---|---|---|---|---|
| Lager, 50 L keg (pints) | 132 | 264 | 110 | 286 | 279 | −7 pints |
| Gin 70 cl (25 ml measures) | 84 | 112 | 70 | 126 | 120 | −6 measures |
| House red 75 cl (175 ml glasses) | 34 | 43 | 30 | 47 | 45 | −2 glasses |
| Bottled lager 330 ml | 96 | 144 | 88 | 152 | 152 | 0 |
Usage = opening + deliveries − closing. Work in serves (pints, measures, glasses) on the drinks side, so usage and till sales use the same unit. A 70 cl bottle holds 28 measures of 25 ml; a 75 cl bottle about 4.3 glasses of 175 ml; a 50 litre keg about 88 pints.
Step by step on stock take day
- Before opening and before any delivery: count the cellar (full kegs, part kegs by weight, cases).
- Count the bar: bottles and tenths of open ones, fridges, mixers.
- Collect delivery notes, credits and transfers since the last stock take; record ullage from line cleaning.
- Pull till sales per line for exactly the same period.
- Work out the difference per line, at cost and at selling price, and start with the largest in pounds.
Detailed method and a calculator: wet stock reconciliation. Printable sheet and Excel: stock take template. Want to do it for other pubs? See starting a stocktaking business.
After the stock take
Note the lines with the biggest deficit in pounds, check them first next week, and keep the paperwork with the figures in case the stocktaker or area manager asks.
Scan the barcode or snap a photo: mise's AI finds the product and categorises it. Free trial.
Start freeFrequently asked questions
How often should a pub do a stock take?
Weekly or fortnightly for wet stock; many use an independent stocktaker monthly.
What is a good stock result?
Within ±1–2% of sales.
Do I still need a stocktaker?
An app speeds up the count; an independent stocktaker still adds a second pair of eyes.
Should I value the stock result at cost or retail?
Both are useful. At cost it shows the stock you paid for; at selling price it shows the takings you missed. Stocktakers commonly report the result at retail.
What counts as ullage?
Drink lost in normal operation: beer pulled through during line cleaning, fobbing at keg changes and drinks returned by customers. Record it so it is not mixed with unexplained losses.
Can I try mise for free?
Yes. You get a free trial, with no card needed.
