How Pharmacies Should Track Expiry Dates — Pharmacy Inventory Best Practices

For pharmacies, tracking expiry dates is not just good inventory management — it is a safety requirement. Dispensing expired medication can harm patients and expose your pharmacy to liability. This guide explains best practices for tracking medication expiry dates, managing inventory by batch, and reducing expired stock losses.

Why expiry date tracking matters for pharmacies

Expired medication is more than a financial loss — it is a public health risk. Medications that have passed their expiry date can lose potency, change chemical composition, or become toxic. Dispensing expired medication can lead to treatment failure, adverse reactions, and legal liability for the pharmacy.

Beyond safety, expiry date management has direct financial implications. Medications represent a significant inventory investment, especially for pharmacies that stock specialty or imported drugs. Without proper tracking, you discover expired stock only when pulling it from the shelf — by which time the investment is a complete loss. An effective expiry date tracking system helps you sell medications before they expire, return soon-to-expire stock to suppliers where policies allow, and adjust purchasing to avoid overstocking short-dated products.

For Haitian pharmacies dealing with imported medications, expiry tracking is especially critical. Shipments that take weeks to arrive through the Port-au-Prince seaport may arrive with limited shelf life remaining. A medication manufactured 6 months ago with a 24-month expiry has only 18 months left when it reaches your shelf. Without tracking, you may not notice until customers complain or — worse — until a patient receives a compromised product. The Vendrex pharmacy POS includes inventory management features that help you track stock levels.

Best practices for expiry date tracking

Whether you use a POS system or a manual process, these best practices will help you manage medication expiry dates effectively:

Record expiry dates on receipt. The moment you receive a shipment from your supplier, check and record the expiry date of each batch. Write it on the packaging and enter it into your inventory system. This creates the foundation for all expiry management. If you are using Vendrex, you can add expiry information to product notes or custom fields. Make this a non-negotiable step in your goods-in process.

Use First Expiry, First Out (FEFO). Arrange your stock so that medications with the earliest expiry dates are at the front of the shelf and are dispensed first. This simple physical arrangement reduces the risk of products expiring before they are sold. Train your staff to always check expiry dates when picking stock and to use the soonest-expiring batch first. This FEFO method is the industry standard for pharmacy inventory management.

Conduct regular expiry date checks. Set a schedule to physically inspect your inventory for approaching expiry dates. Weekly for fast-moving medications, monthly for slower-moving stock. Create a checklist of all products and check each one against its recorded expiry date. Document the checks so you have a record of due diligence.

Use your POS system's stock tracking. While Vendrex does not currently have dedicated batch-level expiry tracking, you can use its existing inventory management features to stay on top of stock levels. Combined with regular physical checks and good record-keeping practices, even basic stock tracking can help you manage expiry dates more effectively than paper-based systems.

Managing near-expiry stock

When you identify stock approaching its expiry date, you have several options:

  • Discount and promote. Reduce the price of near-expiry medications to encourage faster turnover. Train your staff to offer these medications to customers when appropriate, clearly communicating the remaining shelf life. Customers who need the medication soon are often happy to purchase at a discount.
  • Return to supplier. Some pharmaceutical suppliers accept returns of near-expiry stock, especially if the product has a minimum of 6-12 months remaining. Check your supplier agreements. Track return acceptance rates by supplier in supplier management to identify which vendors offer the best terms.
  • Transfer between locations. If you operate multiple pharmacy locations, a product that moves slowly at one store might sell quickly at another. Consider physically moving near-expiry stock to the location with the highest sales velocity.
  • Write off expired stock. When medication expires, it must be removed from inventory and disposed of properly. Record the loss and remove it from your active stock counts. Proper disposal of expired medications is important for environmental and safety reasons — follow pharmaceutical waste disposal guidelines applicable in Haiti.

Setting up a manual expiry tracking system

