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.
4 free medical bill templates, ready to edit in your browser and download for Excel, Word, Google Sheets or your calendar app. This collection brings together 3 spreadsheets 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.
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.