How to Track Drug Expiry Dates and Batch Numbers in a Nigerian Pharmacy

As a community pharmacy or patent medicine store operator in Nigeria, your biggest silent profit killer isn’t low patronage—it is expired inventory.

Discovering boxes of high-value antimalarials, antibiotics, or syrups at the back of your shelf that expired three months ago is an immediate financial loss. Worse still, selling an expired product to a customer by accident destroys your pharmacy’s reputation and risks regulatory sanctions from PCN or NAFDAC.

Most local pharmacies try to manage expiry dates using marker pens on drug boxes or messy exercise books. But when you are balancing multiple wholesale deliveries across busy counter shifts, paper registers always fail.

Here is a highly effective operational system to organize your drug batches, monitor shelf-life, and keep your pharmacy profit margins healthy.

The Danger of "First-In, First-Out" (FIFO) in Pharmacy Retail

Many retail stores use the traditional FIFO (First-In, First-Out) method for their stock. They sell the goods they bought first before opening newer stock.

In a pharmacy, this approach can ruin your cash flow. If you purchase a batch of Amoxicillin in January with an expiry date of December 2027, and then buy another batch in February with an closer expiry date of August 2027 (due to manufacturer clearances), selling the January batch first means the February batch will expire on your shelf.

Pharmacies must operate on FEFO (First-Expired, First-Out). Your oldest stock isn’t determined by when you bought it, but by when it expires.

A Foolproof Workflow to Manage Drug Batches

Step 1: Log Supplier Invoices by Batch Delivery

Never dump a new consignment of medications straight onto the retail floor. When your supplier delivery arrives, separate the items by their Batch Number and Expiry Date. Even if you receive five cartons of the same multivitamin, verify if they share the same batch code. If they don’t, treat them as separate inventory entries.

Step 2: Use Visual Date Tranches on Your Shelves

Organize your physical shelves into color-coded zones or tranches based on remaining shelf life: * Green Zone: Medications with more than 12 months before expiration. * Yellow Zone: Medications with 6 to 12 months remaining. (Review these monthly). * Red Zone: Medications with less than 6 months remaining. Move these to the front of the counter immediately for fast clearance or contact your supplier to check for return/exchange options.

Step 3: Audit Stock Levels During Staff Shift Handovers

When your pharmacy attendants swap shifts between morning and evening, do not just count cash. Run a quick audit on your high-cost or fast-moving tranches. Ensuring your team pulls stock from the correct batch protects your inventory structure from human error during rush hours.

Stop Writing Expiry Dates on Paper Logs

Manually flipping through a notebook to check which drugs are expiring next is exhausting and unreliable. You need a system that alerts you automatically before a loss occurs.

How to Monitor Drug Batches Seamlessly inside NairaFlow:

1. Enter the Supplier Invoice: When fresh drugs arrive, open NairaFlow, log the Supplier Invoice, and input the total cost.
2. Assign the Batch: Under the product details, use the Batches module to type in the manufacturer batch code and select the exact expiration month and year.
3. Set Up Automated Expiry Reports: Open your Reports dashboard in NairaFlow to filter your inventory by expiration timelines. The app will neatly group your medications into time tranches, showing you exactly what needs to leave the shelf first.
4. Track Shift Performance: Use the Shifts and Staff settings to ensure counter attendants are logging individual sales accurately without guessing which batch an item belongs to.

Shifting your pharmacy from paper guesswork to data-driven batch tracking saves thousands of naira in expired stock and keeps your business running smoothly.