A controlled substance report reconciles your scheduled drugs over a period. You upload three files from your pharmacy management system, a starting inventory, an ending inventory and what was dispensed in between, and BatchRx lines them up NDC by NDC.
What each row shows
One row per NDC, for every NDC in your inventory that is scheduled CI to CV:
- the starting count;
- the quantity ordered;
- the quantity dispensed;
- the expected ending count;
- the actual ending count, with the number of unopened containers, the number of opened containers and the quantity in the opened ones;
- the discrepancy between the expected and the actual count;
- the schedule of the drug.
Read it your way
Filter the report to one schedule or several, and read quantities in units or in packages. Open the ordered or the dispensed quantity of any NDC to see the lines behind it, each with its date and quantity.
When the package size of an NDC differs between your starting, ending and dispensed files, the report says so on the row and can list only those NDCs.
What you upload
- A starting inventory and an ending inventory: NDC, drug name, package size and quantity. The ending inventory also takes the unopened and opened container counts.
- A dispensed file for the period between the two counts.
- Your wholesaler purchase files, if you want the quantities ordered in the period included. They are optional for this report.
All of them are uploaded as CSV or Excel.
Export
The report exports to CSV, in units or in packages.
Controlled drugs in an inventory report
An inventory report knows which of its NDCs are controlled too: you can flag them by schedule, and its audit review counts them.
Frequently asked questions
What does the controlled substance report compare?
For every scheduled NDC it shows the starting count, the quantity ordered, the quantity dispensed, the expected ending count, the actual ending count and the discrepancy between the expected and the actual count.
Which files does a controlled substance report need?
Three files from your pharmacy management system: a starting inventory, an ending inventory and a dispensed file for the period between them. Wholesaler purchase files are optional.
Which drugs appear in the report?
The NDCs in your uploaded inventory that are scheduled CI to CV. The report can be filtered to one schedule or several.