Medical Expense Tracking Spreadsheet


The Medical Expense Tracking Spreadsheet is part of a financial planning series called How to Make a Budget – Easy Steps for Beginners.

Reader Question: Kerry, I’ve been following your budgeting series — where’s the best place to record my medical expenses? Right now I just stack everything in a pile. But by tax season I’ve often misplaced a few receipts and have lost track of what was reimbursed by my medical expense insurance plan. Got a spreadsheet or medical record form for someone like me? — Jen

Download: Medical Expense Tracking Spreadsheet

Answer: If you need to keep additional records on medical expenses, go ahead and download the Medical Expense Tracking Spreadsheet. Over the years I’ve used it to track various doctor, dentist, and physiotherapy costs, and a few non-traditional health care costs as well (acupuncture, anyone?). Anyhoo, if you have prescriptions, lab tests, glasses, and other related medical expenses, indicate those costs in the Medical Professional Paid column.

This spreadsheet is just a starting point — a guideline of sorts — so feel free to add columns or change headings so they work for you and your family. And if you’re not a fan of spreadsheets, print out this download and use it as a simple medical record form. Easy.

I added a column for Mileage, just in case it’s a tax-deductible expense in your neck of the woods. The columns Date Submitted and Insurance Reimbursement are for families paying medical bills before submitting claims or paying the differences not covered by insurance and needing to keep this information separate.

Keep all your receipts in a safe spot, and during tax time this spreadsheet should help you save a lot of time. I know it helped me when I needed knee surgery. Cheers, Kerry.

Got a spreadsheet or worksheet request? Leave your asks in the blog comment section. 🙂 I love reader requests!

Get the series, How to Make a Budget – Easy Steps for Beginners, for more free tools, tips, and downloads.

how to make a budget

Love love love,


  1. Nick November 1, 2010 at 12:07 pm

    this seems similar to a regular budget spreadsheet, i think these are a simple and great way to keep track of your expenses.

  2. The SOFT Blogger November 1, 2010 at 3:12 pm

    Really like the spreadsheet!

    I think a lot of people can use this or customize it for their own use. I know for our clinic that patients have a tough time keeping track of what they’re spending or how much they might be able to claim on their income tax or through insurance.

  3. marci357 November 2, 2010 at 1:37 pm

    You’re so sweet to share this!

  4. Ms. February 12, 2015 at 1:57 pm

    Would love to see a spreadsheet for daily medications and meal times (ie, someone who takes at least 25 meds a day – 4 times a day some on empty stomach, some taken 2x a day spread 12 hours apart, some with food… etc.)

    I’m making one from scratch now, looking to modify … something! thanks

  5. sarah December 7, 2017 at 1:29 pm

    I am so thankful to have found this. It is helpful as I apply for my disability thank you!

Leave A Comment