Blog

Use last year's EOBs to forecast next year's health costs (worksheet)

A worksheet that turns a year of EOBs and pharmacy receipts into a spending forecast you can run through two candidate plans, with a filled-in example.

Every explanation of benefits (EOB) you received this year is a record of what care you actually used and what it was worth under your plan's negotiated prices. That makes the pile of EOBs the best raw material you have for choosing next year's plan, better than any average. This worksheet shows how to turn it into a forecast in about an hour, and how to run that forecast through two plans so the choice rests on arithmetic instead of a guess.

Everything below uses invented numbers for a made-up reader named Priya, 41, single, covered by a plan with a calendar-year deductible. The dollar amounts are illustrations, not prices, and the two plans are not real products.

What you need before you start

Gather four things.

  1. Every EOB for the year. Your insurer's website or app usually keeps them for at least a year, and many let you download a claims history. An explanation of benefits is not a bill. It is the insurer's statement of what the provider charged, what the plan allowed, what it paid and what you owe. If one is missing, the claims history shows the same lines.
  2. Pharmacy receipts or a pharmacy history. Prescriptions often do not appear on medical EOBs. Your pharmacy or plan portal can print a year of fills with the amount you paid.
  3. Bills that never got an EOB. Dental, vision and any care you paid for in cash fall outside the claims history, so list them separately.
  4. Your current plan's numbers. Premium, deductible, coinsurance and the out-of-pocket maximum, so you can sanity-check your own totals.

If you want a refresher on reading the columns, the guide How to read an explanation of benefits (EOB) line by line walks through one line by line. For this worksheet you only need two columns from each EOB: the allowed amount and what you paid.

Why the allowed amount, not the billed amount

A hospital might bill $1,200 for a visit and your plan's contract price for that service might be $300. The $300 is the allowed amount. Your deductible and coinsurance are calculated on it, so it is the number that tells you how a different plan would treat the same visit. The billed amount is a sticker price that mostly tells you about the provider's list of charges.

If you used out-of-network care last year, flag those lines. Their allowed amounts followed different rules, and a plan with a different network may treat them differently next year.

Step 1: sort every claim into categories

Make one line per category and add up the allowed amounts. Categories that work for most people:

  • Preventive care (annual checkup, screenings, vaccines)
  • Primary care sick visits
  • Specialist visits
  • Labs and imaging
  • Therapy (physical therapy, mental health, other recurring visits)
  • Urgent care and emergency care
  • Prescriptions
  • Surgery, hospital stays and other one-time events
  • Dental, vision and anything else outside the plan

Priya's year, in allowed amounts, all in-network:

Category What happened Allowed total
Preventive One annual checkup, covered at no cost $300
Primary care sick visits 3 visits at $150 $450
Specialist 2 dermatology visits at $200 $400
Labs Routine blood work $350
Physical therapy 8 sessions at $120 $960
Urgent care 1 visit $250
Prescriptions One generic, 12 fills at $20 $240
One-time event Ankle fracture: ER visit, cast, orthopedic follow-ups $3,600

The preventive line is listed so the picture is complete, but she will treat it as $0 in the plan math, because non-grandfathered plans cover most recommended preventive services without cost sharing. Her total of everything except preventive care is $6,250. Add it: $450 plus $400 is $850; plus $350 is $1,200; plus $960 is $2,160; plus $250 is $2,410; plus $240 is $2,650; plus $3,600 is $6,250.

Step 2: separate the repeating from the one-time

This is the step that most often goes wrong. A forecast built on last year's total treats a broken ankle as if it were a hobby. Draw a line between two groups.

  • Recurring care: things that will probably happen again at a similar rate, such as maintenance prescriptions, regular therapy, routine specialist follow-up and the usual cold-season visits.
  • One-time events: a surgery, a delivery, an ER visit after an accident, a hospital stay. These can still happen next year, but not at the same time or size, and you should not assume zero or a repeat.

For Priya, the recurring group is everything except the ankle: $2,650. The one-time event is $3,600. Keep the two numbers apart, because you will use them separately in step 5.

Step 3: adjust for what you already know about next year

Last year is a starting point. Now change each line for anything you can foresee.

  • Treatment finished or starting. If a course of therapy ended, remove it. If a doctor has told you to expect a new test or a new medication, add it.
  • A pregnancy, planned surgery or other scheduled care. Add the realistic cost, and see what is the most my family of four could pay in a bad year on each plan? for how a high-cost year plays out against an out-of-pocket maximum.
  • Changes in who is covered. A new baby, a spouse joining or leaving, or a child aging off a parent's plan changes the total.
  • Drugs. Look each prescription up in the new plan's formulary. A drug can sit on a different tier, need prior approval or be excluded, and the monthly price can change even if the plan name does not.
  • Doctors. If a doctor you see regularly is not in a candidate plan's network, that plan's forecast is wrong until you decide what you will do about it.

Priya's adjustments: her therapist says six more sessions will be enough, so physical therapy drops from 8 sessions to 6 (6 times $120 is $720, a change of minus $240). Her doctor added a second generic at $15 a month, which adds 12 times $15, or $180. Her adjusted recurring total is $2,650 minus $240 plus $180, which is $2,590.

Step 4: write down two candidate plans

Pull the numbers from each plan's Summary of Benefits and Coverage, and from the out-of-pocket maximum listed there. You need five figures per plan: yearly premium (monthly times 12), deductible, coinsurance percentage, out-of-pocket maximum, and what the plan does with copays. To keep this example small, Priya's plans use only a deductible and coinsurance, with no copays. Real plans often mix copays in, so use your own plan's rules where they differ.

Plan A Plan B
Monthly premium $320 $160
Yearly premium $3,840 $1,920
Deductible $500 $3,000
Coinsurance (you pay) 20% 20%
Out-of-pocket maximum $4,000 $7,000

