How to Take Bar and Liquor Inventory Guide Header Image of Woman Taking Wine and Liquor Inventory Counts

How to Take Bar Inventory | Tips for Liquor Management in Restaurants

Bar inventory can sometimes feel like the boogeyman waiting at the end of the month. Its dreaded by almost every bartender, manager, and restaurant professional tasked with it. But Uncorkd is here to help make liquor inventory manageable.

This step-by-step inventory guide is a checklist on how to take bar inventory quickly and efficiently. The right inventory practices can help your restaurant or bar reach higher profits and sustain success.

Table of Contents
click links to jump to sections

  1. Why bar inventory is important
  2. Setting up your inventory list
  3. Setting up your bar and liquor room
  4. When to take inventory at your restaurant or bar
  5. What to do with your inventory data
  6. How inventory impacts ordering
  7. Biggest mistakes restaurants and bars make
  8. Analyzing and optimizing your beverage program

Why bar inventory is important

Inventory is a valuable process that helps you understand key components of your beverage program. The insights you take from inventory should result in more dollars of profit on your bottom line. The following guide will break down the most important information and metrics that you should monitor and analyze through inventory.

Bar Finances

Taking inventory is like a physical exam that checks up on your bar’s financial health. Understanding where and how much money is tied up in your inventory is the first step to achieving goals like lowering your pour costs and sticking to purchasing budgets.

How to Take Bar and Liquor Inventory Image of Uncorkd's Inventory Summary

Viewing your Inventory Financial Summary with Uncorkd

Liquor Inventory Usage Rate

Inventory usage is the pace at which inventory is depleted. It is an alternative look at sales by measuring the quantity of items sold instead of the revenue itself.

Here is the inventory usage formula to calculate your usage rate.

Opening Inventory + Purchases Received – Closing Inventory = Inventory Usage

Cost of Goods Sold

Cost of Goods Sold (COGS) is the direct costs required to serve your drinks and make sales. This includes the cost of everything going into and necessary for creating the drinks along with the direct labor costs used to produce the drinks. For example, this includes supplies such as the liquor, garnishes, juices, mixers, soda, and napkins, and labor such as the bartender, barback, server and dishwasher, who all may be required for you to sell a drink to a customer. For individual drinks you may wish to just use the liquor cost as an approximation of the COGS, but for your entire bar financial picture all other direct costs should be included.

Inventory Turnover

Another critical metric to measure is inventory turnover. Inventory turnover is important to know because it tells how well you are using your cash, how often you need to order items and what your item par levels should be.

Inventory turnover is a ratio showing how many times you have sold and replaced inventory during a period. You can then divide the days in the period by the inventory turnover formula to calculate the days it takes to sell the inventory on hand. The higher the turnover the better (you are using cash more efficiently to generate sales). The formula for inventory turnover is:

Cost of Goods Sold [or liquor cost] / Average Inventory= Inventory Turnover

To calculate average inventory for the formula above, use:

(Beginning Inventory + Ending Inventory) / 2 = Average Inventory

And then to determine the days it takes to sell inventory, use the formula:

Inventory Turnover / Days [between beginning and ending inventory] = Average Inventory

Example
At the beginning of month 1 you count $50,000 in inventory. At the end of month 3 you count $90,000 in inventory. Your average monthly inventory is ($50,000 + $90,000) / 2 = $70,000.  If your cost of goods sold during that period is $140,000, your inventory turnover is 2. If you divide the number of days in the period (90) by your turnover (2), you’ll find out that you sell through your inventory every 45 days.

Par Levels

Establishing par levels will give you a guideline for the minimum amount of a product that you should have on hand at all times. Setting par levels will help you put together liquor orders with your distributors. It accomplishes two important things: (1) not tying up excessive cash in inventory, and (2) making sure you don’t run out of products.

We can use the formulas from the previous section to determine par values. Calculate the inventory turnover ratio for each item, then calculate the number of days to sell the inventory. Most liquor orders are placed weekly, so you should at least plan on having enough product for 7 days. You should also add a safety factor to account for sales fluctuations, or if there’s difficulty sourcing the product consistently. We recommend a safety factor between 1.5x – 3x depending on the product and supplier.

