Simplify inventory with our free bar inventory template

Are you having trouble creating a spreadsheet to track bar inventory? Backbar is here to help.


It can be difficult to know what information to track and how to set up your template, especially if excel spreadsheets aren't your thing.


Our template will keep you organized and give you more control over spirits, beer, and wine so you can track performance and costs to strengthen your bar.

Graphic of an inventory spreadsheet

Backbar is a better way to manage restaurant inventory


Rather than using spreadsheets, try using Backbar, the free-forever restaurant inventory software. Backbar is a cloud-based platform to manage your entire beverage program, from inventory to ordering to staff training.

  • Use our mobile app to take inventory faster and enable others to count with you simultaneously.
  • Cut the time it takes to put together and place your weekly orders, and track your spending. Utilize our extensive wine, beer and spirits database to train your waitstaff and bartenders with tasting notes, images and producer information.
  • Staff can access drink information right from their own phones.


Try Backbar's free inventory app



What you'll find in our inventory template



Bar and liquor inventory is a headache for every bar manager and bartender tasked with taking bottle counts. But this spreadsheet will help you manage inventory to maintain a profitable program that focuses on profits and high performance. Here's the value this spreadsheet provides:


  • Record inventory counts
  • Record counts by location
  • Input purchases
  • Track costs by unit and per ounce
  • Highlight items below par
  • See your inventory totals by dollars and volume