How to Do Bar Inventory by Hand: A No-Software Guide

If you searched “how to do bar inventory by hand,” you already know what you want. You want to count your bottles. You do not want to be sold an app three paragraphs in. Fair enough. Our team has run plenty of counts with a clipboard, a half-dead Bic pen, and a phone calculator we kept unlocking.

So this guide respects that. No mid-article pitch. Just the honest walkthrough. Supplies, sheet structure, tenthing, math, time estimates, and the triggers that tell you when the clipboard has outlived its usefulness. We run a software company and we still think a clean clipboard beats a messy rollout every week. Bookmark this for Sunday night.

What do you need before you start a manual bar inventory?

The minimum kit:

• A printed count sheet with your products pre-listed in shelf order
• A clipboard
• Two working pens (one will fail)
• A calculator on your phone
• A flashlight for the back of shelves
• Comfortable shoes

That is it. No scale. No app. The baseline is one person, one sheet, one pen.

Three things to do the night of the count:

1. Close the bar. No pours, no deliveries. A count during active service is a count that lies.
2. Reset your POS and pull a sales report for the period since your last count. You need it for variance math at the end.
3. Stage your backstock. Pull full cases where you can see them so you do not forget the walk-in.

Jeffrey Morgenthaler puts it plainly. Without inventory, “you have absolutely no idea what is going on in your bar.” The count is the audit. Treat it like one.

How is a bar inventory count sheet structured?

Your count sheet is the whole game. Get it wrong and you will be flipping pages at 2am, trying to figure out if “Tito’s” on page one is the same SKU as “Titos 1.75” on page three.

We wrote the full column and formula walkthrough in our bar inventory spreadsheet template guide. Here is the short version for a manual count.

• Product Name. Brand and bottling. “Buffalo Trace 750ml,” not “bourbon.”
• Category. Vodka, gin, whiskey, tequila, rum, liqueur, wine, beer.
• Unit Size. 750ml, 1L, 1.75L, 12oz, half keg.
• Par Level. Your par level is what you want on the shelf after a delivery.
• Full Bottles on Hand. Whole number, sealed only.
• Partial Bottles on Hand. Decimal, 0.1 to 0.9.
• Unit Cost. Distributor price, not menu price.
• Last Count. Last period’s on-hand number.

The biggest accelerator is what operations teams call “shelf to sheet.” Your sheet lists products in the exact order they sit on the shelf, left to right, top to bottom. You walk the bar in a line and read off the sheet in the same line. Bar-i, a professional inventory service, says this approach can “cut your counting time in half” versus an alphabetical sheet. Print with generous row spacing. You will be writing while standing up, sometimes with a flashlight in your teeth.

How do you count full bottles and partial bottles by hand?

Sealed bottles are always 1.0. Three sealed Jamesons is 3.0. Count, write, move on.

Open bottles are where tenthing lives. Tenthing is the technique working bars have used for decades. You mentally divide the bottle into ten equal vertical sections and record how many tenths of liquid remain. Full is 1.0. Half is 0.5. About 30% left is 0.3. No scale, no math, no app.

Morgenthaler endorses it directly: “Take a look at your bottle and break it down into tenths in your mind. Decide where the liquid line falls and make an educated guess about the contents.” That is not a workaround. It is a professional standard. Tenthing runs roughly a 15% margin of error per bottle compared with weighing, according to industry inventory services like Sculpture Hospitality and Bar Cop. That is fine for category-level pour cost, and the accepted tradeoff for the speed it buys you. Our tenthing bottles explained deep dive covers the tricky cases. Crown Royal in its opaque bag, tequila in tinted glass, short-necked liqueurs.

Three tips that matter most:

1. Tenth the same way every time. Stable error is readable error.
2. Train one counter. Two people will disagree by a tenth on the same bottle. Pick your sharpest eyes and let them own it.
3. Never skip the wells. A well vodka at 0.3 you called 0.5 is a bigger miss than a Pappy nobody touched.

Add full bottles and tenths per SKU. Two sealed plus one at 0.7 is 2.7.

How do you count kegs without software?

Two options, neither needs an app.

Count by weight. A half barrel weighs roughly 160 pounds full and about 30 pounds empty, the widely cited industry standard across draft beer suppliers. A bathroom scale from any hardware store works. Weigh, subtract the tare, and record what remains as a decimal of a full keg. Half full is 0.5.

Estimate by line level. Rock the keg. If it tips easily, it is getting light. If it still feels like a cinder block, it is closer to full. Looser than weighing, but accurate enough for most back-of-house beer between weekly counts.

Record kegs like bottles. Sealed is 1.0, half-gone is 0.5, total is the sum of decimals for that SKU.

How do you count beer bottles and cans?

Beer is the cleanest category on the sheet. Most bars order by the case, and a case is 24. A sealed case is 24 bottles. A cracked case gets counted one by one. Loose bottles in the cooler are counted individually.

Some bars record by the case and let the sheet do the math. Others count total bottles. Either works, but be consistent so your inventory count is comparable period over period. If you write “1 case plus 7” this week, do not write “31 bottles” next week. Flag seasonal and limited beer on your sheet so it does not skew your usage reports when the keg or case runs out.

How do you count wine for a manual inventory?

