Guide

Controlled substance tracking software for Canadian pharmacies

NarcCount calculates the expected balance of every narcotic and controlled substance from your own records, and shows the variance against your count.

What it does

Calculates the expected balance instead of asking you for it

It reads your dispensing, purchase and destruction records and works out what should be on the shelf.

Shows the variance, and the transactions behind it

Every drug shows expected on hand, counted, and the difference. Open the difference to see its transactions.

Keeps a per-drug history keyed by DIN

A count from eight months ago, the variance it raised, and what resolved it, all in one place.

Prepares the loss or theft report from the count

When a shortage turns out to be a loss, the details are already recorded. A qualified person reviews and submits it.

Imports what you already have

Existing counts and transaction history can be brought across.

Canadian, and hosted in Canada

DIN rather than NDC, and your data stored in Canada.

What it is not

  • It is not dispensing software and does not replace it. It reconciles what is on the shelf against your records.
  • It is not inventory management for your whole store. It covers narcotics and controlled substances only.
  • It does not decide anything a pharmacist has to decide. Whether something is a reportable loss, and what to do about it, stays with the qualified person in charge.

Comparing vendors?

The buyer’s guide to narcotic reconciliation software in Canada describes each tool from its vendor’s own page, says which one is ours, and gives you six questions to ask any of them.

Start on paper if you would rather

The sheets are free and there is no account to make.

Questions

What is controlled substance tracking software?

It is software that maintains the expected on-hand balance for every narcotic and controlled substance in a pharmacy, from the receipts, dispenses, destructions and returns already recorded, and compares that expected figure against a physical count. The output is a variance per drug, and the transaction history that explains it.

Is there free pharmacy inventory software for controlled substances?

There are free templates, and we give away a full set of them — a perpetual log, a shift-change count sheet, a physical count sheet and a periodic inventory form, plus a spreadsheet that calculates the running balance. A spreadsheet works until the volume of transactions makes reconstructing a variance the slow part; that is the point at which software earns its keep.

How is this different from Kroll, Fillware or my dispensing system?

A dispensing system is where prescriptions are filled and where dispensing data is reported. It knows what went out; it does not, on its own, reconcile that against a physical count of what is in the safe, including purchases and witnessed destructions. NarcCount takes those records as input and does the reconciliation. It sits beside your dispensing software rather than replacing it.

Which software is best for a pharmacy?

It depends which job you are solving. For dispensing and billing, that is your dispensing vendor's decision and a large one. For narcotic reconciliation specifically, the questions worth asking any vendor are: does it calculate the expected balance from my own records or make me type it, does it keep the history a college inspection asks for, is my data in Canada, and does it use DIN rather than an American drug identifier.

How often would I use it?

The Ontario College of Pharmacists expects narcotics and controlled substances to be reconciled at least every six months. Nova Scotia and Prince Edward Island are stricter: narcotics and controlled drugs are reconciled monthly. Alberta, British Columbia, Saskatchewan, Manitoba, and Newfoundland & Labrador generally require reconciliation every three months. Many pharmacies count more often than the minimum, because a small discrepancy is far easier to resolve while the transactions behind it are still recent.

See it on your own numbers

Bring a month of records and we will show you what the reconciliation looks like.

General information, not legal or professional advice. For authoritative requirements, refer to the Ontario College of Pharmacists, your own provincial college, and Health Canada.