Example
Monthly Inventory Turnover = 10
Days to sell inventory = 3
Number of products sold per week = 2.33
Occasionally the distributor is out of stock of this item, so we’ll add a safety factor of 2.5
Par Value = 2.33 x 2 = 5.8

Inventory Variance

Variance, or shrinkage, is inventory product that is gone but not accounted for by sales. The missing inventory could be a product of over pouring drinks, unaccounted breakage, or even something as concerning as theft.

It’s not possible to fully eliminate variance, but it is possible to reduce variance which will increase profits. Here is the basic inventory variance formula. 

Ending Inventory Count – Initial Inventory Count + Purchases – Sales  = Variance

You can think of the above formula another way: your actual inventory count minus expected inventory count. In the formula above, you expect your count to be what you initially had plus the quantity you bought minus the quantity you sold.

Perpetual Inventory vs. Physical Inventory

There are two types of inventory methods, perpetual and physical.

Perpetual inventory is counting down your inventory as it sells (and adding to it when you buy) so that you always know your current inventory on-hand. Keeping a perpetual inventory makes placing weekly liquor orders much easier, and can also assist in 86’ing items from your menu so a customer doesn’t order something you’re out of.

However, perpetual inventory is a theoretical value and is highly dependent on the accuracy of input to your POS system and other variance.

Physical inventory is the act of actually counting each of your items. It is certainly more accurate than perpetual inventory, but requires a lot of labor and is not performed frequently, making it unreliable for placing weekly orders.

The most effective means of inventory management is using the combination of perpetual inventory and physical inventory.

If perpetual inventory is your theoretical expected value, and your physical inventory is your actual value at a given point in time, then your variance is the difference between the two. And when you perform your physical inventory, you reconcile the perpetual inventory count so that the number resets to the actual number counted.

You can use tools like Uncorkd to track perpetual inventory and measure variance.

Uncorkd tracks accurate perpetual inventory by syncing with your point-of-sale system and placing orders with your alcohol vendors. When a sale is recorded through the POS system, your inventory counts will automatically update.

Likewise, when you place an order with a vendor and it is received, your inventory counts will be automatically updated. Uncorkd also makes it easy to do physical inventory counts quickly from any device, and see the resulting variance reports.

Manually tracking inventory variance is more difficult and cumbersome. You will need a spreadsheet to track your starting and ending inventories, all items purchased, the costs and sales of each item. Unless you prefer to spend hours each day doing data entry into spreadsheets instead of being on the floor, for many bars and restaurants it is not feasible to do accurately without software.

Pour Costs

How to Take Bar and Liquor Inventory Guide Image Pour Size for Pour Costs

Pour costs are the ratio between the cost of products purchased and the revenue from products sold. For more information on pour costs read this great post detailing ways to lower your pour cost.

Product Costs / Product Sales = Pour Cost

Your pour cost is important because if it is too high, then you will generate lower profits overall from beverage sales. Pour costs have an inverse relationship to margin. Another way to state margin, is that for every extra dollar in sales you make, the margin is the incremental gross profit (profit before other expenses such as fixed costs, labor, utilities, etc…). Your margin percentage is calculated as:

(Sales – Costs) / Sales = Margin

Looking at industry costs is a good guideline, but depending on your business, you will want to determine the ideal pour costs and margins for you. A business in a major metropolitan city with high rents and labor costs will need lower pour costs and higher margins than one that isn’t.

Here are industry averages for pour costs:

Liquor: 15% Draft Beer: 20% Bottled Beer: 25% Wine: 30% – 40% Average Total: 18% – 24%

Beverage Sales Performance

 

How to Take Bar and Liquor Inventory Image of Uncorkd's Sales Summary Report

Viewing your Sales Summary Report with Uncorkd

Tracking all of the information laid out above will give you insights into sales trends and performances for your bar inventory.

Analyzing data like usage rate will tell you which items sell fastest or don’t move at all.

Understanding your pour costs for specific items will underscore which items generate the highest profits when they are sold.

