Uploading purchase, dispensing & destruction data
Import your transaction records from a CSV or Excel export in seconds.
Open Purchases, Dispensing or Destructions and press Import a file. It opens the import page with that record type chosen. Pick your file, CSV or Excel, and press Import. NarcCount validates each row and tells you how many were imported.
Required columns
- Purchases: Date, DIN, Quantity, Invoice (optional)
- Dispensing: Date, DIN, Quantity, Rx (optional)
- Destructions: Date, DIN, Quantity, Method (optional)
Formatting notes
- Include a header row. Column names are case-insensitive.
- Dates may be YYYY-MM-DD or “Mon DD, YYYY”.
- Quantities may be decimals (e.g. methadone 12.5).
- Unknown DINs are added to Drug Management automatically.
Where this data comes from
Most pharmacies export these reports directly from their dispensing software or wholesaler portal. Upload the file as it downloads: CSV and every Excel format are read, so there is nothing to convert. To upload the physical counts themselves, use Add counts from a file inside a specific count instead.