How One Pharmacy Lost ₹2L on Expired Stock—A Deep Dive with ERP Logs

Imagine walking into your local pharmacy to collect medicine, only to learn the store just wrote off two lakh rupees worth of expired stock. For any pharmacy—small or large—this is a painful hit. Margins are tight, customer trust is crucial, and inventory is the lifeblood of the business. In this post, we’ll peel back the layers on how a single outlet let ₹2 lakh in medicines slip through the cracks, and show exactly how their ERP logs told the full story. We’ll end with practical steps any pharmacy can take to prevent a similar disaster.

The ₹2L Shock: A Costly Discovery

It began with a routine month‑end audit. The store manager noticed unusually large disposal entries in the ERP system—entries labeled “Stock write‑off” totaling ₹2,00,000 for expired medicines. No one on the counter team had flagged these items or suggested markdowns. It wasn’t a one‑off SKU, but dozens of products across painkillers, antibiotics, and chronic‑care drugs. In one moment, inventory that cost the pharmacy significant capital simply had to be destroyed.

Why did they discover it in the ERP, not on the shelf? Because the expired boxes were tucked away in the back, mixed with fine stock. They’d missed every visual check. In an industry where every rupee matters, this oversight was more than a clerical error—it was a wake‑up call.

Mapping the Pharmacy’s Profile

Before we dig into the logs, here’s a quick profile of the outlet:

• Type: Single‑location retail pharmacy
• SKU Count: ~1,200 active products
• Monthly Sales: ₹10–12 lakh
• Inventory Turnover: 4–5 times per month
• ERP System: Cloud‑based pharmacy management with stock, billing, and disposal modules

This isn’t a massive chain; it’s a neighborhood pharmacy where stock moves quickly and relationships matter. Even here, a ₹2 lakh loss represented nearly two weeks of sales—a serious blow.

The Moment of Truth: Examining the ERP Logs

Let’s look at how the ERP told the story:

Date

Activity Type

Description

User/Source

Notes

Date

Activity Type

12 Jan

Purchase Invoice

100 strips of medicine entered in inventory

Supplier: MedHealth

Batch: MHTX-452

12 Jan

Purchase Invoice

20 Jan

Sale Entry

2 strips sold to customer

Counter Staff

Retail bill

20 Jan

Sale Entry

18 Mar

Stock Check

Stock report shows 98 strips still available

SwilERP

No movement for 2 months

18 Mar

Stock Check

02 Apr

Near Expiry Alert

System alert triggered for upcoming expiry

SwilERP

Ignored by user

02 Apr

Near Expiry Alert

05 May

Stock Audit

Internal audit flags unused inventory

Inventory Manager

Escalated to owner

05 May

Stock Audit

1. Last Sale Date vs. Disposal Date
   Many items hadn’t sold since December or January. No counter staff used them in February, even as expiry drew near.
2. Received On vs. Expiry Date
   Batches had 4–6 months of shelf life. Under normal turnover, they should have sold, but low demand or poor visibility kept them hidden.
3. Disposal Value
   Each disposal entry captured the original cost. Accounting saw ₹2 lakh vanish in one click of “Approve Disposal.”

Without the ERP logs, this pattern would have been impossible to spot until the auditor’s surprise walk‑through.

Uncovering the Root Causes

Why did this happen? The logs reveal several gaps:

1. No FEFO (First‑Expiry, First‑Out) Picking

What went wrong: Staff used FIFO (First‑In, First‑Out) or random picking. That meant newer stock got sold first, leaving older, expiring batches at the back.

How ERP helps: Modern systems enforce FEFO. During packing or counter sales, the software suggests the batch with the earliest expiry date, keeping all stock fresh.

Read Also : Inventory control using FEFO & ABC analysis

2. Lack of Expiry Alerts

What went wrong: With no automated warnings, nobody knew which batches were 30 or 60 days from expiry. A manual calendar check would have been needed—a task nobody had time for.

How ERP helps: Configure expiry thresholds (e.g., 90/60/30 days). The system then pops up daily alerts or dashboard cards showing “20 products expire in 30 days,” triggering discount campaigns or removal.

3. No Automated Markdown Rules

What went wrong: The pharmacy never ran clearance promotions for near‑expiry stock. Managers forgot or didn’t see the need until it was too late.

How ERP helps: Set rules like “If a batch is within 30 days of expiry, apply 20% discount.” At checkout, the system applies the markdown automatically or prompts staff to suggest the discount to customers.

4. Informal Disposal Process

What went wrong: Disposals were logged only after staff piled expired boxes in a corner. The ERP’s disposal module sat unused until month‑end.

How ERP helps: Require disposal entries with photographed receipts and supervisor approval. Make it a daily task: when staff see an expired item, scanning its barcode forces a disposal dialog before continuing.

5. Poor Visibility in Reports

What went wrong: Weekly or monthly reports lumped disposals under “stock adjustments,” buried among thousands of transactions. No one noticed the spike until the big audit.

How ERP helps: Create a “Stock Health” report showing ageing inventory at every glance. Dashboards spotlight disposal trends, so any spike in write‑offs pops up red.

The Financial Pain and Opportunity Cost

Writing off ₹2 lakh isn’t just a paper loss. Consider:

• Lost Margin: At a 25% margin, that write‑off equates to ₹50,000 in lost profit.
• Cash Flow Impact: Money tied up in expired goods can’t restock faster‑moving items.
• Man‑Hours Wasted: Counting, disposing, and logging 300+ boxes took days of staff time.

Conversely, if even half of that stock sold at 20% discount, the pharmacy would have made a net gain:

• Sale Revenue: ₹1.6 lakh
• Cost Price: ₹2 lakh
• Discount Impact: −₹40,000
• Net: ₹1.6 lakh – ₹1.6 lakh = breakeven, but no write‑off.

Plus, you build goodwill with bargain‑hunters and avoid the headache of bulk disposals.

Prevention: Your 5‑Step ERP Action Plan

1. Run an Expiry Report Today
   Log into your ERP, filter stock by expiry, and review items expiring in the next 90, 60, and 30 days.
2. Enable Automated Alerts
   In system settings, switch on expiry threshold notifications. Deliver them via email or show them on your dashboard every morning.
3. Activate FEFO Enforcement
   Under your picking or billing settings, turn on “Pick by earliest expiry” to ensure outdated batches move first.
4. Set Up Automatic Markdown Rules
   Create a pricing rule: e.g., “If expiry ≤30 days, apply 15% discount; if ≤15 days, apply 30%.” The POS screen will handle it.
5. Lock Down Disposal with Approvals
   Make disposals a supervisor function. Require barcode scan, photo, and note before the system accepts the stock removal.

Implement these today and significantly reduce your write‑offs tomorrow.

A Final Word

No business can afford ₹2 lakh vanishing into expired medicines. Yet, without the right processes, it’s easy to let stock slip through the cracks. ERP logs don’t just record history—they guide your future. By using expiry alerts, FEFO picking, automatic markdowns, and clear disposal workflows, you empower your counter staff with the tools they need to keep your shelves fresh and your cash drawer full.

Take a few minutes today to check your ERP settings. Those simple steps can save you tens of thousands—and maybe even your worst ₹2 lakh nightmare.