RxAuditwise — Pharmacy Reconciliation v4.2

RxAuditwise

Pharmacy Purchase Reconciliation · v4.2

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 files here or browse
CSV, XLSX, XLS, TSV · McKesson, ABC, Smith Drugs, Belco & more

🧾

Billing Files

Drop files here or browse
Rx dispense data — NDC, insurer, BIN · multiple files OK

SR#	DESCRIPTION	NDC	PKG SIZE	RX INS NAME	RX INS BIN	FILLED QTY	PURCHASED QTY	DIFFERENCE	STATUS	INS PAID ($)	SUPPLY COST ($)

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 dollar analysis.

🗑️

Run reconciliation to see discarded NDCs.

⚠️

Run reconciliation to see issues.

⚠️

Run reconciliation to see unbilled NDCs.

Sr#	Description	NDC	Package Size	Rx Ins Name	Rx Ins BIN	Rx Qty Filled Total	Purchase Quantity	Difference	Status	INS PAID ($)	SUPPLY COST ($)