Wine splits into two buckets. Bottles sold as bottles count like any full bottle, 1.0 per unit. Wine sold by the glass is trickier because an open bottle oxidizes. A 5-ounce pour means a 750ml bottle yields five glasses. Count an open BTG bottle the way you tenth a spirit. Eyeball the liquid line, round to the nearest tenth.

The difference is timing. A spirit bottle lasts weeks. An opened BTG wine bottle holds up for roughly two to five days before quality drops, depending on grape and storage, per Coravin’s preservation guidance. A bottle at 0.4 that has been open four days is usually already dead stock. Keep a separate line for wine that got dumped. It matters at month-end.

How do you record par levels and depletion?

Par is what you want on the shelf after a normal delivery. Write pars on the sheet once and leave them. They do not change week to week unless your volume shifts.

Depletion is what moved between counts:

Depletion = Last Count + Purchases - Current Count

If you had 5 bottles of Tito’s, bought 6, and now count 4, depletion is 7 bottles. That is what the bar sold, spilled, over-poured, or lost. Convert to ounces for pour cost work. Seven 1.75L bottles is about 414 ounces. Cross-reference against vodka drinks your POS rang, times your pour spec, and the gap is your variance. Our how to calculate pour cost walkthrough runs the math end to end.

What order of operations saves the most time?

The biggest time-saver after shelf-to-sheet is a fixed route. Count in this exact order every single time.

1. Speed rail first. Highest-volume bottles, and you are sharpest at the start.
2. Back bar, left to right, top to bottom. Pick a corner and march. Never jump.
3. Well and overflow. The duplicates stashed under the bar.
4. Beer cooler. Bottles and cans, then the tap tower.
5. BTG wine station. Open bottles only.
6. Walk-in. Kegs, backstock beer, backstock wine.
7. Dry storage and wine cellar last. Slowest moving, least error prone.

Same route every week builds muscle memory. By the fourth count you will feel whether Skyy moved faster than usual. That intuition is worth more than a dashboard.

How long does a manual bar inventory actually take?

Real world numbers, with a clean shelf-to-sheet template and an experienced counter. Mileage varies with backstock depth. These ranges are extrapolated from Bar-i’s 250 bottles per hour benchmark and our own time at the clipboard, so treat them as directional.

• 20 SKUs (pop-up bar, seasonal beach bar, event bar): 15 to 25 minutes solo.
• 50 SKUs (small neighborhood bar, dive, beer and shot program): 35 to 55 minutes solo.
• 100 SKUs (standard single-unit cocktail bar): 75 to 110 minutes solo. 60 to 75 minutes with a two-person team.
• 150 SKUs (full-service restaurant bar, mid-size cocktail bar): 2 to 2.5 hours solo. About 90 minutes with a team of two.
• 200+ SKUs (multi-bar venue, wine-heavy, hotel bar): 3 to 4 hours solo. This is where solo counts start to break down.

Bar-i reports experienced counters hit roughly 250 bottles per hour using tenthing, which is our upper-end assumption. Add 15 to 20 minutes of prep and 20 to 30 minutes of math at the end. Add 25% the first time through. Muscle memory takes four to six sessions to build.

When does manual inventory still beat software?

Most content online wants you to believe the clipboard is dead. It is not. Manual still wins in specific situations.

• Fewer than 50 SKUs. A clean spreadsheet and a clipboard count in under an hour. A subscription is hard to justify at that scale.
• You want the ritual. Some owner-operators count personally every Sunday because it is their audit, walk-through, and quality check rolled into one. Legitimate philosophy.
• You cannot commit to consistent app usage. An app you forget to update is worse than a clipboard you filled every time.
• Wi-Fi is unreliable in storage. Plenty of basements and walk-ins where phones simply do not connect.
• Your POS does not integrate cleanly. If you are reconciling by hand anyway, the app layer adds work without subtracting it.
• Your SKU list is still moving. Until the menu settles, maintaining a product catalog is more work than the count itself.

None of those are failure modes. A disciplined clipboard count is professionally valid bar operations.

When should you stop doing bar inventory by hand?

Exact triggers. When any two are true, the clipboard is costing you more than software would.

• Your SKU count passes 150. The clipboard makes you slower than your variance window.
• Your count routinely runs over three hours. You are giving up half a day of manager time every week.
• You run more than one location. Comparing variance across bars by hand is painful and error prone.
• Beverage spend is over $12,000 per week. A single 2% variance at that scale eats more than a monthly software subscription every week, which is the silent shrinkage you cannot afford.
• You had a variance surprise in the last 90 days that cost real money. Your numbers are telling you the system missed something.
• Version control problems. “Bar Inventory FINAL v4 (real)(use this one).xlsx” is a warning sign.
• The clipboard lives in your head alone. When only one person understands the count, you have a bottleneck, not a system.

Two of those ringing true means you have outgrown the manual method. Not a failure. That is your bar getting bigger.

The honest next step

Print the sheet, block 90 minutes Sunday night, and run your first count. The math is not hard, the tenthing gets faster every week, and the discipline is what moves your pour cost. You do not need an app to run a tight bar.

When you are ready to stop doing this by hand, PourIQ replaces the clipboard for $75 a month flat, no hardware. Until then, this guide works. Bookmark it for next Sunday. If you eventually want to see the manual process become a live dashboard, you can book a 15-minute demo whenever it makes sense.

Happy counting.

The PourIQ Team