← All articles

·4 min read

How to Track Near-Expiry Stock in an Independent Pharmacy

Track expiry by lot, assign follow-up and reconcile the shelf count with your system. Copy a sample queue to test the workflow in your pharmacy.

Track near-expiry pharmacy stock by product, lot and location. Record the labelled expiry at receiving, assign each flagged lot to an owner with a due date, and verify the physical count before closing the task.

Key takeaways

  • Keep a separate row for each lot and location.
  • Use the next action deadline to order the queue.
  • Record count corrections and the outcome of each approved action.

What should staff capture at receiving?

Record the product identifier and pack size, lot number, labelled expiry, quantity in a defined unit, storage location and receipt reference. If a delivery contains two lots of the same SKU, enter each lot on its own line. Keep separate quantities by location so the reviewer knows where to look.

Use the date precision shown on the package. If the label has only a month and year, record that precision and use your pharmacy's procedure to determine which date drives the alert. If the label is unclear or the barcode import omits the lot or expiry, assign a verification task so the receiver can check the package or supplier record.

For Ontario community pharmacies, review the workflow with the Designated Manager against the pharmacy's own inventory procedures and the Ontario College of Pharmacists' policy. The alert windows below are illustrative operating choices. Ontario College of Pharmacists medication procurement and inventory management policy

How do you turn an expiry alert into an assigned task?

Record receipt → Create alert → Assign owner and due date → Verify shelf count → Carry out the approved action → Reconcile and close

Pick a regular review time and a backup owner. A pharmacy might test a 60-day warning and a weekly queue review, then schedule earlier action when a supplier's confirmed cutoff or an internal follow-up date calls for it. Refresh the task when a count changes or a return is delayed. Keep one open task per product, lot and location so repeated alerts update the existing work.

Copy this near-expiry queue

The example assumes a review on 1 February 2027. All SKU, lot, quantity and deadline values are fictional. Owner roles are placeholders to replace with staff names.

SKU · lot · locationLabelled expirySystem / shelf packsOwnerDue dateStatus and next action
EXP-101 · L27A · Shelf A15 Mar 20278 / 8Inventory lead3 Feb 2027Verified. Confirm the supplier's return window and record its response.
EXP-101 · L27B · Shelf A28 Mar 20275 / 3Stock reviewer1 Feb 2027Discrepancy open. Recount both lots and check recent movements.
EXP-204 · L27C · Shelf B20 Mar 20274 / 4Buyer5 Feb 2027Action in progress. Record the reference when the supplier-authorized return is complete.
EXP-308 · L27D · Shelf C25 Mar 20270 / 0Inventory lead1 Feb 2027Closed. Return reference and stock adjustment recorded.

How do you resolve a shelf-to-system mismatch?

First check the product, pack size, lot and storage location. Then compare the physical count with the latest receipts, transfers, stock adjustments and returns. In the example, the total for EXP-101 alone would not tell the reviewer where the two missing packs went. Recount L27B and check whether a movement was posted to L27A or another location.

If the cause is still unclear, leave the discrepancy open with the count, reviewer and next check. When the authorized reviewer confirms the correction, record the before-and-after quantities and the transaction reference. Close the task once the record reflects the physical outcome, including any approved action for the units that remain.

What should you test with your existing software?

  • Receive the same SKU in two lots with different expiry dates and find each lot by location.
  • Generate an alert, assign it to a named person and show overdue tasks to the backup owner.
  • Simulate a two-pack discrepancy and record who verified the correction.
  • Complete a mock return and export a report with the action date, quantity and reference.

Bring those scenarios to your next demo. The Ontario pharmacy software selection guide includes a wider scorecard for evaluating inventory, reporting, integration and data exports.

Frequently asked questions

How far ahead should a pharmacy flag near-expiry stock?

Choose a lead time that gives staff enough time to review the lot and act before the relevant date. The 60-day alert in this article is a trial setting. Check supplier return cutoffs and your pharmacy’s procedures.

Can you track two lots of the same SKU in one row?

Use a separate row for each lot and location. Each row needs its own expiry, quantity and status so staff can locate the stock and track the right action.

What should you do if the expiry label shows only a month and year?

Record the label at its stated precision. Follow the pharmacy’s procedure for setting the alert date and have unclear labels verified.