Pharmacy Inventory Management: Batches, Expiry, Reorder

Pharmacy Inventory Management: Batches, Expiry, Reorder

A Dhaka pharmacy can have medicine inside the business and still lose the sale at the counter. One branch is out of stock, another branch is holding the same item in a shorter-dated batch, and the team places a fresh order before anyone reviews what should move first. That is a pharmacy inventory management problem.

This guide is for pharmacy owners, operations heads, branch managers, and inventory decision-makers who need tighter control over batches, expiry risk, and reorder decisions. If any of these checks fail in your business, pharmacy inventory management needs attention:

  • You cannot see stock by batch and expiry date
  • Counter stock and back-store stock do not match
  • Branches reorder without checking each other first
  • Short-dated medicines stay hidden until too late
  • Sales and stock reports disagree at month-end

Why pharmacies lose control of inventory even when stock is available

Pharmacies lose control when they track quantity without tracking condition, location, and timing. Stock may exist, but it may be in the wrong batch, near expiry, sitting in the wrong branch, or not posted correctly after sale, return, or adjustment.

That is why pharmacy inventory control breaks even in businesses with strong demand. The issue is not only purchase volume. The issue is disconnected records between counter, store, branch, and accounts. AKIJ iBOS makes the same broader point in its guide on connected billing and stock: when sales and inventory do not move together, management decisions start from doubtful numbers.

The business cost appears in three places. First, customers hear “stock nai” even though the medicine is somewhere in the network. Second, short-dated stock stays untouched while newer stock sells first. Third, cash gets locked into overbuying because reorder decisions are made from partial visibility.

What pharmacy inventory management must track every day

Pharmacy inventory management must track the exact medicine, exact batch, exact expiry date, exact location, and exact remaining quantity every day. Anything less creates blind spots.

At minimum, every active medicine record should show:

  • item name, strength, form, and pack size
  • batch or lot number
  • expiry date
  • current available quantity
  • branch, store, and shelf location
  • supplier and inward reference
  • purchase cost and selling price
  • transfer, sale, return, and adjustment history

Item-level stock is not enough in a pharmacy

Item-level stock is misleading when the same medicine exists in multiple batches. A report that says “120 strips available” does not tell management whether 40 strips expire next month and 80 expire six months later.

Pharmacy batch tracking matters because movement decisions should be batch-sensitive, not only item-sensitive. If the counter sells the newest batch while an older batch remains in back-store, expiry loss becomes a process failure, not a demand problem.

Counter stock, back-store stock, and branch stock must match

Pharmacy stock management only works when location-level stock is trustworthy. The counter needs to know what is sellable now, the back-store needs to know what should be refilled next, and management needs to know which branch is overstocked or understocked.

Once locations drift apart, every later decision becomes weaker. Expiry review becomes inaccurate, reorder review becomes aggressive, and branch transfer decisions happen too late.

Pharmacy batch tracking from purchase to sale

Pharmacy batch tracking means the same batch identity follows a medicine from receiving to shelf movement, branch transfer, sale, return, and adjustment. That is the backbone of traceability.

AKIJ iBOS positions its Pharmacy Management Software around tracking every medicine by batch and expiry date across branches. That is the right operating model because a pharmacy cannot control expiry or branch imbalance without batch-level visibility.

What to capture when medicines are received

Receiving is where medicine inventory management either becomes reliable or stays weak for the rest of the cycle. If batch data is skipped at inward entry, later reports will only guess.

| Receiving field | Why it matters | |, -|, -| | Medicine name, strength, and pack | Prevents confusion between similar items | | Batch or lot number | Creates traceability for every later movement | | Expiry date | Supports FEFO issue and expiry review | | Received quantity | Builds the opening balance for that batch | | Supplier name and invoice reference | Helps with follow-up, dispute, and return | | Unit cost | Supports margin and stock valuation review | | Received date | Helps analyse supplier lead time and ageing | | Branch/store location | Places stock correctly from day one | | Short, excess, or damaged receipt note | Keeps exceptions documented |

