A controlled substance log, filled in — worked example
Download the PDF — freeNo account, no email address.
This is what a correct month looks like, including the two entries people get wrong: a patient return, which adds to the balance and usually leaves again as a witnessed destruction, and a partial fill.
The closing balance is worked out at the bottom, so new staff can check their own arithmetic.
What is on it
- The same columns as the blank perpetual log
- A month of dated entries with real reference numbers
- The closing-balance calculation, written out
When you reach for it
- Training a new technician or assistant on the narcotic book.
- Settling an argument about how a return should have been recorded.
- Checking your own sheet against a worked one before an assessment.
How often to count, and how long to keep a sheet, are answered on the count sheets hub. Every sheet prints the Ontario and federal retention rules in its own footer.
More sheets
- Narcotic count sheet — shift change — At handover, when custody passes from one person to another.
- Physical count & reconciliation sheet — At your periodic reconciliation.
- Periodic inventory form — At opening, at a fixed interval, at closing, or on a change of ownership.
The counting is the easy half
NarcCount works out what you should have from records you already keep. See it worked through on one drug or get the data out of your dispensing system.