Pub stock take template: the UK operator’s guide
Last updated: 12 April 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 UK pub landlords lose more money to inventory chaos than they realise — not through theft alone, but through the simple inability to see what’s actually in the cellar. A proper pub stock take template isn’t an administrative task you do once a quarter and forget about. It’s the single most effective tool for understanding where your real profit margins sit, spotting wastage patterns, and catching stock shrinkage before it becomes a crisis. You already know your till takings. What you probably don’t know is whether your draught beer margin is being eroded by poor dispense control, overpour, or actual loss. This guide walks you through building and running a stock take that actually works for a wet-led pub, a food-led operation, or anything in between. You’ll learn what data matters, how often you should be counting, and what a realistic stock take looks like when you’re managing staff across kitchen and bar simultaneously.
Key Takeaways
- A stock take template reveals profit leaks that EPOS systems and till data cannot detect.
- Wet stock (draught beer, spirits, wines) requires different counting methods than dry goods and food.
- Running a full stock take monthly is realistic for most UK pubs; weekly spot checks on high-value items cost less time.
- Combining stock take data with your pub profit margin calculator shows exactly where margins are compressed.
Why a proper stock take template matters in your pub
I’ve managed stock control in a busy pub handling wet sales, dry sales, quiz nights, and match day events simultaneously. The difference between a landlord who does a proper quarterly stock take and one who guesses is often £5,000–£15,000 per year on a mid-sized operation. That’s not an exaggeration. It’s the difference between buying rounds for the staff at Christmas and wondering where the margin went.
A stock take template is not about accounting compliance — it’s about operational visibility. Your till tells you what you sold. Your stock count tells you what you actually lost. The gap between the two is where problems hide. That gap might be overpour, theft, breakage, evaporation in the cellar, or customers walking out with glasses. Without counting, you never know. With a good template, you count in 30 minutes instead of three hours.
I’ve also evaluated pub IT solutions that promised to replace manual stock counting. None of them do. Cameras in the cellar? They catch some theft but miss overpour and breakage. Weight sensors on kegs? They work until someone tops up a keg with water. The reality is that a physical count, done properly, is still the gold standard. The template just makes it fast and reliable.
When selecting systems for Teal Farm Pub, Washington, Tyne & Wear, I tested stock management integration with EPOS during a busy Saturday night. The system recorded 47 pints of lager sold between 8 pm and close. The cellar showed two kegs used (roughly 40 pints per keg). That’s a 7-pint discrepancy in three hours. One person overpours slightly, one glass breaks, one customer leaves with a glass, and your margin is gone. That’s why the template matters — because the numbers never lie once you count them.
What your pub stock take template must include
A working template needs five core sections:
1. Header information
Date, venue name, staff member counting, and supervisor checking. This is non-negotiable for auditing. If someone questions the count later, you need to know who did it. Record the time the count started and finished — if it took longer than expected, something went wrong (usually the count wasn’t organised properly).
2. Wet stock section
Draught beer, cider, and lager listed by font name or pump number. For each product, record: keg depth (if using a stick measure), number of full kegs in storage, number of bottles or cans in fridges and behind the bar, and bottles of spirits/liqueurs by count. Use the pub drink pricing calculator to convert stock levels into value so you can track your biggest cost areas.
3. Dry goods section
Crisps, peanuts, bottled mixers, and canned soft drinks counted by line or box. Be specific: 12 boxes of salt and vinegar crisps, not “some crisps.” This matters because shelf-stable goods have the lowest variance but the highest frequency of loss through casual theft or staff consumption.
4. Food and kitchen stock
If you operate food service, you need a separate sub-template for deep freeze, walk-in fridge, and ambient storage. This is where most pub food waste hides. A dedicated FIFO pub kitchen system prevents much of this, but the stock take catches what FIFO misses.
5. Variance calculation
This is where the template becomes powerful. List your opening stock (last count), add purchases from invoices, subtract closing stock (today’s count). The result is “stock used.” Compare stock used against till takings and recipe costs. If your till says you sold 200 pints but stock says 240 pints were used, investigate. If 160 pints were used when 200 were sold, you’ve found a dispense problem or till error.
The variance section must also flag percentage variance. On draught beer, anything over 8% variance in a week is a warning sign. Over 3% per month suggests systematic loss. Get this wrong and you’re flying blind.
Wet stock vs dry stock: the real differences
This is where most pub operators miss the point. Wet stock and dry stock require completely different counting disciplines.
Wet stock counting (draught, bottles, spirits)
You need keg stick measurements because partial kegs are your biggest inventory variable. A 30-litre keg of lager isn’t “half full” or “nearly empty” — it’s 14 litres or 6 litres. That’s the difference between knowing you have £45 in stock or £20. For bottle spirits, count by unit. For wine bottles, count by shelf or position. Be absolutely precise because draught beer is typically 40–45% of your profit on wet sales.
One operator insight I’ve learned from years in the cellar: keg stick measurements are only accurate if the keg is on level ground. Tilted kegs give false readings. Before you start counting draught stock, level every keg. It takes five minutes. It saves you from discovering a phantom 10-litre discrepancy that doesn’t exist.
Dry stock counting (crisps, mixers, bottles)
Count by physical unit. Don’t estimate. One box of crisps is one box. If a box is partially consumed, count the individual packets. This sounds tedious, but it takes 8 minutes and it prevents the casual habit of staff “borrowing” stock without recording it.
Food stock (if applicable)
This is where accuracy costs time. In a gastro-pub, food stock can represent 15–20% of your total inventory value. Frozen goods, fresh goods, and dry goods need separate counts. Most food waste in pubs happens in the walk-in — either because old items are hidden behind new ones or because portion control has drifted. A stock take template forces visibility every single month.
According to UK Food Standards Agency guidance on food safety, regular stock rotation and inventory checks are a core component of HACCP compliance. A template documents this. If an environmental health officer visits and asks “How do you manage stock rotation?” you can show the template. If you say “We just check things as we go,” they’ll write it up.
Running an accurate stock take: the process
The template is useless if the counting process is sloppy. Here’s how to actually run one in a working pub.
Preparation (day before)
Clear the counting area. Move stock so every item is visible and accessible. Check that your keg stick works and that your scales are calibrated (if using them). Print the template and assign roles: one person counts, one person records, one person supervises. In a small pub, two people can manage it. In a larger operation, you need three.
Timing
The best time to stock take is first thing Monday morning, or the quietest trading period in your week. Do not attempt a stock take during service. You’ll miss items, get interrupted, and end up with invalid numbers. It’s better to count on a quiet Tuesday afternoon than a hectic Saturday morning.
Full stock take once a month. Spot checks on high-value items (draught beer, premium spirits) weekly. This is where the template saves time — you don’t recount everything, just the lines with the highest variance or highest value.
Execution
Count from highest value to lowest. Start with draught beer (usually 30–40% of wet stock value), then spirits, then wine, then dry goods. This prevents fatigue-driven errors on the items that matter most. Use tally marks if you’re counting large quantities of one item. Read out the count and have the supervisor verify it. Record immediately. Do not try to record everything from memory at the end.
Verification
Once counted, physically walk through the cellar and fridge a second time as a spot check. You should find 95%+ of the items listed on the template. If items are missing or appear uncounted, recount that section.
Kitchen-led pubs often miss frozen goods because they’re “out of sight.” Allocate 10 minutes just to the deep freeze. It’s the highest-value area most operators ignore.
Common mistakes that invalidate your stock count
These are the errors I’ve seen undermine counts and render the template useless:
Counting during service
Staff are pulling stock as you’re counting it. Items go missing. Numbers become invalid halfway through. One person is always in the bar during trading hours in a real pub. Never count while the bar is open.
Not reconciling against invoices
Your opening stock plus purchases minus closing stock should equal stock used. If it doesn’t match till takings or recipe costing, something is wrong. Without invoices to reference, you can’t diagnose the problem. Keep your supplier invoices filed in order. Match them to the count. It takes 20 minutes and it’s worth thousands.
Estimating partial stock
“That bottle of vodka is about three-quarters full.” No. Measure it or weigh it or don’t count it. Estimation is where 5–8% variance creeps in on spirit stock.
Not flagging new items or discontinuations
If you’ve added a new draught line or removed a slow-moving spirit, the template needs to reflect it. Otherwise you’re comparing apples to oranges month to month, and the variance numbers become meaningless.
Ignoring the cellar temperature or humidity
In summer, draught beer loses volume through evaporation and head generation (more foam, less pint poured). Winter brings the opposite. A proper template includes a note on conditions. If variance spikes in hot weather, it’s expected. If it spikes uniformly across all products, it’s a problem.
One common mistake specific to wet-led pubs: forgetting to count staff stock. Many pubs keep a small “staff practice” area or training setup for new hires learning to pour. That stock isn’t being sold. It needs its own line on the template or it distorts your numbers.
Using your stock take data to drive decisions
The template only works if you actually use the data. Here’s how to translate counts into action:
Spot variance trends
If draught lager variance is consistently 6% but cider is 12%, something is different about cider. Is overpour higher? Is there a leaky tap? Is one staff member’s pour technique different? Use the data to investigate, not to blame.
Identify slow-moving stock
If you counted five bottles of a premium gin last month and four this month, it sold one bottle in four weeks. That’s a slow mover. Either promote it, remove it, or lower the price. The template shows you which products are dead weight.
Track seasonal patterns
Run stock takes the same week each month so you can compare seasons. Summer variance might be 4%, winter might be 6% due to different service patterns. Once you know the pattern, you can forecast purchasing and avoid overstocking.
Link to staff scheduling
If variance spikes on days when a particular staff member works, you’ve found a training opportunity or a performance issue. Use the pub staffing cost calculator to factor in the cost of overpour or waste by team member. It sounds harsh, but it’s data-driven feedback.
At Teal Farm Pub, we found that Saturday night variance on draught was always 1–2 percentage points higher than Tuesday afternoons. The difference was volume and speed — Saturday night staff pour faster and occasionally overfill. Teaching better technique or slowing down service during peak times would cost us sales. Instead, we accepted the variance as the cost of meeting Saturday demand and budgeted for it. The template made that decision conscious rather than accidental.
Calculate true profit margins
A stock take template reveals your actual gross profit margin on each product line. Your till says you sold 200 pints of lager. Your stock count says you used 215 pints. That’s a 7% variance, worth approximately £15 per week on a mid-sized account. Annually, it’s £780 in ghost cost. Use that number to justify investing in dispense staff training or upgrading your bar setup. Use the pub management software dashboard to track these costs over time.
Many operators who’ve implemented a proper stock take template report that the single biggest insight isn’t theft — it’s waste. Broken glasses, overpour during training, expired stock, and spillage typically account for 60–70% of variance. Theft is only 20–30%. Once you see that split, you can act accordingly. You don’t need CCTV, you need better staff training and cellar organisation.
Frequently Asked Questions
How often should I run a full pub stock take?
Monthly is the standard for UK pubs. It’s frequent enough to catch problems before they compound, but infrequent enough to be manageable with one person taking 1.5–2 hours. Weekly spot checks on draught beer and high-value spirits take 20–30 minutes and catch shrinkage faster. Quarterly full counts are too infrequent — variances get buried in seasonal noise.
What should I do if variance is consistently above 5% per month?
Investigate the root cause. Check that your till is ringing every sale (some staff skip it). Review dispense technique with staff — overpour is the most common cause in wet-led pubs. Verify that invoices match deliveries (suppliers sometimes misdeliver or overbill). If variance is on a specific product, test the tap or measure dispense into a glass. Five percent monthly is not normal and costs you real money.
Can I use a spreadsheet template or do I need pub management software?
A paper template and pencil works. A spreadsheet template is better because it calculates variance automatically. Pub management software with integrated stock tracking is best because it connects stock data to till data and shows discrepancies in real time. For most operators, a spreadsheet is the sweet spot between effort and insight.
Should I include staff drinks or freebies in the stock take?
Yes. Record them separately on the template as “staff consumption” or “wastage” so you can see the true cost. Many pubs spend £200–£400 per month on unmeasured staff drinks. Once you see it itemised, you can implement a staff drinks policy. The template creates visibility so you can make conscious decisions rather than bleeding money unnoticed.
What if I operate a food-led pub as well as wet sales — how do I handle food stock?
Use a sub-template for food stock with separate sections for frozen, chilled, and dry goods. Count food stock the same day as wet stock so the numbers align. Track food variance separately — it’s typically higher than wet (5–8%) due to prep waste and short shelf life. Over time, improve FIFO rotation and portion control to reduce food variance. For detailed guidance on reducing food waste through better systems, review our pub food events guide which covers stock management during high-volume trading.
A stock take template only works if you’re tracking what actually drives your profit — and that means connecting inventory data to your pricing, margins, and staffing costs.
Take the next step today.
For more information, visit pub profit margin calculator.
For more information, visit pub staffing cost calculator.