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 a math slip cannot create a false variance.
It is a plain .xlsx file: Excel, LibreOffice and Google Sheets all open it.
What Is On It
- Date, reference, received, dispensed, destroyed, returned to stock
- Balance: calculated, not typed
- A count tab: expected on hand and counted, with the variance calculated on each line
When You Reach For It
- A pharmacy that already keeps the log on a computer rather than on paper.
- Checking a handwritten month's math 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 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
- 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, by NDC. See NarcCount for US pharmacies or read the Florida inventory guide.