Select your file formatsoptional — skip to auto-detect
📦 SUPPLIER FILE FORMAT
Auto-detect: the parser reads column names and figures out the format automatically.
Need a different format? Let us know and we'll add support for it.
🧾 BILLING FILE FORMAT
Auto-detect: the parser reads column names and figures out the format automatically.
Need a different format? Let us know and we'll add support for it.
📦
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
Ready to reconcile
Something went wrong reading your files
Double-check the file format matches what you selected above, or try Auto-detect if you picked a specific format. If this keeps happening, the Help Center has more on supported file types, or you can ask your admin directly.
A few columns need your help
We couldn't automatically figure out every column below. Pick the right one from each dropdown, or skip and fix it later in Preview.
RxAuditwise
Preview
Suppliers
Results
MFP
Final
Bill
Dollar
Discarded
Not Billed
Issues
Show / hide tabs
Date Range
→
About RxAuditwise
What this does
RxAuditwise reconciles pharmacy purchase data against dispensing/billing records at the NDC level, flagging each drug as OK, SHORT, or OVER so you can spot discrepancies fast.
How status is calculated
OK — quantity purchased matches quantity billed/dispensed
SHORT — more was billed/dispensed than was purchased
OVER — more was purchased than was billed/dispensed
Account details are managed by your administrator. Contact them to update pharmacy info, credentials, or license terms.
⚙️ Settings
Appearance
Darkens the top bar, sidebars, and background. Data tables stay light for readability.
Default landing tab
Choose which tab opens automatically after you upload and reconcile files.
Tabs
These preferences are saved in this browser only.
📖
Help Center
Everything you need to use RxAuditwise effectively
Getting Started
RxAuditwise reconciles what your pharmacy purchased from suppliers against what was billed/dispensed to insurers — at the individual NDC level — so you can quickly spot where the two don't line up.
The basic workflow
Upload your files — supplier purchase files (McKesson, ABC/AmerisourceBergen, Cardinal Health, Smith Drugs, Belco, Alpine Health, TRXADE, rxpost) and your billing/dispense export (RxReportPlus, NEW_DATA, or Invoice Details).
Check Preview — confirm each file's columns were read correctly. If a column was misread, remap it here — every other tab updates automatically.
Review Results — the main reconciliation view. Every NDC is flagged OK, OVER, or SHORT.
Drill into specialized views — Final for a clean variance summary, Bill for insurer-level totals, Dollar for cost vs. reimbursement, Issues for a focused list of what needs attention.
What OK / OVER / SHORT mean
OKQuantity purchased matches quantity billed/dispensed. No action needed.
OVERMore was purchased than billed — you may be holding excess stock. Consider a return or credit.
SHORTMore was billed than purchased — check for a missing purchase record or a needed reorder.
A note on package sizes
The billing file's package size is treated as authoritative. Toggle ÷PKG (top right of most tabs) to view quantities as whole packages instead of individual units — useful when you think in terms of boxes/bottles rather than units.
Tabs Guide
Each tab gives you a different lens on the same reconciled data.
👁
Preview
Raw contents of every uploaded file, exactly as read. Remap a column here if it was auto-detected incorrectly — the whole app re-reconciles instantly.
📦
Suppliers
Combined purchase data across all supplier files, one row per NDC, with per-file quantity breakdowns.
📊
Results
The main reconciliation table — every NDC, grouped by insurer, with a total row per NDC showing its overall OK/OVER/SHORT status. Hover any cell for full details; hover an NDC's row to highlight every other row sharing that NDC.
🔀
MFP
Manufacturer Fair Price — NDCs on the current MFP program list, filtered from the full Results set.
✅
Final
A clean variance summary: needed vs. ordered, by status, without the per-insurer row detail — good for a quick top-level view.
📄
Bill
Totals grouped by insurer/payer instead of by drug — see which insurer has the most OK/OVER/SHORT NDCs.
💲
Dollar
Reconciliation by dollar value instead of quantity — compares what you paid suppliers against what insurers reimbursed.
🗑️
Discarded
NDCs that were billed/dispensed but have no matching supplier purchase record at all.
⚠️
Not Billed
NDCs that were purchased from a supplier but never appear in your billing/dispense file.
❗
Issues
A focused, two-table view of only the SHORT and OVER items — the ones that actually need your attention, sortable independently of the full Results table.
Filtering
Every tab has its own set of filters suited to what it shows. Here's what's available across the app.
Dropdown filters
Insurer — narrow to a single payer. On Results, the row-level status is recalculated for that insurer specifically.
Drug Form — TAB, CAP, INJ, SOL, etc.
Brand — Brand-only, Generic-only, or All.
Ins Paid / Cost — filter to a dollar range (e.g. "$0", "$5,000+").
Quick status filters
The OK / Over / Short buttons at the top of most tabs instantly narrow the table to just that status — useful before the more granular column-level sort described in the Sorting section.
Search
Every tab has its own search box — type an NDC (with or without dashes) or part of a drug name. Search is instant as you type.
Non-NABP
Flags NDCs purchased from a wholesaler not on the NABP-accredited list. Click the Non-NABP button to isolate just those.
Sorting
There are two ways to sort any table — pick whichever is faster for what you need.
1. The Sort bar
Along the top of each tab: quick preset buttons like Name A→Z, Highest / Lowest, Most Filled, Most Purchased, or by NDC. One click, whole table reorders.
2. Per-column sort menu
Click the small filter icon next to any column header for options specific to that column:
Text columns (Description, NDC, Insurer) → A→Z / Z→A
Number columns (quantities, dollar amounts) → Highest→Lowest / Lowest→Highest
Status columns (Reconciliation, Status) → OK First / Over First / Short First — this sorts by what's actually shown in that specific column for each row, so if a drug has multiple insurers, each insurer's own row is sorted independently.
Reordering columns
Drag any column header left or right to reorder it. Use ↺ Cols (near the sort bar) to reset a tab back to its default column order.
Keyboard Shortcuts
Built for fast, mouse-free navigation through large reconciliation tables.
F1–F9Jump directly to a tab (F1=Preview, F2=Suppliers, F3=Results, F4=MFP, F5=Final, F6=Bill, F7=Dollar, F8=Discarded, F9=Not Billed)
Ctrl+FJump to the current tab's search box
Ctrl+HomeJump straight to the Results tab
↑↓←→Move between cells in the focused table
Tab / Shift+TabMove to next / previous cell
Ctrl+CCopy the focused NDC to your clipboard
Click an NDCAlso copies it directly — no need to select text first
EscClear the current cell focus
Contact Support
Didn't find what you needed? Reach out directly, or send a question below.
RxAuditwise