👉 The new ASAP CURES 4.2 A or 4.2B format is currently in a beta testing phase and is not yet compliant. It will be released to the entire customer base in the near future once the beta testing is completed.
📝 Overview
The Controlled Substances Log report is a DEA-compliant report that can be downloaded for submission to your local jurisdiction. Certain required fields must be completed for data to populate correctly in the report. Additional fields, while not mandatory for all users, are needed if you are submitting the report in the ASAP CURES 4.2A or 4.2B format.
You can access this report by navigating to Reports > Inventory > Controlled Substances Log. This article reviews best practices for maintaining an accurate log, explains where to enter the data fields, and outlines how to properly export the report for submission to your jurisdiction.
⚠️ Please always refer to your local jurisdiction for controlled substance report regulations.
💉 Inventory & Controlled Substances: Marking Items and Managing Purchases and Adjustments
When setting up and managing inventory items, there are a few essential steps to keep in mind in order for controlled substances to be tracked correctly.
Click the arrow to learn about controlled substances and inventory
Click the arrow to learn about controlled substances and inventory
Marking an Item as Controlled
Any inventory item classified as a controlled substance must be marked as such in its item profile to appear in the Controlled Substances Log report. Follow the steps below to ensure proper setup:
Navigate to the Inventory module
Search for the item in the search bar, or if adding a new item, click New Item on the top left.
Click Edit Item the top left
Click on the Controlled field and select Yes from the dropdown
NDC (National Drug Code) - Optional Field
If your jurisdiction requires it, the NDC can be entered in at the inventory item level, within the item's profile or when entering in a purchase.
💡 The NDC number will only transfer to the ASAP CURES 4.2A or 4.2B format report option when downloading.
To enter it in the item's profile, edit the item and enter the NDC in the National Drug Code field, and click Save + Done on the top left.
The NDC will automatically carry over when entering in a purchase for the item. If it differs from what is listed on the item profile, you can enter it in when recording a purchase.
Additionally, when entering New Items on a receipt, you will have a NDC field as well. The NDC will carry over from the item profile, or add in a different NDC as needed.
Purchases
It is critical that your purchases are entered in with all the correct information, as the report will log the Lot #, Manufacturer, and Expiration from the specific purchase. The balance of the item is updated when a purchase is entered in as well.
💡 Learn how to work with purchases by using clicking the article below.
Adjustments
The Controlled Substances Log records the balance after every transaction. To ensure accurate calculations, it is critical that inventory items marked as controlled always reflect the correct balance. If any portion of an item is wasted or destroyed, be sure to navigate to the item and record an adjustment so the log remains accurate and compliant.
💡 Learn how to work with adjustments by using clicking the article below.
📖 Optional Data Fields
This section outlines the optional data fields to complete the Controlled Substances Log, based on the format you are exporting and the regulations of your local jurisdiction.
Click the arrow to learn about the optional data fields
Click the arrow to learn about the optional data fields
DEA Number & Pharmacy Number
Your clinic’s DEA number and pharmacy number can be entered in the account profile, on the main Settings page. This information will only carry over to the ASAP CURES 4.2A or 4.2B format when downloaded.
Days Dispensed Field
When an item is marked as controlled, a Days Dispensed field will appear when entering in a medical record for that item. This information will only carry over to the ASAP CURES 4.2A or 4.2B format when downloaded. This field is currently only available for items marked as controlled. The field appears in the following instances:
Adding a New Record from the patient profile
Adding a New Record from a medical note
Adding a New Item (new record) from an invoice
When converting an estimate to an invoice
New Record Example:
Bundle Example:
Client Birthdate and Driver License
If your jurisdiction require a client’s Birthdate and Driver’s License number, you can enter this information in the client's profile, which will transfer to any downloaded version of the controlled substance report.
🗂️ How to Filter and Export the Report
Learn how to filter the report to generate accurate information about your clinic’s controlled substance usage. Once the filter is applied, you can export the report for downloading or printing.
💡 Because requirements vary by jurisdiction, once the report is downloaded—regardless of the selected format—it can be modified as needed to meet your local regulatory requirements.
Filtering the Report
Click the arrow to learn how to correctly filter the report
Click the arrow to learn how to correctly filter the report
In order to generate the correct information, make sure to carefully apply the filters to the report on each use.
From the Reports module, click the Inventory tab and click the Controlled Substance Log report.
Click Filter on the top left.
Select the Type field. The options include All Inventory Items, which will display every single item marked as controlled, regardless of the category type. The other options are Inventory or Service, which will only show items marked as controlled in those inventory category types.
💡 If an item is not showing up on the report and you have the Type filter set to either Inventory or Service, filter for All Inventory Items to ensure you are not missing any controlled substance.
Ensure the date range is selected for the time period you need. Click in the Date Range field and make the correct selection. Either use the dropdown, or manual select the specific dates as needed.
Select the Items field, and choose to Display all items, which will show every controlled substance based on the Item and Date range field. If you are only looking for a specific Item(s), click the Display specific items option and search the items you need.
Lastly, you can choose wether to show all records created from Display all providers, or choose Display specific providers and search for the provider(s) needed.
Exporting the Report (.csv) and Printing Report
Click the arrow to learn how to download or print the report
Click the arrow to learn how to download or print the report
Click Export on the the top of the report and choose either Download for all or Print for all. Printing the report will open the report in a new tab (make sure pop-up blockers are off).
When downloaded, it will download to an excel file (or computer specific spreadsheet) which can be manipulated as needed for your jurisdictions specific requirements. The file is exported as a .CSV
Clinics will need to refer to their state or other jurisdictions reporting agency to find information on how the file is submitted.
You may need to convert and modify the exported report depending on the jurisdiction requirements.
Many jurisdictions have specific naming conventions for the submitted file.
Exporting the ASAP CURES 4.2A or 4.2B Format Report
Click the arrow to learn how to export the report
Click the arrow to learn how to export the report
Click Export on the the top of the report and choose your exporting option. To export it in ASAP 4.2A or 4.2B Format, hover over the Export ASAP Report option and choose the format you need. The report will then be downloaded onto your device.
💡 When the report is exported, the system automatically checks for missing required fields. If any are detected, a label will display identifying the specific fields — such as DEA Number, Days Dispensed, etc. — that need to be completed. This alert indicates the report may be rejected by your jurisdiction if submitted incomplete.
Clinics will need to refer to their state or other jurisdictions reporting agency to find information on how the file is submitted.
You may need to convert and modify the exported report depending on the jurisdiction requirements.
Many jurisdictions have specific naming conventions for the submitted file.
❓Frequently Asked Question (FAQs)
Find answers to common questions or additional details that may not be covered in the main instructions.
Click the arrow to learn the frequently asked questions
Click the arrow to learn the frequently asked questions
1. What does the Controlled Substances Log report include?
Click the arrow to learn more
Click the arrow to learn more
The report lists all controlled items along with invoice details, patient and client information, administering staff, quantity, lot, expiration, manufacturer and the current balance.
2. How do I make sure an item appears in the Controlled Substances Log?
Click the arrow to learn more
Click the arrow to learn more
Any inventory item classified as a controlled substance must be marked as such in its item profile. To do this, navigate to the Inventory module, select or add the item, click Edit Item, and set the Controlled field to Yes.
3. Why are purchases important for the log?
Click the arrow to learn more
Click the arrow to learn more
When entering purchases, the system records details such as Lot Number, Manufacturer, and Expiration Date. The item’s balance is also updated. Accurate entry ensures the log reflects correct inventory levels.
4. How are adjustments tracked in the log?
Click the arrow to learn more
Click the arrow to learn more
The Controlled Substances Log records the balance after every transaction. If any portion of a controlled item is wasted or destroyed, you must record an adjustment to keep the log accurate and compliant.
5. How do I filter the report for accurate results?
Click the arrow to learn more
Click the arrow to learn more
From Reports > Inventory > Controlled Substances Log, click Filter. You can filter by type (All Inventory Items, Inventory, or Service), date range, specific items, and providers. Always check filters carefully to avoid missing data—for example, if an item doesn’t appear, set the filter to All Inventory Items.
6. Are there any integrations for controlled substance management?
Click the arrow to learn more
Click the arrow to learn more
Yes! We integrate with VetSnap. VetSnap is an integrated digital controlled drug log software with error checking and auto-reconciliation. VetSnap makes DEA compliance simple by alleviating the manual effort and risk of maintaining paper DEA controlled drug logbooks, also offering State reporting, and smart safes for extra security of your controlled substance. This integration allows VetSnap to access client, patient, inventory, and billing records. Click below to learn more about VetSnap.