Distributor feeds
Automated commercial
data reconciliation
Mage connects distributor feeds, learns your product and account mappings, and prepares reconciled commercial data with unresolved records kept visible.
HCO accounts
NDC mappings
Match NDCs
Reconcile vials
Check gaps
Publish data
Review gaps
Channel reconciliation
Weekly reporting
Included vials
1,950
Held vials
50
| Account group | Included | Held |
|---|---|---|
| Hospital accounts | 1,170 | 30 |
| Community practices | 780 | 20 |
Feeds A + B · C late, excluded
IncludedExceptionsSource basis
From distributor records to reporting data you can trace
Match source product codes and healthcare accounts, reconcile net vials, and keep disputed records separate from included totals.
Distributor A · A-1042
SKU-01
Account A-087
Distributor B · B-2031
SKU-77
Account B-142
Mapping v07
Matched product & account
NDC-01
Package unitVial
Healthcare accountHCO-1042
Account groupHospital
One product and account identity
Resolve distributor codes to a package NDC and healthcare account without merging strengths, mixing units or multiplying sales rows.
Gross vials2,200
Returns−200
Candidate net2,000
Included vials
1,950
Held vials
50
Included and unresolved units
Deduct returns from sales, then separate unmatched records so unresolved vials stay outside the reporting dataset.
Source register
Cutoff · 08:00 ET
ARevision 03Included
BRevision 02Included
CLate arrivalExcluded
NDC-01 · mapping v07
2 of 3 feeds included
The source basis retained
Keep feed revisions and cutoff decisions alongside the dataset so late files remain visible and corrections can be traced.
Measure the work behind each reconciled refresh
Less recurring
file preparation
Measure collection, matching and reconciliation effort at the same product scope and source quality.
Data ready
for reporting
Track elapsed time from the agreed source cutoff to the dataset and exception register being prepared.
Unresolved work
kept visible
Track unmatched NDCs, account conflicts and late feeds against the expected source population.
How Mage fits
Connect channel records to your reporting data
Use authorized distributor feeds, product masters and HCO crosswalks to prepare matched datasets and mapping exceptions.
Your systems
Distributor feeds
Transaction IDs, resales and returns
Product and HCO records
Package NDCs and account crosswalks
Accepted mapping rules
Units, revisions and source cutoffs
The workflow between your tools
- 1Match product and account IDs
- 2Reconcile net vials
- 3Separate and deliver records
Your teams & tools
Included dataset
Matched channel rows for reporting
Exception register
Unresolved identities and units
Source basis
Feed and mapping revisions
Your data owners approve mappings and resolve disputed records.
Your commercial data, reconciled for the next refresh
A matched dataset and reconciliation workbook, with held records and source revisions ready for your team to review.
Explore industry solutionsChannel sales
HCO records
Mapping rules
NDC mapping
Metric rules
Channel reconciliation
Single NDC · Weekly reporting
Included vials
1,950
Held vials
50
| Account group | Included | Held |
|---|---|---|
| Hospital accounts | 1,170 | 30 |
| Community practices | 780 | 20 |
Feeds A + B · C late, excludedMapping v07 · source r03 · 50 vials await mapping review
IncludedExceptionsSource basis
Learn
Define the data scope
Agree package NDCs, account IDs and the source feeds to include.
Design
Set reconciliation rules
Define return handling, mapping reviews and source cutoff rules.
Automate
Launch recurring refreshes
Validate one closed cycle, then deliver datasets and exceptions.
Automate your commercial data reconciliation
Tell us which distributor feeds, product codes and healthcare account mappings your team needs to reconcile.