How to Use This Worksheet

  1. Collect your EOBs — Gather the Explanation of Benefits statements from your insurance company for the medical visits you want to track.
  2. Match each EOB to the provider bill — For each visit, write down what the provider billed, what insurance paid, and what the EOB says you owe.
  3. Spot discrepancies — If the provider bill shows a different "you owe" amount than your EOB, highlight it. That's a potential billing error.
  4. Track payments — Mark each bill as paid once you've verified the correct amount.
  5. Ready to go digital? — EOBVault does all of this automatically — tracks deductibles, highlights overcharges, and keeps everything in one place forever.
Medical Bill & EOB Reconciliation Worksheet
Patient: _________________________    Insurance Plan: _________________________    Policy #: _________________________
# Provider / Patient Service Date Service Type Billed Insurance Paid You Owe (EOB) You Owe (Bill) Match? Status Notes
EX City General Hospital
Pat: Jane Doe		 01/15/26 ER Visit $4,200 $3,780 $420 $420 ✅ Paid Met deductible with this visit
EX Valley Radiology
Pat: Jane Doe		 01/22/26 MRI $2,800 $2,240 $560 $560 ✅ Paid
EX Dr. Patel — Cardiology
Pat: Jane Doe		 02/03/26 Follow-up $350 $280 $70 $70 ✅ Paid
1          
2          
3          
4          
5          
6          
7          
8          
9          
10          
TOTALS
Deductible & Out-of-Pocket Tracker
Category Annual Limit Met So Far Remaining % Complete
EX Deductible $3,000 $1,050 $1,950 35%
EX Out-of-Pocket Max $7,500 $1,050 $6,450 14%
Deductible
Out-of-Pocket Max
Payment Log
Date Paid Provider Amount Method Confirmation # HSA/FSA?
EX 02/15/26 City General Hospital $420 Credit Card #CHG-8821 No
      
      
      
      

Ready to Go Digital?

EOBVault tracks all of this automatically — no paper, no spreadsheets, no account needed. See your deductible progress, spot billing errors, and keep every bill organized in one place. Free forever.

📋 Try EOBVault Free →

Want encrypted backup, receipt & EOB attachments, or household views? Upgrade to EOBVault Pro — $9 one-time

🔒
Local-First All data stays on your device
📊
Deductible Tracking Auto-calculated from your bills
⚠️
Error Detection Spot overcharges instantly
📱
Works Everywhere Phone, tablet, desktop — offline too

❓ Common questions

What is this medical bill reconciliation worksheet?
A free printable worksheet that helps you match your EOBs (Explanation of Benefits) to provider bills, track what insurance paid, and know exactly what you owe. It includes columns for the provider, service date, amount billed, insurance paid, what the EOB says you owe, what the bill says you owe, match status, and payment status.
How do I use the reconciliation worksheet?
Four steps: 1) Collect your EOBs from your insurance company for the visits you want to track. 2) Match each EOB to the provider bill and write down what the provider billed, what insurance paid, and what the EOB says you owe. 3) Spot discrepancies — if the provider bill shows a different "you owe" amount than your EOB, highlight it as a potential billing error. 4) Track payments and mark each bill paid once you have verified the correct amount.
Is the worksheet free and does it require an account?
Yes, it is completely free to use and no account is required — it is 100% private. The worksheet is print-friendly, works on any device, and has a free printable layout with example rows showing how to fill it in.
What if the EOB and the provider bill show different amounts I owe?
That is a potential billing error. Highlight the discrepancy and verify the correct amount before paying. The worksheet's Match column makes it easy to see which rows disagree between what the insurance EOB says you owe and what the provider bill says you owe.
What is the difference between "You Owe (EOB)" and "You Owe (Bill)"?
"You Owe (EOB)" is the amount your insurance company's Explanation of Benefits says you owe, while "You Owe (Bill)" is the amount the provider's bill says you owe. The Match column shows whether they agree, so you can spot discrepancies that may be billing errors.
What does EOBVault Pro include?
EOBVault is free for unlimited medical bills, deductible tracking, and CSV export — no account, no credit card, and no cloud storage. EOBVault Pro is a one-time $9 upgrade for encrypted backup export, receipt and EOB attachments, and multi-person household views.

© 2026 Juncture Logic. This worksheet is a free resource from EOBVault — the privacy-first medical bill tracker. Not medical, insurance, tax, or legal advice. Verify all amounts against your official EOB.