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.
8 free medical bill invoice templates, ready to edit in your browser and download for Excel, Word, Google Sheets or your calendar app. This collection brings together 4 spreadsheets, 3 documents and 1 form from Medical Billing & Admin and Personal Finance. Start with Medical Billing Claims Tracker, Medical Expense and HSA Tracker and Medical Practice Budget: 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.
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.
Revenue to date
$990,500
Costs to date
$867,900
Operating margin
12%
A twelve-month budget for a clinic with revenue by service line, staff and operating costs, and budget against actual.
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.
Use this form to give us permission to share your health records. You may withdraw permission at any time by writing to us.
Full name *
Date of birth *
Phone
A patient’s written permission to send specific records to a named person or organisation.
Practice: Practice name Patient / responsible party: Name Account number: Number Date: Date
1. Balance
The patient owes $ amount for services provided on dates, after any insurance payments.
2. Payment schedule
| Payment | Due date | Amount |
| Deposit | Date | $ |
| 1 | Date | $ |
Payments will be made by card on file / bank transfer / at the front desk. No interest is charged if payments are made on time.
Agree a balance, instalment amount and dates in writing, with what happens if a payment is missed.
Open denials
4
Amount at risk
$1,015
Recovered
$243
Work denied claims to resolution: reason, owner, appeal deadline and how much was recovered.
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.