Complete Pub Stock Take Templates That Actually Save Time in 2026

Last updated: 6 April 2026

Most pub landlords spend 4-6 hours every week doing stock takes with spreadsheets that miss thousands in shrinkage. I used to be one of them until I realised the templates everyone downloads online are designed by people who’ve never run a pub. After 15 years at The Teal Farm, I’ve built stock take systems that cut inventory time by 70% while catching every missing pint and bottle. This guide gives you the exact templates and processes that transformed our inventory control from a weekly nightmare into a 90-minute routine. You’ll get proven templates that actually work in real pubs, plus the systems that ensure your stock figures are accurate every single time.

What Makes a Pub Stock Take Template Actually Work

The most effective way to design a pub stock take template is to separate products by margin impact, not alphabetical order. Most templates I see online list everything from A-Z, which means you’re treating £2 cleaning products the same as £40 whisky bottles.

At The Teal Farm, we learned this the hard way. Our first stock take template was a beautiful Excel sheet that took 4 hours to complete and still missed £300 worth of spirits every month. The problem wasn’t the template design—it was that we weren’t prioritising the products that actually matter to cash flow.

Here’s what separates working templates from time-wasting ones:

• Category separation: Spirits, wines, beers, and soft drinks tracked on different sheets
• Margin weighting: High-value items listed first within each category
• Variance tracking: Expected vs actual quantities with automatic percentage calculations
• Supplier integration: Product codes that match your actual invoices
• Date stamping: Clear recording of when each section was counted

The Pub Command Centre handles all of this automatically, but if you’re using manual templates, these elements aren’t optional—they’re essential for catching shrinkage before it kills your margins.

According to HMRC alcohol duty guidelines, accurate stock records are required for duty calculations, making proper templates a legal necessity, not just good practice.

The Problem With Generic Stock Take Templates

Every “free pub stock take template” I’ve downloaded suffers from the same fatal flaw: they’re built by people who’ve never stood behind a bar at 11 PM trying to count bottles while customers are still ordering.

Generic stock take templates fail because they assume you have unlimited time and perfect conditions. The reality is you’re counting stock when you’re tired, rushed, and dealing with partial bottles, opened casks, and products stored in three different locations.

Here’s what doesn’t work in real pubs:

• Single massive spreadsheet: Scrolling through 300 products on a tablet while standing in a cellar
• No mobile optimisation: Templates that require a laptop when you need to work on your phone
• Missing fields: No space for partial quantities, damaged stock, or location notes
• Poor calculations: Formulas that break when you enter decimals or make corrections
• No integration: Data that sits isolated instead of connecting to sales and ordering systems

At The Teal Farm, we wasted 18 months trying to make downloaded templates work. The breakthrough came when we stopped trying to adapt generic solutions and built something specific to pub operations.

The biggest mistake is treating stock takes as isolated events. Your template needs to connect to everything else: staff cost tracking, supplier orders, and sales analysis. Without integration, you’re just creating more admin work.

Most pub owners find £1,000s in hidden savings in their first week of proper stock control, but only if the system actually gets used consistently.

How Pub Command Centre Eliminates Manual Stock Takes

After years of fighting with spreadsheets, I built the system I wished existed. Pub Command Centre works by connecting your stock levels directly to your sales data, so you know exactly what should be on the shelves before you start counting.

The difference isn’t just convenience—it’s accuracy. When you know you sold 12 bottles of house wine yesterday and had 18 on the shelf, you should have 6 remaining. If you count 4, you know exactly where to investigate.

Here’s how it transforms stock control:

Real-Time Stock Tracking

Instead of weekly stock takes, you get continuous monitoring. Every sale automatically adjusts stock levels, so your monthly count is just verification, not discovery. This alone has saved us 12 hours monthly in admin time.

Variance Alert System

The system flags discrepancies immediately. When our premium gin showed -15% variance in week 3, we caught a staff member giving away doubles for single prices. That detection saved us £400 that month.

Mobile-Optimised Interface

