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.
6 free medical insurance invoice templates, ready to edit in your browser and download for Excel, Word, Google Sheets or your calendar app. This collection brings together 3 spreadsheets, 2 documents and 1 form 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.
Practice name | Address | Phone | Email
| Statement date | Date |
| Account number | Number |
| Patient | Name |
Services
| Date | Service | Charge |
| Date | Service description | $ |
| Date | Service description | $ |
Previous balance: $ Payments received: $ Balance due now: $
How to pay
A clear bill for the patient: services, insurance payments and adjustments, and the balance now due.
Credentials tracked
8
Expired or missing
2
Renew within 90 days
2
Licences, registrations, insurance and payer enrolments for every clinician, with expiry warnings.