Reinsurance

TPA Data Reconciliation for Health Reinsurance: Break Guide

On this page

Last reviewed: November 2026

The reinsurer's auditor asks why the health quota share shows 4.63m of paid claims when the TPA's listing says 4.85m.

Finance blames the TPA, and the TPA says its file is right. Both may be, and nobody has written the bridge between them.

TPA data reconciliation for health reinsurance is matching a third party administrator's claims data with the claims a cedent cedes in its reinsurance accounts.

Solving it means a standing bridge: known breaks listed in order, each with a test, an owner and evidence, so only the true residual needs investigation.

Key Takeaways

  • The TPA file and the ceded account answer different questions. One tracks medical claims; the other follows treaty and accounting rules.
  • Most differences are explainable. Cut-off, treaty scope, fees, duplicates and direct payments cover most of the gap.
  • Pre-authorisation is not a reserve. It is an approval limit that changes at discharge.
  • Build the bridge in a fixed order. The same steps each quarter make the residual meaningful.
  • Close breaks at the source. The owner of each difference should fix it, not the reconciler.

Where Do TPA Claims Data and Health Ceded Accounts Diverge?

TPA claims data and health ceded accounts diverge at each hand-off between the TPA's system and the reinsurance account.

StageWhat it holdsWhat can change here
TPA claims systemEvery claim with billed, approved and paid amounts, member and hospitalStatus moves fast between pre-authorisation and discharge
Cedent claims registerClaims accepted by the insurer and bookedDirect reimbursement claims added; TPA fees separated
Claims bordereauClaims on policies inside the treatyExcluded schemes and out-of-period policies removed
Ceded accountCeded share of paid and outstanding claims for the periodCut-off applied; treaty share calculated

In India, IRDAI's May 2024 master circular requires final authorisation within three hours of a hospital's discharge request, as Business Today reported.

Amounts can therefore change within hours of a snapshot. Timing rules differ by market.

Which Breaks Appear Between TPA Data and Health Ceded Accounts?

The breaks that appear between TPA data and health ceded accounts fall into nine common types. Each needs its own test.

BreakLikely causeTestFix
Paid after cut-offTPA pays on the last day; cedent books next monthCompare TPA paid date with booking dateMove to next period's bridge
Policy outside the treatyScheme excluded, or policy incepted outside the treaty periodMatch policy number to the ceded policy listRemove from ceded claims
TPA fees in claim linesAdmin or processing fee added to the claim amountSearch for fee codes or flat amountsSeparate unless the treaty shares fees
Duplicate after reprocessingReopened claim given a new numberMatch member, admission date and hospitalKeep one claim; reverse the other
Direct reimbursementMember claimed from the cedent, not via the TPACedent paid listing not in TPA dataAdd to the bridge
Billed amount usedHospital bill used instead of approved amountCompare billed, approved and paidUse the treaty's agreed amount
Pre-authorisation as outstandingOpen approval limit treated as a reserveOutstanding equals pre-authorised amountApply the cedent's reserving policy
Status mismatchTPA shows approved; cedent shows unpaidCompare status and payment referenceAlign status at cut-off
Two TPAs, one memberMember moved TPA mid-yearMatch member ID across TPA filesKeep claims with the TPA that paid

Our guide to health quota share administration covers how the ceded share itself is set up.

Why should pre-authorisation amounts stay out of ceded outstanding claims?

Pre-authorisation amounts should stay out of ceded outstanding claims because they are approval limits, not loss estimates.

The final authorised amount at discharge may be lower, if treatment was shorter, or higher, if complications arose.

Ceding the pre-authorised amount overstates or understates outstanding claims until discharge. The cedent's reserving policy should set the figure.

Take an illustrative case: 60 open claims carry 900,000 of pre-authorisation. The cedent's policy, based on its own closed claims, reserves them at 85%.

The outstanding figure is then 765,000, and the 50% ceded share is 382,500. Ceding the pre-authorised amounts would give 450,000, overstating it by 67,500.

Which TPA fields make the health reinsurance bridge possible?

