Bar Inventory Spreadsheet Template

This free bar inventory spreadsheet template can be your hub for performing bar inventory counts. A highly functional spreadsheet that helps you record, track, and analyze your liquor inventory.
Illustration for bar inventory spreadsheet template with liquor bottles and a spreadsheet

Free Bar Inventory Spreadsheet 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