How to Manage a Bar Inventory: Your Complete Guide

How to Manage a Bar Inventory: Your Complete Guide
Bar Inventory - September 29, 2022 Written By: Krista Dinsmore

Browse Different Topics

Managing a bar can be a lot of work. The good news is, you can keep your bar well stocked, organized and profitable by implementing the right inventory management processes

This article will take a look at everything you need to know about bar inventory, including signs that you have an inventory problem, best practices, how to conduct inventories, important metrics and so much more. We hope this guide can help give you the foundation you need to become more profitable. 

What to include in your bar inventory 

Your bar inventory should include everything you need to serve your customers. This includes alcohol, mixing ingredients, garnishes, and even your glassware. 

New call-to-action

5 signs you have a bar inventory problem 

Here are 5 common signs that you have bar inventory issues that could be impacting your profitability. 

  1. Inconsistent stock levels without a change in sale – This is a sign that you are not recording inventory data correctly. This is often due to manual inventory processes, which we will talk about shortly. 
  2. One or two servers with much higher tips – If you have a couple of servers with significantly higher tips than others, it could be a sign they are out performing their peers or it could be a sign of employee theft. 
  3. Too much stock on hand – Not having enough inventory can seriously impact your customer experience, but having too much inventory on hand will affect your profit margins. If you consistently have too much stock on hand it could be a sign of poor ordering processes, dead stock or slow moving inventory. 
  4. Not updating menus and pricing – If you aren’t updating your menu and prices in a fairly regular manner (at least once a year), it could be a sign that you aren’t getting the inventory data you need to truly determine how your business is performing. 
  5. High pour costs – If you have high pour costs compared to other similar businesses, it’s likely a sign you have a bar inventory problem. We will talk about calculating this important metric (and others) later on. 

 

Tips for organizing bar inventory 

Before you can start managing and tracking your inventory, you must first organize it. When your bar is organized efficiently, you not only reduce the time it takes to count your bar inventory, you’ll also be able to gain better insights on how to boost your profits. 

To help keep your inventory organized, consider these important rules: 

  1. Place perishable items at the front 
  2. Avoid carrying too much stock 
  3. Make sure products always go in the same place 
  4. Use labels 
  5. Do frequent inventory counts 
  6. Conduct counts outside of business hours
  7. Organize by category 

 

For more information on these rules, as well as additional tips, read our blog on 10 Rules for Successful Organization of Your Bar Inventory

How to store alcohol 

To help increase the shelf life of your alcoholic beverage inventory, you want to be sure it is stored correctly. 

Firstly, be sure to store it away from light. Sunlight and artificial light can break down the molecules in your liquor bottles. While this mostly impacts colour, over time, it can affect the taste as well.

You also want to reduce the amount of air the alcohol is exposed to. When your alcohol is exposed to air (or more specifically the oxygen in the air), it can cause oxidation. Oxidation speeds up the aging process and reduces the quality of the alcohol and degrades the flavour. 

If you have multiple bottles open, always use the bottle with less alcohol in it first. Similarly, you want to avoid leaving small amounts of alcohol in the bottom of the bottle. That’s because the less liquid there is in the bottle, the higher the risk of oxidation.

Extreme temperature changes are also bad for alcohol. Being too hot or too cold can severely affect the quality of your alcohol. But the right temperature is dependent on the type of alcohol. 

Liquor: Can be stored at room temperature, however, the ideal temp is 13°C to 16°C

Wine: 11°C to 14°C; white wine can handle temperatures as low as 7°C

Crème liquor: Store in the fridge once opened

Fortified wine: Store in the fridge once opened

Beer: 7°C and 16°C, with light beers being stored in cooler temperatures and strong beers at higher temperatures

Lastly, keep bottles stored the right way. When storing wine, it is recommended you store it on its side to prevent oxidation. Liquor and beer should be stored upright. 

The importance of standard pours 

