Content authored by practitioners with experience at Amazon India, Intuit QuickBooks, and the Tata Group. Meet the team →
TPA batch settlements aggregate 50-500 claims into a single bank credit with deductions for co-pay shortfalls, disallowances, and TDS under Section 194J at 10%.
Ingest TPA sidecar file, disaggregate batch credit by patient ID and claim reference, match to hospital billing system, classify variances as co-pay shortfall, disallowance, or TDS deduction.
19+ TPA-specific file formats, TDS 10% under 194J, settlement window 15-90 days, co-pay tolerance per scheme.
Per-claim settlement status, TDS receivable register for 26AS matching, disallowance analysis by TPA, revenue leakage report.
Most TPA settlement reconciliation processes in Indian hospitals stop at confirming the bank credit arrived. The harder step — unpacking the batch into individual claim settlements and matching each one to the hospital’s billing record — happens manually, often days later, and frequently with data that does not line up across systems.
What TPA Settlement Reconciliation Is
TPA settlement reconciliation is the process of matching each individual insurance claim settled by a Third Party Administrator against the hospital’s billing records and the corresponding bank credit. In India, TPAs process claims on behalf of insurance companies, bundling 50 to 500 individual patient claims into a single batch payment.
The hospital’s bank statement shows one credit entry for the entire batch. The claim-level detail — which patients were paid, how much was approved versus billed, and which claims were partially settled or rejected — exists only in the sidecar file that the TPA sends separately. Reconciliation requires merging these two data sources and matching them against the hospital information system (HIS) billing records.
How TPA Batch Settlement Matching Works
Parsing the Sidecar File
Each of India’s 19+ TPAs sends settlement files in a different format. Star Health TPA uses a multi-tab Excel workbook. Medi Assist sends CSV with pipe-separated fields. New India Assurance provides PDF-based settlement statements that require extraction before matching. The hospital’s reconciliation process must normalise these into a common structure before any matching can begin.
Matching Claims to Billing Records
Once parsed, each claim line in the sidecar file must match to a billing record in the HIS. The match keys vary: some TPAs use the hospital’s claim reference number, others use the insurance policy number, and some use a TPA-generated claim ID that the hospital must cross-reference. Mismatches arise when the TPA truncates reference numbers, when the HIS uses a different patient ID than the insurance ID, or when the claim was submitted under a different billing entity.
Handling Partial Settlements and Clawbacks
Not every claim is settled at the billed amount. TPAs apply sub-limits, co-pay deductions, and package rate caps that reduce the approved amount. These partial settlements create a variance between what the hospital billed and what the TPA paid. Clawbacks — where a TPA reverses a previously settled claim — appear as negative amounts in subsequent batch settlements. Both require separate tracking and follow-up workflows.
TPA Settlement Cycle Comparison
| TPA / Insurer | Avg. Settlement Days | File Format | Typical Batch Size |
|---|---|---|---|
| Star Health TPA | 21–30 | Multi-tab Excel | 100–300 claims |
| Medi Assist | 15–25 | CSV (pipe-separated) | 150–500 claims |
| New India Assurance | 30–60 | PDF + Excel summary | 50–200 claims |
| ICICI Lombard | 20–35 | Excel (single sheet) | 100–400 claims |
| Paramount Health Services | 25–45 | CSV (comma-separated) | 80–250 claims |
IRDAI Settlement Norms and Compliance Context
IRDAI’s guidelines on TPA operations mandate specific timelines for claim processing. Under the IRDAI (Health Insurance) Regulations, cashless claims must receive initial authorisation within 1 hour of request, and final settlement must occur within 30 days of discharge. Reimbursement claims carry a 30-day processing window from the date of submission of all required documents. Delays beyond these timelines expose the insurer to interest penalties.
For hospitals, the compliance obligation is on the receivable side: ageing analysis of unsettled claims, provisioning for disputed amounts, and TDS treatment on corporate health checkup revenue under Section 194J at 10%. Each of these requires that the TPA settlement has been reconciled at the claim level — aggregate bank credit confirmation is insufficient.
Hospitals managing TPA settlements across multiple insurers benefit from reconciliation software India that can parse different file formats and normalise claim data into a common matching structure. The batch settlement pattern is structurally similar to payment gateway reconciliation, where a single bank credit must be unpacked into individual transaction-level detail.
The full regulatory framework for TPA operations and claim settlement timelines is published by IRDAI, the authority governing insurance intermediaries in India.
For related guidance, see cashless claim settlement reconciliation for the preauthorisation-to-settlement workflow, healthcare reconciliation for the full hospital revenue cycle, and exception management in reconciliation for building structured exception queues for disputed TPA claims.
The five most common questions about TPA settlement reconciliation in Indian hospitals are answered below.