DEA recommends at minimum biweekly reconciliation for Schedule II drugs
Drug 1
Drug 2
Embed This Calculator on Your Website
Add this free calculator to your blog, website, or CMS with a simple copy-paste embed code.
Introduction
The DEA requires every registered veterinary practice to maintain a running controlled substance log that accounts for every milligram dispensed, every milligram wasted, and every milligram remaining. An unreconciled discrepancy is not a paperwork issue. Under 21 CFR Part 1304, a practice with unexplained Schedule II losses faces DEA investigation, potential revocation of the DEA registration, and state veterinary board discipline that can cost a veterinarian their license. The most common cause of discrepancy is not diversion. It is math. Doses are documented in volume (mL) while inventory is tracked in milligrams, and staff convert between the two inconsistently. This calculator performs the complete reconciliation: starting inventory in mg, all documented withdrawals (dose x concentration), all documented waste, and the expected remaining quantity compared against physical count. The variance, positive or negative, is what you report.
What This Calculator Does
This controlled drug inventory reconciliation calculator tracks opening balance (in mg or mL), records each withdrawal with dose, concentration, and volume drawn, adds all documented waste events, and computes the expected remaining balance. It compares expected balance against physical count to produce a reconciliation variance. Output includes a transaction log suitable for DEA log book documentation and the variance in both mg and mL.
The Formula
Opening balance is the verified starting quantity in milligrams. Each withdrawal converts volume drawn (mL) to milligrams using the drug concentration: mg withdrawn = mL drawn x mg/mL. Waste is documented in mL and converted to mg. Expected remaining = opening balance minus all withdrawals minus all waste. Physical count is the actual measured quantity remaining. A negative variance (physical count less than expected) requires investigation. A positive variance (more than expected) is unusual and also requires documentation.
Step-by-Step Example
Establish opening balance
At the start of a shift or reconciliation period, physically count and weigh or measure the stock. Example: butorphanol 10 mg/mL, 30 mL vial with 22.5 mL remaining = 225 mg opening balance. Record in log with date, time, and verifying signature.
Document each withdrawal in mg
Patient A: drew 0.5 mL of butorphanol 10 mg/mL = 5 mg withdrawn. Patient B: drew 0.3 mL = 3 mg withdrawn. Patient C: drew 0.8 mL = 8 mg withdrawn. Total withdrawn: 16 mg.
Document all waste events
Patient B required 0.3 mL but protocol was 0.5 mL. Remaining 0.2 mL wasted in the presence of a witness and documented: 0.2 mL x 10 mg/mL = 2 mg wasted. Witness signature required on log.
Reconcile expected vs. physical
Expected remaining: 225 mg - 16 mg withdrawn - 2 mg wasted = 207 mg. Physical count: 20.7 mL x 10 mg/mL = 207 mg. Variance: 0 mg. Log closed with reconciling signatures.
Real-World Use Cases
End-of-Day DEA Log Reconciliation
A practice closes at 6pm. The lead technician runs the reconciliation tool for every open controlled substance: ketamine, butorphanol, and dexmedetomidine. All three reconcile within 0.1 mL of expected due to syringe measurement tolerance. The technician documents the physical counts, signs the log, and the records are audit-ready.
Investigating a Discrepancy
A 5 mg butorphanol shortfall appears during monthly audit. The reconciliation tool shows the discrepancy began three weeks ago on a Tuesday. Cross-referencing the anesthesia sheets for that day reveals a patient was administered 0.5 mL (5 mg) but the log shows 0 mg withdrawn. The missing entry is located and documented as an administrative error with DVM countersignature.
New Vial Conversion and Opening Balance Entry
A new 20 mL vial of ketamine (100 mg/mL) is opened mid-week. Opening entry: 2,000 mg. First withdrawal: 1.5 mL = 150 mg. The reconciliation tool automatically tracks from the vial opening, producing a running balance that satisfies DEA Schedules III-V continuous record requirements.
Comparison
| Drug Schedule | DEA Requirement | Record Retention | Biennial Inventory Required |
|---|---|---|---|
| Schedule II (e.g., morphine) | Separate bound log, signature per transaction | 5 years | Yes |
| Schedule III (e.g., ketamine, buprenorphine) | Log or electronic system, running balance | 2 years | Yes |
| Schedule IV (e.g., diazepam, butorphanol) | Log or electronic system, running balance | 2 years | Yes |
| Schedule V (e.g., some cough preps) | Record of purchase and dispensing | 2 years | Yes |
Common Mistakes to Avoid
Documenting withdrawals in mL without converting to mg. The DEA log must reflect quantity in a measurable unit. A log that shows only 'drew 0.5 mL' without the corresponding mg calculation is non-compliant and cannot be reconciled against a weight-based inventory count.
Skipping waste documentation because the amount seems trivial. Every milligram that is not accounted for is a potential discrepancy. A 0.1 mL waste event on ketamine at 100 mg/mL is 10 mg unaccounted. Over a year of skipped waste entries, that becomes a reportable discrepancy.
Conducting monthly rather than daily reconciliations. A discrepancy identified in the same shift it occurs is almost always explainable. A discrepancy identified 30 days later, with no contemporaneous documentation, is far harder to resolve and looks far worse in an audit.
Using a single log for multiple drug concentrations. Ketamine comes in 100 mg/mL and 500 mg/mL formulations. A log that does not specify the concentration for each entry makes volume-to-mg conversion ambiguous and creates reconciliation errors.
Frequently Asked Questions
Accuracy and Disclaimer
This calculator is a reconciliation tool designed to assist with controlled substance record-keeping. It does not constitute legal or regulatory compliance advice. DEA controlled substance record-keeping requirements under 21 CFR Part 1304 and applicable state veterinary board regulations must be confirmed independently. Discrepancies or suspected diversion must be handled in consultation with qualified legal counsel and the appropriate regulatory authorities.
Conclusion
Clean controlled substance logs are your first line of defense in any DEA or state board audit. Running daily reconciliations, not monthly, catches discrepancies when they are still explainable. Once your controlled drug inventory is reconciled, use the Veterinary Fee Pricing Calculator to ensure your controlled substance dispensing fees cover the DEA compliance overhead and physical inventory cost, and the Anesthesia Drug Calculator to generate dose-level documentation for each anesthetic event.
Related Veterinary Calculators
Pet Medication Dosage Calculator
Calculate weight-based medication dosages for dogs and cats across 12 common veterinary drugs including amoxicillin, carprofen, metronidazole, gabapentin, and more using 2026 formulary references.
Use CalculatorVeterinaryAnesthesia Drug Calculator
Calculate induction and maintenance anesthesia doses for canine and feline patients including propofol, ketamine, dexmedetomidine, alfaxalone, and inhalant MAC values with 2026 protocol references.
Use CalculatorVeterinaryFluid Therapy Calculator
Calculate maintenance fluid rates, dehydration deficit replacement, ongoing loss compensation, and IV drip rates for dogs and cats using allometric formulas and 2026 veterinary fluid therapy guidelines.
Use CalculatorVeterinaryVeterinary Fee Pricing Calculator
Calculate procedure pricing, profit margins, and markup percentages for veterinary services including exams, surgery, diagnostics, and dental work using 2026 veterinary fee benchmarks.
Use CalculatorVeterinaryVeterinary Lab Markup Calculator
Compare in-house vs. reference lab costs, set client pricing with configurable markup multipliers, and project monthly lab revenue using 2026 veterinary diagnostic pricing benchmarks.
Use CalculatorVeterinaryVaccine Titer Cost vs. Booster Calculator
Compare the long-term cost of antibody titer testing vs. routine revaccination for dogs and cats across core vaccines using 2026 veterinary pricing and AAHA guidelines.
Use CalculatorYou May Also Find Useful
Tax Calculator
Estimate your 2026 federal income tax based on filing status, gross income, deductions, and current tax brackets. See your marginal and effective tax rates instantly.
Use CalculatorFinance & AccountingSalary to Hourly Calculator
Convert your annual salary to an hourly wage instantly. Adjust for hours per week, weeks per year, and overtime to find your true hourly rate.
Use CalculatorFinance & AccountingCommission Calculator
Determine sales commissions based on revenue, rate tiers, and bonus structures.
Use Calculator