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 · location | Labelled expiry | System / shelf packs | Owner | Due date | Status and next action |
|---|---|---|---|---|---|
| EXP-101 · L27A · Shelf A | 15 Mar 2027 | 8 / 8 | Inventory lead | 3 Feb 2027 | Verified. Confirm the supplier's return window and record its response. |
| EXP-101 · L27B · Shelf A | 28 Mar 2027 | 5 / 3 | Stock reviewer | 1 Feb 2027 | Discrepancy open. Recount both lots and check recent movements. |
| EXP-204 · L27C · Shelf B | 20 Mar 2027 | 4 / 4 | Buyer | 5 Feb 2027 | Action in progress. Record the reference when the supplier-authorized return is complete. |
| EXP-308 · L27D · Shelf C | 25 Mar 2027 | 0 / 0 | Inventory lead | 1 Feb 2027 | Closed. 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.
