Controlled-substance records: what to log, for how long, and how to make it automatic

The register every pharmacy must keep for controlled medicines — what goes in each entry, how to reconcile it, how long to keep it, and how to stop it being a separate book.

Every pharmacy keeps two sets of records. The ordinary stock book, which nobody outside the shop will ever ask to see. And the controlled-substance register, which an inspector will ask to see — usually without warning, and usually wanting to reconcile it against what is physically in the cabinet right then.

The register is also the one most often kept badly, for a simple reason: it's a separate book. Sales go through the till; the register is filled in afterwards, by hand, from memory, when it's quiet. Which means it's filled in late, or not at all, and the gap between the book and the cabinet grows until inspection day.

The fix is not discipline. It's removing the "afterwards".

The specific list of controlled medicines, the schedule classes and the retention periods are set by your national regulator and vary by country; this article covers the method, which is the same everywhere. Check the specifics with your pharmacy council.

What a register entry needs

Whatever the format, every movement of a controlled medicine — in or out — needs the same handful of facts:

Two rules that catch most pharmacies out:

• One register per product-and-strength. Not one per product. Tramadol 50mg and 100mg are separate balances, separate pages.
• Nothing is crossed out. A mistake is corrected with a new line that references the wrong one. A register with Tipp-Ex on it is a register an inspector stops trusting.

Reconciling: the weekly count

Once a week — the same day, the same person — count the cabinet and compare it to the running balance, product by product. Record the count, the book balance, and the difference, even when the difference is zero. Especially when it's zero: a register that shows weekly zero-discrepancy counts is the most persuasive document you can hand an inspector.

When there's a difference:

1. Check the last week's entries for a line that was missed — a sale rung up but not registered is the usual cause.
2. Check for a dispensing error (wrong strength taken from the shelf).
3. If neither explains it, record the discrepancy, the investigation and the outcome, and follow your regulator's reporting rule. Don't "adjust" the balance to match the count; that's the one thing worse than the discrepancy.

How long to keep it

Regulators typically require controlled-substance registers to be kept for two to ten years after the last entry, and the longer figures are becoming more common. Keep them longer than the minimum; storage is cheap and a destroyed register cannot be un-destroyed. Disposal records and invoices for controlled medicines usually carry the same retention.

Disposal

Expired or returned controlled stock doesn't leave the register when it leaves the shelf. It's moved to a quarantined balance, then written off with a disposal entry: date, quantity, batch, method, who witnessed it. Many jurisdictions require an authorised witness for the destruction itself. The quarantine step matters because a pharmacy with "5 expired capsules somewhere in the back" has a discrepancy waiting to be found.

Making it automatic

Everything above is hard because it's a second act. The sale is made, then the register is written. The delivery is shelved, then the register is written. Every "then" is a place the record can be missed.

The method is to make the register a by-product of the act, not a follow-up to it. The sale is the register entry. The receipt is the register entry. That only works when the till knows which products are controlled and refuses to treat them like paracetamol.

What this looks like in Shopman

• A product is flagged as a controlled substance once, in its record, alongside "prescription required".
• Every movement is already recorded. Receipt by batch, sale, return, adjustment — each is a stock movement with a timestamp, quantity, batch and the staff member who did it. For a flagged product, that movement history is the register, built as the work happens rather than after.
• Sales of controlled items require a prescription on the sale, which carries the prescriber and patient, so "supplied to" and "prescription reference" are never a separate lookup.
• Running balances are the stock level, per batch, and the expiry tracker quarantines what's about to go off.
• The activity log shows who changed what, with before and after values, so a corrected entry references the original automatically — nothing is crossed out, because nothing can be.
• Export the movement history for any product to PDF or Excel on inspection day (Professional plan), rather than photocopying a book.

Prescription and controlled-substance features are on the Starter plan and above — the tier built for a single-branch pharmacy.

Start free — fourteen days of the full plan, no card

Frequently asked

Do I still need a paper register if I use software? That depends on your regulator — some require a bound book, some accept an electronic record with an audit trail, many accept either. Until you have confirmed in writing, keep both; the software makes the paper one a five-minute copy rather than a reconstruction.

What's the most common inspection finding? Running balances that don't match the cabinet, caused by sales that went through the till and never reached the book. Followed by corrections made by crossing out.

Who should be able to dispense controlled medicines in the system? Only the pharmacist role. A cashier can sell a controlled item's sale once it's been dispensed, but cannot create the dispensing entry — the system should enforce that, not a notice on the wall.