Medical Expense Tracker
Log each bill with the amount charged, the amount paid and any write-offs. The tracker totals everything, calculates outstanding balances, and lets you print or export a clean worksheet.
Medical Expense Tracker
Stays in your browser. Nothing is uploaded. Avoid entering diagnoses, account numbers or other details you do not need.
Medical expense worksheet
Prepared with ClaimSettleIQ (claimsettleiq.com). Figures entered by the user.
| Date | Provider & details | Billed | Paid | Adjusted | Outstanding | Actions |
|---|
Billed, paid, outstanding and recoverable: four different numbers
- Billed amount
- What the provider charged before any insurance discount. Bills can be far higher than what is ultimately accepted as payment.
- Amount paid
- What was actually paid by a health plan, auto medical coverage, you, or anyone else.
- Adjustments / write-offs
- Amounts the provider agreed not to collect, often under a contract with your insurer.
- Outstanding balance
- What the provider still says is owed: billed − paid − adjustments.
None of these automatically equals what may be recoverable in a claim. States take different approaches to whether the billed amount or the amount actually paid is the measure of medical damages, and to whether payments from health insurance reduce what can be recovered. Tracking all three figures lets an attorney or adjuster work with whichever measure applies. Read Economic Damages and Medical Liens.
Tips for accurate entries
- Ask each provider for an itemized bill, and compare it with the explanation of benefits (EOB) from your insurer.
- Use one row per bill or per date of service, not per payment, to avoid counting a charge twice.
- Include pharmacy receipts and equipment purchases, which are easy to forget.
- Keep the original documents. This worksheet is a summary, not evidence in itself.
Privacy and storage
Entries live in this page’s memory and disappear when you close it, unless you tick “Remember on this device”. In that case they are stored in your browser’s local storage on this device only, and are never sent to ClaimSettleIQ. Clearing all entries, unticking the box, or clearing your browser’s site data removes them. The CSV download is created in your browser. When opened in spreadsheet software, text that begins with characters such as = is prefixed with an apostrophe to prevent it being treated as a formula.