How to Do Bar Inventory in the UK

When a bottle of decent gin costs what it does these days, you can't afford to have it vanish into thin air. And with new staff coming and going, you need to know if someone's heavy-handed with the measures or if that premium whisky is walking out the back door.

A proper inventory system helps you spot the problems early. Maybe your Stella consumption doesn't match your sales. Maybe you're ordering too much of that craft beer that seemed like a good idea but just sits there. Or maybe you're running out of tonic water every weekend because nobody's keeping track.

It's about staying ahead of the chaos instead of constantly playing catch-up.

Why Bar Inventory Matters

Keeping on top of alcohol stock helps you:

• Monitor wastage and unauthorised pours

• Calculate pour cost and margins accurately

• Streamline ordering to avoid overstocking or running dry

• Identify your best-performing drinks and upsell strategically

• Comply with HMRC alcohol duty regulations and licensing requirements

According to the Toast Consumer Preferences Survey 2025, where 200 UK hospitality workers were polled on their training preferences, 63% believe that ongoing training on inventory and wastage could significantly improve profitability.

What Inventory Should You Track?

At a minimum, your bar inventory should track:

• Starting stock

• Received stock (deliveries)

• Ending stock

• Alcohol type, brand, name, and bottle size

You can use a digital system, but even a spreadsheet works if kept consistent. 

Bar Inventory Formulas You Need

Once your setup is ready, use this formula to calculate usage: Opening Inventory + Purchases – Closing Inventory = Usage

Then, calculate pour cost: Pour Cost = Inventory Usage / Sales Revenue

These figures help you:

• Analyse ingredient-level profit margins

• Track shrinkage and monitor losses

• Adjust drink prices to reflect actual costs

Step-by-Step: How to Take a Bar Inventory

1. Choose a consistent inventory period: weekly or fortnightly is common in the UK

2. Organise your bar: group bottles logically to speed up counting

3. Print or load your inventory sheet with columns for start, received, and end counts

4. Count during quiet hours: ideally before opening or after closing

5. Use decimal values for partially full bottles (e.g. 0.7 for 70% full)

6. Record spills and comps separately for loss tracking

Pro tip: Keep the order of bottles in your sheet the same as their layout behind the bar. It saves time and avoids mistakes.

Staff Training & Accountability

Inventory management only works when the whole team is on board. Train your FOH staff to:

• Measure pours accurately using jiggers or pour spouts

• Log spillage, breakages, and complimentary drinks

• Take responsibility for their section’s stock levels

According to the Toast Consumer Preferences Survey 2025, almost 90% of UK hospitality staff surveyed said that a structured onboarding process is valuable.

Tech That Makes the Day-to-Day Easier

Many UK bars now use inventory apps or POS-integrated systems to save time. Look for tools that:

• Sync with your POS and track sales in real-time

• Offer visual stock reports and reorder alerts

• Let you manage stock across multiple sites

Final Thoughts

When you track your stock consistently, use the right formulas, and get the whole team involved, you gain more than numbers — you gain control. Start simple with a spreadsheet or template, give your staff the right training, and let the insights lead the way to better margins and less guesswork.