In most hospitals, a single dose of medicine passes through three systems: the pharmacy application that records the dispense, the inventory system that records the stock movement, and the billing system that records the charge. Each system is accurate on its own. The problem is that nobody checks whether all three agree for the same transaction, and that is precisely where money escapes.
What is inventory reconciliation?
Inventory reconciliation is the process of comparing the stock your records say you should have with the stock you physically have, then investigating and correcting every difference. In a hospital pharmacy it also means checking that every unit that left the shelf reached a patient's bill.
Inventory reconciliation formula
Expected closing stock = Opening stock + Receipts − Dispensed − Returns to supplier ± Adjustments
Variance = Physical count − Expected closing stock
A negative variance points to loss, expiry write-offs or unrecorded dispensing. For billing accuracy, the dispensed quantity should also equal the quantity billed to patients.
What "three-way reconciliation" means
Three-way reconciliation matches every dispense against its stock movement and its billed line item. For a transaction to be considered clean, all three must line up: the medicine dispensed, the stock deducted, and the amount billed to the patient. When one is missing, you have a leak, and you can see exactly which one.
The three checks
Dispensed but not billed → lost revenue. Billed but not dispensed → over-billing risk. Stock reduced with no dispense → pilferage or wastage. All three surface only when the records are linked.
Where pharmacy leakage actually happens
Bills cancelled after dispensing
The bill is raised, the medicine leaves the counter, then the bill is cancelled, but the dispense and stock movement are never reversed. This single pattern is one of the largest silent leaks in Indian hospitals, and it is invisible to a collections report. See our full breakdown in 7 silent ways hospitals lose money.
Ward and OT consumption never billed back
Stock issued to a ward or operation theatre is consumed against a patient but never tied to that patient's bill. Without a link between the issue and the encounter, it becomes an unexplained variance at the next stock take.
Expiry and overstock
Money also leaks silently through medicine that expires on the shelf or capital tied up in overstock. Both are inventory problems that demand forecasting, not just counting.
How to fix it
- Link the three records. Every dispense should carry its stock movement and its billed line item as one connected transaction.
- Reconcile daily, not monthly. Continuous matching catches a discrepancy while it can still be attributed and recovered.
- Gate reversals. Require an approval trail on post-dispense cancellations so they can't quietly erase a transaction.
- Forecast demand. Use consumption trends, seasonality and lead times to prevent both stock-outs and expiry.
Reconcile pharmacy, stock and billing automatically
Shucon MedAI writes dispensing, inventory and billing to one shared model, then reconciles all three continuously, flagging dispensed-but-unbilled items, post-dispense cancellations and stock variances with the exact records. Its AI also reads supplier invoices into stock and forecasts reorders before you run out.
Book a Hospital Revenue Review Explore pharmacy and inventory intelligenceFrequently asked questions
What is inventory reconciliation?
Inventory reconciliation is comparing recorded stock with physical stock and investigating every difference. In hospital pharmacies it also confirms that dispensed stock was billed.
What is the inventory reconciliation formula?
Expected closing stock equals opening stock plus receipts minus dispensed quantity minus returns, plus or minus adjustments. Variance is the physical count minus the expected closing stock.
What is pharmacy reconciliation in a hospital?
It is the process of matching every medicine dispensed against its inventory movement and its patient bill, so that no item leaves the pharmacy without being accounted for in both stock and revenue.
Why does pharmacy stock never match the billing?
Because dispensing, inventory and billing typically run on separate systems. Unless those records are linked per transaction and reconciled continuously, small mismatches accumulate into large, unattributable variances.