Skip to content
Medical Expense Tax Log cover: a sample sheet with paid for care, insurance paid back and out of pocket and a bar chart, beside the Dashboard and Visits tabs

Medical Expense Tax Log

Spreadsheet template for Google Sheets and Excel

Make a copy in Google Sheets
Price
Free
Slides
4
Difficulty
Beginner
Updated
November 13, 2026

Every slide (4)

Overview

This log is for households that track doctor visits, prescriptions, dental work, vision care, lab tests and therapy sessions. The Visits tab records the person treated, the provider, what you paid, what insurance paid back and whether the receipt is saved. Out of pocket is worked out on each row, and the Dashboard totals those amounts by person and by type of care.

Log each visit when you pay for it, while the bill is still in front of you. Tick Receipt saved only once the paper or PDF is filed somewhere you can find it again. Whether a cost helps on your return depends on your income and on the current rules, so take these totals to a tax preparer rather than relying on the sample figures.

Useful for

  • Tracking family care costs through the year
  • Gathering receipts before a tax appointment
  • Comparing what you paid with what insurance returned

What's included

  • 3 tabs: Dashboard, Visits, How to use
  • Dashboard: a dashboard with 4 summary figures
  • Visits: 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 Visits 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

Which medical costs can I include?

Costs you paid for diagnosis, treatment and care for yourself or people you support can be relevant, but the rules set limits. Read the current IRS guidance and ask a tax preparer which ones apply to your return.

What if insurance has not paid yet?

Enter 0 in the insurance column for now, and update the row when the payment arrives. The out-of-pocket figure changes to match, so the Dashboard stays current.

Should I keep the receipts as well as this log?

Yes. Keep the receipts or statements behind each row, since a log alone does not prove a payment. Note where you filed each one in the provider column or in your own records.

  • #tax-tracker
  • #medical-expense-tax-log
  • #google-sheets
  • #excel
  • #spreadsheet-template
  • #free-template

More tax tracker templates

See all 10

Also in Finance

All finance templates
Get this template

Preparing your template…