Controlled Substance Log Book: What a Veterinary Practice Needs (2026)

A controlled substance log book is the physical record where a veterinary practice tracks every controlled drug it administers, dispenses, and wastes. It is the document a DEA investigator reaches for first — and the format you choose, bound book, loose-leaf binder, or spreadsheet, changes how well it holds up.

This guide is about the log book itself: whether the law requires a bound book, how the common formats compare, what a log book must contain, and how to set one up so it survives an inspection rather than creating findings. If you want the full picture of controlled substance recordkeeping — entry rules, schedules, the worked example — see our pillar guide, the veterinary controlled substance log.

Do you need a bound log book?

Federal law does not name a specific format. Under 21 CFR Part 1304, a DEA registrant must keep complete and accurate records of controlled substances on a current basis, and those records must be available for inspection at the registered location. The rule is about accuracy, completeness, and retention — not about whether the pages are stitched into a spine.

So a bound log book is not legally mandatory under federal DEA rules. But it is the format most practices use, and most consultants recommend, for one reason: a bound book makes tampering obvious. Pages are numbered and sewn in. A missing page leaves a gap. An altered entry stands out. That built-in tamper evidence is exactly what an investigator is looking for when they assess whether your records can be trusted.

Two cautions. First, some state veterinary boards or state pharmacy boards do specify a bound book, or specify other format details — your state rule can be stricter than the federal floor, so confirm it. Second, “bound book” is a means to an end. The end is a record an inspector cannot reasonably suspect has been edited after the fact. A digital log with a locked audit trail achieves the same thing.

Bound book vs. loose-leaf vs. digital

The three common formats trade off tamper resistance, convenience, and error control differently.

Bound log book

A pre-printed, stitched logbook with numbered pages.

Strength: the strongest tamper evidence. Pages cannot be swapped or removed without leaving a trace, which is why this is the traditional default.
Weakness: no automatic math. Every running balance is calculated by hand, and a hand-math error is the most common way a log stops matching the physical count.
Best for: practices that want the simplest defensible paper trail and are disciplined about arithmetic.

Loose-leaf binder

Printed log sheets kept in a three-ring binder.

Strength: flexible — a fresh sheet per container, easy to organize.
Weakness: pages can be removed and replaced with no trace. This is the weakest format for tamper evidence, and inspectors know it. A loose-leaf log invites the question “what’s missing?”
Best for: acceptable only if pages are sequentially numbered, dated, and reconciled so a gap is obvious. Even then it is the riskiest of the three.

Digital / spreadsheet log

An electronic log, a spreadsheet, or a controlled-substance module in practice-management software.

Strength: calculates the running balance automatically — directly preventing the most common citation. Software with a locked audit trail is also genuinely tamper-evident.
Weakness: a plain spreadsheet with no version control is not tamper-evident on its own; anyone can edit a past cell. It is only as defensible as its audit trail or its printing-and-signing discipline.
Best for: practices that want automatic math. Use either software with a true audit log, or print, sign, and date each completed page so the paper copy is the record of truth.

A practical hybrid many practices land on: a spreadsheet template that calculates the balance, printed at the close of each container and signed — automatic arithmetic, plus a signed paper trail.

What belongs in a controlled substance log book

Whatever the format, each opened-container log in the book should capture enough that an inspector can reconcile it against physical stock and trace a single dose. At minimum:

A header identifying the container — drug name, strength, dosage form, lot or container ID, and the date the container was opened.
The beginning balance — the full amount in the container when opened.
For every transaction: the date, the patient and client, and the amount administered, dispensed, and wasted.
The running balance remaining after each transaction.
The initials of the person responsible, and for any waste, the initials of a witness.
A closing entry when the container reaches zero or is disposed of.

The running balance is the field that matters most. After every entry, the book should show exactly how much drug is left — and that number should always equal what is physically in the container.

