About The Medical Bill Tracker
This Medical Bill Tracker is a resource provided by Triage Cancer for personal use. Please feel free to share this resource with your communities or to post a link on your organization's website. However, this content may not be reproduced, in whole or in part, without the express permission of Triage Cancer. Please email us at info@TriageCancer.org to request permission.
The Medical Bill Tracker can be helpful when calculating your medical expenses for financial and health insurance purposes.
How To Use the Medical Bill Tracker
Click here to open the Medical Bill Tracker.
Once you have opened the sheet, you will be viewing an example worksheet, if you click on the sheet to the right called “My Medical Bill Tracker” you will see a blank worksheet that you can customize for your own use.
To use this worksheet in Excel, select “File” and download a copy to your computer. To use this worksheet in Google Sheets, select “File” and make a copy (note: you will need to be logged in to your Google account to see the option to make a copy).
Once you have downloaded/copied the worksheet, complete the following steps:
Step 1: fill out the information in the top 4 rows using information from your health insurance policy.
Step 2: as you receive and pay bills, fill out rows with the information from your Explanation of Benefits (EOB). Each time you add information in rows 9 – 55, the totals at the top and bottom of the sheet will automatically calculate.
For more information on managing medical finances, our Quick Guide to Managing Medical Bills is available.
