How to Keep Accurate Veterinary Inventory Counts

Every practice has that one bottle. The 1000-count that's somehow always either full or empty, never anything in between. You scan the shelf, the on-hand number in your PIMS says 340, and you'd bet a paycheck the real answer is closer to 90. That gap is the whole problem with veterinary inventory counts. On a busy floor they drift, quietly and constantly, until the number on the screen and the number on the shelf are barely on speaking terms.

The good news is you don't fix this with a heroic annual count and a lot of suffering. You fix it with a couple of small, boring habits that catch drift while it's still small. Let's walk through them.

Why veterinary inventory counts drift in the first place

Counts don't go wrong because your team is careless. They go wrong because the way medicine actually gets practiced fights against tidy recordkeeping:

• Large multi-dose bottles get opened and dispensed from in the middle of chaos. A tech draws up a dose mid-appointment, the patient's crashing or the lobby's full, and the charge gets entered later, or not at all.
• Unrecorded use adds up. A few mLs here for a fractious cat, a tablet there split for a tiny dog, the in-house "we'll fix it later" dose. Each one is small. A year of them is not.
• Big-count items hide their own shrinkage. Nobody notices that a 1000-count bottle is 40 capsules light. You'd notice fast on a 12-count. The bigger the container, the more room for "mystery shrinkage" to live undetected.

The centerpiece: log the open date on your big bottles

Here's the habit with the biggest payoff, and it costs you about ten seconds per bottle. When you crack open a new large container, a big injectable vial, a large tablet or capsule count, a jug of liquid, write down the date you opened it.

That open date is gold. It gives you a known starting mark: on that day, the bottle held a full, factory-sealed count. Now you have a fixed point to measure from. Everything dispensed since that date should come straight off that starting number, and what's left is your estimate.

The math is genuinely this simple:

Estimated On-Hand = Starting Full Count - Units Dispensed Since Open Date

Then you do a quick physical count of that one bottle and compare. If the estimate and the count agree, great, your records are honest. If they don't, you've just found drift on a specific item, with a specific time window to investigate, instead of staring at a year-end variance with no idea where it came from.

A tiny worked example

Say you open a fresh 500-count bottle of an oral medication on June 1 and jot "Opened 6/1" on the label.

1. Starting full count: 500.
2. Pull the dispensing transactions since June 1 from your PIMS. Suppose they total 180 tablets sold and dispensed.
3. Estimated on-hand today: 500 - 180 = 320 tablets.
4. Quick physical count: you tip out the bottle and count 296.
5. Variance: 320 - 296 = 24 tablets unaccounted for.

Twenty-four tablets walked off the books in roughly three weeks. That's not a catastrophe, but it's a real signal. And because you logged the open date, you know exactly which item and exactly which window to look at. Without that starting mark, those 24 tablets just vanish into the annual count and you never learn a thing.

You don't need to do this for every SKU. Do it for the big-count, high-movement, or high-value containers, the ones where drift hides best and hurts most. A grease pencil on the label or a one-line shared note is plenty.

Cycle counting beats the dreaded annual count

The annual count is where good intentions go to die. You shut down, everyone counts everything at once while exhausted, and the numbers you get are only accurate for about a day. Then they start drifting again immediately.

Cycle counting flips this. Instead of one giant event, you count a small slice of the shelf every week. Over a quarter you've covered everything, nobody's miserable, and you catch problems in near-real-time. The trick is deciding how often to count each item, and that's where an ABC approach helps:

• A items, count often (weekly or biweekly). Your fast movers and high-dollar drugs. They turn over quickly, so errors compound quickly, and the money at stake is real.
• B items, count monthly-ish. Moderate movement and value.
• C items, count rarely (quarterly is fine). The slow, cheap, long-shelf-life stuff. A miscount here barely moves the needle, so don't burn labor on it.

The point isn't to count more. It's to count smarter: frequent attention where the money and motion are, light touch everywhere else.

Make it stick: ownership, timing, and variance triage

A counting system only works if it's somebody's actual job and it runs the same way every time.

Assign clear ownership

"Everyone counts" means no one does. Name a person, an inventory lead or a rotating role, who owns the cycle-count schedule and follows up on variances. Accountability is the difference between a system and a wish.

Count at consistent times

Count the same item the same way, ideally before the day's dispensing scrambles the numbers: early morning or before opening. Counting a fast mover at 4 PM, mid-rush, is how you manufacture a variance that isn't real.

Investigate variances; don't just adjust and move on

When the estimate and the count disagree, resist the urge to silently "fix" the system number. A variance is information. Triage it into one of three buckets:

1. Unrecorded dispense: the most common by far. The product was used or sold but the charge never got entered. This is a charge-capture problem (and a missed-revenue problem) hiding inside an inventory problem.
2. Miscount: someone counted a partial bottle wrong, or two similar SKUs got swapped. Recount before you conclude anything.
3. True shrinkage: waste, expiry, breakage, or, occasionally, theft. This is the smallest bucket, but it's the one people jump to first.

Most "missing" inventory turns out to be bucket one, which is good news, because charge capture is fixable with process, and it ties straight to the cash quietly trapped in your inventory.

A quick checklist to start this week

• Grab a grease pencil and start dating the open date on every large/high-value bottle as you crack it.
• Tag your shelf into A, B, and C buckets by movement and value.
• Pick a sustainable weekly count target and put it on one person's plate.
• Set a consistent count time, before the dispensing rush.
• When something doesn't match, run the open-date math and triage the variance instead of silently adjusting.
• Make sure your starting data is clean by pulling a tidy report out of your PIMS.

Why it matters

Accurate counts aren't a tidiness exercise. They're the foundation everything else sits on. Your reorder points, your order quantities, your valuation, your sense of how much cash is sitting on the shelf: all of it is only as trustworthy as the on-hand number it's built on. Feed those systems a number you don't believe, and you'll order on instinct again, which is exactly the guesswork you were trying to escape.

Date your bottles. Count a slice each week. Chase the variances that matter. Do that, and the next time someone asks how much of that 1000-count is left, you'll have an answer you can actually stand behind. And maybe, finally, that bottle will land somewhere between full and empty.