A useful SOP is simple: no inward posting without batch and expiry entry, and no shelf placement until the inward record matches the physical goods.

How batch-wise stock should move between store, shelf, and branch

Batch-wise movement should preserve batch identity at every step. If 20 strips from Batch A move from central store to front shelf, the system should show Batch A at the new location, not only reduce one total and increase another.

The same rule applies to inter-branch movement. A branch transfer should carry item, batch, expiry, quantity, source branch, destination branch, and receiving confirmation. The control logic is similar to AKIJ iBOS’s guide on managing stock transfers across retail branches: location changes must be documented or stock visibility turns unreliable.

How sales, returns, and adjustments should stay batch-linked

Sales, returns, and adjustments should always affect the correct batch. If the counter sells an item but the system reduces a generic item balance instead of the actual issued batch, the next near-expiry report will be wrong.

Returns need the same discipline. A returned medicine should be checked, linked back to the right batch where possible, and kept separate if condition is uncertain. Manual adjustments should never be treated as normal movement; they need reason codes and review.

Expiry control in pharmacy inventory management

Expiry control in pharmacy inventory management means identifying short-dated stock early enough to act before value is lost. Good expiry control is a workflow, not a once-a-month clean-up.

FEFO vs FIFO for medicine inventory

FEFO means first expiry, first out. FIFO means first in, first out. For medicine inventory, FEFO is the safer operating rule because the batch nearest to expiry should move first, even if it was not the first batch received.

FIFO may still work inside a group of batches with similar expiry dates, but FEFO should guide shelf arrangement, internal issue, and sale preference. That reduces the chance of keeping a shorter-dated batch idle while a newer batch leaves the pharmacy.

Daily, weekly, and monthly expiry review workflow

Expiry control works best when responsibility is assigned by cadence, not left to memory.

| Review cadence | Typical owner | What to review | Action | |, -|, -|, -|, -| | Daily | Branch in-charge or store pharmacist | Short-dated items, shelf order, damaged packs | Move FEFO batches forward, flag transfer need, isolate damaged items | | Weekly | Branch manager or operations lead | Branch-wise near-expiry ageing and slow movers | Hold fresh purchase, plan transfers, review movement priority | | Monthly | Owner, operations, and accounts | Expired value, write-offs, repeat expiry patterns | Approve disposal/write-off process, review buying discipline, fix master data issues |

The exact ageing buckets should match your business policy, but the review rhythm should not change. Daily protects the shelf, weekly protects branch balance, and monthly protects management decisions.

What to do with short-dated, expired, and damaged medicines

Short-dated medicines should be visible in reports and physically easier to identify. The right response is usually to stop overbuying, move demand toward that batch first, and review whether another branch can consume it faster.

Expired medicines should be blocked from sale, separated physically, and documented by item, batch, quantity, and date. Damaged medicines should also be quarantined and reviewed before any stock adjustment is posted.

Non-moving medicines need a different decision. They may not be near expiry yet, but they still consume working capital and raise future expiry risk. That is why expiry review and non-moving review should never be separated.

Reorder controls without overstocking

Reorder controls protect availability without forcing the pharmacy to buy too early or too much. In practice, pharmacy reorder level decisions should combine sales speed, supplier lead time, safety stock, and branch-wise stock visibility.

How to set reorder levels using sales speed and supplier lead time

A practical reorder level formula is:

Reorder level = expected demand during lead time + safety stock

Start by grouping medicines into fast, medium, and slow movers. Then review average daily or weekly movement, how long suppliers usually take, and how much buffer is reasonable for that item. Fast movers need tighter review frequency; slow movers need stricter buying discipline.

A pharmacy reorder level should also consider usable stock only. If part of the balance is short-dated, reserved, damaged, or sitting in a branch that cannot consume it fast enough, it should not be treated as freely available stock.

