Expiry date checking is a routine but important part of pharmacy stock management.
Traditionally, many pharmacies organise this using a date checking matrix: the dispensary is divided into sections, each area is checked according to a schedule, and staff sign or initial the matrix once the check has been completed.
It is a familiar system and, when followed consistently, it works.
But for busy pharmacy teams, a paper date checking matrix can also become difficult to manage. Sheets need to be updated, short-dated medicines may be recorded separately, completed checks need to be retained, and managers may have little visibility of progress without physically checking the paperwork.
A digital expiry checking system can make the same process easier to follow and easier to demonstrate.
What is a pharmacy date checking matrix?
A pharmacy date checking matrix is a schedule used to make sure that all medicine storage areas are checked regularly for expired and short-dated stock.
A dispensary may, for example, be divided into sections such as:
- dispensary shelves;
- fast-moving stock;
- controlled drugs;
- medicines stored in refrigerators;
- retail medicines;
- stock rooms;
- consultation rooms; and
- other medicine storage areas.
Each area is allocated to a particular week or date.
Once the stock has been checked, the member of staff carrying out the check records that it has been completed.
The purpose is simple: make expiry checking systematic rather than relying on somebody remembering to do it.
Why are documented expiry checks important?
Finding an expired medicine on a dispensary shelf is more than a stock-control problem.
Pharmacies need processes that reduce the risk of expired medicines remaining available for supply and should be able to demonstrate that those processes are being followed.
Recent GPhC inspection and improvement reports continue to refer to documented date-checking programmes, dispensary date checking matrices and records of short-dated stock.
A good expiry-checking process therefore needs to answer several basic questions:
What needs checking?
When was it checked?
Who completed the check?
Which medicines are approaching expiry?
What happened to stock identified during the check?
A traditional matrix normally answers the first three questions.
Digital expiry tracking can go considerably further.
The limitations of a paper date checking matrix
Paper date checking matrices are simple, inexpensive and familiar to pharmacy teams.
But the information recorded on them is limited.
Imagine that Shelf A has been checked and signed as complete.
The matrix confirms that somebody checked the shelf, but it does not necessarily tell you:
- which short-dated products were found;
- when each product expires;
- how many packs are affected;
- the value of the stock at risk;
- whether the item was later dispensed;
- whether it was removed;
- whether it was eventually destroyed; or
- whether another member of staff needs to take action.
This often results in several different systems being used at once.
There may be a date checking matrix, a separate short-dated stock list, stickers on packs, waste records and additional notes or spreadsheets.
For a busy pharmacy, keeping all of these records aligned can become another administrative task.
Moving from a date checking matrix to digital expiry tracking
A digital system does not need to change the basic principle behind pharmacy date checking.
The pharmacy can still divide its stock into locations and follow a regular checking cycle.
The difference is that the check becomes connected to the actual stock records.
With PharmaAudit, pharmacies can create their own storage locations and run expiry-check cycles across those areas.
Instead of simply marking a section as checked, medicines identified during the process can be recorded with information such as their expiry date, quantity and location.
The dashboard can then show which stock requires attention.
See what is approaching expiry
One of the biggest differences between a traditional pharmacy date checking matrix and digital expiry tracking is what happens after the initial check.
A paper matrix mainly records that the job was completed.
PharmaAudit keeps the expiry information available so that it can be acted on later.
Teams can identify medicines that are:
- expiring this month;
- approaching expiry;
- already expired; or
- requiring attention within selected expiry periods.
This creates a live list of short-dated stock rather than a record that disappears into a folder once a shelf check has been completed.
Track expiry checks by pharmacy location
Pharmacies are organised differently, so a fixed date checking matrix does not always suit every dispensary.
PharmaAudit allows organisations to create locations that reflect their actual pharmacy.
These might include:
- Dispensary A
- Dispensary B
- Fridge
- Controlled Drug Cabinet
- OTC Shelves
- Stock Room
- Consultation Room
Expiry-check cycles can then be used to monitor which areas have been checked and which are still outstanding.
This provides a digital equivalent of the traditional date checking matrix while maintaining a clearer history of the work completed.
Scan medicines instead of repeatedly writing them down
Entering every medicine manually can make any expiry-recording system time-consuming.
PharmaAudit supports barcode and GS1/2D barcode scanning through the mobile app.
Previously used medicines and barcode mappings can also be remembered, reducing the amount of repeated data entry when the same products are encountered during future checks.
For teams carrying out regular stock expiry checks, this can make maintaining a digital short-dated stock list considerably more practical.
What happened to the short-dated stock?
Identifying a medicine approaching expiry is only the beginning of the process.
Ideally, the pharmacy should be able to see what eventually happened to that stock.
Within PharmaAudit, stock can progress through actions such as:
- used or dispensed;
- removed or set aside;
- destroyed; or
- otherwise updated as appropriate.
Waste records can also be reviewed separately.
This creates a clearer link between finding short-dated stock and recording the eventual outcome.
Reduce medicine waste
Expiry checking is primarily a patient-safety and governance activity, but good expiry management can also reduce unnecessary stock losses.
If short-dated medicines are identified early enough, there may be an opportunity to use appropriate stock before newer stock, review ordering levels or take other action before the medicine becomes waste.
PharmaAudit can record pack values and provide visibility of the value of stock approaching expiry.
That means the expiry-checking process can help answer another useful question:
How much stock value is currently at risk of expiring?
Keep an audit trail
Paper records work well until somebody needs to find an old one.
Digital records can make it much easier to review previous activity.
PharmaAudit records expiry-check activity and provides reporting tools through the mobile app and web dashboard.
Managers can review expiry checks, stock actions and waste information without searching through folders of historical matrices and handwritten sheets.
This can also make it easier to demonstrate that expiry checking is an ongoing process rather than an activity completed immediately before an inspection.
Does digital expiry checking replace the pharmacy SOP?
No.
Technology should support the pharmacy’s procedures rather than replace them.
Each pharmacy should still have an appropriate procedure describing how medicines are stored, rotated, date checked and dealt with when they become short-dated or expired.
The advantage of a digital system is that it can make following that procedure easier to organise, record and review.
From a date checking matrix to a live expiry dashboard
The traditional pharmacy date checking matrix has served pharmacies for many years.
Its basic principle remains sensible: divide the pharmacy into manageable areas, check them regularly and record completion.
But the same process can now provide considerably more useful information.
Instead of simply knowing that Shelf A was checked on Tuesday, a digital system can help the pharmacy see:
- which areas have been checked;
- which checks remain outstanding;
- which medicines are approaching expiry;
- where those medicines are located;
- how much stock is affected;
- the value of stock at risk;
- what action was taken; and
- a historical record of previous checks.
For pharmacies still relying on paper matrices, spreadsheets and separate short-dated stock lists, moving to digital expiry tracking can simplify the process while creating a much clearer audit trail.
Try PharmaAudit
PharmaAudit is designed for pharmacies and healthcare teams that want a simpler way to manage expiry dates, stock checks and other routine governance records.
Alongside expiry tracking, PharmaAudit includes tools for medicine recalls, waste, temperature monitoring, near misses, incidents, Responsible Pharmacist records, SOPs, learning and staff responsibilities.
It can be used through the PharmaAudit mobile app and secure web dashboard.
Start a 7-day free trial and see how PharmaAudit can replace a traditional date checking matrix with a live, searchable expiry-management system.