Narcotic Count Sheet for Clinics: What to Include

The fields a working sheet needs, how often to count, what to do the day it will not close, and the point where a paper sheet can no longer answer the question.

Key takeaways

Home/Resources/Narcotic count sheet

Narcotic Count Sheet for Clinics: What Belongs on It, and Where a Sheet Stops Being Enough

The fields a working sheet needs, how often to count, what to do the day it will not close, and the point where a paper sheet can no longer answer the question.

Written forMulti-provider pain clinics

Reading time11 minutes

Reviewed and current as ofSeptember 22, 2026

What is a narcotic count sheet, and what belongs on it?

A narcotic count sheet is a perpetual inventory of the controlled substances held at a clinic: what is on hand, what was delivered into inventory, what was checked out for a case, what was administered, what was wasted and witnessed, and what the physical count showed at the end of a shift. There is no DEA form for it and no official template to download, because federal rules require complete and accurate records that are readily retrievable rather than one prescribed layout (21 CFR 1304.21(a), 1304.04). The field list below is the whole specification. Put those columns on a page or a spreadsheet in the order the handling actually happens and you have a working sheet. What the sheet cannot do is move the obligation. Controlled-substance records trace back to a registrant, in whatever format they are kept.

Which part of your practice does this sheet cover?

Worth settling before the columns, because the word narcotic gets used for two different things. This is the stock you hold on site and administer in your own rooms, the fentanyl, midazolam, ketamine and similar agents in the safe. Strictly speaking, narcotic is a legal term for opioids and cocaine derivatives (21 USC 802(17)), and much of what lives in a clinic safe, like midazolam or ketamine, is a controlled substance but not a narcotic. The accurate name for this record is a controlled substance log, but narcotic count is what everyone says, so it is the word this guide uses. The sheet covers that stock and not what your providers prescribe. Prescribing carries its own obligations, including reporting to your state prescription drug monitoring program, and a count sheet has nothing to do with them. If your clinic does both, keep the two records apart.

What should a clinic narcotic count sheet include?

A usable sheet captures every handling step in the chain of custody, in the order it happens, with the person who did it and the person who witnessed it. If a column is missing, that step becomes the one you cannot reconstruct later. These are the fields to build from:

FieldWhat it capturesWhy it matters later
Date and timeWhen the step happenedOrders the record and lets you match it to a schedule
Drug, strength, formExactly what was handledSo a partial-strength entry is not read as a full one
Beginning countWhat the record says should be on handThe baseline any discrepancy is measured against
Delivery into inventoryQuantity added and the sourceOpens the chain of custody for that stock
Checkout for a caseQuantity signed out and the case or patient identifierThe step where an unmatched or cancelled case becomes visible
AdministeredDose given to the patientSeparates what reached the patient from what left the safe
WastedQuantity discardedCloses the gap between checked out and administered
Waste witness signatureThe second person, signed at the moment of wasteThe single most common documentation gap in a clinic
Returned to stock, if your policy allows itQuantity that went back, and who returned itThe leg that makes the arithmetic balance when a case is cancelled
Provider or handlerWho performed the stepMakes the record traceable to a person and clears them later
Ending countPhysical count at closeThe reconciliation moment
Variance and resolutionAny difference, and what was foundTurns a discrepancy into a closed item instead of an open question

Two of those columns do more work than the rest. The checkout column is where a drug that leaves the safe for a case that never happens becomes visible, and the waste witness column is where the record either holds up or does not. If your current sheet is missing either one, add it before you change anything else.

The return line is a policy decision before it is a column. Some clinics return an unused quantity to stock and record the return. Others waste everything that leaves the safe. Both are defensible, and which one you are held to is set by your own policy, your state board and your accreditor. What is not defensible is a sheet where the quantity checked out does not equal what was administered, plus what was wasted, plus what came back.

How often should the count be done?

Many clinics reconcile at a fixed point in the day, typically at the open and close of the controlled-substance safe or at shift change, and again whenever stock is delivered into inventory. The right cadence is the one your team can keep every single day, because a count that gets skipped on busy days produces a record nobody trusts.

A separate obligation sits on top of that daily rhythm. A complete inventory of all controlled substances on hand is required at least every two years, timed from your last one rather than on a calendar date (21 CFR 1304.11(c)), and the first one is the initial inventory taken the day you first dispense at that location (21 CFR 1304.11(b)). A running sheet does not replace that count. The sheet tells you what should be there. The inventory tells you what is there, and the difference between them is the thing worth paying attention to.

