On-Hand Inventory

What on-hand inventory actually means

On-hand inventory is what is really there. Not what the POS thinks. Not what the invoice said. What you can touch, count, and put on a shelf. That number is the only one that matters when you are paying bills.

The gap between what your book says and what is physically there is variance. A bar that never counts has no idea how big that gap is.

How it is used on the floor

On-hand is the number at the top of your count sheet. Bar manager walks the bar, counts every bottle, every keg, every case in the back, and totals it up. The result is on-hand inventory at that moment in time.

Most bars count weekly for liquor, daily for kegs, and monthly for everything including consumables like straws, napkins, and glassware.

How it ties to the books

On-hand inventory is a line item on your balance sheet. It is an asset. When it drops, either you sold product (revenue) or product walked (loss). Your P&L reads:

COGS = Beginning on-hand + Purchases - Ending on-hand

Example: you started the month with $18,000 on-hand. Bought $12,000. Ended with $16,000. COGS for the month is $14,000. Every dollar of on-hand is a dollar that has not hit your P&L yet.

The two versions of on-hand

There is physical on-hand (what you counted) and book on-hand (what the system says). They should match. They never do perfectly. The job of a good inventory process is to keep the gap small and find the leaks fast.

Book on-hand comes from starting count plus purchases minus POS-recorded sales. Physical on-hand comes from walking the bar. Both are valid. The difference is where all the interesting questions live.

Common mistakes

Counting backup stock on one day and open bottles on another, so the number never reconciles. Forgetting the case in the basement. Not counting the bottle in the fridge. Treating “on-hand” as a monthly guess instead of a Sunday night fact.

How PourIQ handles it

PourIQ calculates book on-hand continuously from POS sales and purchase receipts. Every time you count, it compares physical to book in real time and flags any SKU where the two disagree by more than a set threshold. You see variance the second you finish the count, not next month when the damage is done.