At your bar, over pouring means losses to your bottom line, and under pouring can result in frustrated customers. Standard pours are what bars use to ensure consistency. It also helps with bar inventory management and can help boost your overall success. 

Standard pours depend on the type of alcohol being served: 

Red or white wine: 5 ounces

Dessert wine: 2 ounces

Fortified wine: 3 ounces

Wine tastings: 2 to 3 ounces

Champagne: 4 ounces

80 proof mixed drinks: 1.5 ounces

On the rocks or neat: 2 ounces

Beer: 12 ounces 

How to count bar inventory 

To count your bar inventory, you first want to count the number of full bottles. You must then determine how much is left in any partial bottles. There are several different methods you can use to inventory liquor at your bar, each with its own pros and cons.

  1. Tenthing – Eyeball the bottle to estimate how much liquor is still in the bottle to the nearest tenth. 
  2. Electronic tenthing – A computer estimates how much alcohol is left in a bottle using pictures of the bottles. 
  3. Weighing – Use electronic scales to determine exactly how much alcohol is in the bottle. 

When choosing an inventory counting method, it is best to use weighing. This method provides the most accurate inventory count, is objective and takes much less time. It also makes counting alcohols in opaque bottles easier. 

What is inventory shrinkage? 

Inventory shrinkage happens when you have less inventory on the shelf than is recorded in your records. It is calculated by subtracting actual inventory from recorded inventory and then dividing the answer by recorded inventory. 

The most common causes of inventory shrinkage are: 

  • Theft: While this can be done by someone externally, internal theft (employee theft) is also a major problem. Some of the ways staff can steal inventory from you is by overserving friends and family or giving away free dishes, over pouring drinks for higher tips, taking food and alcohol home with them and recording false spills only to sell the drink later for cash and pocketing the tender. 
  • Waste: Alcohol, mixers, garnishes and food can all go bad over time, some much faster than others. If they aren’t used by their best before dates, they will have to be disposed of, which can increase inventory shrinkage.  
  • Spills: Accidents happen, which is why inventory shrinkage will never truly disappear. Dropping bottles, toppling trays, or replacing a customer’s spilled drink all increase your level of shrinkage. 
  • Over pouring: When it comes to serving alcohol, many drinks are poured by eyeing the pour. This leaves room for staff to accidentally pour more into a glass than standard. 
  • Admin error: There is a lot of alcohol and food moving in and out of your bar or restaurant, which means there are lots of opportunities for administrative errors. This may include inputting incorrect quantities per case counts or receiving inventory based on the packing slip without verifying the right amount was actually shipped. 

 

Important bar inventory metrics 

Bar analytics is the process of collecting and analyzing the data points related to all areas of your business, and using them to build meaningful insights that help you improve your restaurant or bar. 

There are several different metrics you should be aware of when managing your bar inventory. Here are some of the most important ones: 

1. Inventory usage – the amount of bar inventory that has been used in a specified period 

Inventory Usage = Opening Inventory + Purchases Received – Closing Inventory 

2. PAR levelPeriodic replacement level, commonly referred to as PAR level, is the minimum supply of each product your bar needs in stock to meet the demands of your customers.  

Inventory Usage = Opening Inventory + Purchases Received – Closing Inventory 

 

3. Pour cost percentage – Your bar’s pour cost is how much your drinks cost compared to your bar’s resulting sales from those products. It is usually expressed as a percentage. 

Pour Cost Percentage = (Wholesale Price Of The Product / Retail Price) X 100 

Why your bar inventory spreadsheet is failing you 

Spreadsheets are a seemingly simple tool for managing bar inventory – they can be organized by storage locations, data is easy to enter, the software does the math for you, and you can quickly produce charts and graphs to aid in decision making. Not only that, but they can be free to use as well. 