Taking all of this into account will give you a detailed understanding of the health of your bar program. You can now make informed decisions that will help your bar become more profitable. Which after all, is the point of taking inventory.


Setting up your liquor inventory list

Organization is essential for an efficient inventory system that adds value (dollars) to your business. Staying organized will also save you significant time and reduce the frustrations of performing inventory.

Liquor Inventory Spreadsheet Template CTA

 

Inventory Locations

Whether you use a spreadsheet or an inventory solution like Uncorkd, you should set up separate locations or areas for your items. Locations are the physical places that inventory is stored in your restaurant or bar.

For example:

Front Bar | Back Bar| Beer Cooler | Liquor Storage | Wine Room

This will help you maintain accurate counts and keep things streamlined when you’re taking inventory. It also allows you to divide up the work of counting inventory at the end of the month more easily by having different staff counting in different areas at the same time. You can total the counts for each item in each location when you’ve completed counts for all locations.

Item Order for Inventory List

Once you’ve established your inventory locations, it’s time to add and organize the products listed in each section. The best way to do so is not necessarily alphabetically, but by matching the order of your inventory list to the order in which they are physically organized behind the bar and in storage. This allows you to quickly go down your list as come across the actual bottles to record counts.

Recording Costs

In order to calculate important information like Pour Costs, Variance, and Margins, you need to know the cost of each product you’ve purchased.

To record your costs, you will have to copy pricing information from your invoices into a spreadsheet. If you’re using Uncorkd, you can upload your invoices to our system to have your costs recorded for you automatically.

The most important information is the cost per bottle. So if you order cases, divide the case price (including discounts and taxes if possible) by the number of bottles in the case to find the bottle cost. It’s best to keep as much information centralized as possible. So if you use a spreadsheet for inventory, you should add a separate column for item cost.

Establish Pour Sizes and Pricing

Your pour sizes and pricing for products like wine and spirits will be influenced by your costs.

A general guideline for pricing is to sell items at a 20% liquor cost. That is, if an item costs you $1, you would sell it for $5. So, 1/5 =.2 or 20%.

Standard wine pours are typically 5 oz. or 6 oz. per glass

Standard pours for spirits are 1 – 2 oz. for neat pours, or 1.5 to 2 oz. for mixed drinks

20% isn’t always possible with premium items like a rare whiskey or an expensive bottle of wine because you may price out your customers by charging too much to hit a 20% pour cost. It’s important to know your client base when setting pricing. In general, the lower the cost of an item, the higher the pour cost should be; and the more expensive the cost of an item, the lower the pour cost should be.

Your cheapest wines by the glass may have a pour cost of 25%, while your most expensive wines by the bottle may have a pour cost of 60%. Despite a much higher pour cost, you’d prefer to sell a $200 bottle of wine with a 60% pour cost ($80 of gross profit) compared to a $50 bottle of wine with a 30% pour cost ($35 of gross profit).

Establishing the liquor cost percentage is easy once you know the cost per bottle. For spirits, wine, beer and other liquors sold by the ounce (as opposed to selling by the bottle), you will need to calculate the cost per ounce. Record your sale price for each item in a column next to your cost column.

To calculate cost per ounce, divide the bottle cost by the number of ounces.

Identifying the cost per ounce will also help you decide on your pour sizes by determining the margin you want per bottle for items sold by the ounce.

For wine, where a standard bottle is 750ml or 25.3 ounces, industry standard is 5 oz. pours (yields 5 glasses per bottle) or 6 oz. (4 glasses per bottle).

Liquor Price Calculator CTA

Planning Ahead

One of the points we’ve hammered on in this inventory guide is that inventory is about much more than just counting bottles. The information you capture from a mature inventory system can be the difference between failure and success for your business. And although we’ve thrown at you a lot of complex formulas and calculations, running an efficient and profitable inventory system is not as difficult as it seems, it just requires some upfront planning.

When putting together your liquor inventory spreadsheet you will want to decide what type of information you want to have available for analyzing your bar program.

