A Controlled Substance Log, Filled In: A Worked Example
Download the PDF — freeNo account, no email address.
This is what a correct month looks like, including the entries people get wrong: a prescription that was never picked up and goes back to stock, damaged tablets destroyed on site and recorded on DEA Form 41, and a partial fill.
The closing balance is worked out at the bottom, so new staff can check their own math.
What Is On It
- The same columns as the blank perpetual inventory log
- A month of dated entries for hydromorphone 2 mg tablets, NDC 42858-122-01, Schedule II
- The closing-balance calculation, written out
When You Reach For It
- Training a new technician on the controlled substance log.
- Settling an argument about how a return to stock should have been recorded.
- Checking your own log against a worked one before an inspection.
How often to count, and how long to keep a sheet, are answered on the count sheets hub. Every sheet prints the federal rules it relies on in its own footer, each with its 21 CFR citation. Your state board of pharmacy may require more.
More Sheets
- Narcotic Count Sheet: Shift Change — At handover, when custody passes from one person to another.
- Physical Count & Reconciliation Sheet — At every reconciliation count you schedule.
- DEA Inventory Form (Initial And Biennial) — For the initial inventory, the biennial inventory, and a newly scheduled drug.
The Counting Is The Easy Half
NarcCount works out what you should have from records you already keep, by NDC. See NarcCount for US pharmacies or read the Florida inventory guide.