Vial LedgerKeep the whole register

Controlled drug register template

One sheet per bottle or container, with a column for each kind of entry and a running balance. Write the drug, concentration and starting volume in the location field or at the top, set the rows and print.

Controlled drug register

Date: ____________   Drug and mg/mL: ____________________   Starting volume (mL): ________

DatePatient / refDispensed (mL)Administered (mL)Waste (mL)Adjustment (+/- mL)Balance (mL)InitialsWitness
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         
         

25 rows. Signature: ______________________   Witness signature: ______________________

Runs in your browser; nothing you type is sent anywhere. Arithmetic for your records: we do not give legal or compliance advice.

Columns on the sheet

Keeping the balance column

Each line's balance is the line above minus any dispensed, administered or waste volume, plus or minus an adjustment. Keep one sheet per container so a count can be compared with a single balance. The calculator does the same arithmetic if you want to check a finished sheet.

Questions

Why one sheet per container?

A count is taken per container, so a balance per container is the figure it can be compared with directly.

Does this tell me whether my log is compliant?

No. We keep and total your records; we do not give legal or compliance advice. The calculator adds and subtracts the figures you type and shows where two of them differ.

Related calculators

Keeping this for every bottle, every day?

Vial Ledger keeps the running balance for each container, records waste with a witness, checks what went to patients against what left the shelf and prints the count sheet when you need it. $99/mo, self-serve, first month free for early signups. No payment now.