Veterinary Controlled Substance Log

Keep a running balance for each controlled-substance container, catch the entries an inspector would question, compare the record with your physical count, and see when the next biennial inventory is due. Runs entirely in your browser; nothing is uploaded.

Drugs and containers (CSV with columns Drug, Strength, Form, Schedule, Container/Bottle ID, Opening Count, Opening Date, Unit; optional Max Single Use, Physical Count, Count Date)

Open a drugs CSV

Activity (CSV with columns Date, Time, Drug/Container ID, Type, Quantity, Patient, Client (Owner) Name, Staff, Witness, Invoice/Form 222 No, Notes)

Open an activity CSV

As-of date

Last biennial inventory date

Types: received adds to the balance; administered, dispensed, wasted and returned (to a supplier or reverse distributor) subtract; adjustment uses the sign you enter and needs a note.

This is a helper for organizing and checking records, not a compliant system of record on its own, and it does not make a practice compliant. Controlled-substance records must be kept as DEA (21 CFR part 1304) and your state board of pharmacy and veterinary board require, including how long, in what form and where. Keep the original records, invoices, DEA Form 222 copies and CSOS records. Rules on losses, theft, DEA Form 106 and disposal have specific requirements and deadlines; check DEA rules and your state's rules. Not legal advice.