Look Up Product
Adjust:
Inventory Period
▼
| DIN ⇅ | Drug Name ⇅ | Prev. Count ⇅ | Current Stock ⇅ | Divergence ⇅ | Expected | Actions |
|---|
Divergence Summary — Potential Issues
Products where the actual count diverges from what the system expects. Sorted by severity. Click a row to view the full calculation breakdown.
| DIN | Drug Name | Prev. | Purchases | Sales | Adj. | Expected | Actual | Divergence | % | Note |
|---|
Physical Count Checklist
Check off each product as you physically count it. Progress is saved automatically.
Cloud Backup
Not logged in
Merge Duplicate DINs
Combine two products that share the same DIN or were imported under different names into one. Stock quantities are added together.
Keep this product (primary)
⟵
Merge this into it (will be deleted)
Transfer Between DINs
Move expected stock impact from one DIN to another with before/after preview.
From DIN −
To DIN +
Quantity to Transfer
Note (optional)
Molecule Balancer (multi-DIN)
Paste equivalent DINs (comma/newline/space separated). The system will suggest best balancing transfers from overage to shortage.
Admin — Import Recovery
Use these only when a wrong import was applied. This will remove log impacts from divergence calculations.
Current stock quantities are not changed by these actions; only purchase/sale log effects are cleared.
Import Data
Mode:
Option A — Upload CSV File directly
OR
Option B — Copy & Paste from Excel (recommended)
Log Expired Medication
DIN *
Drug Name *
LOT Number
Expiration Date
Qty
Pharmacist License #
Note (optional)
Expired Medication Log
| Date | DIN | Name | LOT | Exp. Date | Qty | License # | Note |
|---|
Log Medication Destruction
DIN
Drug Name
LOT Number
Expiration Date
Qty
Pharmacist License #
Witness Name
Destruction Method
Note (optional)
Destruction Log
| Date | DIN | Name | LOT | Exp. Date | Qty | Method | License # | Witness |
|---|
Adjustment Register
| Date ↕ | DIN ↕ | Drug | Adjustment | Current Note | Action |
|---|
Internal Investigation Form
Event Type *
DIN
Drug Name
Quantity Concerned
Event Summary *
Justification / Root Cause *
Status
Linked Adjustment Log IDs (comma-separated, optional)
Investigation Dossiers
| Dossier ID | Date | Type | DIN | Drug | Status | Linked Logs | Action |
|---|
Monthly Review of Manual Adjustments
Month (YYYY-MM)
Reviewer
Role
Review Date
Review Summary
How to Import Sales (Stock OUT)
📤 Ubik — Sales Report (Rapport statistique des produits)
1
In Ubik, go to Gestion → Rapports → Autres → Rapport statistique des produits
2
In the product type filter, select only: Contrôlé, Contrôlé rapportable, Narcotique, Narcotique rapportable, Substance ciblée
3
Generate the report in EXCEL format — open the file in Excel
4
In Excel, go to File → Save As, choose CSV (comma delimited) (*.csv) and save
5
Go to the Import tab, select "Sale — subtract from stock"
6
Click "Upload CSV File" (Option A) and select the .csv file you just saved
💡 Tip: If the file upload doesn't detect the right columns, use Option B (paste) instead: open the CSV in Notepad, press Ctrl+A then Ctrl+C, and paste into the text box.
How to Import Purchases (Stock IN)
📥 Ubik — Purchase Report (Substances narcotiques et contrôlées)
1
In Ubik, go to Accueil → Rapports → Substances narcotiques et contrôlées
2
Generate the report in EXCEL format — open the file in Excel
3
In Excel, go to File → Save As, choose CSV (comma delimited) (*.csv) and save
4
Go to the Import tab, select "Purchase — add to stock"
5
Click "Upload CSV File" (Option A) and select the .csv file you just saved
💡 Tip: Quantity is automatically calculated as boxes ordered × units per box (e.g. 2 boxes of 100 = 200 units). The package size is read from the drug name description.
How to Migrate Your Legacy Inventory
📋 Excel Legacy Report (DECOMPTE)
1
Open your Excel inventory sheet (the one with DIN, PRODUIT, DECOMPTE columns)
2
In Excel, go to File → Save As, choose CSV (comma delimited) (*.csv) and save
3
Go to the Import tab, select "Migrate legacy inventory (DECOMPTE)"
4
Click "Upload CSV File" (Option A) and select the .csv file
5
NarCount will automatically use the DECOMPTE column as the previous count baseline
Stock Adjustments
⚙ Manual Adjustments (Lookup Tab)
1
Expired: Look up the product, select "Expired" and enter the quantity. Logged separately for audit trail.
2
Lost/Damaged: Look up the product, select "Lost/Damaged" and enter quantity with a note explaining the reason.
3
Manufacturer Balance: Look up the product, select "Transfer" and use the note to indicate the manufacturer.