For example, if you want to know how much money you have tied up in wines vs. beer, then you will need to add a spreadsheet column to notate the type of beverage it is. Uncorkd and other inventory programs are so useful because that information is already associated with the items you enter into the system.

Here are some categories you may want to capture information on for inventory analysis

Product Types

Wine, Beer, Spirits, etc.

How to Take Liquor Bar Inventory Image of Different Product Types

Subtypes

Red wine, White wine, IPAs, Lagers, Tequila, Vodka, Whiskey, etc.

How to Take Bar Liquor Inventory Guide Item Image of Wine Glass, Champagne Flute, Cocktail Shaker, Beer Glass

Vendors

The distributors you purchase from alcohol and beverages from.

Size

Determines pour costs, pour sizes, price point

Varietal or Style

Chardonnay, Merlot, Single Malt Scotch, Blended Scotch, Blanco Tequila, Anejo Tequila

Why this information is useful

Capturing data by additional categories like those listed above will help you determine which areas of your business are most profitable. It will also help ensure you don’t have too much money tied up in inventory of any specific type of product. For example, if Cabernet Sauvignon accounts for 15% of your wine sales, it would be useful to know if your on-hand inventory value of Cabernet deviated drastically from 15%.

We noted above that different types of alcohol have different average pour costs. By capturing more data to analyze your beverage program you can approach your inventory data from different perspectives to determine how you can become most successful.


Setting up your bar and liquor room

We mentioned that it’s best practice to organize whatever you use to record inventory counts (spreadsheet, paper, software like Uncorkd) in the way that you’ve ordered your bar and storage areas. It’s also important to organize the physical spaces in an efficient way.

Ways to Organize

Much of your organization will depend on what type of bar or restaurant you are. If you sell a lot of tequila, you will want to put an emphasis on making tequila accessible in storage and in a prominent location at the bar.

Sales Volume

The products you sell most should be the most accessible

Product Type

Organize like-items with one another. Rum with rum.

Well Liquors

Well liquors will sell faster than premium, keep them accessible.

Bin Numbers

Organize large wine programs by bin number. More below.

 

More On Bin Numbers

Bin numbers designate a location for where a specific bottle is kept. If you have a large wine program, then you will want to organize your selection by assigning bin locations to each wine.

This will help maintain order for wines and will also help your staff provide timely service because they will know exactly where to find a wine when it is ordered by guests.

Pro Tip: If you have a large wine selection and use bin numbers, consider putting the bin number at the beginning of the name of the item in your POS system. It will make it easy for staff to find and easy for management to compare sales from POS reports to inventory from spreadsheets for measuring variance.


When to take inventory at your bar or restaurant

How to Take Bar and Liquor Inventory Image Of Inventory Calendar for When to Take Bar and Liquor Inventory

When you take inventory is important. And it’s one of the reasons that inventory is dreaded by so many people. It’s often done late at night or early in the morning, when the restaurant isn’t open for service.In order to be accurate with your inventory counts, you cannot take inventory during service hours. This will give you altered counts that will make it difficult to generate accurate data.

Time of Day

Take inventory while your restaurant or bar is closed. This may require you to come in earlier if you’re business doesn’t serve breakfast or lunch hours. It may also mean staying late after a shift. Or, if your venue isn’t open 7-days a week, then coming in on the off day will provide you plenty of time (and peace) to record inventory.

Opening and Closing Monthly Inventory

The restaurant industry standard is to take inventory on the last day of each month.

This means that your inventory periods and data will be in monthly segments.

It’s important to stay consistent with when you take inventory because it will standardize the period of information you use to calculate your beverage program’s performance.

When calculating things like Inventory Usage Rate, you have three factors:

  • Opening (or starting) Inventory
  • Goods Purchased
  • Closing (or ending) Inventory

If you are taking your inventory counts for the month of February, and you conducted January inventory on the 31st, then you can use the January closing inventory as your opening inventory for February.

Throughout the month, record your weekly purchases in a separate column or spreadsheet  tab so you can identify your new purchases from the previous standing inventory.

Finally, take your closing inventory on the last day of February.

