Bar Stocktaking: A Complete Guide for Irish Pubs and Hotels

Summary:

Regular bar stocktaking helps Irish pubs and hotels protect profit margins by comparing physical inventory with EPOS sales, supplier invoices, and recorded wastage to identify stock variances, over-pouring, theft, and other losses. Accurate stock control involves counting spirits, draught kegs, bottled products, auditing deliveries, reviewing sales reports, and calculating actual versus potential gross profit to uncover shrinkage and operational inefficiencies. Combining physical stocktakes with EPOS data, proper measuring equipment, and independent auditing can give hospitality businesses clearer financial visibility and help them improve stock management and profitability.

 

In the Irish hospitality industry, running a pub or hotel bar without regular stocktaking is like driving blindfolded with your fuel tank leaking. Between rising keg costs, excise duties, and tighter consumer spending, every fraction of a percentage point in gross profit matters.

Most publicans and hotel food & beverage managers know their top-line revenue, but surprisingly few know their true stock variance. If your draught beer lines waste 5 pints per clean, your bartenders pour 40ml instead of the statutory 35.5ml spirit measure, or supplier price increases slip through unnoticed, thousands of Euros in profit vanish before hitting your bank account.

Why does an EPOS report showing €35,000 in weekly sales still leave you with lower-than-expected GP margins at month-end? The answer lies in the gap between Potential GP and Actual GP.

This comprehensive guide explains the exact end-to-end process of bar stocktaking for Irish pubs and hotels. You will learn how to measure open spirits and draught kegs correctly, calculate variance and identify shrinkage, audit supplier invoices and put systems in place to protect your profits.

What Is Bar Stocktaking and Why Does It Matter for Irish Hospitality?

In simple terms, wet stocktaking compares the physical inventory sitting in your cellar against your delivery invoices and EPOS sales. The Irish licensed trade is getting squeezed tightly right now by rising supplier costs and energy bills. The main goal here is to protect your 65% to 75% target Gross Profit (GP) margin. If you want true financial transparency, bringing in hospitality stocktaking services in Ireland is often the smartest move to get an unbiased view of your operation.

 

Defining Wet Stocktaking vs. Dry Stock Control

Wet stocktaking focuses entirely on your liquids, kegs, spirits, bottled beers, and post-mix syrups. This is notoriously harder to track than dry stock (like crisps or toilet rolls) because liquids are poured, spilled, and subject to line waste. Dry stock control is straightforward counting, wet stock control requires factoring in yields, allowances, and exact metric measurements.

The Economic Reality of the Irish Licensed Trade Today

Running a pub in Ireland right now is tough. You are squeezed by rising energy costs, minimum wage increases, and some of the highest excise duties in Europe. You cannot afford to lose 3% of your stock to careless pouring or unrecorded staff drinks. Every pint that goes missing is pure profit stripped directly from your pocket.

 

The Financial Anatomy of Bar Stocktaking: Margins, GP%, and Yields

Your EPOS terminal tells you what you sold, not what you lost. To figure that out, you need to dig into the math.

How to Calculate Cost of Goods Sold (COGS)

COGS is the actual cost of alcohol used. Calculate it by taking your opening stock, adding purchases, and subtracting your closing stock. If COGS creeps up but sales are flat, you have a serious leak.

Potential Gross Profit vs. Actual Gross Profit

Potential GP is the profit you should make if every drop is sold perfectly. Actual GP is the harsh reality, what you actually make after dropped bottles and heavy pouring. Understanding how to calculate gross profit in a bar is the only way to close this margin gap.

Formula for Actual GP%

Divide your gross profit (Sales minus COGS) by total sales, then multiply by 100.

Irish Industry GP Benchmarks

Aim for these targets in a typical Irish pub: draught stout and ale (62%–68%), draught lager (64%–70%), and spirits (78%–84%, provided staff strictly stick to the 35.5ml measure). Post-mix minerals should hit 80%–88%.

Understanding Stock Variance (Surplus vs. Deficit)

