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
| Input | Where it comes from |
|---|---|
| Last count | The counted quantity on your last signed count, not the expected one. |
| Received | Wholesaler invoices and your receiving record, at the quantity that actually arrived. |
| Transferred in | Stock bought from another pharmacy, with its paperwork. |
| Dispensed | Your dispensing software's report for the window, by DIN. |
| Destroyed | Your destruction records for inventory stock, such as expired or damaged tablets. Patient returns are not inventory. |
| Returned or transferred out | Stock 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
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.
Go deeper
Sources
Show the 3 sourcesHide the 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.