But spreadsheets also have a number of flaws. If you are still using an inventory spreadsheet, here are some reasons you may want to look for a new solution: 

  1. You have to know which formulas to enter to get the right information and you must ensure they aren’t accidentally changed, otherwise it could send your whole inventory calculation into disarray
  2. They aren’t designed for your bar inventory which means they are missing important features 
  3. They don’t provide real-time data 
  4. Spreadsheets don’t integrate with other systems to streamline processes 
  5. They don’t scale well as your inventory grows 
  6. There’s lots of room for human error 
  7. It’s hard to find errors in spreadsheets 

This is just a brief summary of why you shouldn’t be using spreadsheets for bar inventory. For more detailed information, check out our article on 7 Ways Your Bar Inventory Spreadsheet is Failing You.

What is bar inventory software?

Bar inventory software, known as a bar inventory management system, is a technology that helps automate and centralize the processes associated with managing your bar inventory. 

Why should you use it?

Manual spreadsheets are time-consuming and typically lead to errors, resulting in inaccurate insights into your inventory. Bar inventory management software eliminates these issues. It also helps you: 

  1. Save time so you can concentrate on delighting your customers
  2. Gain visibility and control over your inventory 
  3. Improve ordering processes 
  4. Reduce labour costs and make better use of staff’s time 
  5. Minimize errors 
  6. Find out where you are losing money 
  7. Optimize sales by identifying products that bring in the most and least amount of money 
  8. Automates data collection, analytics and reporting

What to look for in a bar management software 

When looking for a bar inventory management software, there are some key features and functions you should look for: 

  1. Direct POS integration

A POS provides several inventory management functionalities, from data forecasting, order planning reports, integrated accounting and much more - but a POS doesn’t give you complete inventory insights like a bar inventory management system will. 

Instead, it’s crucial to integrate both systems. This will allow you to pull sales data directly from your POS system into your inventory management system, giving you greater insight into inventory losses.

  1. A large database of products to make inventory counts more seamless

Counting your inventory should be easy. Look for a liquor inventory management system that has a large database of different types and brands of alcohol to choose from during your counts. 

This will speed up the entire process and make it more efficient, allowing you to focus on tasks that drive real value to your bar. 

  1. Expert on-hand advice when needed

A bar inventory management system is incredibly helpful, but to truly use your system to maximize ROI and optimize your inventory expert support is crucial. 

Technology should be combined with expert advice from specialists who understand exactly how the software works and what specific features will help your bar become more profitable. 

What is a bar inventory app?

A bar inventory app is a mobile phone application, typically available on iOS and Android devices, that has been specifically created to give bar managers improved insights into their inventory usage.

It differs from inventory management software by giving you the ability to access your inventory information from anywhere. It can also help improve inventory counts using innovative technologies to automate this process, with barcode scanning, huge databases of products and electronic weighing to make the entire process more efficient. 

Interested in learning more about bar inventory management? Contact Sculpture Hospitality today

Contact your Local Inventory Consultant Today

2024-trends-thumb
Sculpture-BuyersGuide-Cover

A Complete Buyer's Guide to Food & Beverage Inventory Management Systems

With around 25 to 35 percent of a restaurant’s operating budget dedicated to purchasing food (that’s not even taking into account beverage inventory costs for the bar), proper inventory management can significantly improve expected revenue.

To maximize profits you need to improve visibility and control over your restaurant or bar’s inventory. 

Download Free eBook

Related posts

A Guide to Bar Inventory Management: Key Tips to Get You Started
Bar Inventory - February 13, 2024

A Guide to Bar Inventory Management: Key Tips to Get You Started

Krista Dinsmore
Written by Krista Dinsmore
Your 10-Step Guide to Mastering Bar Inventory Management
Bar Inventory - January 09, 2024

Your 10-Step Guide to Mastering Bar Inventory Management

Krista Dinsmore
Written by Krista Dinsmore
How to Choose the Best Bar Inventory Management Software
Bar Inventory - December 05, 2023

How to Choose the Best Bar Inventory Management Software

Krista Dinsmore
Written by Krista Dinsmore