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.

Bar Inventory Spreadsheet Template

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