Pharmacy Stock Reconciliation in UAE: Checking Batches, Expiry Dates and Quarantined Products
A pharmacy can have the correct number of medicine packs on its shelves and still have inaccurate inventory records. Some packs may belong to a different batch, carry an earlier expiry date or be awaiting a decision before they can be dispensed.
Pharmacy stock reconciliation means comparing physical medicines with inventory records by product, quantity, batch, expiry date, location and stock status. It helps pharmacy teams understand what they hold, what is available and which differences need investigation.
For UAE pharmacies, this level of detail supports purchasing decisions, traceability and stock accountability.
Why Is a Total Stock Count Not Enough?
A total quantity can hide a shortage in one batch and an excess in another. It can also include medicines that remain physically present but are blocked from dispensing.
Reconciliation should therefore answer three questions: Does the quantity match? Does the identity of the stock match? Does its recorded availability match its actual status?
Keeping these checks together makes the final stock report more useful than a list of product totals.
Prepare the Pharmacy Before Counting
Set a clear counting time and identify every location, including shelves, drawers, refrigerators, receiving areas and stock awaiting return. Allocate each area to a named counter to reduce duplication.
Save an inventory snapshot before counting. Record any dispensing, deliveries or transfers that continue during the exercise so movements can be reconciled to the same point in time.
Agree on counting units. A box, strip and individual tablet must not be treated as interchangeable quantities. Record opened packs consistently without compromising packaging or product integrity.
Resolve pending receipts and branch transfers wherever possible before comparing balances.
Check Medicines Batch by Batch
For each product, record:
- Product name, strength and dosage form.
- Pack size and counting unit.
- Batch or lot number and expiry date.
- Physical quantity and storage location.
- Stock status, such as available or quarantined.
Keep different batches on separate lines, even when they share the same product code. Compare those lines with the system records and relevant receiving documents.
Do not assume that scanning a product barcode captures its batch and expiry information. Confirm what the scanner and software actually record, then verify any missing details against the packaging.
Investigate missing or unreadable batch information with the responsible pharmacist. Replacing it with an estimated value weakens traceability and can make a later recall harder to manage.
Review Expiry Dates Before Stock Becomes Unusable
Compare the expiry date on each batch with the date recorded in the inventory system. Look for transposed digits, incorrect years and dates copied from another delivery.
For eligible stock, use first expiry-first-out, or FEFO: prioritise the earliest expiry rather than the earliest receipt. WHO storage guidance supports this approach. It does not make expired or otherwise unsuitable medicines eligible for dispensing.
Create a near-expiry report using internal alert periods that reflect demand, supplier return arrangements and applicable requirements. Do not confuse a supplier’s return deadline with the manufacturer’s expiry date.
Assign follow-up actions to purchasing or pharmacy staff. An expiry report without an owner can leave the same stock unnoticed until the next count.
How Should Quarantined Products Be Reconciled?
Quarantined products are held separately, physically or through effective controls, while a decision is pending. Reasons can include returns, quality concerns or suspected storage problems. Maintain required storage conditions during the hold, including refrigeration where applicable. Release requires an authorised decision under the relevant procedure; intact packaging alone does not establish suitability.
Count these products, but distinguish their physical quantity from stock available for dispensing. Give each quarantine entry a reason, date, responsible person and review status.
Check that the physical holding location agrees with the system status. A labelled quarantine shelf provides incomplete control if the same packs still appear as available in the dispensing system.
Investigate Differences Before Changing Records
Recount discrepancies first, preferably using a second person. Then review receipts, dispensing entries, returns, branch transfers and pack conversions.
Differences may reflect unposted transactions or stock recorded against the wrong batch. Avoid using a general adjustment to conceal the underlying cause.
Keep the original balance, counted quantity, explanation, supporting reference and approval together. Separate quantity corrections from changes to batch details or availability status so reviewers can understand what changed.
Review recurring differences by product and location. Repeated errors in one refrigerator or receiving area may point to a workflow problem that another full count will not resolve.
Finish with a reconciliation report showing unresolved differences, near-expiry quantities, quarantined balances and named actions, so the next review starts with a follow-up list.
Close the Loop on Returns and Disposal
Stock accountability continues after medicines leave the saleable area. Match supplier returns to collection evidence and follow up on agreed credits separately.
For disposal, confirm the applicable approval route. Where the Emirates Drug Establishment’s safe-destruction service applies, declared quantities must match the actual products, and destruction evidence from the relevant entities is required. Keep that evidence linked to stock records.
The pharmacist responsible should confirm current requirements for the pharmacy and product category, particularly for controlled medicines. These operational checks do not replace applicable regulatory procedures.
Maintain Accuracy Between Stock Counts
Reconciliation becomes easier when everyday transactions capture accurate details. Check batches and expiry dates on receipt, record movements promptly and make status changes visible to dispensing staff.
Set a documented counting schedule based on transaction volume, product risk and applicable requirements. Between full counts, target products with recurring differences, high values or approaching expiry dates. These checks can identify problems before they spread.
Automation can help. Use exception reports to identify missing expiry dates, unexpected batch balances and quarantined products still marked as available. AI tools can help prioritise unusual patterns, while staff investigate the evidence and approve corrections. Review unresolved differences and overdue actions. Pharmacy stock reconciliation in the UAE depends on keeping physical quantities, batch records and dispensing availability aligned.