Independent Pharmacy Chain
How a 17-Outlet Pharmacy Chain Cut Expiry Write-Offs by 68%
17
Retail outlets across the network
Rs14L+
Annual procurement savings recovered
11 days
Faster supplier credit reconciliation
1 Qtr
Time to measurable results post go-live
The Problem
Running 17 pharmacy retail outlet operations means managing thousands of active SKUs across Schedule H medications, OTC products, and nutritional lines, all with hard expiry dates and strict FSSAI batch traceability requirements. The chain’s existing workflows were built for a single-store operation and had never been properly scaled.
Three interconnected problems were eating into margins every month.
No Batch-Level Expiry Visibility
Stock was counted by SKU, not by batch or expiry date. Near-expiry units sat undetected on shelves until physical verification, at which point the write-off was unavoidable.
Unreconciled Supplier Credit Notes
Distributors issued credit notes for short-dated returns, but manual matching against purchase invoices lagged by weeks. Some credits were never claimed at all, representing direct procurement losses.
Fragmented Inter-Outlet Transfers
When one outlet had slow-moving near-expiry stock and another had a stockout of the same molecule, there was no system to flag the mismatch. Both problems persisted side by side.
The Solution Stack
Aaxonix implemented a three-product Zoho stack with the central design principle that every inventory movement, from goods receipt to inter-outlet transfer to return, had to carry batch and expiry metadata.
01
Zoho Inventory
Batch Tracking with FEFO Dispatch Rules
Every inward shipment is received against a batch number and expiry date at the time of GRN. FEFO (first-expiry, first-out) dispatch rules ensure older batches are allocated to sales orders before newer ones. A rolling 90-day near-expiry alert surfaces batches requiring action, either inter-outlet transfer or return initiation.
02
Zoho Books
Supplier Debit Note Automation and GST Reconciliation
When a return shipment is raised in Zoho Inventory batch tracking, a linked debit note is auto-drafted in Zoho Books against the original purchase invoice. GST input credit on the original purchase is flagged for reversal or re-claim depending on the return type, keeping GSTR-2B reconciliation clean. Outstanding supplier credit notes are tracked on a live aging dashboard.
03
Zoho Creator
Near-Expiry Action Workflow and Inter-Outlet Transfer Portal
A Creator app aggregates near-expiry alerts from all 17 outlets. Pharmacy managers log into a single view showing batch-level expiry dates, current stock at each location, and suggested transfer destinations. Transfer orders raised inside Creator push directly into Zoho Inventory, eliminating WhatsApp and phone-based coordination.
Before vs After
| Area |
Before Implementation |
After Implementation |
| Expiry tracking |
SKU-level only, no batch dates in system |
Batch, lot, and expiry date on every inward GRN |
| Near-expiry alerts |
Manual monthly physical check per outlet |
Rolling 90-day automated alert across all 17 outlets |
| Dispatch logic |
FIFO by receipt date, no expiry consideration |
FEFO enforced at pick time via Zoho Inventory rules |
| Supplier credit reconciliation |
Manual spreadsheet matching, 2 to 3 week lag |
Auto-drafted debit notes, reconciled within 2 to 3 days |
| Inter-outlet transfers |
Coordinated over phone and WhatsApp, no system record |
Creator portal raises transfer order directly in Zoho Inventory |
| GST input on returns |
Handled ad-hoc, frequent mismatches in GSTR-2B |
Auto-flagged for reversal or re-claim on each debit note |
| Expiry write-off value |
Estimated Rs20L to Rs22L per year |
Reduced to approximately Rs7L per year (68% drop) |
Implementation Phases
1
Discovery and Data Audit
Weeks 1 to 2
Mapped all 17 outlet workflows, catalogued SKU master data, and audited the last 12 months of supplier credit notes to quantify unrecovered procurement losses. Identified 340 SKUs across Schedule H and FSSAI-regulated categories requiring mandatory batch traceability.
2
Zoho Inventory Configuration and Batch Master Setup
Weeks 3 to 5
Enabled batch tracking for all 340 regulated SKUs. Configured FEFO dispatch rules, GRN templates with mandatory batch and expiry fields, and multi-warehouse locations representing each outlet. Migrated opening stock with batch data for the current live inventory.
3
Zoho Books Integration and Debit Note Workflow
Weeks 5 to 7
Connected Zoho Inventory returns to Zoho Books supplier reconciliation debit note drafts via webhook. Built supplier aging dashboard and GST input flag logic. Reconciled the backlog of outstanding credit notes from the previous 6 months during this phase.
4
Zoho Creator Portal Build and UAT
Weeks 7 to 10
Built the near-expiry action portal in Zoho Creator workflow apps. UAT conducted with pharmacists from 4 pilot outlets. Feedback loops refined the transfer suggestion logic and the mobile view for outlet-level managers. Parallel-run period with existing WhatsApp workflow to validate accuracy.
5
Full Chain Rollout and Training
Weeks 10 to 13
Rolled out to all 17 outlets in two waves. Conducted on-site training at each location covering GRN entry, near-expiry alert response, and transfer order creation. Hypercare support for 30 days post go-live.
Results After One Quarter
68%
Drop in near-expiry write-offs
11 days
Faster supplier credit reconciliation
Rs14L
Annual procurement savings recovered
Monthly Near-Expiry Write-Off Value (Rs Lakhs) , 6 Months Pre vs 6 Months Post
For a pharmacy chain at this scale, expiry write-offs and unclaimed supplier credits are not an operations problem. They are a data problem. The moment batch-level expiry data existed in a structured system and every return triggered an automated financial workflow, the losses became visible, actionable, and stoppable. The technology investment paid back within the first quarter.
Frequently Asked Questions
Does Zoho Inventory support batch tracking for Schedule H and Schedule H1 drugs specifically?
Yes. Zoho Inventory’s batch tracking feature is product-category agnostic. You configure which SKUs require batch and expiry capture at the item level. For Schedule H and H1 drugs, you can make both fields mandatory on the GRN form, ensuring no inward shipment is received without full traceability data. This satisfies standard CDSCO and FSSAI batch record requirements for retail pharmacy.
How does the automated debit note workflow handle partial credit notes from distributors?
When a return shipment is raised for a subset of a purchase invoice, the Zoho Books integration creates a debit note referencing only the returned line items and quantities. GST input reversal is calculated proportionally. The outstanding balance on the original purchase invoice is updated automatically, and the supplier aging dashboard shows the net amount still pending credit from that distributor.
Can inter-outlet transfers be tracked for GST purposes, given that outlets may be in the same GSTIN or different GSTINs?
This is handled at the configuration stage. Outlets under a single GSTIN are set up as internal warehouses in Zoho Inventory, so inter-outlet transfers are stock movements with no GST implication. If any outlets operate under separate GSTINs, those are configured as distinct organisations with a branch transfer workflow that raises a delivery challan and tax invoice as required under GST rules for stock transfers between distinct persons.
What is the typical implementation timeline for a pharmacy chain of this size?
For a 15 to 20 outlet independent pharmacy chain, the full implementation including data migration, Zoho Inventory configuration, Zoho Books integration, and the Creator near-expiry portal runs approximately 10 to 13 weeks from discovery to go-live. A phased rollout across outlet batches, rather than a single cutover, reduces operational risk and allows training to be absorbed more effectively at store level.