From there, you can use those three data points to calculate important things like usage rate and identify sales trends.

Weekly Inventory for Orders

Each week you will be placing orders with your distributors. It’s important to track inventory closely so you don’t order and spend too much. Keeping a perpetual inventory, where possible, helps tremendously with more quickly determining weekly orders.

Over-ordering will cause your pour costs to bloat and will suck up profits by having too much money tied up in standing inventory. Under-ordering will cause you to disappoint customers by running out of items and will also put stress on your staff.

Par Levels
Identifying par levels for your popular items will help you know when to order.

Spot Check Inventory
When putting together your orders, you should create an order form that allows you to mark down the items you need to order under the distributor that carries the item. If you don’t have perpetual inventory, walk through your bar and storage areas to identify which items are low compared to the par level and place orders accordingly.

Recording Daily Inventory Updates

Some bars will record daily inventory updates to keep a keen eye on their product usage. For things like bottles of beer and wine, this is easily done by generating a sales report from the POS system.

For things like spirits or wine by-the-glass, you can manually record when a bottle is finished, called “bottle kills,” or if your service and bar space allows, physically save the bottles to count at the end of the night and create a “kill list” from these bottles.

The perpetual inventory provided by Uncorkd’s inventory integration for POS systems will record daily count updates.

How to Take Bar Inventory and Liquor Management Image of Inventory Flow Chart

Inventory Flow Chart


How to take bar inventory

There are many different systems and methods for taking your inventory. The best systems provide the most value to your business at a competitive cost.

That value is determined by a handful of factors:

  • Ease of use
  • Speed
  • Compatibility with other management tools or technology
  • Onboard process
  • Hardware
  • Reporting and data provided
  • Auxiliary services like distributor ordering

How to Take Bar and Liquor Inventory Image of Writing on Pen and Paper to Record Inventory Counts

Different Inventory Methods

Pen and Paper

If you own a bar on a beach, and the bar is just a hut with a roof thatched from dried grass, and the beach is on a volcanic island that dots the Pacific Ocean, then taking inventory with a pen and paper is probably fine. If you’re not that exact bar then you need a better way to take inventory.

Pen and paper inventory is the least valuable form of beverage inventory. It’s disorganized, labor intensive, and does not provide any valuable data or insights into your business.

 

 

How to Take Bar and Liquor Inventory Guide Image of Spreadsheet to Record Inventory Counts

Spreadsheets for Inventory (Excel)

This is the most common method for recording and taking inventory because if you have a computer then you have access to a spreadsheet tool. But spreadsheets are cumbersome and take a lot f time and expertise to manage.

Pros

  • Accessible
  • Familiarity
  • Can customize and create formulas to calculate data

Cons

  • Labor intensive
  • Difficult to generate data
  • Not compatible with other software or hardware
  • Data not usually accessible from other devices

 

How to Take Bar and Liquor Inventory Image of Mobile Bar Inventory Software on Phone

Inventory Software or App

A quick google search will reveal that there are many inventory software services available for restaurants and bars. These platforms are generally focused on providing a simple interface for taking inventory counts and providing reports and and inventory analysis.

Here’s a sample overview of Uncorkd, one of the top bar inventory solutions available.

Pros:

  • Time saving counting interface
  • Easy set up
  • Mobile-friendly and can use on any device
  • Multiple people can count simultaneously
  • POS integration + Perpetual inventory
  • Dozens of pre-built reports
  • Distributor ordering platform
  • Digital menu compatible
  • Upload invoices to auto-record costs
  • Export all data and reports to spreadsheets

Cons

  • POS integration not available for all systems
  • Must identify bottle volume by sight for physical inventory
  • More expensive than spreadsheets (but still very affordable)

 

How to Take Bar and Liquor Inventory Guide Image of Barcode Scanner for Liquor Inventory

Barcode Scanners for Inventory

Another system for taking inventory is a barcode scanner. The scanner is used to identify the items in front of you to enter in the relevant inventory information.

Pros

  • No need to manually search items
  • Faster than spreadsheets

