Veterinary Kardex (Stock Ledger) for Meds, Batches and Expiry
Veterinary Kardex (Stock Ledger) for Meds, Batches and Expiry
In a veterinary clinic or a small practice, stock is rarely lost to theft or mess: it is lost to expiry. A box of vaccines that expires before it is used is money already paid, shelf space already taken in the fridge, and revenue that will never happen. And there is a worse problem still: when a patient arrives needing that medicine and the product is not there, the visit stops, the owner leaves with a sick animal for another clinic, and the loss stops being measured in vials and starts being measured in clients who never come back.
This is where the veterinary kardex (stock ledger) comes in. A kardex is a stock card: the record in which every product tells its own story, movement by movement. In a veterinary practice that record has a feature almost no commercial inventory has: every line must say which batch the product came from and how long it can be used. It is not enough to know that twenty vials remain; you need to know which twenty, which batch they belong to and how many days of shelf life they have left. A balance without those three answers is a number that cannot tell you whether to buy, which vial to dispense first, or what to write off before it spoils.
What changes in a veterinary practice compared with a normal inventory
A hardware warehouse can run for years on an inventory that only counts quantities. A veterinary practice cannot, because almost every product it holds has a date. Medicines expire, vaccines expire and also lose effectiveness if the cold chain breaks, and food has a use-by limit. On top of that come four pressures specific to the sector, and all four end up in the same place: the stock card.
The first is small, high-value units. A vial of anaesthetic, an ampoule or a tube of cream can cost far more than a tool of the same size, and they are handled in small quantities, so a discrepancy of five units is a large loss in money even when it looks small in number. In a commercial inventory a shortage of five units goes almost unnoticed; in a veterinary practice it can equal the value of several consultations.
The second is that supplies are bought by the package and sold by the dose. The practice buys a sealed box of one hundred vials and charges the patient for one application or a few doses taken from that same vial. If the stock ledger records boxes or records units but does not handle the equivalence between package and unit, the balances will never add up, and the difference will surface exactly at the physical count, which is the worst possible moment to find it.
The third is controlled medicines, which demand an exact record of every exit: who administered it, when, how much, and with what supporting prescription or service order. For these products the stock card is not only a costing tool: it is the backup for daily work and for any later review.
The fourth is the cold chain, and it is the one most often forgotten. Biologicals do not only have an expiry date: they also have storage conditions. That forces inventory and storage to be planned together, because a perfect balance on paper is worthless if the vial spent two days out of temperature. A badly stored product is a lost product even when the card says it is available.
| Aspect | Normal commercial inventory | Veterinary stock ledger |
|---|---|---|
| Value per unit | Inexpensive items with fast turnover | Small vials and ampoules with high unit value |
| Expiry | Applies mainly to food and consumables | Applies to almost everything: medicines, vaccines, biologicals and food |
| Storage | Room temperature in most cases | Cold chain required for vaccines and biologicals |
| Buying and selling | Bought and sold in the same unit | Bought by the box or vial and dispensed by the dose |
| Exit record | Quantity and commercial document | Quantity, document and destination: who, when and with what support |
| Main risk | Shortage or excess stock | Loss through expiry and shortage of a product that stops care |
What the veterinary stock ledger includes
The veterinary stock ledger is not a different format from the general stock ledger: it is the same stock ledger with two extra pieces of data on every line, batch and expiry, and with dispensing rules adapted to the product. That means a practice already keeping a stock ledger sheet in Excel does not have to start from scratch; it has to add columns, decide rules and hold to them over time.
In practice, this is what it includes.
| Component | What it means in practice | How it looks on the card |
|---|---|---|
| Product and presentation | The same active ingredient may come as a box, a vial or a dose | One line per presentation, not one line per generic name |
| Batch | The manufacturing group that unit came from | A fixed column on every entry and every exit |
| Expiry | The use-by date of that batch | A fixed column, with the days remaining in sight |
| Document | Invoice, prescription, service order or internal record | The number that ties the movement to its support |
| In | Purchases, returns and positive adjustments | Quantity coming in, always with batch and expiry |
| Out | Applications, sales, consumption, transfers and negative adjustments | Quantity going out, with source batch and destination |
| Balance | The real stock left after each movement | The final column, the one compared with the physical count |
| Cost | The value at which stock is estimated | Controlled by average cost over the entries |
The columns of the veterinary stock ledger and what goes in each one
The card reads left to right and top to bottom: each row is one movement, and the balance in a row is the balance of the row above plus what comes in minus what goes out. What makes the veterinary stock ledger different is that the batch and the expiry travel with the movement: they are not facts about the product in general, they are facts about the exact portion that moved.
These are the minimum columns and what belongs in each.
| Column | What goes in it | Example |
|---|---|---|
| Date | The day the movement is recorded | 22/03 |
| Document | Number or reference of the support: invoice, prescription, service order or record | Service order 2230 |
| Concept | What happened: purchase, application, sale, transfer, adjustment or expiry write-off | Expiry write-off |
| Batch | Identifier of the manufacturing group that moved | L-2312 |
| Expiry | Use-by date of the batch that moved, not of the product in general | 20/03 |
| In | Quantity coming in, always with its batch and its cost | 100 |
| Out | Quantity going out, always with its source batch and its destination | 12 |
| Balance | The stock left after the movement | 88 |
How to dispense: the FEFO rule
When biologicals or a cold chain are involved, the order of issue is not a choice: it is imposed. The FEFO rule, which comes from the idea that what expires first goes out first, requires always dispensing the batch with the nearest date, even if it arrived later than another. It is not a warehouse preference or a staff habit: it is the only way for stock to rotate by itself and for whatever expires to be, with luck, little and cheap.
It is worth stating plainly because it is the costliest mistake of all: issuing by order of arrival is not the same as issuing by expiry date. A practice can receive a new batch on Tuesday while three vials of a batch expiring next month are still on the shelf. If the staff takes the vial at the front of the fridge, the old batch stays behind, expires and is lost, and the stock ledger shows it too late, when nothing can be done.
FEFO rests on two very simple things: the expiry date visible on the same line of the stock ledger, and physically separating whatever is about to expire. If the batch that expires first is mixed in with the rest in the same fridge, nobody will find it in time. That is why the weekly review and a separate area for soon-to-expire stock are part of the method, not a decoration.
Here is what an orderly issue looks like, with four batches of the same product.
| Issue order | Batch | Expiry | Available balance | Reason |
|---|---|---|---|---|
| 1 | L-2312 | 20 March | 6 vials | It is the batch that expires first: dispense it until it runs out |
| 2 | L-2401 | 30 April | 18 vials | It expires after batch L-2312 |
| 3 | L-2402 | 12 June | 40 vials | It expires after batch L-2401 |
| 4 | L-2405 | 03 December | 100 vials | It has the longest shelf life and stays for last |
Worked example: from the box to the vial, with batch and expiry
Imagine a practice that buys a sealed box of 100 vials of an injectable antibiotic at 4.500 per vial. The same day it opens the stock ledger sheet for the product, notes the batch, the expiry and the cost, and starts recording every movement with its document. The dates are in March, the batch that expires first is L-2312, and the practice applies FEFO without exceptions.
| Date | Document | Concept | Batch | Expiry | In | Out | Balance |
|---|---|---|---|---|---|---|---|
| 02/03 | Invoice 418 | Purchase of a box of 100 vials at 4.500 per vial | L-2312 | 20/03 | 100 | 100 | |
| 05/03 | Service order 2211 | Application to a hospitalised patient, 12 vials | L-2312 | 20/03 | 12 | 88 | |
| 09/03 | Service order 2230 | Application in outpatient care, 20 vials, from the batch that expires first | L-2312 | 20/03 | 20 | 68 | |
| 22/03 | Record 01 | Expiry write-off, 6 vials that were not used in time | L-2312 | 20/03 | 6 | 62 | |
| 24/03 | Invoice 455 | Purchase of a box of 100 vials at 4.500 per vial | L-2405 | 30/09 | 100 | 162 | |
| 28/03 | Service order 2288 | Application, 30 vials, taken from the new batch because the previous one ran out | L-2405 | 30/09 | 30 | 132 |
Read calmly, the example tells three stories at once. The first is the issue: 12 vials went out on 05/03 and 20 vials on 09/03, always from batch L-2312, which was the one expiring first, and the balance column reached 68 after the second movement. The second is the loss: batch L-2312 expired on 20/03 with 6 vials still unused, so on 22/03 they were written off with a record. Those 6 vials, valued at 4.500, are 27.000 that turned into waste for not being rotated in time. The third is the cost: with the purchase of the second batch, the final balance is 132 vials and the stock valued at average cost is 594.000.
The important part of the example is not the figures, it is the batch column. On the day of the physical count, if 130 vials show up instead of 132, the practice can read the card and find where the trail was lost; and if someone asks which batch a dose applied on 09/03 came from, the answer is already written: L-2312.
Step by step to set up the veterinary stock ledger
Setting up the stock ledger does not require a complicated system; it requires discipline and a format with no gaps. These are the steps to follow in order, even if the first month is done on a spreadsheet.
- List every product with its exact presentation, and treat each presentation as a separate product: the box, the vial and the dose are not the same line.
- Define the equivalence between package and dispensing unit: how many vials a box holds, how many doses come out of a vial, and which will be the minimum unit of control.
- Open one sheet per product, or one row per batch, and carry over the opening balance with its batch, its expiry and its cost. An opening inventory without batches is an inventory that was born incomplete.
- Set a minimum stock per product, higher for fast-moving items and for those that cannot be missing in an emergency.
- Record every entry with the document that supports it, the batch received, its expiry and the purchase cost.
- Record every exit with the document that supports it, the quantity, the source batch and the destination, whether a patient, a sale or an internal transfer.
- Review the list of near expiries every week and work out how many days each batch has left.
- Physically separate whatever is close to expiring, in a visible labelled area, and always dispense from there first.
- Take a physical count regularly and compare it with the balance; if there is a difference, do not adjust it from memory, find the movement that explains it.
- When a product expires unused, raise a destruction record with product, batch, quantity, date and responsible person, and write it off the stock ledger as a write-off, not as a sale.
Common mistakes that throw the veterinary stock ledger out of balance
Most veterinary kardexes that fail, fail for the same reasons. It is worth reviewing them before starting, because each one is paid for with money or with lost time.
- Keeping a single line per generic name and losing sight of the fact that several presentations of the same active ingredient exist.
- Recording entries by the box and exits by the dose without converting, so the balance ends up in units that do not mean the same thing.
- Not writing the batch on the exit. This is the mistake that destroys traceability completely: the day it is needed, nobody will know which patient received that batch.
- Issuing by order of arrival instead of by expiry date, which is exactly the opposite of the FEFO rule.
- Storing the new batch in front of the old one in the fridge, so the first one reached is the one that matters least.
- Not separating what is about to expire, and trusting that someone will remember when the time comes.
- Writing off expiries as if they were sales or consumption instead of recording them as a write-off with a record, which hides the loss and distorts real consumption.
- Counting stock once a year, when it is already impossible to reconstruct what happened to each batch.
- Leaving the stock ledger in the hands of one person with no written backup, so one absence stops the record.
Traceability: what to do when a batch turns out to be defective
Traceability is the ability to answer, with documents, what happened to a specific batch. In veterinary work that question is not theoretical: a supplier may warn that a batch was defective, or a patient may react after an application, and in both cases the first question is always the same: which units of that batch were used, on what dates, and on which patients or clients.
With a well-kept stock ledger the question is answered in minutes, because the batch is written on every exit along with the date and the document. Without a stock ledger, the answer has to be rebuilt from memory, loose invoices and the day's appointment book, and in practice that means it is not answered at all.
It is worth noting that traceability also protects the practice going forward. If a supplier claims that a product was returned in bad condition, the stock ledger shows when it came in, with which document and how it was recorded; if a client claims to have paid for something that was never delivered, the same card settles the argument.
Minimum control that cannot be negotiated
Five controls hold up everything else. If they are met, the stock ledger will work even when imperfect; if they are skipped, no format will save it.
- Minimum stock per product, set with judgement and reviewed when demand changes, especially for fast-moving items that cannot be missing.
- Weekly review of near expiries, with the days remaining in sight and not just the date.
- Physical separation of soon-to-expire stock, in an identified area that is easy to reach.
- A destruction record for everything that expires unsold, with product, batch, quantity, date and responsible person.
- A named owner for the stock ledger, with a second person as backup, so the record does not stop when that person is away.
When to move the stock ledger onto software
A stock ledger sheet in Excel works well in a small practice: one location, few products, few batches and a single responsible person. The problem is not the format, it is the volume. When several locations appear, when the number of live batches grows until nobody remembers which expires first, or when the system itself has to warn without anyone remembering to look, the sheet begins to fail exactly where it matters most.
Inventory software solves those three things at once: it lets you register batches and expiries per product, so every entry and every exit stays tied to its batch, and it shows the days remaining for each batch, so the weekly review no longer depends on a hand-made list. With Kardex Tauro the per-product stock ledger keeps the same structure of date, document, concept, in, out and balance, with the batch and the expiry on the same line and with expiry and batch control in sight. Deciding when to make the change is not about the size of the business, it is about how many questions are going unanswered.
Conclusion
In a veterinary practice the stock ledger is not an accounting requirement: it is the memory of the business. It is what lets you know what you have, which batch it belongs to and how long it is good for, and it is what separates a known, controlled loss from a loss that appears all at once on count day. The difference between a practice that rotates its medicines well and one that discovers expiries after they have passed is not size or product count, it is whether somebody wrote the batch and the date on the same line.
Starting is simpler than it looks: a product list with its presentation, a batch column, an expiry column and the habit of always dispensing whatever expires first. With that, the practice stops losing money in the fridge and stops running out of the medicine it needed to have on hand.
