How to Track Expiry Dates and Reorder Levels for Clinic Medical Supplies

Managing clinic medical supplies comes down to two goals: never use an expired item on a patient, and never run out of an essential item in the middle of a clinic day. To get there, a clinic needs one stock sheet that records the batch, expiry date and quantity of every item, a clear shelving rule (first expiry, first out), a calculated reorder level for each item, and a monthly count that someone signs off. It doesn't take complex software. It takes discipline in a few steps.

Our article on medical inventory management in small clinics covers the big picture. This one focuses on the two places where most waste happens: expiry tracking and reorder levels.

Why clinics lose track of expiry dates and shortages

In most private clinics nobody clearly owns the stock. Reception receives the delivery, a nurse puts it on the shelf, and the doctor notices a shortage when they need the item. The result is three recurring patterns:

• Items expiring at the back of the shelf: new deliveries go in front of old ones, so the new stock gets used and the old stock expires. This is common with IV fluids, local anaesthetic, filling materials and topical creams.
• Emergency purchases at retail prices: when gloves or sutures run out suddenly, someone buys them from the nearest pharmacy at a higher price than the supplier's.
• An emergency cart that isn't ready: emergency drugs are rarely used, so they're forgotten, and they may be found expired at the exact moment you need them.

The World Health Organization's guidance on managing medicines in health facilities stresses accurate stock records, storage that respects expiry dates, and regular checks. The steps below apply those principles to a small clinic or medical center.

Step 1: Build one shared stock sheet

Use a shared spreadsheet (Google Sheets or Excel on OneDrive) that everyone who receives or uses stock can open. The key is one sheet, not several notebooks. Give it these columns:

• Item name, strength and form (ampoule, tablets, cream, pack).
• Batch/lot number and expiry date: one row per batch, because two batches of the same item can expire months apart.
• Current quantity and storage location (shelf, fridge, emergency cart, branch).
• Reorder level and par level (explained in Step 3).
• Supplier and last purchase price.
• A calculated "days to expiry" column with conditional colours: red under 30 days, amber under 90.

With that, expiry tracking becomes a glance at one coloured column instead of opening every box.

Step 2: Shelve by "first expiry, first out" (FEFO)

FIFO (first in, first out) is a good habit, but for medical supplies FEFO is more precise: the item that expires first is used first, even if it arrived later. Put it into practice:

• On receipt, always place the batch with the nearest expiry at the front.
• Write the expiry date in large print or with a coloured sticker on the outer box.
• Keep a clearly labelled "expiring soon" box for items with less than 60 days left, so the team uses them first or returns them to the supplier where possible.
• Move expired items immediately into a closed box marked "expired – do not use" until they're disposed of under your health authority's rules.

Step 3: Calculate a reorder level for each item

The reorder level is the quantity at which you must place an order. The simple formula:

Reorder level = (average daily use × supplier lead time in days) + safety stock

Illustrative example: a dental clinic uses an average of 4 local anaesthetic cartridges a day, the supplier takes 5 days to deliver, and the clinic wants 3 days of safety stock. So: (4 × 5) + (4 × 3) = 32 cartridges. When the balance hits 32, an order goes out. The par level is what you want the balance to reach after the order arrives, for example a full month of use.

Don't calculate this for every item on day one. Start with your top 20: the most used, the most expensive, and the ones that would be most dangerous to run out of. Then extend the list.

Step 4: Decide who receives, who uses and who signs off

Stock without an owner is stock without control. Split the roles clearly:

• Receiving: one person checks the delivery against the supplier invoice and enters the batch and expiry in the sheet.
• Daily use: the nurse or assistant logs what was taken from the shelf at the end of each day.
• Changes and approval: only the clinic manager edits balances, prices or reorder levels, and approves orders.

If your spreadsheet supports protected ranges, lock the reorder-level and price columns for everyone except the manager.

Step 5: A monthly count and a weekly emergency cart check

• Monthly count: physically count every item and compare it with the sheet. Any large difference needs an explanation: unlogged use, damage or a receiving error.
• Weekly emergency cart check: a fixed list of items, quantities and expiry dates that one person checks and signs with the date. It's the most important list in the clinic, even though it's the least used.
• Fridge: a daily temperature log for medicines that need refrigeration.

Common ways to manage clinic stock compared

For most private clinics, an organised shared sheet with clear roles solves most of the problem at no extra cost.

Where Ehgizli helps, and where it doesn't

To be clear: Ehgizli doesn't track stock. It has no item balances, expiry alerts, barcode scanning or automatic deduction of consumables. Your shared stock sheet does that job. Ehgizli helps with the billing and organisational side around supplies:

• Services price list: record your services and procedures with their prices, including procedures that use costly materials, so pricing is consistent across staff.
• Invoice line items: add the consumables used in a procedure as separate lines on the patient's invoice (description, quantity, unit price), so the cost of materials isn't lost. See simplifying clinic invoices and payments.
• Branches: if you have more than one location, appointments are recorded per branch, and you can give your stock sheet one tab per branch in the same way. See multi-branch clinic management.
• Permissions and audit trail: each team role has its own permissions, and changes to invoices and clinical records are logged.

To see where clinic revenue slips away more broadly, read causes of medical clinic revenue leakage and how to fix them.

Frequently Asked Questions

What's the difference between FIFO and FEFO in a clinic?

FIFO means using what arrived first; FEFO means using what expires first. For medicines and medical supplies FEFO is more precise, because a newer delivery can expire before an older one.

How often should clinic supplies be counted?

A full count at least once a month, a weekly check of the emergency cart, and a daily temperature log for refrigerated medicines.

How do I set a reorder level if I don't know daily use?

Log what's used for two to four weeks, then divide the total by the number of working days. Until then, use a cautious estimate with a larger safety stock.

Does Ehgizli track inventory and expiry dates?

No. Ehgizli manages appointments, medical records, prescriptions and invoices, and you can bill consumables as invoice lines, but stock balances and expiry dates are tracked in your stock sheet.

Do I need a credit card to try Ehgizli?

No. The 14-day free trial doesn't require a credit card. See pricing.

Conclusion

Managing clinic supplies doesn't start with software. It starts with one sheet, shelves arranged first-expiry-first-out, a calculated reorder level and someone who signs off. Set up your top 20 items this week, add the emergency cart to a weekly checklist, and you'll see the difference in waste within a month.

Start your 14-day free trial of Ehgizli to organise appointments, records and invoices, no credit card required.

Disclaimer: this article is general information on clinic administration. The storage, handling and disposal of medicines are subject to your country's health ministry and drug authority requirements.