Medical Bill Tracker Spreadsheet (Google Sheets & Excel)

Take complete control of your family's healthcare expenses, medical bills, insurance claims, and HSA/FSA savings. The DownloadSuite Medical Bills, Insurance Claims & HSA/FSA Tracker is an automated personal finance operating system engineered specifically for families, caregivers, chronic illness warriors, and individuals navigating the complex healthcare system.

Stop getting blindsided by surprise medical bills, disorganized Explanation of Benefits (EOB) statements, and missed insurance appeal deadlines. This all-in-one Google Sheets and Excel system organizes your entire healthcare financial lifecycle — from auditing provider charges and calculating true patient responsibility to tracking deductible accumulators, managing HSA/FSA tax receipts, and monitoring denied claim disputes.

What's Included in This System:

• Healthcare Command Dashboard: High-contrast KPI cards for Out-of-Pocket Spent YTD, In-Network Deductible Met (%), Out-of-Pocket Max Progress (%), HSA/FSA Balance Remaining ($), and Pending Insurance Claims Count.
• Master Medical Bills & EOB Reconciliation Ledger: Itemize date of service, patient name, healthcare provider, billed charge, insurance allowed amount, insurance paid, and patient responsibility with automatic balance math.
• Insurance Claims & Disputes Radar: Track filed insurance claims, claim numbers, payer review statuses (Approved, In Review, Denied), and statutory appeal filing deadlines.
• HSA / FSA Qualified Expense & Reimbursement Hub: Track qualified medical purchases, receipt documentation, reimbursement statuses, and long-term tax shoebox records.
• Plan Coverage & Deductible Settings: Configure annual individual and family in-network and out-of-network deductibles, out-of-pocket maximums, and starting HSA/FSA contribution allocations.
• Companion AI Prompt Guide Included: Complete 15-module prompt guide for hospital bill auditing, CPT error detection, insurance denial appeals, and triple-tax-advantaged HSA compounding strategies.
• Light & Dark Mode Included: High-contrast Dark Mode (Healthcare Cyan & Obsidian) for evening bill organizing plus clean minimalist Light Mode.

How to Use:

1. Open the Google Sheets link or native Excel workbook and enter your annual deductible and OOP max limits in the Settings tab.
2. Log all incoming doctor and hospital bills in the Medical Bills tab and reconcile with insurance EOBs.
3. Track denied claim appeals in the Claims Radar and save receipts for tax-free reimbursements in the HSA/FSA tab.