Both out-of-pocket maximums sit under the federal cap for marketplace plans in plan year 2027, which is $12,000 for one person, so neither plan breaks that ceiling. Employer plans have their own limits. For a refresher on how the pieces fit, see Higher premium or higher deductible? How to find the break-even.

Step 5: run each scenario through each plan

The formula for one person, when charges fall between the deductible and the out-of-pocket maximum, is:

Your cost = deductible + coinsurance percentage x (allowed charges - deductible)

If allowed charges are below the deductible, you pay all of them. If your cost would exceed the out-of-pocket maximum, you pay the maximum. Then add the yearly premium. Three scenarios give you a range.

Scenario 1: a quiet year (recurring care only, $2,590 allowed).

  • Plan A: $500 deductible, then 20% of the $2,090 left, which is $418. Cost of care $918. Add premium $3,840. Total $4,758.
  • Plan B: $2,590 is under the $3,000 deductible, so Priya pays all $2,590. Add premium $1,920. Total $4,510.

Plan B is cheaper by $248.

Scenario 2: a repeat of last year (recurring care plus a $3,600 one-time event, $6,190 allowed).

  • Plan A: $500, then 20% of $5,690, which is $1,138. Cost of care $1,638. Add premium $3,840. Total $5,478.
  • Plan B: $3,000, then 20% of $3,190, which is $638. Cost of care $3,638. Add premium $1,920. Total $5,558.

Now Plan A is cheaper by $80.

Scenario 3: a very bad year ($40,000 allowed).

  • Plan A reaches its $4,000 out-of-pocket maximum. Add premium $3,840. Total $7,840.
  • Plan B reaches its $7,000 maximum. Add premium $1,920. Total $8,920.

Plan A is cheaper by $1,080.

Step 6: find the crossover and decide how much weight to give it

The totals above hide a useful number: the level of allowed charges at which the plans cost the same. Below the deductible, Plan B's total is $1,920 plus the charges. Plan A's total is $3,840 plus $500 plus 20% of the charges over $500, which simplifies to $4,240 plus 20% of the charges. Setting them equal: $1,920 plus X equals $4,240 plus 0.2X, so 0.8X equals $2,320 and X is $2,900. Check it: at $2,900 of charges Plan B costs $4,820 and Plan A costs $4,240 plus $580, also $4,820.

So Plan B costs less when the year's allowed charges stay under $2,900. Above $2,900, Plan A costs less, by $80 once charges pass $3,000, and the gap widens in a bad year. Priya's expected year, $2,590, sits just under the crossover, which is why the answer flips between her scenarios. That is the honest result: the two plans are close, and the decision depends on how she weighs a quiet year against the risk of an expensive one. The tool health plan comparison calculator runs the same math for any pair of plans.

When the crossover sits well above or well below your expected spending, the decision is easier. When it sits close to it, as here, other factors carry more weight: whether you could pay a $3,000 deductible from savings, whether an HSA is available, whether your doctors are in each network, and how you feel about volatility.

Your blank worksheet

Copy this into a notes app or a sheet and fill it in.

  1. Recurring allowed charges from my EOBs and pharmacy history: $______
  2. Adjustments for known changes (plus or minus): $______
  3. Adjusted recurring total: $______
  4. One-time events last year, and my best guess at a repeat: $______
  5. Scenario totals: quiet (line 3) $______; repeat (line 3 plus line 4) $______; severe (use the out-of-pocket maximum) $______
  6. For each plan: yearly premium $______; deductible $______; coinsurance ____%; out-of-pocket maximum $______
  7. Plan cost in each scenario = premium + the smaller of (formula result, out-of-pocket maximum)
  8. Crossover = the allowed charges where the totals match: $______

Cautions before you trust the result

  • A plan's network can change the prices. Your allowed amounts came from your current plan's contracts. A different insurer may have negotiated other prices with the same hospital. Treat your numbers as an estimate and expect some drift either way.
  • Copays change the arithmetic. If a plan charges a flat $30 for a visit and only counts some services toward the deductible, redo the lines for those categories instead of using the single formula.
  • Family plans have two deductible designs. An embedded deductible lets one person's spending trigger coverage before the family deductible is met; an aggregate one does not. The plan documents say which applies.
  • Premium help is not in the sticker price. If you receive a premium tax credit, compare plans on the premium you will actually pay, not the listed premium. The marketplace shows it after the credit.
  • One surprise is not a pattern. If your year had a single unusual event, do not size your plan around it; do, though, confirm you could survive its cost under the plan you choose, which is what the severe scenario is for.
  • Check the plan year. Deductibles and out-of-pocket maximums reset on the plan's start date, usually January 1, so last year's progress toward them does not carry into next year. The tracker described in deductible and out-of-pocket tracker helps keep this year's numbers visible while you decide.

If your forecast raises questions the numbers cannot answer, such as whether a specific doctor will be in network or how a drug is classified, the right person is the plan's member services line, a licensed broker, or a marketplace navigator. For a plain-language view of the whole exercise, the guide how to estimate your total yearly health care costs for a plan covers the method at a higher level.

Key takeaways

  • Allowed amounts on your EOBs, not billed charges, are the numbers that translate across plans.
  • Split recurring care from one-time events before you forecast, then run a quiet, a repeat and a severe scenario.
  • The break-even point between two plans is often more informative than any single total; when your expected spending is near it, the decision rests on risk tolerance and doctors, not dollars.
  • Check each candidate plan's drug tier and network against your own list before you rely on the math.
  • Redo the arithmetic with the plan's actual copay rules, and ask member services, a navigator or a broker when the documents are unclear.

Terms used in this guide

Related tools

Related guides

Latest on this topic