Where does a count sheet break down on a light day?

The place a well-kept sheet fails is not the busy day. It is the light one. Waste is co-signed by a second person who was present, and on a full procedure day that person is standing right there. On a Friday with one physician, one nurse and two cases, the second licensed person may be down the hall, at lunch, or gone at two o’clock. The waste still happens. The co-signature migrates to the end of the day and gets signed from memory, and the time on that line stops describing anything that actually occurred. Clinics tend to know this about themselves, and it is rarely written down.

The other thing nobody writes down is where that leaves the person holding the pen. The sheet is in your handwriting, the variance sits in your column at the end of the shift, and the person you would have to ask about it may be a physician who has been here longer than you have. That is an uncomfortable position, and the way out of it is procedural rather than personal.

What do you do when the count does not close?

Work it while the day is fresh. Recount with a second person, walk the sheet back to the last point where it balanced, check the cases and the cancellations in that window, and confirm every waste has its witness signature. Most discrepancies have an ordinary explanation: a missed entry, a partial dose recorded against the wrong line, a delivery logged twice. Then write down what you found and the time you found it, and raise it the same day with whoever owns the record. A discrepancy that was resolved but never recorded as resolved looks exactly the same, months later, as one that was ignored. The written resolution protects the record, and it protects you.

There is no federal clock on working a discrepancy itself. If you find a discrepancy late it is still worth working, and the reporting clocks that exist start on discovery rather than on the date something went missing. The reason to work it early is that memories, schedules and the people who were there are easier to reach today than in three months. Where a discrepancy turns out to be a theft or a significant loss, a separate reporting path opens with its own deadlines, and that determination belongs to the registrant. DEA Form 41 and Form 106 each have their own procedure for that path.

When does a count sheet stop being enough?

A count sheet is enough while one person can hold the whole picture. It stops being enough when enough providers share one supply that nobody can see across all of them, because a sheet records each handling step in isolation and nothing in it compares one provider to another. That is a limit of the format, not a failure of the people using it.

Three specific things a paper sheet cannot do, no matter how well it is kept:

  • It cannot tell you what normal looks like across your providers, so it cannot show you a departure from normal.
  • It cannot surface a pattern that only exists across pages, weeks or providers, because reading across the binder is manual work nobody is assigned.
  • It cannot produce an organized record set on demand when an inspector or a surveyor asks for one. It can only be photocopied.

A well-kept binder is a legitimate record and a great many clinics run on one. The question is not whether paper is allowed. It is whether the record can answer a question that cuts across providers and weeks, and a discrepancy can sit in a binder for months before anyone has a reason to open that page.

What replaces the sheet when a clinic outgrows it?

Before what Countra does, the part worth saying first is what it does not do. It does not make a clinic DEA compliant, and it does not file DEA forms. It reasons over the record it is given, so if a dose is documented as administered and was not, the record can look consistent while the physical reality is not. It does not replace the physical count, and it does not reach a conclusion about a person. Anyone selling you the opposite of those sentences is selling you something that does not exist.

What a digital record can do is capture each step as it happens, keep the whole chain readily retrievable, and produce it cleanly when someone asks. Countra is a controlled-substance documentation and per-provider diversion-monitoring software for multi-provider clinics and surgery centers that handle controlled substances in-house, with no hospital pharmacy and no dispensing cabinet. It runs from the locked safe or cabinet you already have, with the clinical staff you already have, on a smartphone, tablet, desktop or laptop.

The documentation layer covers the same chain of custody as the sheet above: delivery into inventory, checkout for a case, administration, witnessed waste with a witnessed co-signature, reconciliation against the perpetual inventory, and a PDF report export on demand for an inspection, an accreditation survey or your own files. It is designed to capture the witnessed co-signature at the moment of waste rather than in a later reconstruction. The honest test of that is the light day, when the second clinician is not in the building at the moment of waste. Countra's answer is strict. A waste entry cannot be completed until both the person wasting and the witness have signed, in one sitting, each with their own PIN, so there is no way to record a waste now and collect the witness later. The workable practice on a light day is the one your policy probably already requires: hold the waste until a witness is available rather than wasting unwitnessed and signing from memory at the end of the day. What the record can never contain is a co-signature that was reconstructed after the fact, because an entry either has both signatures at its timestamp or it does not exist. Each entry is locked once it is recorded, and a correction is captured as a new time-stamped entry, so the original is never erased, which a shared spreadsheet only gives you if someone has set up version history and actually reviews it.

