Lesson 2 of 5

The reconciliation formula

Last count, plus what came in, minus what went out.

▶ 1:40 video · 5 min read · 3-question check

In this lesson

  • Expected on-hand = last count + received − dispensed − destroyed − returned.
  • Use only transactions inside the window: from the moment of the last count to the moment of this one.
  • Each DIN is its own line, counted in the unit you dispense.
  • Variance = counted − expected. A negative number is a shortage, a positive number an overage.

Every reconciliation runs on one line of arithmetic. When the inputs are right, most variances explain themselves. When a variance will not go away, the problem is usually one of the inputs.

Where each number comes from

InputWhere it comes from
Last countThe counted quantity on your last signed count, not the expected one.
ReceivedWholesaler invoices and your receiving record, at the quantity that actually arrived.
Transferred inStock bought from another pharmacy, with its paperwork.
DispensedYour dispensing software's report for the window, by DIN.
DestroyedYour destruction records for inventory stock, such as expired or damaged tablets. Patient returns are not inventory.
Returned or transferred outStock sent back to a wholesaler or sold to another pharmacy.

Worked example: oxycodone 10 mg tablets

Last count
300
Received, two bottles of 100
+200
Dispensed
−410
Destroyed, expired
−10
Expected on-hand
80
Counted on the shelf
74
Variance
−6, six tablets short
A made-up example. Lessons 3 and 4 show how to count it and how to find where the six went.

Rule 1: the window

Use only what happened between the moment of your last count and the moment of this one. The moment matters, not just the day. A prescription filled at 2 p.m. on count day belongs before or after the count depending on whether it was filled before or after that shelf was counted.

Rule 2: one line per product

Each strength, form and brand of a drug has its own Drug Identification Number, the DIN, and each DIN is reconciled on its own. Mixing two DINs together hides a problem; splitting one DIN across two lines invents one.

  • Count in the unit you dispense: tablets, capsules, patches, or millilitres for a liquid.
  • Convert packs to units before you add them: two bottles of 100 are 200 tablets.
  • A brand switch is a classic trap: one DIN shows a shortage and its interchangeable sister DIN an overage of exactly the same size.

Reading the variance

Variance is counted minus expected. A negative number is a shortage; a positive number is an overage. Neither is a conclusion yet. Both are questions the records can usually answer.

Check your understanding

3 quick questions. Answering them marks this lesson done. Your answers stay in this browser.

  1. 1.Last count 120, received 60, dispensed 95, destroyed 5. What is the expected on-hand?
  2. 2.You expected 80 and counted 74. What is the variance?
  3. 3.A prescription for 30 tablets was filled halfway through the count. What is the risk?
0 of 3 answered

Go deeper

Sources

Show the 3 sources

Primary sources for the figures on this page. Regulations change; confirm the current requirement with the source before you rely on it.

General information, not legal or professional advice. For authoritative requirements, refer to your provincial regulator and Health Canada.