Cons

  • Not all items on-premise have barcodes
  • Generally must print out custom labels for bottles without barcodes
  • Lag on scanning technology in some cases
  • Problems with accurately identifying items
  • Must purchase and maintain additional scanner hardware
  • Limits number of people who can do inventory simultaneously to the number of scanners

 

How to Take Bar and Liquor Inventory Guide Image of Weight Scale for Taking Liquor and Bar Bottle Inventory

Weight Scales

Measuring bottles by weight can offer very accurate inventory counts. But a small weight difference isn’t the most important aspect of taking inventory. And splitting hairs on liquid volume doesn’t provide the insights into inventory necessary to increase profits.

Pros

  • Accuracy

Cons

  • Hardware costs
  • Multi-step process that requires you to weigh bottle and then record weight
  • Time consuming

Where to Start When Taking Inventory

It’s best practice to start in your bar or service areas as opposed to starting in storage areas. This makes sure you get an accurate count for bottles that will be sold first. We mentioned previously that it’s important to finish bar inventory between service so your numbers are most accurate. This is why starting in service is helpful. If you can’t finish inventory between service, then make sure to be vigilant about marking bottles that move from storage area to bar or from bar to bar.

How to Take Inventory Counts

Train Yourself and Staff
Consistency is key for taking inventory counts. Especially when it comes to open, or partial bottles. If you’re taking inventory counts by eye, then you will need to make sure you are consistent and to also train your staff to assess bottle volume with accuracy and consistency. The difference between considering a bottle to be .75  full and .8 full is negligible, but it’s important to call a .8 a .8 each time you see it.

Tips for Taking Wine Inventory
Wine inventory is very similar to spirit inventory when it comes to counting bottles. But there is an important difference: Open wine goes bad.

Throwing out bad wine can cost restaurants significant amounts of money. And it will drive up your pour costs for wine. For managing your wine inventory make sure to date open bottles. At the end of service, make sure staff records the date that the bottle was opened. This way, you know when the wine is no longer fit to sell, and you can take steps to sell that wine before it goes bad.

Pro Tip: You can also utilize old wine for cooking by giving it to the kitchen if it has been opened to long. 

Tips for Taking Beer Keg Inventory
Beer kegs can be difficult to track depletion for. To start, they’re super heavy. Secondly, unless your Superman and have x-ray vision, you can’t see through a keg. Here are two tips for taking more accurate beer keg inventory:

Perpetual Inventory: As mentioned above services like Uncorkd that can integrate with POS services can track perpetual inventory so you have a much better idea of how much beer is left in a keg.

Keg Scale: There are also keg scales available for weighing kegs. You can weigh the keg at the start and then weigh it again when taking inventory. This can be labor intensive and require multiple people to lift kegs. But if total accuracy is your main goal, then this is the best method for you.


What to do with your inventory data

Lowering Pour Costs

Data to use: Variance, inventory summary, slowest movers, sales trends

Reducing variance will help you lower your pour costs by generating more dollars for the volume sold. By identifying where the largest instances of variance are, you can take steps to control it at those points.

Inventory summary will give you the total inventory counts for the physical number of items as well as your dollar totals for inventory. Using these two metrics, bottle counts and dollar totals, you can asses the best ways to reduce pour costs.

Bottle counts can be reduced by putting items on special, utilizing ingredients in cocktails or for cooking, or ramping up the hand selling of items by your staff.

Total Value is really useful because you can identify the areas of your inventory that are taking the biggest hits on your cost of goods. You can also re-adjust your price points for items if its worth it to sell more items at smaller profit.

Loss leaders is a concept to consider when determining your pricing. A loss leader is an item that is sold under market price in order to capture customer attention and generate more sales from related items.

A good idea for a loss leader is a low cost cocktail that comes at a discount if ordered with certain food items. Or if you don’t serve food, selling a wine, beer, or spirit flight (sampler), where you can charge less per individual serving but generate a higher sale total from the sampler. Intelligently designed strategies like loss leaders can help lower pour costs by influencing what customers purchase.

Menu Engineering is designing your menus to promote high profit items so to influence customers to purchase them. You can analyze your highest performing items through inventory usage rates, profit margins, and sales trends.