A simple reorder example for one medicine SKU

Here is a simple medicine inventory management example:

| Item | Avg. daily sales | Supplier lead time | Lead-time demand | Safety stock | Reorder level | Current usable stock | Decision | |, -|, -:|, -:|, -:|, -:|, -:|, -:|, -| | Cefixime 200 mg | 18 strips | 4 days | 72 strips | 24 strips | 96 strips | 88 strips | Start replenishment review |

This example is simple on purpose. The point is not the formula alone. The point is that reorder control should be based on actual movement and lead time, not on guesswork or last month’s emergency.

When to transfer stock between branches before placing a fresh purchase

Branch transfer should be reviewed before a fresh purchase whenever another outlet is holding the same item in usable quantity, especially if that stock is shorter-dated. That protects both cash and expiry control.

A worked example makes the decision clearer:

| Branch | Batch | Expiry | Usable stock | Avg. daily sales | Immediate decision | |, -|, -|, -|, -:|, -:|, -| | Uttara | CFX2407 | Aug 2026 | 35 strips | 14 | Needs stock soon | | Uttara | CFX2409 | Dec 2026 | 20 strips | 14 | Keep after FEFO batch | | Mirpur | CFX2407 | Aug 2026 | 60 strips | 4 | Transfer part of short-dated batch | | Mirpur | CFX2410 | Jan 2027 | 40 strips | 4 | Hold for later use |

In this case, pharmacy stock management should transfer part of Batch CFX2407 from Mirpur to Uttara first. That lets Uttara sell the nearer-expiry stock through demand, reduces expiry risk in Mirpur, and may delay or reduce the fresh purchase.

A practical workflow for medicine inventory management in a pharmacy

A practical medicine inventory management workflow connects receiving, storage, sale, and review into one discipline. Good pharmacy inventory management is not one screen; it is one operating flow.

Purchase and receiving

Purchase should begin from reviewed demand, not panic. When medicines arrive, the receiving team should verify item, quantity, batch, expiry, and condition before posting inward stock. Weak data at this point will flow into every later report.

Storage and shelf placement

Storage should support FEFO, not fight it. Shorter-dated batches should be easier to reach, and shelf placement should match system location. If the system says one thing and the rack says another, expiry review cannot be trusted.

Billing and sale

Billing should reduce the correct medicine stock at the correct location and, where the process allows, against the correct batch logic. For pharmacies comparing counter flow and stock flow, AKIJ iBOS’s article on POS software for pharmacy in Bangladesh is useful context because it connects billing, inventory, and daily sales visibility.

Returns, adjustments, and physical count

Returns, adjustments, and physical counts keep pharmacy inventory control believable. Physical count should not wait for a year-end surprise. Small, regular cycle checks help catch posting delays, leakage, and location mismatch before management loses trust in the numbers.

Reports pharmacy owners and managers should review every week

Weekly review is where pharmacy inventory management becomes a decision tool. Entry alone does not protect the business; management review does.

Batch-wise stock report

A batch-wise stock report should show item, batch, expiry, branch, and available quantity in one view. This is the first report to open when a team says stock exists but the counter cannot find it.

Near-expiry ageing report

A near-expiry ageing report should group medicines by upcoming expiry window and location. It should answer three questions fast: what needs action now, which branch can still sell it, and which items should stop being repurchased immediately.

Reorder review report

A reorder review report should compare current usable stock with the pharmacy reorder level and recent movement. The goal is not to buy blindly. The goal is to review shortage risk before the shelf goes empty.

Non-moving and slow-moving stock report

A non-moving and slow-moving stock report shows where working capital is getting trapped. It also acts as an early warning for future expiry exposure, especially in pharmacies carrying many brands, strengths, and duplicate substitutes.

Sales vs stock discrepancy report

