Free controlled substance log spreadsheet (Excel)
Download the XLSX — freeNo account, no email address.
The paper log with the sums done: enter what came in and what went out, and the balance carries itself forward, so an arithmetic slip cannot create a false variance.
It is a plain .xlsx — Excel, LibreOffice and Google Sheets all open it.
What is on it
- Date, reference, received, dispensed, destroyed, returned
- Balance — calculated, not typed
- Expected vs counted, with the variance calculated at the bottom
When you reach for it
- A pharmacy that already keeps the log on a computer rather than on paper.
- Checking a hand-written month's arithmetic quickly.
- As a stopgap before moving the whole reconciliation into software.
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
- Perpetual inventory log — The ongoing record you keep between counts.
- Log example (filled in) — When you want to see one done before you start.
- Narcotic count sheet — shift change — At handover, when custody passes from one person to another.
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.