Pharmacy stock doesn’t match the shelf? How to Trace the movements before adjusting

You count 65 tablets on the shelf. The system says 75.

Earlier that morning, someone received a box of 100 tablets as one saleable tablet. That error has already been corrected. So why are ten tablets still unaccounted for?

It is tempting to reduce the system balance by ten and move on. But that adjustment would close the difference without explaining what happened. The next order, stocktake or branch transfer could expose the same problem again.

Reconstruct the movements in time order. For each one, check how many tablets physically moved, what the ledger recorded and when the entry appeared.

The example below follows one product, one batch and one dispensing location. It assumes a box contains ten strips of ten tablets and that this product can appropriately be supplied in those quantities under the pharmacy’s procedures.

At 8 a.m., one box arrives

The opening balance is zero. Staff check the delivery and confirm 100 tablets.

The receiving entry adds one tablet, leaving the physical balance at 100 and the ledger at 1. This is a unit-conversion error. The invoice quantity of one box was entered into a field counting tablets.

The receiver checks the pack size and corrects the original receipt through the approved process. Both balances now show 100 tablets. The correction retains the supplier invoice reference so the delivery remains traceable.

This fixes the first discrepancy. It does not explain any later movements.

At 9 a.m., two strips are sold

Two strips contain 20 tablets. The POS correctly deducts 20.

The shelf holds eight strips, or 80 tablets. The ledger also shows 80 tablets.

This checkpoint matters. It establishes that the receipt correction worked and that this strip sale used the correct conversion. If a difference appears later, you can focus your investigation on subsequent events.

At 10 a.m., five tablets leave before the entry is completed

A staff member supplies five tablets and records the transaction on the pharmacy’s approved temporary record while the workstation is unavailable.

At 10:05 a.m., the shelf contains 75 tablets, but the electronic ledger still shows 80.

At 10:12 a.m., the staff member completes the entry. The ledger falls to 75, matching the physical balance.

The five-tablet difference was caused by the delay between the physical movement and its electronic entry. The temporary record and the eventual transaction establish what happened.

That distinction prevents a second error. If someone had adjusted the balance down by five at 10:05 and the original transaction was then entered at 10:12, the same movement could be deducted twice.

At 11 a.m., one strip goes to another branch

A full strip of ten tablets leaves the dispensing location. The receiving branch signs for it, but the dispatching staff member omits the transfer from the electronic ledger.

At noon, the shelf contains 65 tablets. The ledger still shows 75.

Unlike the earlier five-tablet sale, this transfer has no completed ledger entry when the discrepancy is investigated. The signed transfer document identifies the product, batch, quantity, destination and recipient.

The investigator searches the transaction history to confirm that the transfer was not entered under another reference. Once that is checked, an authorised staff member records the missing transfer and links the supporting document. The sending location’s ledger becomes 65 tablets.

The receiving branch’s records also need checking so that the transfer is accounted for at both ends.

What the morning’s investigation established

Three different problems produced three different explanations:

• Unit conversion: The receipt treated one box as one tablet. The receiving quantity needed correction.
• Timing: Five tablets had physically left before the electronic entry appeared. The temporary record and later entry explained the gap.
• Missing ledger movement: Ten tablets were transferred, with supporting evidence, but the transfer had never been posted. The ledger needed the documented movement.

In this example, all the tablets are accounted for. A missing ledger entry does not establish that stock was stolen or lost. If the physical count still disagrees after checking the records, document the remaining difference as unresolved and investigate it under your facility’s procedures.

Compare the same stock at the same time

A shelf count at noon and a report downloaded at 10 a.m. describe different moments. Check the product, strength, form, batch, location and unit of measure before comparing quantities.

Record the count time and control movements during the count. MSF’s pharmacy guidance recommends avoiding incoming and outgoing stock movements during inventory, recording movements on stock cards and clarifying differences between recorded and physical quantities. MSF Medical Guidelines

If an urgent movement interrupts your count, document it and recount the affected stock at a clear cutoff. Otherwise, a correct transaction can look like a shortage simply because it happened between counting the shelf and reading the report.

A five-minute check before you adjust the balance

Choose one product with a discrepancy. Start from its last verified balance and work forward using receipts, sales, returns and transfers. Convert every quantity into the same stock unit.

For this example, the calculation is straightforward:

100 received − 20 sold − 5 sold − 10 transferred = 65 tablets remaining.

Write the document or transaction reference beside each movement. Then compare the result with a fresh physical count at the same cutoff.

If you can support all four movements, the correct balance is 65. If you cannot support the ten-tablet transfer, those ten tablets remain an unresolved discrepancy. Assign someone to investigate it and record what evidence is still needed.

Before reordering, use the reconciled balance and your normal demand calculation. For this pharmacy, the morning’s work ends with 65 tablets available, a corrected receiving entry and a transfer that can be traced to its destination.