English
It ends up on a notepad, in a photo on somebody's phone, or typed into the wrong field of a system nobody opens again. The counting was never the problem — the count had nowhere to land.
The Bar Inventory Count Sheet is the place it lands. It is not an inventory system and it is not trying to replace one. It is eight columns, arranged so that two counts taken a week apart can actually be subtracted from one another.
Eight columns, and deliberately not a ninth. Section, product to the format, vendor item, pack size, count unit, count, par, and who counted it. Most sheets carry half of these, and the missing half is usually why the numbers never reconcile.
The vendor item column, which most sheets skip. It is what puts a purchase price behind the line. A count with no price behind it is a quantity, not an inventory — it produces no value, no usage and no variance, however carefully it was taken.
The count unit column, which is the one that saves the evening. A beer arrives on the invoice by the 24-can case, sells by the can, and sits under the bar as both. Record a case as a case and a loose can as a can, and let the arithmetic happen somewhere other than in your head at eleven at night. Products that live in both states get a second unit of their own.
One sheet per section, not one sheet per venue. The same beer at three bars is three numbers, not one total — and a sheet that cannot hold that is a sheet that quietly loses stock between rooms.
Partial bottles, counted in tenths. Record 0.4 or 0.7 rather than "about half", agree your sight lines once with whoever else counts, and use the same ones every week. Consistency between counts matters more than accuracy within any one of them.
Two formats, because counting and reporting are different jobs. A printable sheet for the clipboard at the bar, and a spreadsheet with filters, a frozen header and 400 rows for the office.
Order the rows sheet-to-shelf — the way you physically walk the room, left to right along the back bar, then the cooler, then the liquor room — or by category, grouping beer, wine and spirits wherever they sit. Sheet-to-shelf is faster to count and matches what your eyes do. Category order is easier to read afterwards and easier to hand to an accountant.
Pick one, write it at the top of the sheet, and do not change it between counts. Two counts taken in different orders are not comparable, and the comparison is the entire point.
Bar managers who count by hand and want the count to survive the walk back to the office. Owner-operators building out a back bar who would rather start with a method than inherit one. And anyone who has just taken over a bar and discovered that the last person's counting system left with them.
Prefer a spreadsheet? Download the same eight columns as an Excel file — filters on, header frozen, 400 rows.
Download the sheet — no email, no form — and print one per section before your next count.
Counting by hand works until it doesn't. When it stops working, Opsi Restaurant Intelligence — GoTab's back-of-house platform — builds the count guides, pulls purchase prices straight off your invoices and reports the variance for you.
