Bar Stock Taking: How to Do a Bottle Count the Right Way

Every bar owner knows the feeling: the sales look fine, the bar is busy every weekend, but at the end of the month the liquor bill is higher than it should be. Somewhere between the store room and the customer's glass, stock is disappearing. Without a regular, honest bottle count, you cannot tell whether it is over-pouring, unbilled drinks, breakage or simple counting errors.

Stock taking is not glamorous, but it is the single most useful habit for a profitable bar. This guide explains how to do it properly, how often, and what to do with the numbers.

Why stock taking matters in a bar

In a restaurant kitchen, a small loss is spread across many ingredients. In a bar, each bottle is expensive and each peg is a fixed measure. That makes bar stock easy to measure — and easy to lose if nobody is measuring. A regular count tells you three things:

• How much stock you actually have, brand by brand.
• How much was used since the last count.
• Whether that usage matches what was billed.

Step 1: Decide how often you will count

A sensible routine for most bars:

• Every shift change: count open bottles behind the bar for high-value brands.
• Daily: a quick count of the full bar at closing.
• Weekly or monthly: a full count of the bar and the store room together.

Start with what your team can do consistently. A simple daily count done every day is better than a perfect monthly count that keeps getting skipped.

Step 2: Fix the count order and the people

Count in the same order every time — shelf by shelf, left to right — so nothing is missed or counted twice. Ideally, two people count together: one counts, one records. If the bartender on duty counts alone, mistakes and adjustments are harder to catch.

Step 3: Count sealed bottles separately

Sealed bottles are simple: count them as whole units. Keep sealed stock in the store room and only issue bottles to the bar against a written or recorded issue. That way you always know how many bottles moved from store to bar.

Step 4: Measure open bottles consistently

Open bottles are where most errors happen. Choose one method and use it every time:

• Visual tenths: estimate the level in tenths of the bottle. Quick, but less accurate.
• Measuring in ml or pegs: estimate how many pegs are left using a marked guide for each bottle shape.
• Weighing: weigh the bottle on a scale and subtract the empty bottle weight. This is the most accurate for expensive brands.

Whatever you choose, record open bottles in the same unit you use for billing — usually pegs or ml — so the numbers can be compared directly.

Step 5: Calculate usage and compare with sales

For each brand, the basic formula is:

Usage = Opening stock + Bottles received − Closing stock

Then compare usage with what was billed for that brand in the same period. Here is an example with illustrative numbers:

• Opening stock: 4 bottles + 12 pegs left in an open bottle
• Received: 6 bottles
• Closing stock: 3 bottles + 8 pegs
• Pegs per bottle (planned): 24
• Usage: (4×24 + 12) + (6×24) − (3×24 + 8) = 108 + 144 − 80 = 172 pegs
• Pegs billed in the same period: 160
• Difference: 12 pegs not accounted for

A small difference is normal because of pouring and measuring. A large or growing difference means something needs attention.

Step 6: Investigate the gaps

When a brand shows a big gap, check these common causes:

• Over-pouring from free-hand pours. Use jiggers or measured pourers.
• Unbilled drinks for friends, regulars or staff.
• Wrong brand billed — a premium pour billed as a cheaper brand.
• Breakage or spillage that was never recorded.
• Counting errors — the wrong bottle counted or a shelf missed.

Our article on stopping liquor theft and peg leakage covers these controls in more detail.

Step 7: Keep records that match your excise register

Your counts should line up with your brand-wise stock records. Many states require bars to keep daily stock registers, and rules differ by state. Keep your count sheets organised by date and brand, and confirm your record-keeping requirements with your excise consultant or CA. See our bar excise register guide for the basics.

Tips to make counting faster

• Arrange bottles by category and brand so each shelf has a fixed place.
• Count at the same time every day, before staff leave.
• Use a phone or tablet instead of paper so totals calculate automatically.
• Share the results with the bar team. When people know counts are checked, careless pouring often drops.

What to do after a count

A count is only useful if someone acts on it. After every weekly or monthly count, sit down with your bar manager and go through a short list:

1. List the five brands with the biggest gap between usage and pegs billed.
2. Check whether those brands were poured by the same shift or the same bartender.
3. Look at voids, complimentary drinks and happy-hour sales for those brands.
4. Agree on one or two fixes — for example, jiggers for all premium brands, or a rule that complimentary drinks need a manager's approval in the system.
5. Check the same brands again at the next count to see whether the gap has reduced.

Keep the tone fair. The aim is to find and fix the leak, not to blame people without evidence. Clear numbers make these conversations much easier.

How DUOZENT helps

DUOZENT's Bottle Count feature lets staff record sealed and open bottle levels on a phone at every shift change or closing. Because every peg billed in the POS is deducted from stock automatically, DUOZENT can compare what was used with what was sold. The Leakage Report shows the gap brand by brand, so you know exactly where to look. The excise register keeps daily brand-wise stock records ready, and AI insights flag brands where the gap keeps growing.

Want to know where your bar stock is really going? Book a free demo — 14-day free trial + free leakage report.