Most bars already count. That is worth saying first, because the usual framing — that operators do not take inventory seriously — is wrong, and insulting to anyone doing the job at midnight with a clipboard.
The problem is what happens to the count afterwards.
A bar manager at a venue that counts three bars and a liquor room separately described her last count to us:
"I think I took pictures of everything too."
"I believe I still have it in my locker at work and I should have pictures of them."
Nothing went wrong. The count happened. It just never reached anything that could subtract one week from the next. A bar POS tells you what sold; it cannot tell you what is left. A free count sheet fixes that — this post is about the eight columns it needs.
Every can, every case, every keg, across three bars, a liquor room and a walk-in, counted the week before with the outgoing manager. The work was done. It was sitting on paper in a locker and in photographs on a phone, which is the same as not having been done at all, and that is the gap this sheet exists to close.
Count unit
A count unit is the measure you record a product in when you count it — a can, a case, a bottle, a keg, a jug. It is not the same as the unit you bought it in, and it is not the same as the unit you sell it in. A beer can arrive by the 24-can case, sell by the can, and be counted either way depending on whether it is stacked or loose. A product can carry more than one count unit at the same time, and a good sheet lets you switch between them mid-count without doing arithmetic.
How Do You Do Bar Inventory?
Count every open and unopened container of beer, wine and spirits in every place you keep them — back bar, cooler, liquor room, storeroom — and record each one against the unit you bought it in. Do it on the same day of the week, in the same order, every time. The order matters more than the day.
That is the whole method. What makes it work or fail is the sheet you write it on.
If you want the reasoning behind how often to count, what a par level is, and how to read the gap between what sold and what is left, our brewery inventory guide covers it and this post will not repeat it. What follows is the mechanical half: the units, the bottles, and the columns.
What Units Should You Count In — Bottles, Cases or Kegs?
Count in whatever unit is physically in front of you. A beer arrives on the invoice by the 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 system convert. Converting in your head is where counts go wrong.
Asked whether she wanted her sheet broken out by area, by brand or by category, the same bar manager answered without hesitating:
"I just counted all the cans."
"That seems a little easier for me to just count, like how many cans we have in each section."
She is right, and it is worth saying plainly because most inventory advice implies otherwise. The best count unit is the one the person counting will actually say out loud while holding the thing. Not the one that is tidiest in a spreadsheet.
She also said the part that most sheets have no answer for:
"So I would say for me cans. But there might be someone, like in the future who takes this over and might want it a different way."
That is the argument for writing the method down rather than carrying it in your head. Whoever counts next inherits your sheet, and if the sheet does not say how you counted, they will invent their own way and the two weeks will not be comparable.
Products that live in both states — stacked by the case under the bar, loose in the cooler — need two units on the same line. One column for each, so nobody has to divide by twenty-four at eleven at night.
How Do You Count Liquor Bottles for Inventory?
Count sealed bottles as whole units, by product and by size, in each location separately. A 750 ml and a litre of the same gin are two lines, not one. Count the back bar and the liquor room as different sections, because the same bottle in two places is two numbers, not one total.
This is the rule that single-sheet templates get wrong, and it is not a small error. One house gin behind three different bars is three separate numbers. Add them into a single line and you have lost the ability to tell which bar is running dry, which one is over-ordering, and which one has a problem.
How Do You Measure Liquor Bottles for Inventory?
By eye, in tenths. Hold the bottle up, judge the level against the shoulder and the base, and record 0.4 or 0.7 rather than "about half". Agree the sight lines once, with whoever else counts, and use the same ones every week. Consistency between counts matters more than accuracy within one.
Two people counting the same shelf will produce two different numbers. That is normal and it is not a failure of either person. What matters is that the same person, or people who have agreed the same sight lines, produce numbers that move consistently from week to week. A count that is reliably five per cent generous is far more useful than one that is sometimes exact and sometimes not.
How Do You Weigh Liquor Bottles for Inventory?
Put the bottle on a scale, subtract the empty bottle's weight, and divide what is left by the weight of a full pour. It is the accurate method and the slow one. Weigh the twenty products that carry your money and eyeball the rest — a whole bar weighed is a count nobody repeats.
The scale is not the point. Finishing is the point. The most accurate counting method in the world is worthless if it turns a forty-minute job into a two-hour one and quietly stops happening in March.
How Do You Make a Liquor Inventory Spreadsheet?
Start with one row per product per format per location, then add the columns in the list below. The common mistake is one row per product: a beer that comes in cans and kegs is two rows, and the same beer at two bars is two more. Download the template rather than rebuilding it.
The eight columns a bar inventory sheet needs
- Section. Where the product physically lives — main bar, second bar, patio bar, liquor room, walk-in, storeroom. One product in three bars is three rows.
- Product, to the format. Name plus container plus size. Cans and kegs of the same beer are separate lines, because the invoice separates them and the price per unit differs.
- Vendor item. The purchase record the line maps to. Without it the line has no cost, and a count with no cost is a quantity, not an inventory — it produces no value, no usage and no variance.
- Pack size. How many sell-units are in the purchase unit. This is the number that lets a case become 24 cans without anyone doing the sum.
- Count unit, and a second one where it earns its place. The unit you will actually say out loud standing in front of it. Allow two for the products that live in both states.
- Count. One field, filled on the night, in the unit chosen. Not a cost, not a value.
- Par. The level you reorder at, per product per section.
- Date and counter. Who counted and when. This is what makes a count auditable, and what lets the next person inherit the method instead of inventing one.
Do not add a ninth column. The pull will be toward cost, value and variance. All three belong somewhere else, and a sheet that tries to be a ledger is a sheet that takes too long to fill in.
Sheet-to-shelf, or by category?
The sheet forces one decision and it is better to make it deliberately than to drift into it.
Sheet-to-shelf orders the rows the way you walk the room — left to right along the back bar, then the cooler, then the liquor room. It is faster to count and it matches what your eyes are already doing.
Category order groups beer, wine and spirits regardless of where they sit. It 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.
One more failure worth naming
The same manager told us what had happened to her previous count:
"Last week when I had did it, I was going actually under the inventory where it's like, hey, how many, like the 33 bucks for like a case."
"I thought that's where that number went."
"Yeah, that's where I was told to put that in."
The count number had been going into a cost field, because the person who trained her had shown it that way. This is the quiet version of the problem: the count happened, it was written down, it went somewhere — and it did not add up, and nobody found out for a month. A sheet with labelled columns is not bureaucracy. It is the thing that stops a correct count landing in the wrong box.
Plenty of bars run their counts on a notepad, and plenty more type them straight into a spreadsheet. Neither is the problem, and neither needs replacing. The problem is the one from the top of this post: the count exists, and it never lands anywhere it can be compared with last week's. Eight columns is all it takes to fix that, and you do not need to buy anything to get them.
Download the bar inventory sheet — printable for the clipboard, spreadsheet for the office. No email, no form.
If you want the count to stop being a manual job altogether, that is a question about connecting a count to a purchase price automatically, and GoTab integrates with fifteen inventory and purchasing platforms that do exactly that. Where the products, vendor records and stock levels live on the GoTab side is the manager dashboard.
Frequently asked questions
How do you take bar inventory?
Count every container in every place you store it, one sheet per section, recording each product in the unit that is physically in front of you. Do it the same day each week, in the same order. The sheet above has the eight columns that make the numbers comparable week to week.
How often should a bar take inventory?
Weekly is the common rhythm and a reasonable default. The reasoning is in our brewery inventory guide, which covers cadence, par levels and how to read the result.
What is sheet-to-shelf inventory?
Sheet-to-shelf means ordering the rows on your count sheet the way you physically walk the room, rather than alphabetically or by category. Counting then follows your eyes instead of making you hunt. It is faster; category order is easier to read afterwards. Pick one and keep it.
How do you count a partial bottle?
By eye, in tenths, for most of the bar — record 0.4 or 0.7 rather than "about half", using sight lines you have agreed once and reuse every week. For the twenty products carrying most of your money, a scale is more accurate and worth the extra minutes.
Do you need software to take bar inventory?
No. A sheet works, and this one is free. What software adds is the purchase price behind each line, which is what turns a count into a cost — GoTab connects to fifteen platforms that do it.
