Five Claims Data Checks Before a Self-Funded Renewal
The renewal meeting is approaching, and your claims report shows one large annual total. But which dates does that number cover? Does it include pharmacy spending? Were late claims left out? For plan sponsors, healthcare claims data analytics becomes useful only after those questions have answers. We suggest auditing the input before treating a trend line as a renewal forecast. The aim is a comparison that the finance lead and third-party administrator (TPA) can defend.
First Check the Reporting Window
Ask the TPA for both the service-date range and the paid-date range. A claim for treatment delivered in December may be paid in February. A report of claims paid during the calendar year therefore differs from one organized by services incurred that year. The mistake is treating these views as equivalent.
Record the extract date, the last payment date included and the claims runout allowed after the experience period. If the prior-year report was prepared three months after year-end but this year's file arrived after only two weeks, the newer total will likely be less complete. Request updated runout before interpreting that gap as improvement.
Ask What Is Missing From the File
An impressive dashboard can hide gaps in the source files. Medical claims and pharmacy claims may arrive from different vendors, while carved-out services might never reach the standard TPA feed. Reversed claims can also appear beside their replacements. Use this short file-quality check when requesting a renewal extract:
| Field or feed | Question for the TPA | Risk if missing |
|---|---|---|
| Medical and pharmacy | Are both feeds included through the same cutoff? | Incomplete spending picture |
| Reversals and duplicates | How are corrected or voided claims handled? | Double-counted payments |
| Eligibility counts | Which enrolled members match each period? | Misleading per-member trends |
| Service and paid dates | Are both available and consistently defined? | Incomparable periods |
| Vendor carve-outs | Which benefits sit outside this file? | Unseen utilization or costs |
Request a written data dictionary as well. Field names such as “paid” or “net” mean little unless the parties agree on their definitions. Identify missing streams explicitly rather than guessing at their value.
Separate Spending From Recoveries
Before comparing costs, decide which financial measure answers the question. An allowed amount generally reflects the negotiated or otherwise recognized charge. Plan-paid spending is different from the member's share, and a TPA report may show gross payments before later adjustments. Subtracting cost sharing twice can make the result look better than it is.
Stop-loss reimbursements, when applicable, also need their own line. They may arrive in a different reporting period from the underlying large claim. Ask whether the analysis presents gross plan claims, subsequent recoveries and net financial exposure separately. Consistent definitions matter more than unsupported savings percentages.
Apply HIPAA Boundaries Before Segmenting Results
More detailed records are not automatically better records for every recipient. A plan sponsor may need information for lawful plan-administration functions, but that does not give the employer's hiring or supervisory teams access to identifiable diagnoses. HHS describes privacy limits for plan sponsors that include separation of plan administration from employment decisions under applicable conditions.
Ask what will be aggregated or de-identified before reports circulate. Very small groups, unusual diagnoses or combinations of demographic fields can raise re-identification concerns; have privacy counsel or the responsible plan administrator approve the approach. Privacy requirements and intended use both matter. Do not download employee-level health records simply because a reporting platform makes them technically available.
CMS outlines rules on access to de-identified claims data under the federal gag-clause restrictions. Those protections do not erase privacy obligations or guarantee an instant, unrestricted file delivery from every vendor. Clarify the request process, permitted recipients and formatting in advance.
Turn the Audit Into Five Renewal Questions
Once the file is understood, the sponsor can conduct a focused conversation with its TPA rather than debating a headline number. Put these questions in the renewal packet and ask for written answers:
- What reporting cutoff and runout period were used for each comparison year?
- Which medical, pharmacy and carved-out claims are absent, and why?
- Are allowed amounts, plan payments and stop-loss recoveries displayed separately?
- Who may receive which data fields under the plan documents and privacy rules?
- How were member counts, large claims and year-over-year changes normalized?
If any answer remains unresolved, label that portion of the forecast as provisional. Request a corrected extract before accepting the renewal recommendation. When diagnostic uncertainty in employee care enters the discussion, claims patterns may prompt questions, but they cannot substitute for clinical review.
At Self Funding Magazine, we see the best first step as a simple one: agree on what the numbers represent before negotiating what they might mean. Reliable analysis begins with a verifiable file, not a more elaborate chart.
