Medicines: lots, expiry and rotation
Pharmaceutical stock in a practice is defined by three things at once: how much there is, which batch it belongs to, and when it expires. A system that captures only the first cannot answer the questions that actually arise, which are whether the vial in the drawer is still in date and whether a supplier recall affects anything the practice holds.
Batch and expiry data has to be captured at receipt. It is printed on packaging that gets opened, split and discarded, so a batch number not recorded when the delivery arrives is effectively unrecoverable, and any later reconstruction is guesswork with a professional signature under it.
Rotation follows from the same data. First expired, first out is the correct rule for medicines, and it only works when the person reaching into the fridge can see which pack goes first. Expiry alerts a few weeks ahead turn write-offs into a decision about whether to use, return or reorder, rather than a discovery.
- Capture batch and expiry at receipt, per line, before stock is put away
- Rotate by earliest expiry rather than by what is at the front
- Alert ahead of expiry so there is time to act, not just to discard
- Keep a lot-level trail so a supplier recall can be answered in minutes
Controlled substances and a balance that reconciles
Controlled drugs are the part of veterinary stock where accuracy is not an efficiency question. The requirement is a running balance that can be compared against physical stock at any point, with each movement attributable to a named person and a date, and with discrepancies investigated rather than adjusted away.
The operational difficulty is that these movements happen during clinical work, often in small fractions of a vial, and the record has to be made at the time. Any process that relies on writing it up at the end of the day depends on memory of a day that was, by definition, busy.
The record keeping obligations for controlled veterinary medicines vary by country and are set by the relevant authority, so the specific register format, retention period and reconciliation frequency should come from your regulator or professional body rather than from a software vendor. What a stock system contributes is a movement history per item, per batch, per person that can be reconciled and evidenced.
Consumables used at the point of care
Syringes, needles, gloves, sutures, dressings, catheters and test kits are consumed continuously, by several people, in rooms where nobody is thinking about inventory. This is the category where practices most often discover a stockout at the moment of use, which is the worst possible moment.
Two things make consumption recordable. The first is a scan rather than a form: a phone camera reading the barcode on the box takes a fraction of the time of finding the right line in a spreadsheet. The second is honest par levels on the small number of items whose absence stops work, so a low-stock alert fires while there is still time to order normally.
Not everything deserves this treatment. A practice that tries to track every cotton swab abandons the whole system within a month. Choose the items where running out has a clinical or financial consequence, track those properly, and let the rest be replenished on a visual check.
Branches, consulting rooms and the vehicle
A practice with a second branch has two stock locations, and a practice doing farm or equine visits has a third that moves. Stock in the vehicle is not consumed the moment it leaves the building; it is stock in a different place, and treating it otherwise means medicines quietly reach their expiry date in the back of a car.
Transfers between sites need to be recorded as transfers rather than as an adjustment at one end and a discovery at the other. Otherwise the branch that lent a box shows a shortfall it cannot explain and the branch that received it shows a surplus nobody trusts.
Shared visibility is the other half. A nurse at the second site should be able to see whether the item is available at the main clinic before ordering it, which is a query nobody makes if the answer requires a phone call.
- Treat each branch and each vehicle as a stock location
- Record movements between them as transfers, not adjustments
- Check expiry on vehicle stock on a schedule, since nobody sees it daily
- Give every site visibility of the others before they reorder
Equipment readiness alongside stock
Anaesthetic machines, monitors, autoclaves, dental units, microscopes and portable ultrasound all have the same property: they are needed on a specific morning and the fact that one is due a service is not visible in a drawer. Practices that track equipment separately from stock end up with two systems and one of them stops being maintained.
What is worth recording is small: which asset, where it is, when it was last serviced or calibrated, when the next is due, and whether it is currently available. That is enough to answer whether tomorrow morning can go ahead, which is the only question anybody asks.
In StockFlow, medicines and consumables can carry batch numbers, expiry dates and per-location minimum levels with low-stock and expiry alerts, while equipment is marked as an asset with check-in and check-out, maintenance status and readiness reporting. Asset tracking is included on every plan, including the free Starter plan.
Know what is in date, in stock and in the van
Track medicines by batch and expiry, record consumable use with a scan, and keep every branch and vehicle visible in one place. Free to start.
Trusted by small businesses
What our customers say
“Super Kind! Quick replies from their support and very easy fixes, changed the dashboard a bit and customized it. Also gave me 450 items extra on the free plan just for me. Highly recommend and again great service!”
“Best customer service! Stockflow's customer support is fast and extremely helpful. They assisted me with customization of the software to improve my experience as a user.”