Hospital pharmacy case study

How Connected Data Identified $15,000+ in Hospital Pharmacy Revenue Leakage

A real hospital workflow showed why collections could appear correct while fulfilled pharmacy transactions were later cancelled. Connecting the complete transaction exposed the discrepancy.

Anonymous hospital caseConnected transaction analysisNo fabricated customer details
1 · Hospital context

A live hospital operation with pharmacy, billing and inventory activity.

The hospital used routine departmental reports to manage collections and pharmacy operations. Its identity and unsupported operational details are intentionally omitted.

2 · Operational problem

Older pharmacy bills could be cancelled after fulfilment.

Medicine had already been dispensed and inventory had already moved. A later cancellation changed the billing record without consistently reconnecting the corresponding dispense and stock consequences.

Prescription

The clinical intent existed.

Dispense

The medicine was supplied to the patient.

Inventory

The stock movement reflected medicine leaving the pharmacy.

Cancellation

The bill was later cancelled without a complete linked reversal.

3 · Why reports missed it

Each department saw only its own version of the event.

A collection report checks current bills against collections. Once an older bill is cancelled, it can disappear from that view. Pharmacy and inventory records may still be internally valid, but the report does not ask whether those records still have a valid bill and payment outcome.

4 · What Shucon detected

A cross-department mismatch with traceable source records.

Shucon connected cancelled billing events back to fulfilment and inventory activity. This surfaced transactions where the financial state no longer agreed with the operational state.

$15K+

Hospital pharmacy revenue leakage identified

The analysis found more than US$15,000 in discrepancies tied to this pattern. The process gap was then closed. This is a historical case result, not a guarantee of savings for another hospital.

5 · What hospitals can learn

Reconcile the transaction, not just the department.

Preserve the origin

Every cancellation or refund should remain linked to the service, medicine and stock event it reverses.

Check fulfilment

A reversal control must know whether medicine or a service has already been delivered.

Review exceptions

Route unmatched reversals to an owner with the supporting records and a clear next action.

Apply the lesson

Find the equivalent pattern in your hospital.

Start with an estimate, use the checklist, or examine real workflows in a revenue review.