Using this information you can make sure to place high profit items are as the most visible items on your menu by utilizing item placement, icons, bold fonts, or other call outs.

Services like Uncorkd’s digital menus provide menu analytics to track item and item type performance on menus.

Setting Item Pars

Data to Use: Inventory Usage Rate

Setting item pars is crucial to keep your orders under control and your inventory volume reasonable. By looking at your usage rate you can determine how much product you need on hand at a given time based on the pace that you pour through those items.

Pars will help you stick to ordering budgets and will also inform you of reasonable ways to reduce your costs like bulk purchases to that lower per bottle cost.

Determining Sales Potential

Data to use: Inventory summary and margin

It’s useful to determine your sales potential by taking the inventory on hand and calculating your potential profits. This sales forecasting can help you make decisions about how to spend your money today by determining what you expect to earn in the near future.


How inventory impacts ordering

How to Take Bar and Liquor Inventory Guide Image of Case Order from Liquor Distributor

Ordering and inventory are two sides of the same coin. And that coin is literally in your pocket (or bank account!). How you order liquor, wine, and beer has a big impact on your bar program’s bottom line.

Setting a Purchasing Budget

Data to Use: Inventory Usage Rate, Inventory Financial Summary

It’s important to have a purchasing budget in addition to setting item pars for your bar. Budgets will keep you from spending too much on inventory so you can make sure your stock is manageable.

The best type of budget to construct is called a Depreciating Budget. A depreciating budget begins with setting a limit on your spending. Because inventory counts are generally based on monthly periods, you can set a monthly purchasing budget.

Tracking Purchasing in Spreadsheet or App

In addition to taking inventory and recording individual purchases, you will also want to set up a separate liquor purchasing spreadsheet or tabs in the same bar inventory spreadsheet to record your purchases.

Smart Ways To Better Track Inventory

 

A big advantage of Uncorkd is that you don’t need to manage many different spreadsheets with lots of different tabs on each. All your data is stored in the Uncorkd and automatically calculated for you and presented in an easy to digest format, accessible from any device.

To track your purchases by distributor you simply navigate to the Spend History by Distributor report and select the date range you’d like to review to analyze purchases.

How to Take Bar and Liquor Inventory Guide Image of Uncorkd Inventory Platform Purchases by Distributor

Information to Track

  • Distributor or Vendor Name
  • Date of Invoice
  • Date of Payment
  • Invoice Total
  • Invoice Number
  • Check Number (if paying by check) or Transaction Reference Number from your bank

Your first budget amount can be based on the total inventory dollars you have and your sales numbers for a given period. You can find your pour cost this way.

You can then determine your expected sales for a month, and then make sure your purchases + current inventory on hand don’t account for more than 18-24% of that expected sales amount.

For example:

If you’re projecting $24,000 in liquor sales per week, and you keep your weekly purchases around $2,070 per week, then you should cap your spending at around $8,280 per month.

So $8,280 is your budget.

To make the depreciating budget work you will take the $8,280 budget number and subtract your liquor purchases each week from this number. As you move through the month, you will have a guideline to restrain from making unnecessary purchases. A goal should be to reduce your standing inventory to give you more spending power to purchase products you know will move across the bar.

Establishing Order Frequency

Data to Use: Inventory Usage Rate, Par Levels, Budget

Using these 3 data sets you can determine how often you should be ordering products. This may change depending on season, holidays, or special events.

Ordering Liquor by the Case or Bottle

Distributors and alcohol vendors have a complicated pricing system where the price of an item can change due to a host of different variables.

Case Break Fee

One of the most common ways that restaurants hurt their bottom line is by “breaking cases” to order individual bottles. Breaking cases will often come with an added case break fee.

For example, if a case of vodka comes with 12 bottles per case, then it’s more expensive to order 3 bottles per week, than to purchase the case up front and receive a month’s supply of that vodka.

Once you know how often you pour items and your budget, then you can determine which items to purchase by the case or bottle.

Case Discounts 