Variance is the difference between till sales and physically missing cellar stock. A deficit means stock is gone and you weren’t paid for it. A surplus usually means unrecorded deliveries or staff short-measuring customers to cover previous mistakes.

 

The 4 Main Causes of Stock Loss in Irish Bars and Hotels

If your margins are slipping, the culprit almost always falls into one of these four categories.

1. Operational Wastage

You have to clean lines, which means throwing away beer. Poorly managed cellars suffer from excess fobbing and leaks. Enforcing strict bar cellar management best practices limits this unavoidable waste to a manageable 3% to 5% per keg.

2. Over-Pouring and Free Pouring

Spirits in Ireland must be sold in 35.5ml multiples. If a bartender free-pours 40ml, you lose 4.5ml of profit. Do that 100 times on a busy Saturday night, and you’ve given away half a bottle for free.

3. Unrecorded Comps and Staff Drinks

The problem isn’t giving a regular a free drink; it’s failing to record it. If staff drinks, spillages, and comps aren’t rung through the EPOS waste tab, they show up as a negative variance at month-end.

4. Theft, Short Deliveries, and Invoicing Discrepancies

Loss can happen before a keg even reaches the cellar. Delivery drivers make mistakes, suppliers hike prices without warning, and staff pilferage happens. Regular stocktaking catches all of this instantly.

 

How to Do a Bar Stocktake: A Step-by-Step Procedure

A proper count requires a strict routine. Here is how to execute it flawlessly.

Step 1: Pre-Stocktake Preparation

Never start in a messy cellar. Clear out the empty kegs, stack new deliveries by brand, and face up your back-bar displays. Organization makes the count faster and more accurate.

Step 2: The Physical Count

Move logically from the front bar through to the cold room and main cellar, counting all full units.

Counting Open Spirits

Visual guessing ruins GP calculations. Use calibrated digital scales to weigh the bottle, subtract the empty glass weight, and find the exact number of 35.5ml measures left.

Measuring Draught Kegs

For open kegs, dipsticks are cheap but break the seal. Ultrasonic flow meters track real-time data, but for physical counts, a heavy-duty keg scale gives the exact volume down to the pint.

Counting Bottled Beer and Wine

Count individual bottles for open cases and multiply full cases by their unit count. For open wine sold by the glass, use an optic ruler.

Step 3: Auditing Delivery Invoices & Credits

Don’t just assume every delivery was spot on. Grab every single invoice, docket, and credit note that came through the doors over the stock period. You need to verify that what you were charged actually matches your agreed supplier rates. Did you get that credit for the bad keg? Once you confirm the numbers, log them into your ledger as your total purchases.

Step 4: Extracting EPOS Sales Reports

Next up is figuring out what actually crossed the counter. Jump into your back-office system and pull a detailed PLU (Price Look-Up) report. This will show you exactly what the staff rang through the till every pint, shot, and bottle.

Step 5: Generating the Stock Variance and Valuation Report

This is the moment of truth. You are basically taking what you physically counted and comparing it against your sales and purchases to see if anything went missing.

{Stock Variance} = {Physical Closing Stock} – ({Opening Stock} + {Purchases} – {Sales Depletions} – {Allowances})

If that final number comes back negative, you are actively losing money. You’ve got a shrinkage problem on your hands that needs fixing immediately.

Special Considerations for Hotel Bars and Multi-Outlet Venues

Hotels have it harder. Stock constantly moves between the main bar, resident lounges, and function rooms. Accurate food and beverage stocktaking for hotels demands rigorous tracking of these inter-bar transfers to stop inventory from disappearing during busy wedding banquets or room service drops.

Technology in Modern Stocktaking: EPOS, Scanners, and Automation

An EPOS system is brilliant for logging sales, but it won’t tell you if a bartender dropped a bottle of gin and swept it up without telling anyone. Pure reliance on software is dangerous. The best approach is hybrid auditing: blending your EPOS data with hard physical counts using handheld scanners and precision scales.