The per-provider monitoring layer is a different question, and it is worth being clear about who it is for. It works by comparison across providers performing the same kinds of actions. Monitoring needs at least two active providers to have something to compare, and it says less in a solo practice, where there is no internal baseline. When something drifts from peer patterns, it reaches your administrator as an alert to review. A flag is a prompt to look closer, not an accusation and not a conclusion, and the judgment stays with your clinic. If that is the question your sheet cannot answer, https://www.countra.ai/pain-clinics lays out how a multi-provider clinic keeps the record and how an outlier gets surfaced for review.

Frequently asked questions

Is a narcotic count sheet required by the DEA?

The rules require complete, accurate and readily retrievable records rather than one prescribed form. A count sheet is a practical way to keep those records day to day, and it is what many clinics use. Your state board and your accreditor may add their own expectations on top of the federal requirement, so check both.

Can we keep the count sheet in a spreadsheet instead of on paper?

Many clinics do, and a spreadsheet solves legibility and arithmetic. The federal rules are format neutral for the running record: readily retrievable is defined with electronic recordkeeping systems in mind (21 CFR 1300.01(b)), and what matters is that Schedule II records stay separate and everything is producible at the registered location for two years (21 CFR 1304.04). The one record with a required format is the inventory itself: initial and biennial inventories must be maintained in written, typewritten, or printed form at the registered location (21 CFR 1304.11(a)), so whatever holds the daily record, print, sign and file the inventory. What a spreadsheet does not solve, once several people share the file, are the two things that matter most: capturing the witness signature at the moment of waste, and making any later edit visible instead of quiet. If you use a spreadsheet, be deliberate about who can change a past entry and how a change is recorded.

Who should sign the count?

The people who counted. Common practice is a two-person count at the open and close of the safe or at shift change, with both signing the ending count, so the number never rests on one person’s word. How often you count and who pairs up is set by your own policy, your state board and your accreditor rather than by one federal line. Signatures on individual handling steps are a different matter: the person performing the step signs it, and waste is co-signed by a witness who was present.

Does Countra make my clinic DEA compliant?

No. Compliance is the registrant’s responsibility. Countra supports the recordkeeping behind it by capturing each step, keeping records readily retrievable, and making reconciliation and export straightforward.

How long do we keep completed count sheets?

At least two years from the date of the record, readily retrievable and available at the registered location for inspection (21 CFR 1304.04). Several states require longer, so check your state requirement alongside the federal one and keep to whichever is longer. The DEA clock is also not your medical record retention clock, which is usually much longer.

WHEN THE SHEET STOPS

Where to go if the sheet is not holding

If your sheet is holding and you came here for the columns, take them and go. If it holds for each provider individually and still cannot tell you anything about the group, the workflow for multi-provider clinics is laid out on the pain clinics page, and you can request a demo there.

Request a Demo

About 20 to 30 minutes, screen share, real workflow.

Prefer to talk? (650) 447-1122

Related resources

Sources

21 CFR Part 1300Definitions used across the DEA regulations, including the definition of non-retrievable.https://www.ecfr.gov/current/title-21/part-1300
21 CFR Part 1304Records and reports of registrants, including where records are kept, how long they are retained, and what an inventory and a dispensing record must contain.https://www.ecfr.gov/current/title-21/part-1304
21 U.S.C. 802Definitions for the Controlled Substances Act, including the statutory definition of a narcotic drug at subsection (17).https://www.govinfo.gov/content/pkg/USCODE-2024-title21/html/USCODE-2024-title21-chap13-subchapI-partA-sec802.htm

This guide is general information about federal controlled-substance recordkeeping. It is not legal advice, and it is not affiliated with or endorsed by the Drug Enforcement Administration. Requirements change, and state boards and accreditation bodies impose their own on top of the federal rules. Confirm what applies to your practice with your counsel, your state board and the current text of the regulations. Reviewed and current as of September 22, 2026.

Countra does not make a facility DEA compliant, does not file DEA forms, and does not prevent or guarantee the detection of diversion. Compliance and reporting remain the registrant’s responsibility.

Countra does not make a facility DEA compliant, does not file DEA forms, and does not prevent or guarantee the detection of diversion. Compliance remains the registrant's responsibility. This article is educational information, not legal, regulatory, or clinical advice. Interface images are illustrative and use sample data.