What is Data Reconciliation

Data Reconciliation Definition

Data Reconciliation is the "Final Audit" in the Provider-Payer relationship. For Health System Executives, reconciliation ensures that the "Roster" they sent to the payer is actually what appears in the "Public Directory" and the "Claims Engine." Discrepancies here lead to "Financial Leakage," where providers who should be in-network are being paid at out-of-network rates. For Payer Ops, reconciliation is a mandatory compliance step; they must reconcile their internal database with external "Sources of Truth" like the OIG Exclusion List or state licensing boards on a regular cadence. High-performing organizations automate this process, generating "Exception Reports" that highlight only the records that do not match, allowing staff to focus their manual effort on fixing specific errors rather than reviewing 100% of the data.

FAQs

What is a "Roster Reconciliation" project?

It is a periodic effort where a large medical group and a health plan compare their lists of active providers, locations, and specialties to "sync up" their systems.

How does reconciliation support "No Surprises Act" compliance?

It allows plans to catch "Ghost Providers" (those who moved or retired) by comparing their directory against "Claims Activity"—if a provider hasn't billed in 12 months, they are flagged for reconciliation.

Why is "Tax ID" (TIN) reconciliation critical for finance?

If the TIN on the provider's record doesn't match the IRS's record for that entity, it triggers "1099 Mismatches" and potential tax penalties for the payer.