Wine is easy to count and easy to get wrong, because two bottles that look the same aren't. A wine inventory spreadsheet has a row for each wine and vintage: the 2023 and the 2024 of one Chardonnay cost differently and may sell at different prices, so they're two rows. Each row has a bin or shelf, the bottles on hand, what a bottle cost, and a par, the number you want on hand before the weekend. A restaurant or wine bar adds one more job. Wine poured by the glass leaves in fifths of a bottle, so open bottles are counted in tenths and compared with what the till says was sold. Below is a sheet for a made-up wine bar, the by-the-glass sums, and the file. A winery's own stock, in tanks and barrels, is a different sheet: see winery inventory spreadsheet.
The short version
- One row for each wine and vintage. A new vintage is a new row.
- Give every row a bin or shelf, and list the rows in walking order.
- Reorder at the par: what you want on hand going into your busiest days.
- A 750 ml bottle is five 5 oz glasses.
- Count open bottles in tenths.
- Compare bottles used with bottles sold. The gap is over-pours, comps and breakage.
- TaroStack keeps stock by place and counts it on a phone. More below.
An example sheet
Counted on a Monday before opening.
| Item | Unit | On hand | Reorder at | Unit cost | Value | Status |
|---|---|---|---|---|---|---|
| Pinot Noir, Willamette Valley 2022 | bottle | 18 | 12 | $21.00 | $378.00 | OK |
| Cabernet Sauvignon, Napa 2020 | bottle | 9 | 12 | $46.00 | $414.00 | REORDER |
| Chianti Classico 2021 | bottle | 14 | 12 | $17.50 | $245.00 | OK |
| Sauvignon Blanc, Marlborough 2024 | bottle | 22 | 18 | $12.00 | $264.00 | OK |
| Chardonnay, Sonoma 2023 | bottle | 16 | 12 | $19.00 | $304.00 | OK |
| Riesling, Mosel 2023 | bottle | 7 | 6 | $16.00 | $112.00 | OK |
Ten rows in all, $2,461.00 at cost, with four to reorder: the Cabernet, the Prosecco, the Champagne and the rosé. Reds are $1,037.00 of it, whites $680.00, sparkling $494.00.
Vintages. When the distributor's delivery brings the 2024 where the 2023 used to be, add a row. Don't overwrite the old one. The list price may need to change, the cost almost certainly did, and a guest who ordered the 2023 should be told. The file's deliveries sheet has a note column for exactly this.
Bins. A bin number on the row and on the shelf turns a count from a search into a walk. It also lets someone who doesn't know the wines pull the right bottle.
Par. The reorder level is this bar's par for each wine, set from what a busy week sells. Nine bottles of the Cabernet against a par of twelve is a reorder, even though nine sounds like plenty. The difference between a par and a reorder point is in par level vs reorder point.
By the glass
| Sauvignon Blanc | House red, 3 L box | |
|---|---|---|
| Size | 750 ml, 25.4 oz | 3 L, 101.4 oz |
| Glasses at 5 oz | 5 | 20 |
| Cost | $12.00 | $24.00 |
| Cost a glass | $2.40 | $1.20 |
| Price a glass | $12.00 | $9.00 |
| Pour cost | 20.0% | 13.3% |
The prices are this bar's own. The sum is what carries over: a bottle's cost divided by the glasses it pours. A 6 oz pour gets four glasses from the same bottle, and the cost a glass goes from $2.40 to $3.00. Setting list prices is in how to price a wine list.
Open bottles are counted in tenths: a bottle with two glasses gone is 0.6. It feels fussy and it matters, because the by-the-glass wines are the ones that move.
Used against sold
Once a month, for each wine by the glass:
| Sauvignon Blanc | Bottles |
|---|---|
| Opening count | 14.0 |
| Received | 24.0 |
| Closing count | 22.0 |
| Used: opening + received − closing | 16.0 |
| Sold, from the till: 62 glasses and 3 bottles | 15.4 |
| Difference | 0.6 |
Sixty-two glasses is 12.4 bottles at five to the bottle, plus three sold whole. The 0.6 of a bottle that was used and not sold is three glasses, $7.20 at cost: a heavy pour here, a taste for a regular there. A small gap is the cost of hospitality. A gap that grows is worth watching a shift for. The same check for spirits is in bar inventory spreadsheet, and for a shop in liquor store inventory.
Get the spreadsheet
Download the wine inventory spreadsheet. Four sheets: inventory with value and REORDER, deliveries by invoice with a note for vintage changes, 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
A list of ten wines fits a sheet. A list of eighty, across a cellar, a cooler and the bar, with vintages rolling over through the year, is three counts and a lot of retyping. The sheet is right on Monday. On Saturday night the server finds out the Cabernet is gone by walking to bin 14.
How TaroStack does it
TaroStack keeps each place's stock, between counts.
Stock is held by location: the cellar, the cooler and the bar each have their own quantity.
Receiving adds each delivery, with or without a purchase order, at the price on that invoice.
Counting works on a phone with no signal, in a cellar. A count shows what each difference is worth.
A reorder list in days of cover, with each distributor's lead time and minimum.
Every adjustment carries a reason: corked, broken, comped.
| The job | Spreadsheet | In TaroStack |
|---|---|---|
| What's in the cellar and what's at the bar | One number, or two tabs | Stock by location |
| What a bottle costs now | The last price typed | From the last delivery |
| What the count found | Typed in afterward | Counted on the phone, valued |
| What to order from each distributor | Rows under par | A reorder list by supplier |
TaroStack doesn't run the till or count glasses poured. It connects to Square. Stock, counts, receiving and reordering are on every plan, from $9.99 a month (50 items) or $39 a month (3,000 items). 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.
