Skip to content
GraviPointThe Centre of Productivity
  • AI AgentNew
  • Pricing
  • Community
Log inGet started free
TemplatesHealth & FitnessMedical Billing & AdminMedical Billing Claims Tracker

SpreadsheetMedical Billing & AdminFree

Medical Billing Claims Tracker

Every claim from submission to payment, with days in A/R, denial reasons and the collection rate by payer.

Shown with sample data

Colour

Medical Billing Claims Tracker

Every claim from submission to payment, with days in A/R, denial reasons and the collection rate by payer.

Outstanding
$1,090
Collection rate
79%
Paid ÷ allowed
Denial rate
22%
Claims over 30 days
3
Outstanding by status
  • Submitted$425
  • Denied$355
  • In review$210
  • Partially paid$99.60
Share of outstanding by status
  • Submitted$42539%
  • Denied$35533%
  • In review$21019%
  • Partially paid$99.609%

How to use it

  1. 1Add a row when each claim is submitted, using a claim or patient ID rather than a name.
  2. 2When the payer responds, set the status and enter the allowed and paid amounts.
  3. 3Work the claims marked Follow up first: they are unpaid after 30 days.
  4. 4Review the summary by payer each month.

In this workbook

  • About
  • What’s included
  • How to use
  • Questions
  • Related resources

About this template

See where the practice’s money is. Log each claim with the payer, date of service, amount billed and its status; record what was allowed and paid when the remittance arrives. The tracker ages unpaid claims, totals what is outstanding by payer, and shows your collection rate and denial rate so slow payers and repeat denials stand out.

Who it’s for

  • Small practices billing in-house
  • Freelance medical billers
  • Monthly revenue-cycle reviews

What’s included

  • Claims sheet: One row per claim.
  • Summary by Status sheet: Outstanding and Billed and the number of entries for each status, calculated from the Claims sheet.

How to use it

  1. 1Add a row when each claim is submitted, using a claim or patient ID rather than a name.
  2. 2When the payer responds, set the status and enter the allowed and paid amounts.
  3. 3Work the claims marked Follow up first: they are unpaid after 30 days.
  4. 4Review the summary by payer each month.

Tips

  • Most denials are fixable. Log the reason every time so you can stop the cause, not just resubmit.

Questions

What is days in A/R?

Days since the claim was submitted, for claims not yet paid or written off.

How is the collection rate calculated?

Total paid divided by total allowed, for claims with an allowed amount.

Related searchesmedical billingclaims trackerinsurance claimsaccounts receivabledenialsrevenue cycle

Details

Format
Spreadsheet
Category
Medical Billing & Admin
Sheets
2
Setup
10 min
Level
Beginner
Price
Free

Download a copy

Downloads need a free account.

SpreadsheetMedical Billing & AdminFree

Medical Billing Claims Tracker

Every claim from submission to payment, with days in A/R, denial reasons and the collection rate by payer.

A free account keeps your copy safe so you can come back to it. Have one? Log in

Download a copy

Downloads need a free account.

Details

Format
Spreadsheet
Category
Medical Billing & Admin
Sheets
2
Setup
10 min
Level
Beginner
Price
Free

Your copy is private to you.

More medical billing & admin templates

View all

Insurance Verification Form

Record eligibility, benefits, copay, deductible and authorization requirements before the visit.

Patient ID *

Appointment date *

Service or procedure *

Save verification
FormMedical Billing & Admin

Insurance Verification Form

Record eligibility, benefits, copay, deductible and authorization requirements before the visit.

10 min setupPreview

Superbill

Practice name Address | Phone | Email

ProviderName, credentials
Provider NPINPI
Tax ID (EIN)Tax ID

Patient

NamePatient name
Date of birthDate
AddressAddress

Services

Date of servicePlace of serviceProcedure code (CPT)
DateOffice / telehealthCode
DateOffice / telehealthCode

Total charges: $0.00 Amount paid by patient: $0.00 Balance due: $0.00

DocumentMedical Billing & Admin

Superbill

A visit receipt with provider details, diagnosis and procedure codes and fees, for patients to claim reimbursement.

10 min setupPreview

Patient Payment Plan Agreement

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

PaymentDue dateAmount
DepositDate$
1Date$

Payments will be made by card on file / bank transfer / at the front desk. No interest is charged if payments are made on time.

DocumentMedical Billing & Admin

Patient Payment Plan Agreement

Agree a balance, instalment amount and dates in writing, with what happens if a payment is missed.

10 min setupPreview

Practical guides and new resources, monthly.

One short email with new templates, calculators and how-tos. Unsubscribe any time.

GraviPointThe Centre of Productivity

Find the right resource. Make it work for you. Get things done with spreadsheets, documents, forms and calculators you can use right in your browser.

support@gravipoint.com
  • @gravipoint
  • @GraviPoint
  • GraviPoint
  • 𝕏@gravipoint

Templates

  • All templates
  • Budgets & expenses
  • Invoices & billing
  • Project management
  • HR & people
  • Inventory & stock
  • Sales & CRM
  • Financial calculators

Popular

  • Monthly budget
  • Invoice
  • Employee shift schedule
  • Weekly timesheet
  • Project plan & Gantt chart
  • Inventory tracker
  • Expense report
  • Mortgage calculator

Solutions

  • Individuals & households
  • Freelancers & consultants
  • Founders & startups
  • Small business owners
  • Teams & operations
  • Students & educators

Company

  • About
  • Features
  • Pricing
  • Community
  • Journal
  • Contact
© 2026 GraviPoint. All rights reserved.
  • Privacy
  • Terms
  • Help centre
  • FAQ