A sales vs stock discrepancy report helps management identify where stock accuracy is breaking. The reconciliation logic is similar to AKIJ iBOS’s guide on reconciling POS sales with warehouse inventory: if sales are posted but stock does not reduce correctly, or stock reduces without a supported transaction, the team needs to find the gap quickly.

When spreadsheet control is no longer enough

Spreadsheet control is no longer enough when the business cannot trust one version of stock. At that point, pharmacy inventory software becomes less about convenience and more about control.

The limits of separate POS, Excel, and manual stock registers

Separate tools create separate truths. The counter may see today’s sales, the store may update stock later, and accounts may review a third file at month-end. That delay is exactly how batch visibility disappears, expiry review becomes reactive, and reorder decisions become expensive.

Manual work also makes exception handling weak. Transfers, returns, damaged packs, and batch corrections start living in phone calls or side notes instead of one traceable record.

What pharmacy inventory software should support before you buy

Pharmacy inventory software should support the control method, not only billing speed. Before you buy, ask whether the system can handle:

  • batch and expiry capture at receiving
  • branch-wise and location-wise stock visibility
  • FEFO-friendly stock review
  • batch-linked sales, returns, and adjustments
  • near-expiry and non-moving stock reports
  • reorder review by usable stock, not only total stock
  • user roles, approvals, and audit-friendly change history

AKIJ iBOS’s pharmacy management software and Managerium Pricing pages are useful next steps once you are comparing how those controls fit your business and rollout scope.

Where Managerium Retail ERP fits in pharmacy inventory management

Managerium Retail ERP fits when a pharmacy needs one connected workflow between billing, inventory, purchase, and management review. The value is not only data entry. The value is visibility and control across outlets.

Batch, expiry, and branch-wise stock visibility in one connected workflow

According to the AKIJ iBOS Managerium Retail ERP page, the platform connects POS and billing with Inventory, Purchase, Accounts, Pricing, Offers, CRM, Loyalty, Payroll, Analytics, and multi-outlet operations. For pharmacy operations, the AKIJ iBOS Managerium Pharmacy Industry page adds the pharmacy-specific workflow angle: connecting counter, stockroom, supplier, and accounts so expiry and stock visibility stay structured.

That is where pharmacy inventory management becomes practical. Decision-makers can review whether stock exists, which batch should move first, which branch should transfer stock, and whether a fresh purchase is really needed.

What decision-makers should ask for in a live demo

A useful live demo should answer control questions, not only show screens. Ask to see:

  • inward receiving with batch and expiry capture
  • branch-wise batch stock view
  • near-expiry review by location
  • transfer flow that preserves batch identity
  • sale and return flow tied back to stock movement
  • reorder review for a fast-moving medicine
  • discrepancy review between sales and stock

What is pharmacy inventory management in a pharmacy setting?

Pharmacy inventory management is the process of controlling medicines by item, batch, expiry date, location, and movement so the business can sell the right stock at the right time. In practice, it connects purchase, receiving, shelf movement, sale, return, expiry review, and reorder decisions into one operating flow.

Why is batch tracking important in a pharmacy?

Batch tracking is important because two packs of the same medicine may not carry the same expiry date or movement priority. Without batch visibility, pharmacies cannot apply FEFO properly, trace returns accurately, or decide which branch should transfer stock before placing a fresh purchase.

Should a pharmacy use FEFO or FIFO?

A pharmacy should normally use FEFO as the main stock-issue rule because the batch nearest to expiry should move first. FIFO can still help inside similar-age stock, but pharmacy inventory management is safer when expiry date, not receipt date alone, drives movement priority.

How do pharmacies set reorder levels without overbuying?

Pharmacies set reorder levels by combining average movement, supplier lead time, and a reasonable safety buffer, then reviewing branch stock before buying more. The key is to use usable stock, not total stock. Short-dated, damaged, blocked, or mislocated quantity should not be treated as freely available for reorder decisions.