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 ledger | Inventory (dispensing) ledger | |
|---|---|---|
| Tracks | Controlled-substance prescriptions written by the practice | Physical stock on site: received, administered, wasted, on hand |
| Who needs it | Any DEA-registered prescriber: primary care, pain management, psychiatry, urgent care, med spas, telehealth groups | Practices 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:
- Date issued
- Patient name, date of birth, and chart/EMR number
- Drug name, strength, and dosage form
- Quantity, days’ supply, refills, and directions (sig)
- DEA schedule (C-II, C-III, C-IV, C-V)
- Prescriber name, DEA registration number, and NPI
- Clinic location, for multi-site practices
- PDMP check — whether the state prescription monitoring program was reviewed, by whom, and when
- Change history — who edited the entry, what changed, and when
Sample drug ledger entry
| Date | Patient | Drug | Qty | Days | Refills | Schedule | PDMP | Prescriber |
|---|---|---|---|---|---|---|---|---|
| 10/14/2026 | Doe, Jane (EMR 10482) | Oxycodone 5 mg tab | 20 | 5 | 0 | C-II | Checked | A. Patel, MD |
| 10/14/2026 | Roe, Sam (EMR 11307) | Alprazolam 0.5 mg tab | 30 | 30 | 1 | C-IV | Checked | A. 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 / spreadsheet | Digital ledger (Rx Ledger CS) | |
|---|---|---|
| Pull a list for a date range or prescriber | Hours, by hand | Filter and export to Excel in minutes |
| Who changed an entry | Not recorded | Field-level history: old value, new value, user, IP, time |
| DEA refill limits | Relies on memory | Blocks C-II refills and C-III/IV refills over 5 at entry |
| PDMP check | Usually not logged | Recorded per prescription with user and timestamp |
| Early deletion | Pages can be lost or removed | Entries can’t be deleted inside the 2-year retention period |
| Patient privacy | Open book on a shelf | Encrypted, 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