If your POS system does not have dedicated batch-level expiry tracking, here is how to set up a practical manual system:

  1. Create a product expiry log. Use a spreadsheet (Google Sheets or Excel) to track each batch of medication. Columns should include: product name, batch number (if available), quantity received, expiry date, and quantity remaining. Update this log whenever you receive new stock or dispense from a specific batch.
  2. Color-code by urgency. Use conditional formatting to highlight products approaching expiry: green for 6+ months, yellow for 3-6 months, red for less than 3 months. This visual system makes it easy to spot which products need attention.
  3. Set review reminders. Schedule a weekly calendar reminder to review your expiry log. Check for products that have moved into the yellow or red zones and decide what action to take — discount, return, or prepare to write off.
  4. Integrate with your POS. Use Vendrex low stock alerts to flag products that are running low. Combine this with your manual expiry log to make informed purchasing decisions. If you have 6 months of stock but it expires in 4 months, do not reorder until you have sold through the existing inventory.

Common pharmacy expiry tracking mistakes

Not recording expiry dates on receipt. This is the most common mistake. Staff are busy, the delivery is large, and recording expiry dates feels tedious. But without this data, you cannot track expiry at all. Make it a required step in your receiving workflow.

Relying only on physical shelf checks. Manual expiry checks happen periodically and can miss products that expire between checks. Combine physical checks with a written log or spreadsheet that you review regularly. This dual system catches what either method alone might miss.

Ordering too much of slow-moving medications. A common pattern: a supplier offers a discount for bulk purchasing, so you order a large quantity of a medication that sells slowly. Months later, half of it expires before it can be sold. The "discount" becomes a net loss. Calculate your actual demand before placing orders and resist the temptation to over-order. The cost of expired stock almost always exceeds the value of the bulk discount.

Forgetting about opened multi-dose vials. Once opened, multi-dose vials have a limited use period (typically 28 days) regardless of the printed expiry date. Track opened vials separately. Write the opening date on the vial and dispose of it after the use period expires. This is especially important for vaccines and insulin, where potency degrades rapidly after opening.

What to look for in a pharmacy POS system

When evaluating POS systems for your pharmacy, here are the expiry-related features to ask about:

  • Batch-level inventory tracking — Can the system track individual batches of the same medication separately? Batch tracking is essential for managing different expiry dates of the same product.
  • Expiry date entry on receipt — Can you record expiry dates when receiving purchase orders? Entering this data at goods-in time is the foundation of expiry management.
  • FEFO picking support — Does the system suggest which batch to dispense first? Automatic FEFO (First Expiry, First Out) picking helps staff always use the soonest-expiring stock first.
  • Expiry date alerts — Does the system warn you before medications expire? Alerts with configurable lead times (30, 60, 90 days) give you time to take action.
  • Expiry reports — Can you run reports showing all products nearing their expiry date, sorted by urgency? Good reporting helps you make informed decisions about discounts, returns, or write-offs.

These features are on the Vendrex roadmap for future pharmacy-specific enhancements. Currently, Vendrex provides core inventory management capabilities that support manual expiry tracking workflows. See the pharmacy POS page for current capabilities.

Frequently Asked Questions

Dedicated batch-level expiry tracking is planned for a future release. Currently, Vendrex tracks inventory at the product level. You can use product notes, custom fields, and a separate spreadsheet or log to manage expiry dates manually while Vendrex handles general stock tracking.

Create a spreadsheet with product names, batch numbers, expiry dates, and quantities. Use conditional formatting to highlight approaching expiry dates. Set calendar reminders to review the log weekly. This manual sysem combined with Vendrex low stock alerts provides a practical approach while waiting for dedicated expiry tracking features.

Return eligibility depends on your supplier agreements. Some suppliers accept returns of near-expiry stock (typically requiring 6+ months of remaining shelf life). Most will not accept fully expired stock. Check your supplier contracts and return policies. Vendrex supplier management can store notes about each supplier's return policy for easy reference.

FEFO stands for First Expiry, First Out. It means you dispense medications with the earliest expiry date first, before moving to batches with later dates. This minimizes the risk of stock expiring on your shelves. FEFO is the industry standard for pharmacy inventory management. In the absence of automated FEFO support in your POS system, train your staff to physically check expiry dates and always pick the soonest-expiring batch first.

Better pharmacy inventory starts here

Download Vendrex and manage your pharmacy inventory with core stock tracking, supplier management, and purchase orders. Free to start.

Download on Google Play

