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
A physical count of 92 agrees, and the count is signed off. On paper, every line of this is worked out by hand for every drug.

Use this as your checklist when you compare products. Each line saves time on a count or makes a number easier to explain.

It shouldWhy it matters
Work out expected on-hand for every drug from purchases, dispensing and destructionsNo hand math, and the same arithmetic every time.
Flag and rank the variancesThe worst lines rise to the top, so you start where it matters.
Show the transactions behind any numberA variance is traced in minutes instead of rebuilt from binders.
Time-stamp every entry, and lock a signed count with an audit logA 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 countThe proof sits beside the number it explains.
Build the count report itselfNothing is left to write up after you sign.
Keep records retrievable for as long as the rules requireFederally, records are kept at least 2 years (Controlled Substances Regulations s. 123(1)).
Connect to your pharmacy softwareDispensing and receiving arrive on their own instead of being typed in.
Host your data in CanadaYou 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.

  1. 1.Under the Controlled Substances Regulations, what must a method of recording controlled-substance information allow?
  2. 2.Why is a spreadsheet a weak place to keep a running narcotic balance?
  3. 3.Which feature lets a reviewer see that a count was changed after it was signed?
0 of 3 answered

Go deeper

Sources

Show the 5 sources

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.