What's inside
- Summary: your deductible, coinsurance and out-of-pocket max; progress bars; what the plan paid; what you were billed; mismatched bills and the amount overbilled; what's still to pay
- Claims: up to 200 claims (Deductible, Copay or Preventive) with what should go toward the deductible, coinsurance, what you should owe, the difference from the bill and the deductible left
- Sample file: a $3,000 deductible, 20% coinsurance and $7,500 out-of-pocket max with 7 claims; one lab bill is $248 more than what's owed
Checked, not just designed: all 1,013 formulas recalculate with zero errors, and every claim and total was checked against an independent claim-by-claim calculation in 7 scenarios.
Works in Excel and Google Sheets. Not medical or financial advice.
Try the free version first
The free online calculator uses the same model for a quick answer. The spreadsheet adds tracking, history and the full views.