Skip to content

Bar Inventory Spreadsheet: Tenths, Pars, Pour Cost

A bar inventory spreadsheet: bottles counted in tenths, a par for each bottle, pour cost from what was used, missing pours, and dates on juice and vermouth.

By Koa Sterling. Product specialist at TaroStack and small business owner. Yes, I am a real human, and I actually sit in front of a computer and write these articles. Reviewed November 21, 2026 · 6 min read

A bar's stock is half-empty bottles, so a bar inventory spreadsheet counts in tenths: 6.4 bottles of vodka is six full ones and one a little under half. Every bottle has a row with what it cost and a par, the level at which it goes on the order. Counted the same way on the same day each week, the sheet gives you two numbers a bar lives on. Pour cost: what you used, as a share of what you sold. And missing pours: the difference between what left the bottles and what the register rang. Juice, syrups and opened vermouth also need dates. Below is a sheet for a made-up bar on a Friday, the two sums, and the file.

The short version

  • Count open bottles in tenths, by eye, the same person each week.
  • A row and a par for every bottle, beer and mixer.
  • Used = opening stock + deliveries − closing stock.
  • Pour cost = used ÷ sales. Missing pours = used − rung.
  • Fresh juice, syrup and opened vermouth get dates.
  • TaroStack counts on a phone and shows what a difference is worth. More below.

An example sheet

Item Unit On hand Reorder at Unit cost Value Status
Vodka, well, 1 L bottle 6.4 6 $14.50 $92.80 OK
Bourbon, well, 1 L bottle 4.2 5 $18.00 $75.60 REORDER
Tequila, blanco, 750 mL bottle 5.5 4 $24.00 $132.00 OK
Gin, London dry, 750 mL bottle 3.1 3 $21.00 $65.10 OK
Single malt Scotch, 750 mL bottle 1.6 1 $52.00 $83.20 OK
Triple sec, 1 L bottle 2.3 2 $9.50 $21.85 OK

Twelve rows in all, $970.05 behind the bar and in the store room, with three to reorder: well bourbon, sweet vermouth and fresh lime juice.

Counting in tenths

Hold the bottle at eye level and call the level: full is 1.0, half is 0.5, a finger left is 0.1. Add the full bottles in the store room. It takes a minute a bottle the first time and seconds after that.

Tenths are accurate enough. A tenth of a liter bottle is about two pours, and you're looking for a missing bottle, not a missing sip. What matters more is consistency: the same person, the same day, before opening or after close, with the speed rail, the back bar and the store room counted in the same order every time. Kegs are counted in the same way, by weight or by a keg gauge: see keg inventory spreadsheet.

Pour cost

Pour cost is what you used, divided by what you sold.

This bar's week
Opening stock, last Friday's count $1,105.00
Deliveries in the week $1,062.00
Closing stock, this Friday's count $970.05
Used $1,196.95
Drink sales $5,440.00
Pour cost 22.0%

The sum only works with two counts and every delivery written down. One number on its own means little. The same bar's number week after week is what tells you something changed: a price went up, a bartender's pour got longer, or a new cocktail costs more than its price allows.

Missing pours

The register knows how many bourbons were rung. The bottles know how many were poured.

Well bourbon, this week
Opening, bottles 6.0
Delivered 6.0
Closing 4.2
Used 7.8 bottles
Pours in a 1 L bottle at 1.5 oz 22.5
Poured 175.5
Rung 152
Missing 23.5 pours, about one bottle

One bottle of well bourbon is $18 at cost and about $164 at the bar's $7 a pour. Missing pours have ordinary causes: free pours running long, comps and spills nobody wrote down, a drink rung as something cheaper. Start with a jigger and a comp sheet before suspecting anything else. Do this sum for your five busiest bottles each week, not all sixty.

What has a date

Spirits keep. These don't:

  • Fresh citrus juice: a day or two. Squeeze to the day's need.
  • House syrups: weeks in the cooler, less with fruit in them.
  • Vermouth and other wine-based bottles: once opened, keep them cold and date them. This bar uses four weeks.
  • Kegs: the brewery's date on the collar, and the day it was tapped.

The sheet's second tab lists these with a use-by date and flags what's close. Batched cocktails are worked out in batch cocktail calculator. A shop that sells sealed bottles counts differently: see liquor store inventory. Pars are explained in par level vs reorder point.

Get the spreadsheet

Download the bar inventory spreadsheet. Four sheets: inventory with value and REORDER, dated items with days left, a count sheet that works out each difference and what it's worth, and a read-me. It's an ordinary Excel file with no macros, and it works in Google Sheets, LibreOffice and Numbers.

Where this stops working

Sixty bottles, counted in tenths, typed into a sheet at one in the morning. Then last week's file has to be found for the opening numbers, the three invoices added up, and the bourbon sum done by hand. Most weeks that doesn't happen, and the count becomes a list of what to order. A bourbon order that doubles while bourbon sales don't goes unexplained for a month.

How TaroStack does it

TaroStack keeps last week's count, this week's deliveries and tonight's count in one place.

Count on a phone, behind the bar, with no signal. Open bottles go in as decimals.

A count shows what each difference is worth, bottle by bottle, in dollars.

Deliveries are received against the order, or without one, at the invoice price, so the week's purchases are already there.

A reorder list from each bottle's level, with each distributor's minimum.

A price-creep report by supplier shows a bottle's cost moving before the menu price is wrong.

The job Spreadsheet In TaroStack
Last week's closing count Find the file Already the opening
The week's deliveries Add up invoices Received as they came
What a short bottle is worth A sum by hand On the count
What to order Read down the sheet The reorder list

TaroStack doesn't measure pours or read drink counts from your register. It connects to Square. Stock, counts and reordering are on every plan, from $9.99 a month. The first 14 days are free, with no credit card. If you'd like a hand setting up, ask, and we'll do it with you.

Questions people also ask

How do you do a bar inventory?

Count every bottle on the same day each week, open ones in tenths, and write down every delivery. Opening stock plus deliveries less closing stock is what you used.

How do you calculate pour cost?

Divide the cost of what was used in a period by the drink sales for the same period. In this example $1,196.95 used against $5,440 of sales is 22.0%.

How many pours are in a bottle?

At 1.5 ounces a pour, a 750 mL bottle holds about 17 and a 1 L bottle about 22.

We use AI to help with the research for these articles. Every one is read, checked against its sources and edited by Koa before it's published. Spot a mistake? Tell us and we'll fix it and say so. How we write these.

Let’s get your stack in order.

Get TaroStack

Sign up now for your free 14 day trial. No credit card required.