Count hospital stock while transactions continue
For Stores manager / pharmacy operations lead · Compare approaches
TL;DR — what you’ll learn
- Define the count population, unit and cutoff before comparing physical stock with a ledger.
- Bridge movements between the ledger snapshot and the physical count time.
- Separate an explained timing difference from a shortage requiring investigation.
- Compare a movement freeze, snapshot reconciliation and controlled rolling count against the site's operating constraints.
A bin's ledger shows 100 units at 14:00. Twelve units leave at 14:05, staff count 88 at 14:10 and the issue is entered at 14:20. A count report proposes a twelve-unit loss because it compares the physical count with an unchanged snapshot.
Hospital inventory cycle counting needs a movement bridge. Record both the count time and relevant physical events, then reconcile the difference before proposing an adjustment. A mismatch can reflect timing, unit conversion, scope or a real unexplained quantity; the count itself does not identify the cause.
Make the count scope reproducible
Specify location, item, batch where relevant, unit and included stock statuses. Decide how restricted, returned, reserved or third-party-owned material appears. Two teams can both count correctly yet disagree if one includes a quarantine shelf and the other excludes it.
Use an item/unit mapping approved for the count. Record two sealed boxes and six loose units as the original observation, then apply the stated conversion; preserve both if the conversion changes. Ask the responsible pharmacy or quality owner to supply restricted-stock handling and access requirements. Counting a quantity provides no decision about its eligibility for use.
Bahmni describes stocking points and movement reports. Ask the actual installation to export a snapshot, business-event time, entry time and linked corrections for the late-issue example. If it cannot distinguish those times, document that limitation and choose a reviewed reconciliation method before relying on automated variance calculations.
Reconstruct the fourteen-ten balance
In the illustrative example, expected physical stock at 14:10 is 100 opening units minus 12 physically issued, or 88 units. The observed count is also 88, so the unexplained quantity is zero once the movement is evidenced.
Scroll horizontally to see all columns.
| Evidence | Physical-event time | Entry or snapshot time | Units |
|---|---|---|---|
| Opening ledger snapshot | Cutoff 14:00 | 14:00 | 100 |
| Issue I-16 | 14:05 | 14:20 | −12 |
| Physical count C-16 | 14:10 | 14:12 | 88 observed |
The issue needs a valid source record; “probably issued” is not a reconciliation. If staff can establish only ten of the twelve units, keep two unexplained and route investigation. Do not create a fictional issue to force agreement or automatically classify the remainder as loss.
Choose a count method that operations can sustain
Scroll horizontally to see all columns.
| Method | Useful when | Control to demonstrate |
|---|---|---|
| Agreed movement freeze | A location can pause safely for a defined period | Clear start/end and an exception route for necessary movement |
| Snapshot with movement bridge | Work must continue and events can be identified | Events between cutoff and count are complete and traceable |
| Controlled rolling count | A large store counts selected bins over time | Each bin has its own cutoff, population and reconciliation |
The operating owner must decide whether a freeze is feasible; stock-count administration must not obstruct necessary care or authorised access. A rolling programme also needs a selection method that does not repeatedly omit difficult locations.
A system that offers only a single count timestamp may suit a simple freeze but require additional controls for rolling counts. Compare the real records and effort rather than calling one method universally best.
Worked workflow
Original illustrative workflow. Follow the labelled transitions, including the exception paths.
- A · StepDefine bin item unit and count cutoff
- B · StepCapture independent physical observation
- C · StepBridge evidenced intervening movements
- D · DecisionDifference explained
- E · StepRetain reconciled count evidence
- F · StepRecount and assigned investigation
- G · DecisionAdjustment authorised
- H · StepKeep unresolved quantity visible
- I · StepPost linked adjustment with reason
Scroll horizontally to see all columns.
| From | Condition | Next |
|---|---|---|
| A: Define bin item unit and count cutoff | Continue | B: Capture independent physical observation |
| B: Capture independent physical observation | Continue | C: Bridge evidenced intervening movements |
| C: Bridge evidenced intervening movements | Continue | D: Difference explained |
| D: Difference explained | Yes | E: Retain reconciled count evidence |
| D: Difference explained | No | F: Recount and assigned investigation |
| F: Recount and assigned investigation | Continue | G: Adjustment authorised |
| G: Adjustment authorised | No | H: Keep unresolved quantity visible |
| G: Adjustment authorised | Yes | I: Post linked adjustment with reason |
Review differences before financial adjustment
An independent recount can identify a misread location or pack quantity. Preserve both observations, who performed them and the reason the later result is accepted. Avoid giving the counter permission to erase the original difference and post an unrestricted adjustment in one action.
Before posting an adjustment, obtain the inventory and finance owners’ authority model, ownership classification and valuation treatment, including restricted and supplier-owned holdings. The count and timing reconciliation below support a proposed quantity difference. They do not establish a financial posting, a change of ownership or permission to release a restriction.
Test the late issue, a receipt after the count, a unit error and a count upload submitted twice. The selected workflow should preserve each observation and create no duplicate adjustment on replay. Confirm how it handles an adjustment already posted before new evidence arrives.
Report the number of item-location observations within an agreed tolerance alongside unresolved cases and the total observed population. State whether “accuracy” means exact quantity agreement, lines within tolerance or value agreement. These are different measures, and the tolerance is an approved reporting choice rather than an industry benchmark.
A useful count process explains differences before changing the ledger. It gives management a defensible view of stock accuracy without treating every timing mismatch as a loss or every balancing entry as a solution.
Next actions
- Choose one location and define its count population, units and cutoff method.
- Reconcile a synthetic late-posting example before enabling adjustment posting.
- Agree independent recount, adjustment authority and the denominator used in the accuracy report.
Discuss this workflow
Request a workflow assessment focused on this question: How can a count distinguish a real shortage from a movement posted late?
Describe the operation using business information only. Please leave out patient details.
Applying this guide
The scenarios and numbers are illustrative. Confirm these provider-specific inputs before implementation:
- Stores/pharmacy manager, quality and relevant operations owner: Approved counting procedure with restricted-stock handling and necessary-movement exceptions.
- Inventory controller and finance: Recount and adjustment delegation plus valuation and consignment treatment.
- HIS/ERP owner: Demonstrate late postings, unit corrections, duplicate count uploads and correction after a posted adjustment.
References
- Bahmni stock management — Advertised inventory concepts only; actual configuration, disposition and access require validation.
Topics: hospital inventory cycle counting · hospital stock audit · hospital inventory count · stock count cutoff