The TPA fields that make the health reinsurance bridge possible are the ones that link a claim to a policy, a period and a payment.

  • Member ID and policy or scheme number. These test treaty scope and catch members who changed TPA.
  • Claim number with a parent claim reference. This links reprocessed claims to the original.
  • Admission and discharge dates. These match duplicates and set the period of loss.
  • Billed, approved and paid amounts. All three, not one, so the amount basis can be checked.
  • Payment date, reference and status. These drive cut-off and status matching.
  • Fee code. This separates administration charges from medical costs.

Ask for these fields in the TPA service agreement. Adding them after a dispute is much harder.

How Does a Worked TPA-to-Ceded-Account Bridge Add Up?

A worked TPA-to-ceded-account bridge adds up by moving from the TPA paid listing to the expected ceded figure in fixed steps.

This quarterly example is illustrative, on a 50% health quota share.

StepAmount at 100%
TPA paid listing for the quarter4,850,000
Less: paid by TPA after the cedent's cut-off-180,000
Less: claims on schemes outside the treaty-95,000
Less: TPA admin fees in claim lines-25,000
Plus: reimbursement claims paid directly by the cedent+110,000
Less: duplicates from reprocessed claims-50,000
Expected paid claims for the ceded account4,610,000
Paid claims in the ceded account4,630,000
Unexplained residual20,000

What does the TPA bridge tell the reinsurer?

The TPA bridge tells the reinsurer that 240,000 of the gap is explained and 20,000 is not.

  1. Explained movement: 180,000 + 95,000 + 25,000 + 50,000 - 110,000 = 240,000. That takes 4,850,000 down to 4,610,000.
  2. Residual: 4,630,000 - 4,610,000 = 20,000 of paid claims in the account with no bridge item.
  3. Reinsurer effect: at 50%, expected ceded claims are 2,305,000 against 2,315,000 in the account, a 10,000 difference.

The residual is small, but the direction matters. Ceded claims exceed what the TPA data supports, so the reinsurer should ask for the claim-level list.

The 180,000 timing item should appear in next quarter's bridge as an addition. If it does not, it was lost, not delayed.

Who Closes Each TPA Reconciliation Break?

Each TPA reconciliation break is closed by the team that owns its source, with evidence the reinsurer can test.

BreakOwnerEvidence to close
Duplicates and status errorsTPACorrected claim listing with reversal references
Cut-off and bookingCedent financePayment dates and booking period per claim
Treaty scopeCedent underwritingCeded policy and scheme list for the treaty period
Fees and amount basisCedent claimsFee schedule and approved amounts
Ceded adjustmentReinsurance accountingAgreed adjustment in the next account

Timing items need ageing. A cut-off break older than one quarter is no longer a timing difference.

Claims data that arrives late makes every bridge harder. See claims bordereaux lag for that problem.

How Does Insurnest Support TPA Data Reconciliation for Health Reinsurance?

Insurnest Bordereaux Calculation and Reconciliation supports the ceded side of this work.

It maintains participation percentages, allocates premium and claims by reinsurer share and calculates each reinsurer's net position.

It compares calculated values with bordereaux, master data, claim and premium registers and settlement records.

Mismatches show in one view with reinsurer-wise status.

Bridging raw TPA files, checking input formats and finding root causes stay with your teams and the TPA.

A clean reinsurance claims ledger makes the claim-level side of the bridge easier to evidence.

Where Should a Head of Health Reinsurance Begin With TPA Data?

A head of health reinsurance should begin with TPA data by writing down last quarter's bridge and seeing how much of it was guesswork.

  • Fix the bridge order. Use the same steps every quarter, so residuals can be compared.
  • Agree the amount basis. Confirm with the reinsurer whether billed, approved or paid amounts are ceded.
  • List excluded schemes. Give the TPA the treaty's ceded policy list each period.
  • Track timing items forward. Check that each cut-off item lands in the next bridge.

Key Terms

  • Third party administrator (TPA): A firm that processes health claims for an insurer.
  • Pre-authorisation: Approval for planned or emergency treatment up to a set amount.
  • Approved amount: The claim amount accepted after policy terms, limits and tariffs.
  • Unexplained residual: The difference left after all known bridge items are applied.
  • Cut-off: The date that decides which period a payment belongs to. See bordereaux cut-off dates.