Restaurants and bars do have a level of control over their purchasing costs. Talk with your distributors to find which items offer the best case discounts. This is especially important for well liquors and other items with a high sales volume.

To illustrate this:

If your bar sells a lot of Old Fashioned cocktails, or you have a Friday night special on whiskey and ginger, then it would be beneficial to find a whiskey that distributors offer aggressive pricing on.

The best way to get significant price breaks on items is with the discounts you can leverage through volume purchases. You might be able to drop the price per bottle by $5 or more if you purchase 3 cases of a whiskey at one time, instead of ordering a case every other week.

And if you know you will sell through those 3 cases in a month or 2, then you won’t be worried about over ordering and your profits per drink sold will be higher for that whiskey.

Leveraging Distributors

You can also come to your distributors to set up deal specials if you are consistently bringing them good business.

Take a look at your spend with each distributor to see who you purchase the most from. Then determine which items you purchase most often. Talk to your distributors to get better deals for the items you buy and sell the most.

The larger the distributors and brands you order from, the more room you have to negotiate discounts. Small or boutique distributors often have less room to negotiate deals.

Process for Receiving Orders

It’s important to make sure that you are vigilant when it comes to receiving orders. Here’s a checklist for what information you should record when orders are delivered.

  • Check your order against the delivery
    • Make sure what you ordered was delivered, and note if the distributors sent any additional bottles
  • Record all received products into a spreadsheet (as mentioned above)
  • Enter costs for each item from your invoice
  • Save invoice (can be digitally saved with Uncorkd)
  • Stay organized

Biggest mistakes restaurants and bars make

Too many bars and restaurants don’t take inventory seriously.

Not Conducting Regular Inventory
Some restaurants don’t even conduct inventory, or only do it several times a year. That is the biggest mistake a venue can make. It’s important to understand the health of your inventory in order to establish a successful beverage program.

Bad Ordering Habits
Businesses get in trouble when they aren’t disciplined with their purchasing. They end up with an ever-growing array of different products, often times sitting in storage and never even making it to the bar. It may be they wanted to offer the newest flavored whiskey, or someone personally liked a new wine so they decided to buy it, and these types of purchasing habits cascade over time, until you have far more inventory than necessary.

Not Tracking Pour Costs and Analyzing Data
As illustrated in this guide, inventory is about much more than counting bottles. It’s necessary to measure and analyze beverage data to make informed decisions. The most successful restaurateurs in the world are very data-driven to maximize profits in an industry with slim margins.


Analyzing and Optimizing Your Beverage Program

Let’s recap what we’ve discussed above.

We know that taking inventory is crucial for successful restaurants and bars. And that the data you track and record will help you run a more efficient business, and give you the information needed to make confident decisions. Let’s recap what we’ve discussed above.

Inventory Checklist

What to monitor and look for

  • Inventory Value
    • Track the total value you have in inventory and work to reduce that number
  • Inventory Usage Rate
    • Identify how often you are pouring through products to determine order frequency and sales behavior
  • Determine Pour Costs
    • Work to lower your pour costs to generate higher profits
  • Identify Variance
    • Track perpetual inventory and variance to reduce lost profits
  • Understand Sales Trends
    • Understand your business and what your customers are likely to purchase at your venue
  • Business Trends
    • Track seasonal habits, the impact that events have on sales, and overall industry trends that you can capitalize on

How to optimize your beverage program

  • Maintain a consistent inventory system
    • Generate important data, record purchases, track sales
  • Sell down overstock inventory
    • Put items on special, utilize product in cocktails and the kitchen, engineer your menu, establish loss leaders
  • Set item pars
    • Determine how much of each item you need in stock to satisfy customer demand
  • Construct and adhere to a purchasing budget
    • Build a budget with a goal to reduce your inventory totals and leverage distributors for better pricing
Kyle Thacker

Kyle Thacker

Kyle handles marketing and PR for Uncorkd. Aside from bartending and restaurant management, he's covered the Chicago dining scene as a freelance writer. He enjoys Miller High Life and getting yelled at by Chicagoans for supporting Boston sport's teams.
Kyle Thacker