Exporting purchase records from Imperial

Use an Imperial ordering account with reporting access. You want your controlled-substance purchases over the reconciliation window (last count → current count).

In Imperial

• Sign in to the Imperial ordering portal.
• Open Reports (often under Account or Order/Invoice History).
• Choose a Purchase History or Invoice History report.
• Set the date range from the day after your last count to your current count date.
• If a product-class filter is offered, select Narcotics / Controlled / Targeted; otherwise export everything — NarcCount only reconciles the DINs you track.
• Export to Excel or CSV and save the file.

In NarcCount

Open Purchases → Import purchases from CSV and upload the file (save Excel as CSV first). NarcCount reads the Date, DIN, and Quantity columns and adds any unknown DINs to Drug Management automatically.