Skip to content
The title slide and first slides of the Medical Bill Tracker template

Medical Bill Tracker

Spreadsheet template for Google Sheets and Excel

Make a copy in Google Sheets
Price
Free
Slides
5
Difficulty
Beginner
Updated
November 16, 2026

Every slide (5)

Overview

Medical bills arrive in pieces: a provider bill, an explanation of benefits and sometimes a second bill. The Bills tab records each one with a short reference, the service date, provider, patient, billed amount, insurance paid and any plan discount. The sheet works out what you owe, adds up the payments from the Payments tab and shows the balance and whether the bill is Open, Overdue or Paid, with overdue rows in red.

The Insurance tab totals billed, insurance paid, what you owe and the balance, then compares coverage by family member and balance by provider in two charts. Payments are logged by bill reference, which lets you handle payment plans with several installments. There is no place for diagnoses or member numbers, which keeps the file safer to share with a relative who helps you.

Useful for

  • Check each bill against the insurer statement
  • Track a hospital payment plan month by month
  • See what each family member costs after insurance

What's included

  • 4 tabs: Bills, Insurance, Payments, How to use
  • Bills: a table
  • Insurance: a dashboard with 4 summary figures
  • Payments: a table
  • 2 charts that update as you type
  • Formulas, dropdowns and colour rules already set up
  • Sample rows that show how to fill it in

How to use it

  1. 1

    Click Make a copy in Google Sheets, then confirm on the Google page. The copy is saved to your own Google Drive.

  2. 2

    Start on the Bills tab: replace the sample rows with your own.

  3. 3

    Keep the formula columns as they are; they fill in as you type.

  4. 4

    Read the How to use tab for tips. For Excel, download the .xlsx file instead.

What you need

Requirements

  • A Google account, or Microsoft Excel for the download

Works with

  • Google Sheets
  • Microsoft Excel (download the .xlsx)

Questions

How do I track medical bills and insurance payments?

Give each bill a reference, enter the billed amount and what insurance paid from the explanation of benefits, then log your payments against the same reference.

How can I check the amount I owe?

Owed is the billed amount minus insurance paid and any plan discount. Compare it with the provider bill and request a line-by-line statement if they differ.

Should I put diagnosis or insurance numbers in the sheet?

No. Keep the file to dates, providers and amounts. This tracker is not medical or financial advice.

  • #bill-tracker
  • #medical-bill-tracker
  • #google-sheets
  • #excel
  • #spreadsheet-template
  • #free-template

More bill tracker templates

See all 13

Also in Finance

All finance templates
Get this template

Preparing your template…