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.
