FEFO Inventory for Indian Pharmacies — Guide [2026]

Indian pharmacy counters move fast. A single shop may dispense hundreds of lines a day across OTC, chronic medicines, and hospital-linked prescriptions. Inventory is not abstract SKUs on a spreadsheet—it is physical cartons with batch numbers and expiry months printed in small type. When staff pick the wrong batch, you lose money, patient trust, and sleep before the drug inspector visits. This guide explains FEFO (First Expiry, First Out) inventory management in plain language for owners, pharmacists, and finance leads—without invented statistics or fake testimonials.

What Is FEFO Inventory Management?

FEFO means First Expiry, First Out. You sell or dispense stock closest to its expiry date before stock that expires later. The goal is simple: reduce waste from expired medicines and reduce the risk of dispensing a batch that should already be off the shelf.

FIFO—First In, First Out—is a warehouse idea based on arrival order. It works when every unit of a product is identical and does not spoil. Pharmacy inventory fails that assumption. Two cartons of the same brand may have different batch numbers and different expiry months sitting on the same shelf. If newer stock is easier to reach at the front, FIFO picking accidentally ships the fresh batch while older batches expire at the back.

In Indian retail pharmacies, the failure mode is familiar: high-volume counters, staff turnover, and verbal instructions (“check expiry”) that collapse during evening rush. A trainee grabs the box in front. A locum pharmacist covers two branches and does not know which shelf was restocked yesterday. Manual FEFO with coloured stickers helps for a week, then discipline drifts. Software should enforce batch choice at billing time—not only report expiry after the damage is done.

Generic substitution adds another layer. When the prescribed brand is unavailable, pharmacists may dispense an equivalent with a different batch profile. FEFO still applies to the batch you actually hand over—document the substitution in your records so inspectors and doctors can follow the trail.

Why Indian Pharmacies Lose Money on Expiry Write-offs

Expiry loss is not only “dead stock thrown away.” It is often near-expiry stock that was still legally dispensable last month but never picked because it sat behind newer cartons. Finance sees the write-off at disposal; operations felt the problem earlier as cash tied in slow-moving batches.

Regulatory context matters. Retail pharmacies in India operate under state drug licensing and national drug standards. Inspectors expect traceable batch records and sensible dispensing practice—especially for products with limited shelf life. CDSCO guidance on good distribution and dispensing practice emphasises preventing expired or substandard medicines from reaching patients. A shop that cannot show batch-level movement during an inspection invites corrective action, even when intent was good.

Manual FEFO breaks down at scale. A single-store owner can walk the shelf weekly. A five-branch group cannot rely on one hero pharmacist at each site. Head office sends WhatsApp reminders; branches nod; then rush hour returns and the front-facing box wins again. Without batch-level visibility per branch, headquarters discovers expiry risk when the write-off entry hits the books—too late to intervene.

Multi-branch transfers make it worse. Stock moved from Branch A to Branch B carries its expiry profile. If the receiving branch treats all cartons as fungible, you inherit Branch A’s picking mistakes. Central purchasing without central expiry discipline is how good margins erode quietly.

Promotions can fight FEFO if not designed carefully. “Buy two get one” on a SKU with two batches may clear the wrong batch first unless the promotion engine respects expiry order. Marketing and pharmacy leads should align promo rules with batch logic, not only with margin targets.

How FEFO Inventory Works in Practice

Step one is goods receipt with batch truth. When purchase stock arrives, each line is recorded with batch number and expiry date—not only MRP and quantity. Barcode scanning reduces keyboard errors; mandatory expiry fields stop “TBD” batches from entering inventory.

Step two is shelf discipline aligned to system truth. Physical placement still matters—humans pick what they see—but the system should not allow billing against a farther expiry if a nearer batch has quantity available. That enforcement happens at the billing counter when the pharmacist selects or confirms a SKU.

Step three is billing-time FEFO. The register proposes the earliest-expiry batch with available quantity. Staff can override only with permission and reason where policy allows; overrides should leave an audit trail for the owner or superintendent pharmacist.

Step four is near-expiry alerts before crisis. Useful thresholds are often 90, 60, and 30 days depending on category and turnover. Alerts should surface to branch managers and owners—not only in a monthly PDF. Action might be promotion, return-to-vendor negotiation, or inter-branch transfer to a faster-moving site.

Step five is reconciliation and returns. Supplier returns, breakage, and patient returns must restore or adjust batch quantities correctly. A FEFO system that only handles sales but ignores returns will drift from physical stock within weeks.

FEFO vs FIFO in Pharmacy — Which Is Required?

For medicines with batch expiry, FEFO is the dispensing discipline regulators expect in practice. FIFO is a shortcut that ignores expiry heterogeneity. Using FIFO logic in software for pharma SKUs is how shops pass audits until one inspection focuses on batch traceability—and then the gap is obvious.

CDSCO’s framework for good distribution and retail practice centres patient safety: expired drugs must not be sold, and batch traceability must be maintainable. While your exact inspection checklist depends on state rules, inspectors routinely ask how you ensure near-expiry stock is managed. “We tell staff to check” is weaker than “the billing system blocks farther expiry when nearer stock exists.”

FIFO still has a place for non-expiry consumables—bags, gloves, some OTC accessories—but drug inventory with batch expiry should be FEFO-first. Mixing both models in one shop is fine if software labels categories correctly.

Temperature-sensitive lines add complexity. Cold-chain products may need FEFO within a fridge with separate batch tracking from room stock. Software should not treat “same SKU” as one pool when storage conditions differ.

What to Look for in Pharmacy Software with FEFO Support

Use this checklist when vendors demo “batch tracking”:

• Batch-level stock on every inbound movement—purchase, transfer, adjustment—not only on paper labels
• Billing counter enforcement that selects earliest available expiry by default
• Configurable near-expiry alerts (30/60/90-day windows) per category or branch
• Branch-level expiry visibility for owners without calling each store manager
• Audit trail on overrides when staff must dispense a non-FEFO batch for clinical reasons
• Returns and breakages that adjust the same batch ledger sales use
• Reports inspectors can follow: batch in, batch out, balance on date

Reports alone are insufficient. If the counter can still bill a farther expiry while nearer stock exists, you will keep paying write-offs. Demand a live billing demo with two batches of the same SKU and watch which batch the system proposes.

Supplier return windows matter. FEFO helps you use stock before expiry; returns help you move stock you cannot sell in time. Software should connect near-expiry alerts to return workflows your finance team already negotiates with distributors.

Training beats posters. Run a ten-minute drill: two batches, one SKU, one sale—watch whether the system proposes the nearer expiry without prompting. Repeat after staff rotation. FEFO dies when only the owner knows the rule.

Finance should review expiry risk monthly, not only at disposal. A simple branch report: quantity and value by 30/60/90-day buckets. Owners use it to negotiate returns with suppliers and to move stock between branches before write-off.

Hospital pharmacies linked to IPD and OPD see higher stakes—controlled products and cold-chain items add constraints. FEFO still applies to batch expiry; clinical protocols may override picking in specific cases, but those overrides must be traceable.

Start with one high-value SKU family—antibiotics, chronic cardiac lines, or high-turnover OTC—and prove FEFO for thirty days before rewiring the entire warehouse. Small wins convince staff faster than a big-bang lecture.

Hayati AI Nexus treats FEFO as operational infrastructure for Indian pharmacy and hospital retail—not a spreadsheet export. See how batch-aware billing and inventory connect on our pharmacy inventory feature page.