How to Maintain Medicine Stock in a Medical Store: Expiry, FEFO & Reorder Levels
Good medical store stock management is simple in principle: know what you have, know which batch expires first, issue the right stock first, and reorder before a fast-moving medicine runs out.
For a pharmacy, stock is more than a quantity on a screen. A useful record should identify the medicine, batch or lot where relevant, expiry date and quantity, while the store itself should be arranged so staff can find and rotate stock correctly. WHO guidance recommends keeping expiry dates visible, maintaining inventory records, organizing stock by expiry date and prioritizing products that expire sooner. WHO guidance on medicine stock management.
Quick answer: To maintain medicine stock, record every purchase batch with quantity and expiry date, organize shelves so earlier-expiring stock is issued first, review near-expiry medicines regularly, set reorder levels from actual usage and supplier lead time, and reconcile software records with physical stock. For Indian medical stores, batch-wise expiry tracking is far more useful than keeping only one total quantity per medicine.
Learn more about medical stock management software.
What is stock in a medical store?
Stock in a medical store means the medicines and other products currently held for sale or use. In practice, that record needs more detail than simply saying “50 strips available.” A pharmacy may have the same medicine in different batches, with different expiry dates, purchase prices or other batch-specific information.
That is why batch and expiry records matter. Indian government training material for medical supplies describes stock registers as records of receipts, issues and balances and specifically shows expiry information being tracked batch by batch. It also instructs stores to issue medicines due to expire first. National Tuberculosis Elimination Programme training material.
Why is medical store stock management different from normal retail?
A grocery shop can usually think in terms of product and quantity. A medical store has another question:
Which batch should be sold first?
Imagine that your system says a medicine has 100 units. That number alone does not tell you whether 20 units expire next month while the remaining 80 expire much later.
For pharmacy inventory, the batch is therefore part of the stock record. This also makes expiry review, supplier returns and physical reconciliation easier.
Should a pharmacy use FIFO or FEFO?
For medicines with expiry dates, FEFO — First Expiry, First Out — is the more useful rule. The stock with the earliest expiry should be prioritized for issue, subject to the medicine’s applicable handling and dispensing requirements.
FIFO, or First In, First Out, is still useful for items without expiry dates or where receipt order is the relevant rotation method. WHO guidance distinguishes expiry-based rotation from ordinary FIFO and recommends prioritizing stock with the shorter remaining life. WHO standard operating procedure guidance.
For a pharmacy, don’t treat FIFO and FEFO as interchangeable words. If two batches arrived at different times but the newer batch expires sooner, expiry date should drive the rotation for that medicine.
How should you organize medicines on the shelf?
Start with visibility.
Medicine categories should have defined storage locations, and products should be arranged so staff can identify them without repeatedly moving boxes around. Expiry dates need to remain easy to see. WHO guidance recommends clearly labeled storage locations and organizing stock according to expiry dates. WHO medical supplies and equipment guidance.
A practical shelf routine is:
- Record the incoming batch before putting it into active stock.
- Place earlier-expiring stock where staff will pick it first.
- Keep later-expiring stock behind or separately where appropriate.
- Keep damaged or expired products out of normal saleable stock.
- Review shelf organization during routine physical checks.
The exact storage conditions depend on the medicine. Follow the product’s labeling and applicable pharmacy requirements rather than applying one storage rule to every item.
How does medicine expiry tracking work?
Medicine expiry tracking starts when stock enters the store, not when somebody notices an expiry date months later.
For each relevant batch, record the batch or lot number, expiry date and quantity. WHO guidance recommends keeping records of batch or lot number, expiry dates and quantities in stock forms or warehouse systems. WHO inventory SOP.
Then create a routine for reviewing approaching expiry. The exact review window should match your products, supplier return arrangements and local procedures. Don’t invent a universal “90-day rule” and apply it to every medicine.
A useful expiry report should help you answer:
- Which medicines have the earliest expiry dates?
- Which batches are approaching expiry?
- How much quantity is affected?
- Which items need a supplier-return decision?
- Which expired or damaged items must be removed from saleable stock?
What should you do with expired or damaged medicines?
Expired, damaged or otherwise unsuitable stock should not remain mixed with normal saleable inventory.
Separate it, record the adjustment and follow the applicable disposal procedure. Indian government training material instructs that expired products should be separated and disposed of according to applicable biomedical-waste procedures, while WHO guidance calls for removing expired or damaged products from shelves and following approved disposal procedures.
Do not simply delete the quantity from your software. Record why the stock was removed. That gives you a better audit trail and helps explain why physical stock and system stock changed.
How do you set a medicine reorder level?
Reordering too late creates stock-outs. Reordering too early ties money up in stock that might move slowly or expire.
A basic starting formula is:
Reorder level = average daily usage × supplier lead time + safety stock
For example, if a medicine is used at a known daily rate and your supplier normally takes several days to deliver, the reorder point should cover expected usage during that delivery period plus a reasonable buffer. The numbers must come from your own sales or dispensing history and supplier performance.
Do not give every medicine the same reorder level. A fast-moving product and a slow-moving product have different stock requirements.
What information should a medical store stock record contain?
A useful medicine stock record should make it possible to understand the movement of an item without reconstructing the story from multiple notebooks.
| Stock information | Why it matters |
|---|---|
| Medicine name | Identifies the product |
| Batch / lot number | Separates one batch from another |
| Expiry date | Supports expiry review and FEFO rotation |
| Quantity received | Records incoming stock |
| Quantity issued/sold | Tracks stock movement |
| Current balance | Shows available recorded stock |
| Supplier | Connects purchases to the source |
| Purchase reference | Helps trace the incoming transaction |
The fields you need should reflect the medicines and products your store actually handles.
Why should physical stock be checked against the system?
Software does not make an incorrect stock count correct.
If 20 units are recorded but only 17 are physically present, someone needs to investigate the difference. The cause could be a data-entry error, unrecorded sale, breakage, damage, return or another stock movement.
WHO guidance describes stock control as keeping reliable records of stock received and issued and performing regular stock-taking. WHO stock-control guidance.
Don’t wait for an annual exercise to discover obvious discrepancies. Use a routine appropriate for the size and risk of your store, with extra attention to high-value or fast-moving products.
How can medical store software make stock management easier?
Software is useful when it removes repetitive work rather than simply replacing a paper register with a screen.
A pharmacy-focused inventory system should make batch and expiry information easy to record, show current stock, identify approaching expiry, support reorder decisions and connect stock movement with sales or purchases where those features are available.
Some current pharmacy systems use batch-wise expiry tracking, expiry alerts and reorder levels as core inventory features. Those are useful concepts to look for when comparing software, but the exact workflow and capabilities should be confirmed in a live demo. citeturn0search0turn0search3
See EasyBill’s medical stock management system.
What should you test before choosing medical store stock software?
Don’t ask only, “Does it have inventory?” Give the vendor one realistic medicine and test the complete workflow.
- Purchase: Enter the medicine, supplier, batch, expiry and quantity.
- Stock: Confirm that the received quantity appears correctly.
- Sale: Sell part of that batch and check the remaining balance.
- Expiry: Find the batch in the expiry report or stock view.
- Reorder: Check how the system identifies low stock.
- Adjustment: Test how damaged, expired or corrected stock is recorded.
- Reporting: Check whether staff can find the information without rebuilding it manually.
If the demo only shows a colorful dashboard, ask for the transaction trail instead. That is where inventory software proves its value.
Who is this approach best suited for?
This method is aimed at medical store owners, pharmacists, pharmacy managers and staff who are responsible for purchasing, stock control and dispensing.
A very small store can run inventory with a disciplined register or spreadsheet. As the number of products, batches and transactions grows, software becomes more useful because expiry, stock movement and reorder information become harder to maintain manually.
The decision should be based on your workflow, not on how many features appear in a product brochure.
Final recommendation: maintain stock around expiry, usage and traceability
If you remember only one thing, make it this: medicine stock should be managed batch-wise wherever batch and expiry information matters, not just as one total quantity per product.
Record incoming stock correctly. Rotate by expiry. Review approaching expiry before it becomes a loss. Set reorder levels from actual usage and supplier lead time. Then compare your system balance with physical stock on a defined schedule.
For a medical store considering software, test one medicine from purchase through sale, expiry reporting and stock reconciliation. If the workflow is easy to understand and the records remain traceable, you have found something worth evaluating further.