Medical Bill Tracking Spreadsheet After Death: What to Track and How

Why a Generic Spreadsheet Fails Executors

A standard medical bill tracker — the kind designed for living patients managing their own insurance — assumes you can call the provider, verify your own coverage, and negotiate on your own behalf. Executors operate under a completely different set of constraints.

Letters Testamentary or Letters of Administration establish a court-appointed personal representative's authority to act for the estate. HIPAA protections continue for 50 years after death; that representative can access PHI relevant to estate administration, and a provider may also disclose information directly relevant to a family member's or friend's prior involvement in care or payment unless that conflicts with a known preference. And the bills you're tracking don't just need to be paid — they need to be ranked by your state's creditor priority hierarchy, because paying a low-priority medical bill before settling higher-priority claims can make you personally liable for the shortfall.

A tracking system for post-death medical bills has to account for all of this. Here's what actually works.

The Columns That Matter

A functional executor-level tracker needs more than provider, date, and amount. These are the fields that prevent mistakes:

Provider name and facility type. Distinguish between the hospital, each individual specialist (radiologist, anesthesiologist, pathologist), the ambulance service, and the pharmacy. A single ER visit can generate five separate billing entities, and each one files independently with insurance.

Service dates. The date range the charges cover, not the date the bill arrived. This matters for determining whether the charges fall within the "last illness" window that many states treat as a higher-priority creditor class. Florida gives Class 4 priority to medical expenses from the last 60 days of the final illness. Older bills drop to Class 8.

Billed amount vs. insurance-adjusted amount. The number on the provider's invoice is almost never the number the estate actually owes. The Explanation of Benefits (EOB) from the insurer shows the negotiated rate, what insurance paid, and the patient responsibility. Until you have the matching EOB, don't treat any billed amount as final.

EOB matched (yes/no). A simple flag that tells you whether you've received and reconciled the insurer's response for each charge. Unmatched bills are the ones most likely to contain errors — duplicate charges, incorrect coding, or balance bills that violate the No Surprises Act.

Payment priority class. Your state's probate code assigns each type of debt a priority ranking. Map each bill to its class as you enter it; the order is state-specific. This column prevents the most expensive executor mistake: paying bills out of order.

Status. Active statuses for an executor's tracker: pending EOB, under audit, appealing denial, sent to charity care, sent debt validation, disputed, approved for payment, paid. Avoid a single "unpaid" bucket — it hides too much.

Notes. Flag anything unusual: a personal guarantee signed at intake, a ground ambulance balance bill (excluded from No Surprises Act protections), a MERP-related charge, or a facility that has already been notified of estate insolvency.

Matching Bills to EOBs

The reconciliation step catches billing errors, and the estate has no obligation to pay charges that insurance should have covered or that were billed incorrectly.

For each bill:

1. Locate the corresponding EOB. Match by provider, service date, and procedure. Insurance companies mail EOBs to the policyholder's last known address — if the mail is being forwarded, expect a 2- to 4-week delay.
2. Compare the billed amount to the allowed amount. If the provider is in-network, the estate owes only the patient-responsibility amount on the EOB (copay, coinsurance, deductible), not the provider's full billed charge.
3. Check for balance billing. If an out-of-network provider treated the deceased at an in-network facility after January 1, 2022, the No Surprises Act caps the estate's liability at in-network cost-sharing rates. Any amount above that is the provider's problem, not the estate's.
4. Request an itemized statement. If the billed amount looks high or the EOB shows unexplained adjustments, request a line-by-line itemized bill with CPT codes. Common errors include duplicate charges for the same procedure, unbundled charges (billing each component separately instead of using a single bundled code), and charges for services documented in the chart but never actually performed.

Mark each bill's "EOB matched" column only after you've completed this comparison. An unmatched bill stays in your active-audit queue.

Deadline Tracking

Medical bill administration has hard deadlines that a simple bill tracker won't surface:

• COBRA election: At least 60 days from the later of the date coverage ends or the date the election notice is provided to elect continuation coverage for surviving dependents. Miss it and the coverage option disappears permanently.
• Insurance claim filing: Check the plan's timely-filing limit. Unpaid provider bills sometimes mean the claim was never filed.
• Hospital charity care applications: IRS Section 501(r) requires nonprofit hospitals to accept financial assistance applications up to 240 days from the first post-discharge billing statement.
• Insurance appeal deadlines: Stage 1 internal appeals typically must be filed within 180 days of the denial. Stage 2 external review has its own window.
• Creditor claim filing period: State law and the notice to creditors set the filing deadline. After that window closes, late claims may be barred.

Your tracker should include a deadline column for each bill that has a time-sensitive action attached. Sort by deadline weekly and escalate anything within 14 days.

When the Tracker Tells You to Get Help

Two patterns in your tracking data signal that the situation has outgrown self-management:

The estate is borderline insolvent. If total medical debt plus other liabilities are approaching total estate assets, the payment-order decision becomes consequential. Paying the wrong creditor first can make you personally liable. A probate attorney can determine the exact priority ranking in your state and protect you from personal exposure.

A facility is pursuing you personally. If a nursing home or hospital is threatening a filial responsibility claim against you as an adult child — not against the estate — that's a legal dispute, not an administrative task. Twenty-nine states have these statutes on the books, and the Pennsylvania Pittas case showed they can result in six-figure judgments.

The Health Insurance & Medical Bills After Death toolkit includes a pre-built bill audit ledger, a deadline tracker, and a communication log designed for exactly this workflow — along with letter templates for debt validation, charity care applications, and MERP hardship waivers.