Lesson 4 of 4
From paper to software: what to look for
Why moving off paper helps, what good reconciliation software should do, and the questions to ask before you choose.
▶ 1:56 video · 4 min read · 3-question check
In this lesson
- Moving your counts from paper to software is a real step forward, and worth choosing carefully.
- Good software works out expected on-hand, ranks the variances and shows the transactions behind every number.
- Look for time-stamped entries, a count that locks when it is signed, and an audit log.
- Records stay retrievable as long as the rules require: federally, at least 2 years under Controlled Substances Regulations s. 123(1).
A real step forward
Many pharmacies still run their counts on paper binders, spreadsheets and fax. If you are thinking about moving to software, well done. It is a real step forward for a controlled-substance program, and this lesson will help you choose well.
Paper can meet the Controlled Substances Regulations, which ask for a recording method that permits an audit at any time (s. 122) and for records that are complete, readily retrievable, legible and indelible (s. 125). The trouble is how much work it takes to keep paper that way.
Where paper and spreadsheets slip
- Every expected figure is worked out by hand, line by line.
- Any spreadsheet cell can be typed over, so a balance can change without a trace.
- Most spreadsheets keep no reliable history of who changed what.
- Sorting a sheet by anything but date scrambles a running balance.
- Copies multiply, and nobody is sure which file is current.
- Invoices end up with the bookkeeper, and destruction sheets in a binder nobody links to the narcotic file.
What good reconciliation software should do
The core job is one line of arithmetic, done for every drug and strength:
The arithmetic software should do for you
- Opening balance
- 48
- Received from the wholesaler
- +100
- Returned to stock after a reversed claim
- +6
- Dispensed
- -56
- Expired stock destroyed and recorded
- -6
- Expected on-hand
- 92 tablets
Use this as your checklist when you compare products. Each line saves time on a count or makes a number easier to explain.
| It should | Why it matters |
|---|---|
| Work out expected on-hand for every drug from purchases, dispensing and destructions | No hand math, and the same arithmetic every time. |
| Flag and rank the variances | The worst lines rise to the top, so you start where it matters. |
| Show the transactions behind any number | A variance is traced in minutes instead of rebuilt from binders. |
| Time-stamp every entry, and lock a signed count with an audit log | A late entry or a later change stays visible, which supports the auditable method Controlled Substances Regulations s. 122 asks for. |
| Keep evidence, such as photos and documents, with the count | The proof sits beside the number it explains. |
| Build the count report itself | Nothing is left to write up after you sign. |
| Keep records retrievable for as long as the rules require | Federally, records are kept at least 2 years (Controlled Substances Regulations s. 123(1)). |
| Connect to your pharmacy software | Dispensing and receiving arrive on their own instead of being typed in. |
| Host your data in Canada | You know where your records live, and can say so when asked. |
Questions to ask before you choose
- Where is the data hosted, and who can see it?
- Can I see the transactions behind every expected figure?
- What happens to an entry made after a count is signed?
- Can I export every record in a format I can open without your software?
- How does my last paper count become the opening balance?
- Is there a free trial, and does it need a card?
Check your understanding
3 quick questions. Answering them marks this lesson done. Your answers stay in this browser.
Go deeper
Sources
Show the 5 sourcesHide the sources
- Controlled Substances Regulations s. 123 — retention, with ss. 122, 124, 125 and 126 — Federal: documents are “kept for two years after the day on which the last record is recorded in the document”, written orders and prescriptions two years after receipt, and every declaration and report two years after it is provided or received. Sections 122 and 124 to 126 cover an audit-ready method, the place, the quality of the records and producing them on request.
- Controlled Substances Regulations (SOR/2025-242) s. 122 — an auditable method of recording — “A pharmacist or pharmacy technician who records any information under these Regulations must do so using a method that permits an audit of it to be made at any time.”
- Controlled Substances Regulations (SOR/2025-242) s. 124 — in force October 1, 2026 — Federal, and verbatim: “The documents must be accessible (a) at the pharmacy where the information was recorded; or (b) if that pharmacy has ceased its operations, at a place in Canada.”
- O. Reg. 264/16 s. 21 (General, Drug and Pharmacies Regulation Act) — The 10 years runs from the last pharmacy service provided to the patient, and longer again for a patient who was a minor.
- Health Canada — Controlled substances guidance for community pharmacists and pharmacy technicians (CS-GD-022), September 29, 2026 — Health Canada's guidance accepts an electronic system for sale records “as long as the system allows for quick and easy retrieval of all documents in an auditable format without having to access individual patient files.”
Primary sources for the figures on this page. Regulations change; confirm the current requirement with the source before you rely on it.
General information, not legal or professional advice. For authoritative requirements, refer to your provincial regulator and Health Canada.

