Pharmacy Inventory Management for Clinics: Expiry, Stockouts and Controlled Drugs
How a clinic or hospital pharmacy in Nigeria controls stock: batches and expiry, reorder levels, counts, stores and transfers, suppliers and controlled drugs.
By Ebuka, Founder of Medly · Last updated: 13 November 2026
The short version
- Record every delivery by batch and expiry date, and dispense the earliest expiry first.
- Set a reorder level for each item so you order before you run out.
- Count stock regularly and write down why anything is missing or damaged.
- Controlled drugs need a witness and a register of every movement.
Common problems
- medicines expiring on the shelf while newer stock is used first;
- running out of a common medicine because nobody noticed it was low;
- stock that disappears between the main store and the ward;
- prices that don’t follow the cost of the last delivery;
- no record of who took a controlled drug, or how much is left;
- equipment nobody can find, or that hasn’t been serviced in years.
The basics of stock control
- Receive every delivery against the supplier’s invoice, with the batch number, expiry date and cost.
- Dispense the earliest expiry first (FEFO), and check the shelf every month for what expires in the next three months.
- Set reorder levels from how fast each item moves, and check what is low every day.
- Count each store regularly, batch by batch, and record differences with a reason: damaged, expired, lost or stolen, used by staff, found or returned.
- Move stock between stores only by a request that someone approves, and record what each store used.
- Keep an equipment register by serial number, with where each item is and when it was last serviced.
Controlled drugs
Medicines such as tramadol, morphine, pentazocine, pethidine, codeine, diazepam and ketamine are controlled. The Pharmacy Council of Nigeria Act 2022 has rules on storing, recording and dispensing dangerous drugs, and PCN’s inspection guidelines say controlled substances are handled only by a licensed pharmacist.
In practice, keep them locked, have a second person witness every movement in and out, and keep a register showing each movement, who made it, who witnessed it and the balance left. Ask PCN or your state pharmacy inspectors what your register must show.
How Medly helps
Medly’s dispensary and stores are pharmacy inventory management software inside the same system as your doctors, wards and billing:
- Deliveries by batch, with expiry, cost, supplier and invoice number. Dispensing and doses given on the ward take the earliest expiry first.
- Reorder levels per item; low stock, stock expiring within 90 days and expired stock are flagged on Today and on the warnings page.
- Stock counts batch by batch, and adjustments with a reason. Lost, stolen and used by staff need a note.
- Anything short at dispensing is marked to buy outside, and the patient sees what to buy in the Medly app. Labels print with the directions, warnings and who dispensed it.
- Generic swaps: give another brand and the record keeps what was given. A different medicine needs a reason.
- Controlled drugs: every movement, from receiving to dispensing, giving on the ward, counts and transfers, needs a witness from your staff, and the Controlled Drugs register shows each movement with who did it, who witnessed it and the balance left in that place.
- More than one store, such as a main store and a ward store, with transfers and requests that need approval. Hospital plan.
- Suppliers and purchase orders, receiving against the order, and prices that follow cost with your own markup. Hospital plan.
- An equipment register by serial number or tag, with where each item is, its condition and service dates. Equipment due for service within 30 days, overdue or not working is listed.