Toast Restaurant Management Blog 

Subscribe to get weekly restaurant resources right in your inbox &
receive the FREE ebook, 15 Creative Restaurant Staff Training Ideas.

Bar Inventory Basics: How to Do Liquor Inventory

Posted by Nick Rubright on 10/26/16 1:00 PM in Restaurant Metrics

5 minute read Print

bar inventory basics

One of the most tedious tasks in the bar industry is taking proper inventory. It’s a long process involving late nights for managers and bartenders in the storeroom. Inventory tracking is especially important for bars, where frequent spills and free drinks can hurt your profitability.

While there is bar software that can help with the bar inventory management process, it’s best to understand the basics of how this is normally handled with pen-and-paper.  Even if you plan on using  restaurant inventory software, having a deep understanding of how liquor inventory is done will help you make better purchasing decisions.

Here’s a look at how to do liquor and bar inventory for your restaurant, pub, or bar.

The Basics: A Bar Inventory Overview

When looking at bar inventory, maintaining enough on-hand inventory to generate sales is only the beginning. Your bar inventory also helps with the following:

  • Determining how your bar is performing financially.
  • Measuring shrinkage.
  • Setting inventory minimums.
  • Identifying beverage costs so you can price effectively.
  • Pinpointing which drinks are the best selling and most profitable in your bar. 

Ultimately, your goal is to calculate your inventory usage within a certain period so you can compare it to your sales. 

Calculating Inventory Usage

To get your bar's inventory usage for a period of time, you’ll need to know your inventory at the beginning of the period, how much you have at the end of the period, and how much you received during the period. 

Here’s the formula to determine your inventory usage:

Usage = Starting inventory + Liquor Purchased – Ending Inventory 


Simple, right? It's just what you once had minus what you now have.

Once you know your usage, you can use this information to gather useful data to better manage your bar. 

One example of how you can use the above formula is to estimate your pour cost – simply divide the result of the above formula by total sales, like so:

     Usage      =  Pour Cost

Total Sales                           


Knowing your pour cost can help you determine better pricing for your drinks.

You can also use your usage to estimate how much inventory you’ll need to purchase in the following periods, and how frequently you’ll need to make these inventory purchases. By getting into a regular ordering routine and altering it as your sales change, your bar can be prepared.

Using this formula to determine the usage of individual drinks in your bar will help you run a more cost effective business. 

How Do You Take Liquor Inventory

Now that you know the formula, it’s time to get into how to actually do liquor inventory. 

There’s a lot that goes into calculating inventory usage, but a basic way to handle it is with a bar inventory spreadsheet.  

a-glass-of-428316.jpgYour spreadsheet should have 3 columns:

  • Starting inventory
  • Received inventory
  • Ending inventory

You should also include rows for identifying your alcohol, such as:

  • Alcohol type
  • Brand
  • Name
  • Bottle size

When entering your products into the spreadsheet, enter them in the order you have them set out in your bar.  This way you don’t have to rearrange them alphabetically each time you do inventory, and can instead just count them in their place.

Once you have your spreadsheet set up, determine what inventory periods you’re going to use (weekly, monthly, etc.), and maintain this consistency.

When it’s time to count, choose a method and stick with it.  For example, if you decide to start in the front of the bar, then work your way to the back, do this every time you count.  As you count, enter the data into your spreadsheet.

For bottles that aren’t completely full, use decimals to represent the amount of alcohol left in the bottle.  For example, if you’re measuring the bottles in tenths, a bottle half full will be 0.5, while a bottle only 10% full will be 0.1.  Enter these decimal amounts into your spreadsheet in the appropriate columns and rows. 

Finally, add up the totals for each category on your spreadsheet. 

At the end of your chosen period – whether it’s a week, two weeks, or a month – repeat this process to get your ending inventory counts, then apply the above formula.

Here’s an example calculation: 

Inventory Usage = 10 bottles + 5 bottles – 3 bottles

Inventory Usage = 12 bottles


Expressed in dollars, if the average bottle of liquor costs the bar $15, the inventory usage in dollars is (12 x $15) = $180. 

You can use this amount to determine how you should price your drinks based on what you want your profit margin to be.

If the average bottle serves 10 drinks, then at eight bottles of inventory usage, the average cost per drink is ($180/80) = $2.25. So if you want to mark your drinks up by 50%, you should price your drinks at ($2.25/0.5) = $4.50

Over the course of the period, be sure to keep track of how much product you take in. You’ll need this information to complete the calculations at the end of the period. 

You want to make sure you take inventory while the bar is closed so that you don’t have any distractions. Being distracted in the middle of counting can result in large amounts of wasted time if you have to keep starting again. Additionally, make sure you train your employees on how to do bar inventory. They should be keeping records of significant spillages, breakage, or comped drinks. 

Once you have your inventory calculated and you can see it alongside your sales numbers thanks to your bar POS system, you can use it to calculate pour cost, make better pricing decisions, and to identify which products are the best sellers and which are the most profitable.

A Better Solution: Bar Inventory Automation

Taking inventory manually can be tedious – entering numbers into a spreadsheet takes time away from other things if you do it yourself. If you hand it off to an employee, make sure it’s someone you trust and is well trained on the process.

You can work towards automating the process with a bar inventory software or inventory spreadsheet integrated in your bar point of sale system. This system can help you count, manage, and value your inventory in an all-in-one platform that can connect with your accounting, order and track inventory accurately, and set your price points wisely.

restaurant-invenetory

toast restaurant management blog

Written by: Nick Rubright

Nick Rubright is the founder and CEO of Dozmia, a music streaming service that provides background music for businesses. He has a passion for helping musicians in their careers, as well as helping businesses find their sound.


Leave a comment today. 

Toast Restaurant Management Blog 

Subscribe to get weekly restaurant resources right in your inbox &
receive the FREE ebook, 15 Creative Restaurant Staff Training Ideas.