Sources

Frequently Asked Questions

What is TPA data reconciliation for health reinsurance?

TPA data reconciliation for health reinsurance is matching the claims data a third party administrator holds with the claims a cedent cedes in its reinsurance accounts. Each difference is explained, such as timing, policies outside the treaty, fees, duplicates or claims paid outside the TPA.

Why do TPA claims data and ceded accounts differ?

TPA claims data and ceded accounts differ because they are built for different purposes at different dates. The TPA records medical claims as they are approved and paid, while the ceded account follows the cedent's accounting cut-off, treaty scope and booking rules.

Should pre-authorisation amounts be ceded as outstanding claims?

Pre-authorisation amounts should not be ceded as outstanding claims without an agreed rule. A pre-authorisation is an approval limit for treatment, not a loss estimate, and the final authorised amount at discharge can be higher or lower. The cedent's reserving policy should decide the outstanding figure.

Are TPA fees part of health reinsurance claims?

TPA fees are usually an administration cost rather than part of health reinsurance claims, but the treaty wording decides. If fees are embedded in claim lines from the TPA, they need to be separated before ceded claims are calculated, or reinsurers pay for expenses they did not agree to share.

How do you reconcile TPA claims data with ceded accounts?

To reconcile TPA claims data with ceded accounts, start from the TPA paid listing, remove claims paid after cut-off, on policies outside the treaty and duplicates, strip out fees, add claims paid outside the TPA, then compare the result with the ceded account and investigate the residual.

What is the difference between billed, approved and paid health claims?

The difference between billed, approved and paid health claims is the stage of the amount. Billed is what the hospital charged, approved is what the TPA accepted after policy terms and tariffs, and paid is what was actually settled. Ceded claims should use the treaty's agreed amount.

Who should close TPA reconciliation breaks?

TPA reconciliation breaks should be closed by whoever owns the source of the difference. The TPA fixes duplicates and status errors, cedent finance fixes cut-off and booking, underwriting confirms treaty scope, and reinsurance accounting agrees the final ceded adjustment.

Does Insurnest reconcile TPA data for health reinsurance?

Insurnest supports part of TPA data reconciliation for health reinsurance. Insurnest Bordereaux Calculation and Reconciliation allocates premium and claims by reinsurer share and compares calculated values with bordereaux, registers and settlement records, while teams still bridge raw TPA data and find root causes.

Hitul Mistry

Hitul Mistry

CEO, Insurnest

An InsurTech leader with more than a decade of experience across insurance and technology, focused on solving business problems with the help of technology. Has worked with brokers, insurance carriers, and reinsurance firms across the India, UAE, and US markets.

View LinkedIn profile →
ShareLinkedInX

Read our latest blogs and research

Featured Resources

Reinsurance

Health Quota Share Administration: Accurate Medical Cessions

Health quota share administration mistakes that distort high-volume medical cessions, what each one costs, how to fix it, and a monthly routine to stop repeats.

Read more
Reinsurance

Claims Bordereaux Lag: Building Earlier Reserve and Cash Forecasts

Claims bordereaux lag delays reserving and cash forecasting. Learn how reinsurers can build earlier reserve estimates and liquidity forecasts despite incomplete and late-arriving claims data.

Read more
Reinsurance

Reinsurance Claims Ledger: Track Every Claim Movement

A reinsurance claims ledger records every paid, outstanding and adjusted amount as its own movement. Learn the structure, split chain and controls that matter.

Read more

Meet Our Innovators:

We aim to revolutionize how businesses operate through digital technology driving industry growth and positioning ourselves as global leaders.

circle basecircle base
Pioneering Digital Solutions in Insurance

Insurnest

Empowering insurers, re-insurers, and brokers to excel with innovative technology.

Insurnest specializes in digital solutions for the insurance sector, helping insurers, re-insurers, and brokers enhance operations and customer experiences with cutting-edge technology. Our deep industry expertise enables us to address unique challenges and drive competitiveness in a dynamic market.

Get in Touch with us

Ready to transform your business? Contact us now!

We respond within one business day.