Skip to content
Bar Inventory cover: a sample sheet with bottles counted, value left on the shelf and ounces left and a bar chart, beside the Dashboard, Bottles and Pours tabs

Bar Inventory

Spreadsheet template for Google Sheets and Excel

Make a copy in Google Sheets
Price
Free
Slides
5
Style
Bold
Difficulty
Beginner
Updated
November 13, 2026

Every slide (5)

Overview

This template is for bar managers, bartenders and owners who count spirits, wine and liqueurs on a regular basis. The Bottles tab holds one row per bottle with its category, size, cost, par and the share left. Ounces left and value left calculate from those figures. The Pours grid counts the shots poured for each drink from Monday to Sunday, with row and column totals. The Dashboard shows the value and ounces on the shelf by category.

Estimate how full each bottle is as a percentage, then type that figure in the Left in bottle column. Use the same method at every count so the figures compare fairly. Count pours at the end of each shift to keep the grid accurate. The Bottles under half figure on the Dashboard tells you which bottles to check first. Compare value left with last month's total to spot stock that has gone missing.

Useful for

  • Counting spirits and wine every Sunday night
  • Comparing pours with the bottles that were used
  • Working out how much stock is tied up on the shelf

What's included

  • 4 tabs: Dashboard, Bottles, Pours, How to use
  • Dashboard: a dashboard with 4 summary figures
  • Bottles: a table
  • Pours: a grid
  • 1 chart that update as you type
  • Formulas, dropdowns and colour rules already set up
  • Sample rows that show how to fill it in

How to use it

  1. 1

    Click Make a copy in Google Sheets, then confirm on the Google page. The copy is saved to your own Google Drive.

  2. 2

    Start on the Bottles tab: replace the sample rows with your own.

  3. 3

    Keep the formula columns as they are; they fill in as you type.

  4. 4

    Read the How to use tab for tips. For Excel, download the .xlsx file instead.

What you need

Requirements

  • A Google account, or Microsoft Excel for the download

Works with

  • Google Sheets
  • Microsoft Excel (download the .xlsx)

Questions

How accurate is estimating a bottle by eye?

Eyeballing a bottle is quick but rough, so the figure is only a guide. To improve it, weigh a full bottle and an empty one, then weigh each open bottle and work out the share left from the difference. Use the same method each time you count.

How do I turn the ounces into shots?

A standard US shot is 1.5 fluid ounces. Divide the ounces left by 1.5 to estimate how many shots remain in a bottle. The sheet keeps ounces in the Ounces left column, so you can check that figure against the pour count.

Can I count sealed bottles as well as open ones?

Yes. Put each bottle on its own row. For a sealed bottle, set Left in bottle to 100 percent and count it with the rest. Keep a separate row for each bottle size you stock, since a 1-liter bottle holds more than a 750 ml one.

  • #inventory
  • #bar-inventory
  • #google-sheets
  • #excel
  • #spreadsheet-template
  • #free-template

More inventory templates

See all 19

Also in Business operations

All business operations templates
Get this template

Preparing your template…