A Schedule II inventory log is a record of the receipt and disposal of Schedule II controlled substances that federal regulations require every DEA registrant to keep for at least two years. It must document the name of the substance, the form, the quantity received or dispensed, the date of the transaction, and the name, address, and DEA number of the person or pharmacy from whom it was received or to whom it was dispensed.
Why the Log Exists
Schedule II drugs—like oxycodone, fentanyl, and amphetamine—have a high potential for abuse and severe psychological or physical dependence. Because they are diverted from legitimate channels more often than other controlled substances, the Drug Enforcement Administration (DEA) imposes stricter recordkeeping rules on them than on Schedule III–V drugs. The inventory log is not an optional internal tool; it is a legal document that DEA investigators may inspect at any time during a routine audit or an investigation into a diversion or theft.
The requirement comes from the Controlled Substances Act (21 U.S.C. § 827) and the implementing regulations in 21 CFR Part 1304. These rules apply to every registrant—pharmacies, practitioners who dispense, distributors, and researchers—unless a specific exemption applies (for example, a practitioner who administers directly to a patient and keeps no inventory may not need a separate log for that activity).
What the Log Must Record
For each Schedule II substance, the log must include the following information, recorded at the time of the transaction:
- Name of the substance (e.g., oxycodone, not just the brand name)
- Form and strength (e.g., 10 mg tablet, 5 mg/5 mL solution)
- Date of receipt or disposal
- Quantity received or disposed of (in metric units, unless the substance is in a solid dosage form, in which case you can record the number of units)
- Name, address, and DEA registration number of the person or entity from whom it was received or to whom it was dispensed
For disposals, you also need to document the method of disposal (e.g., reverse distributor, incineration, or DEA-supervised destruction) and the date. If you transfer a substance to another registrant, that transaction is recorded as a disposal in your log and as a receipt in the other party’s log.
How the Log Works in Practice
Most pharmacies and clinics use a perpetual inventory system, meaning the log is updated continuously as drugs come in and go out. Each bottle of Schedule II medication is assigned a unique lot or batch number, and the log tracks that specific lot from the moment it arrives until the last dose is dispensed or destroyed. At the end of each month (or more frequently, depending on state law), a physical count is taken and compared to the log. Any discrepancy—even a small one—must be investigated and documented.
For a practitioner who personally administers a Schedule II drug to a patient (e.g., a physician giving an injection in the office), the log entry is made at the time of administration. For a pharmacy, the log entry is made when the prescription is filled. The key point is that the record must be contemporaneous—you cannot wait until the end of the week to write down what you dispensed.
Choosing Between a Paper Log and a Digital System
Your choice of format depends on your practice size, your state’s rules, and your comfort with technology. Both are legal, but each has trade-offs.
- Paper logs are simple, require no electricity, and are easy to inspect. However, they are harder to search, take up physical space, and are more prone to arithmetic errors.
- Digital logs (spreadsheets or specialized pharmacy software) allow instant searching, automatic calculation of running balances, and easier backup. But they must be backed up regularly, and you must ensure the software cannot be altered without a trace—DEA expects audit trails.
If you use a spreadsheet, it is wise to protect the cells with formulas and to keep a separate, unchangeable backup. Many states have additional requirements, such as mandatory electronic reporting to a prescription drug monitoring program (PDMP), but that is separate from your internal inventory log.
Common Problems and How to Avoid Them
The most frequent citations during DEA inspections include missing dates, missing DEA numbers of the other party, and failing to record disposals. Another common issue is using brand names instead of generic names—the regulation requires the official name of the substance. For example, writing “OxyContin” instead of “oxycodone” is a violation.
Another problem is not reconciling the log with the physical count. If your log says you have 100 tablets but the shelf has 98, you must document the discrepancy and explain it (e.g., a dispensing error, a spill, or a theft). Leaving the discrepancy unresolved is itself a violation. Also, do not forget that the log must be kept at the registered location and be available for inspection during normal business hours.
Finally, many registrants do not realize that the two-year retention period starts from the date of the last entry, not from the beginning of the year. If you make a disposal entry in March 2025, that record must be kept until March 2027.
Comparisons to Other Schedules
Schedule II substances require more detailed records than Schedule III–V. For Schedule III and IV drugs (like codeine combinations or diazepam), you still need to keep records, but you are allowed to maintain them in a less formal manner—for example, you can keep a single log for all Schedule III–V drugs, and you do not need to record the DEA number of the other party in every transaction. Schedule V drugs (like cough syrups with codeine) have even looser requirements, though you still must keep records of receipts and disposals.
Schedule I drugs (like heroin or LSD) are not prescribable, so they are only handled by researchers and manufacturers, who must follow even stricter protocols, including separate logs for each research protocol. The Schedule II log is often the template for those more rigorous systems.
Costs and Penalties for Non-Compliance
Keeping a log has minimal direct cost—paper, a binder, or a spreadsheet. The real cost is the time spent entering data and performing monthly counts. For a busy pharmacy, this can amount to several hours per month. However, the cost of non-compliance is far higher. Civil penalties for recordkeeping violations can reach $10,000 per violation for a registrant. Criminal penalties apply if the violation is knowing or intentional, with fines and imprisonment up to several years. In practice, DEA often issues a warning letter for minor first-time errors, but repeated failures can lead to a suspension or revocation of your DEA registration, which effectively ends your ability to handle controlled substances.
If you are audited and the log is incomplete, the inspector may assume the worst—that you diverted drugs—unless you can prove otherwise. That is why accuracy matters more than format.
Template for a Schedule II Inventory Log
Below is a blank template you can adapt. It includes the required fields for both receipts and disposals in a single table. The “Balance” column is optional but helpful for a perpetual inventory.
| Date | Substance (Generic Name) | Form/Strength | Transaction Type (Receipt/Disposal) | Quantity | From/To (Name, Address, DEA#) | Balance |
|---|---|---|---|---|---|---|
Sample row (fictional): 2025-06-01 | oxycodone | 10 mg tablet | Receipt | 500 | ABC Wholesale, 123 Main St, Anytown, USA, DEA# FA1234567 | 500
Make copies of this table and bind them in a logbook, or recreate it in a spreadsheet. Always keep a backup.
Frequently Asked Questions
Do I need a separate log for each Schedule II drug? No, you can use one log that lists all Schedule II substances, as long as each entry clearly identifies the drug. Many pharmacies prefer a separate page per drug for easier reconciliation, but it is not required.
Can I use my pharmacy’s computer system instead of a paper log? Yes, as long as the system records all required fields and produces a report that DEA can review. The system must also have a way to detect unauthorized changes (an audit trail). If your software does not do that, you should keep a paper backup.
What if I lose my log? You must attempt to reconstruct it from purchase invoices, prescription records, and other documents. Notify your DEA field office if you believe the loss is due to theft or a system failure. If you cannot reconstruct it, you may face a recordkeeping violation, but cooperating with DEA can mitigate penalties.
How long do I keep the log after I close my pharmacy? You must maintain the log for at least two years from the date of the last entry. When you close, you must notify DEA and arrange for transfer of the records to a custodian or to DEA itself, depending on the circumstances.
Is there a difference between an inventory log and a biennial inventory? Yes. A biennial inventory is a complete count of all controlled substances on hand, taken every two years. The inventory log is a running record of individual transactions. Both are required; the log helps you conduct the biennial inventory more easily.
What if I only administer Schedule II drugs in a hospital setting? Hospitals often have a different system, but the same recordkeeping principles apply. Each administration must be documented, and the log must be reconcilable with the drug stock. Many hospitals use automated dispensing cabinets that generate the required records automatically.