Health and family

Partial claim settlement: matching the deduction letter to bills

Match each line of a partial settlement letter to the hospital bill, find the difference, and book the unpaid amount as your own medical cost.

Editorial illustration for Partial claim settlement: matching the deduction letter to bills

To understand a partial settlement, put the hospital bill and the settlement letter side by side and match them line by line. For each line, write the billed amount, the amount the insurer paid and the difference. The total difference is what you bear yourself, and it should be booked as your own medical cost.

What does the matching table look like?

Say a hospital's final bill has seven lines and the settlement letter shows what the insurer paid against each. All numbers below are hypothetical:

Bill lineBilledPaid by insurerDifferenceReason in the letter
Room rent, 5 days₹40,000₹32,000₹8,000Room category above entitlement
Surgeon and doctor fees₹60,000₹60,000₹0None
Operation theatre₹30,000₹30,000₹0None
Medicines₹22,000₹22,000₹0None
Consumables₹8,000₹0₹8,000Listed as non-payable
Diagnostics₹15,000₹15,000₹0None
Registration and admission kit₹5,000₹0₹5,000Listed as non-payable
Total₹1,80,000₹1,59,000₹21,000Sum of the lines above

Check the arithmetic. Billed: 40,000 plus 60,000 plus 30,000 plus 22,000 plus 8,000 plus 15,000 plus 5,000 is ₹1,80,000. Paid: 32,000 plus 60,000 plus 30,000 plus 22,000 plus 0 plus 15,000 plus 0 is ₹1,59,000. The gap is ₹21,000, which is also 8,000 plus 8,000 plus 5,000.

Where does the difference go in my books?

It is your medical cost. The bill is a ₹1,80,000 expense, the insurer's payment is a ₹1,59,000 credit against it, and what remains is ₹21,000. In a ledger you can show this in two ways, and either works if you stay consistent:

  • Record the full ₹1,80,000 as medical expense, then record ₹1,59,000 as Claim received. The net shows ₹21,000.
  • Record only ₹21,000 as your medical cost and the insurer's share separately as a memo. This is neater, but you lose sight of the full bill.

What if the letter's numbers do not match my bill?

Look for the usual reasons before you assume a mistake: the letter may group several bill lines into one, round figures, apply a co-payment or deduct something already paid as a deposit. Add a column for each of these and put the figure there. If a line still does not reconcile, ask the insurer in writing for a breakup of that line.

How can I use this next time?

Copy the table into a sheet, with a total row using =SUM(B2:B8) and =SUM(C2:C8), and a difference column using =B2-C2. If a deduction repeats across claims, such as room rent, you will see it in the numbers and can plan for it when choosing a room. SpendixAI can keep the bill image and the letter with the transaction, and a custom category for medical costs makes the yearly total quick to read.

What if I only paid part of the bill myself?

Then the same table still works. In a cashless case the hospital collects the difference from you at discharge, so your payment receipt should equal the difference column, give or take a deposit adjustment. In a reimbursement case, the bank credit should equal the paid column. If either figure is off, you have found the line to ask about. Keep the three papers together: final bill, settlement letter and the receipt for what you paid.

Closing checks

  1. Total billed equals the total on the final bill.
  2. Total paid equals the amount in the settlement letter and the bank credit, if paid to you.
  3. Difference equals the sum of line differences.
  4. Each deduction has a reason noted, even if the reason is 'not stated'.
SPENDIXAI JOURNAL

Useful ideas start with a clearer picture of your own spending.

Explore your reports