Guide

What is a drug ledger?

The fields a controlled-substance ledger should hold, a sample entry, how long to keep it, and how clinics move from a paper log book to a digital one.

A drug ledger is a running, dated record of controlled substances — every Schedule II–V prescription a practice writes (a prescription ledger), or every unit of stock it receives, administers, wastes, and holds (an inventory ledger). It lets a clinic produce a complete list for a DEA investigator, state board, or internal reviewer without searching chart notes.

Two kinds of drug ledger

Prescription ledgerInventory (dispensing) ledger
TracksControlled-substance prescriptions written by the practicePhysical stock on site: received, administered, wasted, on hand
Who needs itAny DEA-registered prescriber: primary care, pain management, psychiatry, urgent care, med spas, telehealth groupsPractices that store and administer controlled drugs on site
Typical question it answers“List every Schedule II prescription Dr. Smith wrote between March and June.”“Does the count in the cabinet match the record?”

Rx Ledger CS is a prescription ledger. It does not count vault stock.

What a controlled-substance prescription ledger should contain

Federal rules (21 CFR 1306.05) list what every controlled-substance prescription must carry. A useful ledger records those elements plus the details reviewers ask for:

Sample drug ledger entry

DatePatientDrugQtyDaysRefillsSchedulePDMPPrescriber
10/14/2026Doe, Jane (EMR 10482)Oxycodone 5 mg tab2050C-IICheckedA. Patel, MD
10/14/2026Roe, Sam (EMR 11307)Alprazolam 0.5 mg tab30301C-IVCheckedA. Patel, MD

Sample data. Not real patients.

How long to keep a drug ledger

DEA rules (21 CFR 1304.04) require controlled-substance records to be kept for at least two years and to be available for inspection. Many states require longer. Check your state board.

Paper log book vs. digital drug ledger

Paper log book / spreadsheetDigital ledger (Rx Ledger CS)
Pull a list for a date range or prescriberHours, by handFilter and export to Excel in minutes
Who changed an entryNot recordedField-level history: old value, new value, user, IP, time
DEA refill limitsRelies on memoryBlocks C-II refills and C-III/IV refills over 5 at entry
PDMP checkUsually not loggedRecorded per prescription with user and timestamp
Early deletionPages can be lost or removedEntries can’t be deleted inside the 2-year retention period
Patient privacyOpen book on a shelfEncrypted, role-based access, every view logged

Keep your drug ledger in Rx Ledger CS

Rx Ledger CS is a digital drug ledger for outpatient prescribers. Prescribe in your EMR as usual, record the controlled-substance entry here, and export a DEA-ready list whenever you need one. $49.99/month for the first doctor and location, billed yearly; 30-day evaluation at no charge.

Related: DEA controlled substance log software · Prescription audit trail · Product overview