Alongside the opened-container logs, a complete log book system also holds the receipt records (invoices, and DEA Form 222s for Schedule II purchases), an unopened-stock record, the biennial inventory, and a list of authorized personnel. The opened-container log is the workhorse; the rest let an inspector follow a drug from the invoice that brought it in to the entry that took the last dose out.

Setting up a log book for each container

The single most important setup decision: one log per opened container — never one shared running log for a drug across multiple bottles.

When two vials of the same drug are open and entries are mixed into one running tally, reconciliation becomes impossible. An inspector pulls one vial, measures it, and has no way to match it to a balance. A separate log per container keeps every count provable.

A workable setup:

One page (or one record) per container. When a new container is opened, start a fresh log with its own header and beginning balance.
A container ID. Number each container so the log and the physical bottle are unambiguously linked.
Schedule II kept apart. Under 21 CFR 1304.04, records for Schedule II substances must be kept physically separate from all other records. Schedule III–V records may be kept separately or in a readily retrievable form. The cleanest approach is a separate section, or a separate book, for Schedule II.
Close the log when the container is empty. A final zero-balance entry, dated and initialed, then retain the completed log.
Retain everything. Completed logs are kept at the registered location for at least two years under 21 CFR 1304.04 — longer where your state requires it. See how long to keep controlled substance records.

Paper vs. spreadsheet: the trade-offs

The choice is not really “paper or digital” — it is “manual math or automatic math, and how do I make the record tamper-evident.”

Paper bound book gives you tamper evidence for free and costs you automatic arithmetic. Every error risk lives in the hand calculation.
Spreadsheet gives you automatic arithmetic and costs you tamper evidence — unless you add it back with a locked audit trail or by printing and signing.

For most general practices, the lowest-risk option is a spreadsheet template that calculates the balance, printed and signed per container. It removes the most common citation (a balance that does not match the count) while keeping a signed paper record. A purpose-built template also bakes in the required fields, so a setup mistake is harder to make.

Download a free controlled substance log template {#lead-magnet}

We’ve built a free Veterinary Controlled Substance Log Template — a clean opened-container log with an automatic running balance, the required fields built in, an instructions sheet, and the legal basis explained. Use it as a printed sheet for your log book or keep it digitally. Enter your email and we’ll send it over, free.

Get the free Controlled Substance Log Template →

Frequently asked questions

Does the DEA require a bound controlled substance log book? Federal DEA rules (21 CFR Part 1304) require complete, accurate, current records available for inspection — they do not name a specific format. A bound book is the common, recommended choice because it is tamper-evident, but a tamper-evident digital log is also acceptable. Check your state board, which may be stricter.

Can I keep my controlled substance log book on a computer? Yes, if it is tamper-evident — software with a locked audit trail, or a spreadsheet that is printed, signed, and dated so the paper copy is the record. A plain, freely editable spreadsheet with no audit trail is the weak point to avoid.

Should I use one log book for all my controlled substances? You can use one physical book, but inside it keep a separate log per opened container, and keep Schedule II records physically separate from Schedule III–V records per 21 CFR 1304.04.

How long do I keep a completed log book? At least two years under federal rules, at the registered location. Several states require longer — confirm with your state veterinary board.

Is a loose-leaf binder acceptable for a controlled substance log? It is the riskiest format because pages can be removed without a trace. If you use one, number pages sequentially and reconcile so any gap is obvious — but a bound book or a tamper-evident digital log is the safer choice.

The log book is the format — the system is bigger

Choosing the right log book matters, but the book is only the container. What protects your practice is the full recordkeeping system inside it — correct entries, witnessed waste, reconciled balances, separated Schedule II records, and a retained biennial inventory. Our veterinary controlled substance log pillar guide covers all of it, and the free Controlled Substance Log Template gives you a defensible starting point today.

When you’re ready to close the gaps for good, the Vet Compliance HQ DEA Controlled Substance Compliance System gives you the logs, SOPs, staff training records, and templates to do it.

Vet Compliance HQ provides educational compliance resources for veterinary practices. This article is not legal advice. DEA and state requirements change and vary by state — verify current requirements with the DEA and your state veterinary board.