Enter expiry dates immediately upon receipt. The moment a purchase order is received, enter the expiry dates for each batch. If you wait, you will forget or the information will be lost. Make this a non-negotiable step in your goods-in process. Train receiving staff to always check and record expiry dates before putting stock on the shelf.

Physically arrange stock by expiry date. The system handles FEFO digitally, but your physical shelf arrangement should support it too. Place soonest-expiring stock at the front of the shelf, furthest-expiring at the back. This visual arrangement helps staff physically pick the right batch, serving as a backup to the digital system. Label shelves with the earliest expiry date of stock in that position.

Conduct monthly physical expiry checks. Once per month, physically inspect your inventory for expired stock. Compare physical findings against your Vendrex expiry report. Discrepancies indicate a process problem — either stock was not properly recorded on receipt, or staff are not following FEFO picking procedures. Investigate and correct the root cause.

Audit supplier deliveries for remaining shelf life. When receiving stock from suppliers, check the expiry date before accepting the delivery. Some suppliers may try to offload short-dated stock. Establish a minimum acceptable remaining shelf life for incoming stock — e.g., at least 12 months for most medications, 18 months for slow-moving items. Reject deliveries that do not meet your minimum. Record supplier compliance in supplier management so you can make informed decisions about which vendors to prioritize.

Use sales data to optimize purchasing. Review your medication sales velocity before placing orders. A medication that sells 10 units per month needs a different order quantity than one that sells 10 units per year. Over-ordering slow-moving medications is the primary cause of expired stock. Use Vendrex sales reports to see exactly how fast each product moves and order quantities that match your actual demand.

Common pharmacy expiry tracking mistakes

Not recording expiry dates during goods-in. This is the most common mistake. Staff are busy, the delivery is large, and entering expiry dates for every batch feels tedious. But without this data, you cannot track expiry at all. Make it a required step in your receiving workflow. No expiry date = no acceptance of the batch into inventory.

Relying only on physical shelf checks. Manual expiry checks are important, but they happen periodically (weekly or monthly) and can miss products that expire between checks. A digital system that alerts you in real time catches what physical checks miss. Use both systems together for complete coverage.

Ordering too much of slow-moving medications. A common pattern: a supplier offers a discount for bulk purchasing, so you order a large quantity of a medication that sells slowly. Months later, half of it expires before it can be sold. The "discount" becomes a net loss. Calculate your actual demand before placing orders and resist the temptation to over-order, even with supplier incentives. The cost of expired stock almost always exceeds the value of the bulk discount.

Forgetting about opened multi-dose vials. Once opened, multi-dose vials have a limited use period (typically 28 days) regardless of the printed expiry date. Track opened vials separately. Write the opening date on the vial and dispose of it after the use period expires. This is especially important for vaccines and insulin, where potency degrades rapidly after opening.

Frequently Asked Questions

Vendrex tracks inventory at the product and variant level, not at the batch level. Each product has a single stock count rather than separate counts per batch with different expiry dates. Dedicated batch-level inventory tracking with FEFO (First Expiry, First Out) is planned for a future release.

Vendrex does not currently offer expiry-date-specific alerts. You can use the low-stock alert system to set minimum thresholds that account for expected expiry losses, and review slow-moving products using the inventory reports. Dedicated expiry alerts are planned for a future release.

Vendrex tracks inventory at the product level rather than by individual batch. Each product or variant has a single aggregate stock count. Dedicated batch-level tracking that manages partial batches with different expiry dates is planned for a future release.

Return eligibility depends on your supplier agreements. Some suppliers accept returns of near-expiry stock (typically requiring 6+ months of remaining shelf life). Most will not accept fully expired stock. Check your supplier contracts and return policies. Vendrex tracks purchase order history so you can reference which supplier provided which products when initiating returns.

Vendrex does not currently have a self-service inventory write-off feature. For expired or damaged stock, keep a record of the quantities and contact support for assistance. Dedicated write-off functionality is planned for a future release.

Track expiry dates and protect your patients

Download Vendrex and set up batch-level expiry tracking. Free to start — no commitment required.

Download on Google Play

Explore related guides and features

Pharmacy POS → Inventory → Purchase Orders → Low Stock Alerts → Supplier Management → Reports → Pricing →