TPA Data Reconciliation for Health Reinsurance: Break Guide
On this page
- Key Takeaways
- Where Do TPA Claims Data and Health Ceded Accounts Diverge?
- Which Breaks Appear Between TPA Data and Health Ceded Accounts?
- How Does a Worked TPA-to-Ceded-Account Bridge Add Up?
- Who Closes Each TPA Reconciliation Break?
- How Does Insurnest Support TPA Data Reconciliation for Health Reinsurance?
- Where Should a Head of Health Reinsurance Begin With TPA Data?
- Key Terms
- Sources
- Frequently Asked Questions
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.
| Stage | What it holds | What can change here |
|---|---|---|
| TPA claims system | Every claim with billed, approved and paid amounts, member and hospital | Status moves fast between pre-authorisation and discharge |
| Cedent claims register | Claims accepted by the insurer and booked | Direct reimbursement claims added; TPA fees separated |
| Claims bordereau | Claims on policies inside the treaty | Excluded schemes and out-of-period policies removed |
| Ceded account | Ceded share of paid and outstanding claims for the period | Cut-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.
| Break | Likely cause | Test | Fix |
|---|---|---|---|
| Paid after cut-off | TPA pays on the last day; cedent books next month | Compare TPA paid date with booking date | Move to next period's bridge |
| Policy outside the treaty | Scheme excluded, or policy incepted outside the treaty period | Match policy number to the ceded policy list | Remove from ceded claims |
| TPA fees in claim lines | Admin or processing fee added to the claim amount | Search for fee codes or flat amounts | Separate unless the treaty shares fees |
| Duplicate after reprocessing | Reopened claim given a new number | Match member, admission date and hospital | Keep one claim; reverse the other |
| Direct reimbursement | Member claimed from the cedent, not via the TPA | Cedent paid listing not in TPA data | Add to the bridge |
| Billed amount used | Hospital bill used instead of approved amount | Compare billed, approved and paid | Use the treaty's agreed amount |
| Pre-authorisation as outstanding | Open approval limit treated as a reserve | Outstanding equals pre-authorised amount | Apply the cedent's reserving policy |
| Status mismatch | TPA shows approved; cedent shows unpaid | Compare status and payment reference | Align status at cut-off |
| Two TPAs, one member | Member moved TPA mid-year | Match member ID across TPA files | Keep 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.
| Step | Amount at 100% |
|---|---|
| TPA paid listing for the quarter | 4,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 account | 4,610,000 |
| Paid claims in the ceded account | 4,630,000 |
| Unexplained residual | 20,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.
- Explained movement: 180,000 + 95,000 + 25,000 + 50,000 - 110,000 = 240,000. That takes 4,850,000 down to 4,610,000.
- Residual: 4,630,000 - 4,610,000 = 20,000 of paid claims in the account with no bridge item.
- 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.
| Break | Owner | Evidence to close |
|---|---|---|
| Duplicates and status errors | TPA | Corrected claim listing with reversal references |
| Cut-off and booking | Cedent finance | Payment dates and booking period per claim |
| Treaty scope | Cedent underwriting | Ceded policy and scheme list for the treaty period |
| Fees and amount basis | Cedent claims | Fee schedule and approved amounts |
| Ceded adjustment | Reinsurance accounting | Agreed 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
- Business Today: Health insurance: IRDAI sets 3-hour time limit for insurers to clear cashless claims (29 May 2024)
- Insurnest: Bordereaux Calculation and Reconciliation
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
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 →