RxAuditwise v19 — Pharmacy Reconciliation

💊 RxAuditwise

Pharmacy Purchase Reconciliation · v4.0

Select your file formats optional — skip to auto-detect

📦 Supplier file format

Auto-detect: the parser reads column names and figures out the format automatically.

🧾 Billing file format

Auto-detect: the parser reads column names and figures out the format automatically.

📦

Supplier Files

Drop or click — CSV, Excel, TSV accepted

🧾

Billing Files

Drop or click — CSV, Excel, TSV accepted

Sort by:

SR#	DESCRIPTION	NDC	PKG SIZE	RX INS NAME	RX INS BIN	FILLED QTY	PURCHASED QTY	RECONCILIATION	STATUS	INS PAID ($)	PUR COST ($)	MARGIN ($)	MARGIN %

Preview (Raw) Search across all files:

📄

Raw preview — upload files to see raw data.

📦

Upload supplier files to see combined data.

✅

Final — upload and reconcile files to see summary.

💵

Run reconciliation to see billing summary.

🗑️

Run reconciliation to see discarded NDCs.

⚠️

Run reconciliation to see issues.

⚠️

Run reconciliation to see unbilled NDCs.

💰

Run reconciliation to see dollar reconciliation.

📊

Run reconciliation to see charts.

Sr#	Description	NDC	Package Size	Rx Ins Name	Rx Ins BIN	Rx Qty Filled Total	Purchase Quantity	Difference	Status	Ins Paid ($)	Pur Cost ($)	Margin ($)	Margin %