Health and family

Out-of-pocket versus reimbursed medical spend: an annual view

Build a year-end table of gross medical spend, reimbursements and net cost, using a sample household's twelve months to find the out-of-pocket figure.

Editorial illustration for Out-of-pocket versus reimbursed medical spend: an annual view

To know how much your household really spent on health in a year, build a table with three figures per month: the gross medical spend, the reimbursements that came back, and the net cost, which is gross minus reimbursed. The net total is your true out-of-pocket medical cost, and it can look very different from the sum of all your bills.

Why does gross spend mislead you?

A year of bills may total a large number, but some of it came back through an employer wallet, an insurer or a flexible-benefit claim. If you look only at payments, you overstate your cost. If you look only at reimbursements, you may forget the part that never came back. Both views belong in the same table.

What does a sample household's year look like?

The numbers below are invented to show the method. Reimbursements are placed in the month the money arrived, not the month the bill was paid, because that is how your bank shows them.

MonthGross spendReimbursedNet cost
April₹3,200₹0₹3,200
May₹1,800₹2,500-₹700
June₹950₹0₹950
July₹14,500₹0₹14,500
August₹2,100₹11,000-₹8,900
September₹600₹1,500-₹900
Remaining six months₹9,400₹4,000₹5,400
Total₹32,550₹19,000₹13,550

Check the arithmetic: gross is 3,200 + 1,800 + 950 + 14,500 + 2,100 + 600 + 9,400 = ₹32,550. Reimbursed is 2,500 + 11,000 + 1,500 + 4,000 = ₹19,000. Net is 32,550 - 19,000 = ₹13,550. In this example the household spent ₹32,550 but its own cost was ₹13,550.

What should you do about the timing difference?

A bill paid in July and reimbursed in August makes July look expensive and August look cheap, as the negative net numbers show. That is fine in a monthly view. For the yearly figure it does not matter, but if a reimbursement is still pending on 31 March, it will fall into the next year. Add a line for Pending reimbursements at year end, so you know that part of the net cost may still come back.

How do you collect the numbers?

  • Gross spend: filter your payments by a health category, for the April to March year
  • Reimbursements: note each credit from an employer or insurer, with its date and claim reference
  • Pending: list claims submitted and not yet paid
  • Not claimed: list bills you decided not to claim, with the reason, so they are not mistaken for lost money

You can also turn the table into a simple formula in a sheet. If gross spend is in column B and reimbursed amounts in column C from row 2 to row 13, the net cost for the year is =SUM(B2:B13)-SUM(C2:C13), and the share of your gross spend that came back is =SUM(C2:C13)/SUM(B2:B13). Format the second cell as a percentage. With the sample numbers, 19,000 divided by 32,550 is roughly 0.58, so about 58 percent came back and the rest stayed with the household.

How does SpendixAI help produce the view?

SpendixAI lets you create a health category with sub-categories, import statements, and use its Report builder to filter and group your transactions by month, then download a CSV. Reimbursement credits that arrive in your account can sit under their own category, so the net view is a matter of comparing two totals. Treat any figure as an estimate and check it against your own bills.

A year-end checklist

  1. Total gross medical spend for the year
  2. Total reimbursements received, with dates
  3. Claims still pending, with expected dates
  4. Net out-of-pocket figure, and the share it forms of the gross
  5. One sentence on what surprised you, to guide next year's planning
SPENDIXAI JOURNAL

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

Explore your reports