Count stock on your phone with pre-loaded expected quantities. No more printing sheets or carrying laptops into the cellar. The interface adapts to small screens without losing functionality.

Automatic Ordering

When stock hits reorder points, the system generates supplier orders automatically. No more running out of house wine on Friday night because you forgot to check levels.

The integrated approach means your stock data connects to everything else: labor costs, profit margins, and cash flow forecasting. Instead of isolated spreadsheets, you get a complete picture of how inventory affects your bottom line.

Free Stock Take Templates That Actually Work

If you’re not ready for automated systems, here are the exact templates we used at The Teal Farm before building Pub Command Centre. These aren’t perfect, but they’re designed by someone who’s actually used them in a working pub.

Spirits Stock Take Template

Focus on high-value products first because spirits represent 60% of your stock value in 20% of your products.

Essential columns:

• Product name and supplier code
• Location (back bar, cellar, storage)
• Opening stock from last count
• Deliveries since last count
• Expected remaining (opening + deliveries – sales)
• Actual count
• Variance (actual vs expected)
• Value of variance

Beer and Wine Template

Separate sheets for draught beer (counted in gallons) and bottled products. Include sections for damaged stock and promotional products that might be stored differently.

Soft Drinks and Sundries

Lower-value items that still need tracking but don’t require the same detail as spirits. Focus on fast-moving products and anything with expiration dates.

The key insight from our experience: better to count 50 important products accurately than 300 products roughly. Start with your highest-margin items and expand the template as your processes improve.

Margin optimization starts with knowing what you actually have on the shelves, not what you think you have.

Step-by-Step Implementation Guide

Stock take accuracy improves by 85% when you follow a consistent process every time. Here’s the exact routine we use at The Teal Farm:

Pre-Count Preparation (15 minutes)

1. Download sales data from your till system for the period since last count
2. Check delivery records and update opening stock figures
3. Calculate expected quantities for each product
4. Charge your mobile device and test the template loads correctly
5. Gather counting tools: torch, notepad for damages, pen

Counting Process (60-90 minutes)

1. Start with spirits: Count all premium products first when you’re fresh and focused
2. Work systematically: Left to right, top to bottom, same route every time
3. Record everything: Partial bottles, damaged stock, promotional products in wrong locations
4. Check calculations: Verify variance percentages make sense before moving categories
5. Flag anomalies: Note anything unusual for investigation later

Post-Count Analysis (30 minutes)

1. Calculate total variance value across all categories
2. Investigate any variance over 5% or £50 in value
3. Update reorder lists based on current levels
4. Note process improvements for next count
5. Back up data and file completed template

The financial dashboard approach means treating stock control as business intelligence, not just compliance. Your stock data should inform buying decisions, pricing strategies, and staff training priorities.

Advanced Stock Control Techniques

Once basic templates are working, these techniques separate professional operations from amateur hour:

Perpetual Inventory Method

The most effective way to eliminate stock surprises is to count different categories on different days throughout the month. Instead of one massive monthly stock take, count spirits weekly, wines bi-weekly, and beers monthly.

This approach spreads the workload and catches problems faster. When we implemented perpetual counting at The Teal Farm, we identified a delivery shortage within 3 days instead of discovering it weeks later.

ABC Analysis

Categorise products by importance: A-items (high value, tight control), B-items (moderate value, weekly checks), C-items (low value, monthly counts). This focuses attention where it matters most.

Cycle Counting

Random spot checks between formal counts. Pick 10 random products each day and verify quantities against system records. This ongoing verification prevents drift and keeps staff aware that accuracy matters.

According to Federation of Small Businesses research, inventory control is the second-biggest operational challenge for hospitality businesses after staff management.

Technology Integration

Even with manual templates, you can improve accuracy with simple technology. Use your phone camera to photograph product arrangements before counting, barcode scanners for faster data entry, and cloud storage so multiple people can access current templates.

The SmartPubTools approach connects everything together, but these techniques work with any system.

For more information, visit RankFlow free trial.

For more information, visit RankFlow marketing tools.