In-House Stocktaking vs. Independent Professional Stocktaking

Doing it yourself saves an upfront fee, but in-house counts are notorious for blind spots, rough estimates, and internal bias. Bringing in independent stocktaking services for pubs means getting a harsh, accurate look at your numbers. An external auditor using proper weighing hardware typically recovers 2% to 6% in gross profit, easily paying for themselves.

Why Trust Hospitality Partners?

Real Experience in the Irish Trade

We don’t just read spreadsheets in an office. We’ve spent years standing in cold cellars across Ireland. From massive Dublin city center venues to quiet country hotels, we know exactly how a busy night actually runs. We see the real-world problems that publicans deal with, and we know how to fix them.

Same-Day Results You Can Actually Use

You shouldn’t have to wait a week to find out you’re losing money. The minute we finish counting your stock, we hand you the variance report. You see the numbers on the exact same day, which means you can pull a staff member aside or chase up a supplier immediately. We use proper digital scales and ultrasonic gear to get these numbers, so there is zero guesswork involved.

Independent and Unbiased

Doing your own count is tough because it is hard to spot your own mistakes or catch internal issues. Bringing us in gives you a completely neutral set of eyes. We just deliver the raw facts. For most of our clients, this honest approach ends up recovering about 2% to 6% in gross profit right off the bat, keeping you fully compliant with revenue along the way.

Frequently Asked Questions (FAQ)

Q. What is bar stocktaking?

A. It is the physical counting of all the wet and dry goods in your cellar and bars. You match what is actually sitting on the shelves against what your till says you sold, helping you spot missing stock and protect your profit margins.

Q. How often should an Irish pub do a stocktake?

A. High-volume venues usually do a full count every two to four weeks. Fast-moving or high-value items, like premium spirits and draught kegs, should really be checked weekly to catch leaks early.

Q. Why is regular bar stock control so important right now?

A. Margins in the Irish trade are incredibly tight. Between rising supplier prices and high excise duty, regular counts catch heavy pouring, cellar waste, and unrecorded sales before they drain your bank account.

Q. How do you properly count open spirit bottles?

A. Stop guessing by eye. The only accurate way is to use calibrated digital scales to weigh the open bottle. You then subtract the empty glass weight to find out exactly how many 35.5ml shots are left.

Q. How do you calculate stock variance?

A. Take your closing stock and subtract your opening stock, plus purchases, minus sales and waste. If the final number is a negative, you have unexplained missing stock that needs investigating.

Q. What is the real yield of a 50-litre draught beer keg?

A. A 50-litre keg holds roughly 88 pints. But after you factor in normal line cleaning and tap fobbing, a realistic operational target is 84 to 86 sellable pints.

Q. What is the difference between Actual and Potential GP?

A. Potential GP is the number on paper if absolutely nothing goes wrong. Actual GP is the cold, hard reality—the cash you actually hold onto once you factor in line waste, heavy pours, and broken glass.

Q. Do EPOS systems replace physical stocktakes?

A. No. Your EPOS only records what was actually rung into the till. It won’t tell you if a bartender broke a bottle of gin or gave away a free pint. You need physical counts to catch those physical losses.

Q. What should a good stocktaking report show me?

A. A solid report gives you your opening and closing stock values, a clear breakdown of purchases, your actual achieved GP percentage versus your target, and a detailed list of any stock variances.

Q. Is it worth hiring an independent stocktaker?

A. Absolutely. Bringing in an outsider for pub stocktaking Ireland removes staff bias and lazy guesswork. Most operators see their margins increase immediately by between 2% and 6%, which easily covers the cost of the service, since they use precise scales and never cut corners.

Key Takeaways & Actionable Stocktaking Checklist

If you don’t measure it, you can’t manage it. Get strict on your 35.5ml pours, track every single drop of cellar waste, and never fully trust an EPOS report without a physical count to back it up. Ready to lock down your margins? Make sure you download our free bar stocktake checklist to streamline your next audit and catch those profit leaks before they start.