
How to track medicine expiry dates in a pharmacy comes down to one habit: record the batch number and expiry date for every line at goods-in, before the stock reaches a shelf or dispensing bin. That record makes everything else possible. It tells staff which box to pick, which batch to pull before it expires, and where a batch went. PharmaFlow pharmacy POS software is one option to look at when you review your system. The routine below works on any system that holds batch data correctly, including a well-kept spreadsheet. Without the batch record, it fails.
1How Do You Track Medicine Expiry Dates When Stock Arrives?
Record the expiry date and batch number when the delivery is received. If that data is missing at this point, it is hard to recover later. You cannot rotate or trace the stock when a recall arrives.
The batch number links a physical box to its record. Two boxes of the same product can carry different expiry dates, and only the batch number tells them apart.
Goods-in staff should work through each line:
- Check each carton's expiry date against the supplier invoice. Flag any mismatch before signing for the delivery.
- Record the batch number and expiry date against that line, not just the product name.
- Record the unit cost for that batch, so any later write-off can be valued.
- If a line arrives close to expiry and your supplier only accepts returns within a set window, put it in a hold bin until someone has decided whether to return it.
2What Do Month-Only Expiry Dates Mean for Your Records?
Some packs show only a month and year, such as "03/27" or "MAR 2027". A month-only expiry date still needs a full date in your record, so you need a written rule for converting it.
The rule used here is to record the batch as expiring on the last day of the printed month. A batch marked March 2027 is recorded as expiring 31 March 2027. Some teams choose the first day of the month instead. That gives a shorter window, so it is the more cautious option. Either can work. Confirm your choice against your own policy and your regulator's guidance.
Whichever rule you pick, write it down and apply it the same way on every shift. Two staff members using different rules will produce records that disagree.
3Should Your Pharmacy Use FEFO or FIFO?
Use FEFO. At the counter, the batch with the earliest expiry date goes out first, even when a newer batch sits at the front of the shelf.
This is easy to get wrong. The front box is the easiest to reach, so the older batch stays at the back and expires there. FIFO (first in, first out) and FEFO (first expired, first out) give different answers whenever a newer batch expires sooner. This routine follows expiry order. For a fuller walk-through of batch-level stock rotation, see FEFO inventory for pharmacies.
Two habits make FEFO work in practice:
- When stock is put away, place the earliest-expiring batch where it will be picked first. Note the batch on the shelf label if your layout allows.
- When a box is opened for dispensing, check its batch against the record before it goes into use.
4How Far Ahead Should Expiry Alerts Fire?
Treevoxa's suggested starting windows are 90, 60 and 30 days before expiry. These are not industry standard and not regulation. Treat them as a place to begin, then adjust them to your stock.
| Days to expiry | Stage | Action |
|---|---|---|
| 90 | Flag for review | Add the batch to the short-date list and check stock against expected sales |
| 60 | Plan the exit | Arrange a return, a transfer to another branch, or a sale plan |
| 30 | Remove from active dispensing | Move the batch out of the dispensing bin to a separate area and decide its return or disposal |
You can set different windows for different lines. Shorter windows can suit fast-moving lines. Longer ones suit slow-moving or specialist items that take longer to clear. Set the windows per product group, then review them after a few months of real data.
5What Does a Short-Date Review Involve Each Week?
A short-date review is the regular check that turns the alert list into action. Without it, 30-day flags become write-offs.
The schedule below is a suggested routine, not a regulatory requirement. Name an owner for each step. A routine fails when everyone assumes someone else is doing it.
| Frequency | Step | Suggested owner |
|---|---|---|
| Daily | Check dispensing points for batches near expiry, and pull anything past its date | Dispensing technician, then the pharmacist on duty |
| Weekly | Run the short-date review: go through the alert list and decide return, transfer or sale for each batch | Store manager or a named delegate |
| Monthly | Cycle count of one section, reconciled against the electronic record | Staff member assigned to that section, rotating each month |
| Periodic | Full physical count | Designated manager (Ontario) or pharmacist-in-charge (US) |
A small audit catches what the system misses. Over time, the shelf and the record drift apart. A monthly section count shows where. It might reveal a batch on the shelf that the system does not list, or stock the system still shows that has already left. Those gaps are where expired stock hides.
6Can You Sell or Dispense Expired Stock?
No. Once a batch is past its expiry date, it should not be dispensed or sold.
Remove it from the dispensing area straight away. Place it in a separate, clearly labelled quarantine location so nobody picks it up by mistake. The label should show the product, batch number, expiry date and the word "quarantine", until the batch is returned or destroyed.
The detail depends on where you practise. Some US state rules are explicit. Virginia's rule, for example, says expired drugs must not be dispensed or sold and must be kept apart from dispensing stock. Provinces and states set their own rules, so check your regulator's current wording. The day-to-day routine is the same wherever you work.
7How Is a Beyond-Use Date Different From the Expiry Date?
Staff often confuse these two dates, but they do different jobs. The expiry date is printed by the manufacturer on the pack. A beyond-use date is set by the pharmacy, usually on a label for a dispensed or repackaged product.
| Expiry date (stock side) | Beyond-use date (label side) | |
|---|---|---|
| Where it appears | On the manufacturer's carton or bottle | On a dispensed or repackaged label |
| Who sets it | The manufacturer | The pharmacy, under state board rules or pharmacy policy |
| What it governs | How long unopened stock can be held or sold | How long the product can be used after it leaves the pharmacy |
| Typical rule | The date printed on the pack | Set by your state board or your pharmacy's policy, and the rule varies |
A bottle can carry a manufacturer expiry date two years away and still need a much shorter beyond-use date on the label you prepare. Do not assume a single fixed period applies everywhere. Check your state board's rule, or your pharmacy's written policy, before you set one.
8How Do You Dispose of Expired Stock and Keep Disposal Records?
Every expired batch that leaves the building needs an entry in your disposal log. Expired medicine disposal without a log leaves you unable to show an inspector or auditor what happened to the stock.
Each entry should record:
- Product
- Batch number
- Quantity
- Date
- Reason, such as expired or recalled
- Disposal method
- Who approved it
Return for credit where the supplier allows it. Many pharmacies send expired stock through a reverse distributor, which handles returns to manufacturers for credit. Keep the return paperwork, and file any certificate of destruction the distributor provides alongside the log.
Where you destroy stock yourself, use a method your regulator accepts. Do not rely on a general list from a blog. Check your regulator's current guidance. For US businesses, the EPA's guidance for hospitals, pharmacies and other businesses is a useful starting point. State rules may add to it.
9What Are the Rules in Canada?
This section works from the regulators' own wording. Check each point against the current Ontario regulation and Health Canada guidance before you rely on it, because older consolidations still circulate. If you practise outside Ontario, check your provincial college's policy, since the details differ.
Ontario: What the Designated Manager Must Do
The Ontario College of Pharmacists places responsibility for inventory on the designated manager. The college's policy on designated managers and inventory management says inventory must be managed so that outdated, deteriorated, recalled, obsolete or hazardous drugs are identified and disposed of by appropriate methods.
In practice, that becomes a set of staff actions:
- Identify outdated stock during the daily shelf check and the weekly short-date review.
- Remove it from dispensing at once.
- Record each disposal in the log described above.
- Keep a record of stock movement, so you can show where a batch went.
Health Canada: Inventory Reconciliation and Counts
Health Canada's guidance for community pharmacists refers to "regular inventory reconciliations, including complete manual inventory counts." The count frequency depends on your licence type, so confirm it against the current guidance before you set your schedule.
10What Are the Rules in the United States?
US pharmacy rules come mostly from state boards of pharmacy, so your state's current rules bind you first. If you practise in New York, Texas, North Carolina or Colorado, check the current wording from the relevant board, since the state rules on expired stock and beyond-use dating differ. Two federal points matter for expiry records.
- Lot-level records support traceability. If a manufacturer recalls a lot, you need to know which lots you hold and where they went. A batch number on every line turns that into a query rather than a search through boxes.
- The Drug Supply Chain Security Act (DSCSA) applies to pharmacies, with an exemption for small dispensers. The FDA notice dated 6 August 2026 extends that exemption to 27 November 2027. Once the exemption ends, the electronic product tracing requirements it currently defers will apply to you. Sources disagree on how small dispensers are counted, so read the definition in the notice itself before you plan around it.
11Does Your Pharmacy Software Need to Track Expiry by Batch?
In practice, yes. Reliable expiry tracking depends on pharmacy batch tracking: the software must hold the batch, not just the product name. The checklist below is vendor-neutral. It is the list we would give any pharmacy owner evaluating software.
| Requirement | Why it matters |
|---|---|
| Batch number and expiry date on every stock line | Without both, you cannot rotate stock or trace a recall |
| Expiry captured at receiving | Dates missed at goods-in are hard to recover later |
| FEFO picking | Staff pick by expiry, not by what sits at the front |
| Configurable alert windows | Lets you use 90, 60 and 30 day windows, or shorter ones for fast-moving lines |
| Disposal log with approval | Provides the disposal records an inspector or auditor will ask for |
| Audit trail of stock movements | Shows where a batch went between receiving and disposal |
Ask any vendor, including us, to show each row working on your own batch data before you buy. If your current system cannot hold batch data, custom POS software development is one route to a fix. If you want a second opinion on your routine or your system, contact our team.
If you also sell online, check that one stock count drives both the counter and the web store. Otherwise, the online listing will show stock that the counter has already sold. For more on this, see pharmacy online store software.
12Where Should a Small Pharmacy Start This Month?
Three steps are enough to begin:
- Check current stock for missing or month-only expiry dates. Walk the shelves and dispensing bins. Record the batch and expiry for anything missing, and apply your month-only rule to anything that shows only a month.
- Start recording batch and expiry at every goods-in. Use the checklist at the start of this article, and assign one person to check each delivery.
- Set a weekly short-date review with a named owner. Put it in the calendar, and use the 90, 60 and 30 day windows as your starting point.
To see what expiry costs you, add up your write-offs for a few months and divide by the number of months. Here is an illustrative sample, not a benchmark. A pharmacy writes off 20 boxes of one product each month at $15 per box. That is $300 a month, or $3,600 a year, on one line. Run the same sum with your own stock. For a fuller method, see pharmacy expiry loss.
Learning how to track medicine expiry dates in a pharmacy is a routine, not a one-off project. Start with the first step above: this week, walk the shelves and find every batch with a missing or month-only expiry date. Then keep the weekly short-date review running, because the routine only works while someone runs it.