Outstanding
$1,090
Collection rate
79%
Denial rate
22%
Medical Billing Claims Tracker
Every claim from submission to payment, with days in A/R, denial reasons and the collection rate by payer.
5 free medical invoice for insurance claims templates, ready to edit in your browser and download for Excel, Word, Google Sheets or your calendar app. This collection brings together 3 spreadsheets, 1 form and 1 document from Medical Billing & Admin and Personal Finance. Start with Medical Billing Claims Tracker, Insurance Verification Form and Medical Expense and HSA Tracker: each comes with realistic sample content, working formulas or ready-to-use wording, and a step-by-step guide.
Outstanding
$1,090
Collection rate
79%
Denial rate
22%
Every claim from submission to payment, with days in A/R, denial reasons and the collection rate by payer.
Record eligibility, benefits, copay, deductible and authorization requirements before the visit.
Patient ID *
Appointment date *
Service or procedure *
Record eligibility, benefits, copay, deductible and authorization requirements before the visit.
You paid this year
$4,670
Deductible left
$0
Out-of-pocket max left
$2,130
Log every medical bill, what insurance paid and what you owe, track HSA contributions against the limit and keep receipts for tax-free reimbursement.
Practice name Address | Phone | Email
| Provider | Name, credentials |
| Provider NPI | NPI |
| Tax ID (EIN) | Tax ID |
Patient
| Name | Patient name |
| Date of birth | Date |
| Address | Address |
Services
| Date of service | Place of service | Procedure code (CPT) |
| Date | Office / telehealth | Code |
| Date | Office / telehealth | Code |
Total charges: $0.00 Amount paid by patient: $0.00 Balance due: $0.00
A visit receipt with provider details, diagnosis and procedure codes and fees, for patients to claim reimbursement.
Lowest expected cost
$6,176
Lowest annual premium
$4,776
Lowest worst-case year
$11,276
Compare quotes on what you would really pay in a year: premium, deductible, coinsurance and out-of-pocket maximum.