free bar inventory spreadsheet

Free Bar Inventory Spreadsheet

Looking for a free bar inventory spreadsheet for counting your bar inventory? I gotchu!

We’re all aware that counting your liquor inventory is about as much fun as trying to carve a pound of flesh from your thighs with a fork.

And yet, it needs to be done in order for you to run a successful business. That inventory that you “hate” is actually your profits. There’s gold in them there bottles, and if you casually stock your alcohol and put no effort into tracking where it’s going, then you should be flogged with a wet rope.

Sorry, that was a bit harsh, but you get the point. Stop being a bar owner (manager) and start being a business owner (manager).

The Fastest Way to Increase Your Bar Profits

Anything worth doing is worth doing right, and though counting and tracking your bar inventory can be tedious, it is worth it’s weight in gold.

The average bar loses more than $60,000 per year because of bartender over-pours.

By simply tracking where it’s going, and letting the bartenders know that you are tracking their pours, you can instantly increase your profits.

In fact, if you use a spot-checking method, you can count just a few of your most popular products in 5 – 10 minutes and track how individual bartenders are pouring, which is just as powerful in reducing over-pours, and it’s practically painless for you because you don’t have to count a full inventory.

You can click here to learn how to spot-check your bartenders in 10 minutes flat.

Using a Spreadsheet to Count Your Bar Inventory

Now, unless you have a super-complex spreadsheet built by an Excel engineer, you won’t be able to accurately track your bartender pours easily. However, you can take basic inventory counts to determine your sitting inventory, which will allow you to determine your pour cost percentage. Which is good.

In the end, using a spreadsheet is far more tedious and time-consuming than a quality bar inventory system, but sometimes you just need to start from scratch and learn the basics first, which is fine.

Or maybe you’re just a flat out meat-and-potatoes type of person, which is fine too.

When you’re ready to upgrade and increase your bar profits, Bar Patrol Inventory App only costs $1.61 per day to have a cutting-edge system in house to count faster, easier, track your bartender pours down to the 1/100th of an oz., do your ordering and invoicing, etc. etc.

But until you’re ready for that, let’s get to your free bar inventory spreadsheet I promised you.

Give Me the Free Template Already

Ok, here you go. There are a thousand different bar inventory templates out there that do and calculate different things. This particular template has these components:

  • Broken into 5 catgories: Bottled Beer, Draft Beer, Liquor, Wine & Miscellaneous Bar Items
  • Enter ordering pricing by the unit or the case
  • Enter counting by the unit or case
  • Automatically calculates total costs for each individual product
  • Automatically calculates total sitting inventory in dollar amount
  • Provides summary breakdown of each category (see snapshot below)
bar inventory spreadsheet

Hopefully this helps you get a handle on your bar inventory, or at least gets you started. I wish you the very best. Thanks for stopping by.

Click below to get your free template.

free bar inventory spreadsheet

See you next time,

Dave

Join 5,000+ bar managrs

Sign-Up to Get Awesome Tips, Tricks and Advice on How to Run a Mega-Successful Bar.