The verdict in three sentences
An owner of 3 independent pharmacies in New York who tracks inventory without lot and expiry data usually loses 2 to 4% of purchases to expired product, shrink and returns that never get credited. As a 2026 order of magnitude, a custom inventory and expiry layer that sits on top of your pharmacy management system costs USD 35,000 to 90,000 with a US agency and goes live in 10 to 14 weeks. It also prepares you for DSCSA lot-level requirements, since the small dispenser exemption ends on November 27, 2026.
Why losses reach 2 to 4% in an independent store
In Queens, Brooklyn or Upper Manhattan, an independent store carries 4,000 to 8,000 SKUs and receives daily deliveries from a primary wholesaler such as McKesson, Cardinal Health or Cencora. The pharmacy management system handles claims to PBMs and the prescription workflow well, but most stores still manage front-shop and slow-moving Rx stock without lot data. New boxes go in front of old ones, slow movers pass their date and nobody notices until the annual count.
Three more leaks add up: stockouts on high-volume generics that send patients to the chain down the block, cash discrepancies between registers, and returns to reverse distributors credited late or partially.
| Loss source | Typical share of purchases | With the software | Lever |
|---|---|---|---|
| Expired product | 1 to 1.5% | 0.2 to 0.4% | Alerts at 90, 60 and 30 days, FEFO picking |
| Shrink and count variances | 0.5 to 1% | 0.2 to 0.3% | Cycle counts, per-user permissions |
| Stockouts on fast movers | 0.3 to 1% of lost sales | Under 0.2% | Automatic reorder points |
| Uncredited returns | 0.2 to 0.5% | Close to 0% | Credit tracking per return authorization |
| Total | 2 to 4% | Under 1% |
The FEFO rule (first expired, first out) is the core: every pick suggests the lot that expires first, and alerts leave time to return a product or transfer it to the store where it sells faster.
What the layer includes and what it costs
| Module | Functions | 2026 order of magnitude (USD) |
|---|---|---|
| Lot and expiry stock | Receiving by lot, FEFO, alerts, transfers between stores | 8,000 to 18,000 |
| Wholesaler orders | Suggested orders, receiving, matching against the EDI invoice | 6,000 to 15,000 |
| DSCSA data | Storing transaction information by lot, quick lookups for verification requests | 6,000 to 15,000 |
| Connector to the pharmacy system | Reading dispensing data, writing stock levels | 5,000 to 15,000 |
| Multi-store dashboard | Margins, turns, losses and returns per store | 4,000 to 12,000 |
| Returns and reverse distribution | Return authorizations, expected and received credits | 6,000 to 15,000 |
| Total | 35,000 to 90,000 |
Kolonell builds this kind of custom web application from its own grid in FCFA and EUR: 4,000,000 to 7,000,000 FCFA (EUR 6,100 to 10,670) for a medium application and 7,000,000 to 15,000,000+ FCFA (EUR 10,670 to 22,870+) for a complex one. The USD figures above are US market ranges; the exact price is set in the quote.
Controlled substances stay where they belong: in your certified dispensing system, with New York's I-STOP prescription monitoring and DEA record-keeping untouched. The custom layer reads data, it does not replace regulated workflows. Under HIPAA, the vendor signs a business associate agreement, and access is logged per user.
The 10 to 14 week schedule
Weeks 1 and 2: scoping with the owner, staff pharmacists and the bookkeeper, plus product master import. Weeks 3 to 8: stock, ordering and connector. Weeks 9 and 10: DSCSA data, returns and dashboard. Weeks 11 to 14: initial lot-level count in each store, pilot in one store, then rollout to the other two. The initial count is the heaviest step: plan one overnight session per store.
Mini case study
Need a professional website?
Kolonell builds websites that attract clients, optimized for the Sénégalese market. Free quote in 2 minutes.
Maria Gonzalez, owner of 3 independent pharmacies in Queens, buys USD 450,000 a month across the three stores, of which about USD 120,000 is front-shop and non-PBM stock exposed to expiry and shrink.
- Exposed annual purchases: 120,000 × 12 = USD 1,440,000.
- Current losses at 3%: USD 43,200 a year.
- Target losses at 1%: USD 14,400, i.e. USD 28,800 saved a year.
- Returns credited faster and in full: about USD 9,000 more recovered a year.
- Investment: USD 55,000. Payback: 55,000 / 37,800 × 12 = about 17 months, before counting the time saved on DSCSA lookups.
FAQ
Do we need a full count to switch to lot tracking?
Yes, once, at go-live. For a store with 6,000 SKUs, plan 6 to 10 people for one night with barcode scanners that read the 2D DataMatrix on prescription packs.
Does this replace our pharmacy management system?
No. Claims, PBM adjudication and controlled substance workflows stay in your certified system. The layer reads dispensing data and manages lots, expiry and returns.
How does it help with DSCSA?
It stores transaction information by lot and lets staff answer a verification request in seconds. With the small dispenser exemption ending November 27, 2026, that matters for stores with 25 or fewer full-time pharmacists and technicians.
Can we transfer stock between our stores?
Yes. The dashboard shows slow movers nearing expiry in one store and demand in another, and each transfer is logged by lot.
What does it cost to run after launch?
As a 2026 order of magnitude, hosting at USD 150 to 400 a month plus a maintenance retainer set in the quote. Kolonell maintenance tiers start at 35,000 FCFA (EUR 53) a month.
Let's scope your project. We map lot tracking, wholesaler orders, returns and DSCSA data for your stores, for a rollout in 10 to 14 weeks. Detailed quote within 48 h. WhatsApp +221 77 596 93 33.
Mohamed Bah
Fondateur, Kolonell
Passionate about digital and entrepreneurship in Africa, Mohamed has been helping Sénégalese businesses with their digital transformation since 2020. Founder of Kolonell, he believes every SME deserves a professional and accessible online présence.
