A bar count sheet that matches your shelves

A bar inventory count sheet lists every bottle, keg and case in the order it sits in your bar, with columns for size, full units, the partial bottle in tenths, total on hand and unit cost. Count at the same time each week, before the bar opens, and work out usage as last count plus deliveries minus this count.

That is the whole idea. Most count sheets fail because of the layout and the routine, not the maths. Below is a template you can copy into a spreadsheet tonight, how to fill it in, and what to do with the numbers once you have them.

The columns your count sheet needs

Keep the sheet narrow enough to print on one page per storage area. Every extra column is something a tired bartender has to fill in at the end of a shift. These are the ones that earn their place:

• ✓Location: back bar, speed rail, well, walk-in, liquor room, keg cooler. One section per physical area.
• ✓Item: the product name exactly as it appears on the invoice, so receiving and counting use the same words.
• ✓Size: the bottle or container size as a unit (750, litre, 1.75, half barrel, case of 24).
• ✓Full: unopened units in this location.
• ✓Partial: the open bottle in tenths, written as a decimal (0.4, 0.7). Blank if none.
• ✓Total: full plus partial.
• ✓Unit cost: the last price you paid per bottle, keg or case.
• ✓Value: total times unit cost.
• ✓Par: how many you want on hand after a delivery.
• ✓Order: par minus total, rounded to how your vendor sells it.

Two columns most templates add, and you can skip: a description and a category code. Sort by location and shelf instead. The person counting needs to know where the next bottle is, not what category it belongs to.

Lay the sheet out in shelf order, not alphabetical order

An alphabetical sheet makes the counter walk back and forth across the bar, and that is where bottles get skipped or counted twice. Build the sheet by standing at the bar with a clipboard and writing down what you see, left to right, top shelf to bottom, then the speed rail, then the wells, then storage.

Here is how one section of a plain-text template looks once it is laid out. Copy the pattern for each area:

• ✓BACK BAR, TOP SHELF, LEFT TO RIGHT
• ✓Item | Size | Full | Partial | Total | Unit cost | Value | Par | Order
• ✓Single malt A | 750 | 2 | 0.3 | 2.3 | | | 3 |
• ✓Single malt B | 750 | 1 | 0.8 | 1.8 | | | 2 |
• ✓Aged rum | 750 | 0 | 0.5 | 0.5 | | | 2 |
• ✓SPEED RAIL
• ✓House vodka | litre | 0 | 0.6 | 0.6 | | | | (counted with storage)
• ✓KEG COOLER
• ✓House lager | half barrel | 2 | 0.5 | 2.5 | | | 4 |

When you reorganise a shelf, change the sheet the same day. A sheet that no longer matches the bar is worse than no sheet, because people start counting from memory.

Counting partial bottles and kegs consistently

The tenths method is the standard because it is fast and good enough. Hold the bottle at eye level, imagine it split into ten bands from the shoulder to the base, and write the band the liquid reaches. Odd-shaped bottles fool people, so agree on a few reference bottles for the awkward ones and keep a note of them at the top of the sheet.

For the bottles that matter most, the expensive ones and the house pours you go through fastest, some bars weigh instead. You weigh a full bottle and an empty one once, write both on the sheet, and then each partial is a simple subtraction. It takes longer, so most bars weigh a short list and use tenths for everything else.

Kegs are harder to count by eye. Whatever method you use, use the same one every week and write it on the sheet. A consistent rough method tells you more over time than a precise method used one week and skipped the next.

Turning the count into usage you can act on

A count on its own only tells you what is on the shelf. The useful number is usage, and it needs three things on paper: last week's closing count, everything received since, and this week's count.

Usage for an item = last count + received - this count. Do it per item, then multiply by unit cost to get the value of what left the shelf. Add a received column to the sheet, or staple the week's invoices to it, so nobody has to hunt for delivery paperwork on Monday morning.

Then compare usage with what you rang. If the bar used three bottles of a whiskey and the sales only account for a bit over two, that gap is the conversation: overpouring, an untracked comp, a spill, a bottle moved to the kitchen, or a delivery never logged. The pour cost guide covers how to chase those gaps. The count sheet's job is to make the gap visible every week, item by item.

• ✓Look at the largest gaps by value first, not by bottle count.
• ✓Check receiving before you blame the bar: a missing invoice explains a lot.
• ✓Write the likely cause next to the item and see if it repeats next week.
• ✓Adjust par after two or three weeks of real usage, not after one busy weekend.

How often to count, and who should do it

A full count once a week, on the same day, is the rhythm most bars can keep. Pick the day before your main order goes in, so the order column on the sheet becomes the order you send. Monthly counts are fine for the accounts but too slow to catch a problem while you still remember the week it happened.

Between full counts, some bars spot-count a short list of high-value bottles every night at close. It takes a few minutes and keeps the expensive shelf honest without turning every close into an inventory night.

Rotate who counts. The same person counting the same bar every week will eventually count what they expect to see. Pairing a manager with a bartender on the full count is a reasonable middle ground: the bartender knows where everything is, and the manager owns the number.

Where Opero fits, and what still lives on paper

On Opero Full-Service ($249 per location), each bottle, keg or case can be set up as an ingredient with its unit, barcode, vendor and cost, and each location keeps its own stock count with a par level and a reorder point. Changes to stock go into an audited ledger, and stock is drawn down automatically when a drink sells on any channel, as long as the drink has a recipe. Voided or cancelled orders put stock back. Refunds do not, so a refunded drink still shows as used.

A few honest limits shape how you use it. There are no count sessions and no count history screen, so keep your dated paper or spreadsheet sheets as the weekly record and enter the result. Recipe costing does not convert units, so set each recipe in the same unit you stock the item in. Reorder suggestions are grouped by vendor and can become a purchase order, but nothing forecasts demand for you. Food and beverage cost in the Command Center is only as good as the recipes and received costs behind it. Inventory is not on the $149 Opero plan.