• Skip to primary navigation
  • Skip to main content
  • Skip to primary sidebar
  • Skip to footer
  • Start Here
  • Work with David
  • Our Services
  • Contact
Young Adult Money

Make more. Save more. Live better.

  • Blog
  • Credit Cards
    • Rewards
    • Cash Back
    • Travel
    • Airlines
    • Hotels
    • Balance Transfer
    • Student
    • Business
  • FREE Budget Spreadsheet
  • FREE Student Loan Spreadsheet
This Just In... Check out the latest travel rewards credit card offers

HSA Medical Expense Tracking Spreadsheet

By David Carlson / Last updated: January 31, 2023 / Download, Health Care, Health Insurance, Personal Finance, Spreadsheets, Taxes

We may receive compensation from companies mentioned within this post via affiliate links. Read our full advertiser disclosure. Opinions, reviews, analyses & recommendations are the author’s alone, and have not been reviewed, endorsed or approved by any of these entities.
Pin29
Share
Tweet
Email
Buffer
Share
29 Shares


HSA Medical Expense Tracking Spreadsheet

If you have a Health Savings Account, or HSA, and aren’t using it to pay for medical epenxes, you are missing out on tax benefits.

As we explain in our Health Savings Account Guide, HSAs have a triple-tax advantage:

  • Put Money in Pre-Tax – Contributions put into an HSA are not taxed. Meaning, your adjusted gross income on your taxes will decrease by the amount you deposit.
  • Interest and Investment Gains are Not Taxed – Once your cash balance hits a certain threshold (i.e. $1,000, $2,000, etc.) you can shift any money above the threshold into an investment account. The investment gains are not taxed.
  • Withdraw Money Tax-Free – When you withdraw money to cover a qualified medical expense you are not taxed on the withdrawal. In general a qualified medical expense is defined as an expense that pays for healthcare services, medications, or equipment. Clear-cut examples include a prescription you get at a pharmacy or a bill from a doctor visit.

At a minimum, it makes sense to deposit money into your HSA and reimburse yourself for qualified expenses so that you are paying with before-tax dollars.

So how much can you contribute to an HSA? For 2023 the IRS has set contribution limits for HSAs to $3,850 for an individual or $7,750 for a family. For those over the age of 55 there is an opportunity to contribute an additional $1,000.

Besides contributing to your HSA and reimbursing yourself for qualified medical expenses, there are a couple of other ways to optimize your HSA. You can read a more detailed explanation in our post 2 Hacks to Maximize your HSA Health Savings Account, but at a high level they are:

  • Pay with a credit card, not with your HSA debit card – When you pay with your HSA debit card, you don’t receive any rewards like cash back or points. Use a rewards credit card that either provides you with travel rewards or cash back. You can view all the latest credit card sign-up offers here.
  • Track your qualified medical expenses, then reimburse them years down the road from investment gains – What most people don’t realize is there is no time limit for reimbursing your expenses from your HSA. Meaning, if you incur a qualified expense in 2023, for example, you can reimburse it at any point in the future, even years down the road (you must have had an HSA when the expense was incurred for it to be eligible for reimbursement).

The benefit of tracking your medical expenses and reimbursing later on is that you can keep more cash in your HSA, which allows you to invest more money. Remember, the investment gains are not taxed, so you can keep building your investments tax-free.

Think of the alternative. If you reimburse yourself for a medical expense immediately from your HSA, that cash exits your tax-sheltered HSA account, and you miss out on all the tax-free investment gains.

 

HSA Medical Expense Tracking Spreadsheet

 
The best way to track your medical expenses is in a spreadsheet. That way you have a record of what expenses you’ve paid for but haven’t reimbursed from your HSA. Then at any point in the future you can reimburse yourself for some or all of the expenses in your spreadsheet.

Here’s my approach:

  • Create a folder to store your receipts.
     
    Include the date and some sort of unique descriptor (e.g. 2022_12_15 Chiropractic Block of Care Robert).
  • Add the expense to a tracking spreadsheet.
     
    In the first column, include the name of the receipt (e.g. 2022_12_15 Chiropractic Block of Care Robert). That way you can easily locate the receipt that aligns to the row. Remember, if you use the strategy of reimbursing yourself later on, you may need to go back years later – make it easy on yourself. Include other details in the spreadsheet such as what payment was used, the servicer/company you paid, cost, etc.

Instead of starting from scratch you can grab a copy of our free HSA medical expense tracking spreadsheet.

I included a couple examples in it to give you an idea of the type of details you may want to record. You can grab this spreadsheet for free by entering your email in the below form:

Join our Online Community to Receive your FREE HSA Medical Expense Tracking Spreadsheet

HSA Health Savings Account Medical Expense Spreadsheet

 

Check out some of our favorite personal finance resources:

Are you getting the best credit card rewards? Check out the top cash back credit card offers (updated daily)

Make extra money: 15 ways to make money from your computer

  • Get our FREE Automated Budget Spreadsheet and our Student Loan Spreadsheet

Get the First Chapter Free!

Student Loan Solution Cover - 3D

Join our online community and get the first chapter of the book Student Loan Solution absolutely FREE!

Pin29
Share
Tweet
Email
Buffer
Share
29 Shares

David Carlson

David Carlson is the founder of Young Adult Money. He is a nationally recognized speaker and the author of Student Loan Solution (2019) and Hustle Away Debt (2016). His opinions have been featured on such media outlets as The New York Times, The Washington Post, Cheddar, NBC's KARE11, and more.
Connect:

Comments Policy

Comments, responses, and other user-generated content is not provided or commissioned by this site or our advertisers. Responses have not been reviewed, approved, or otherwise endorsed by this website or its advertisers. It is not the responsibility of advertisers or this website to ensure that all comments and/or questions are answered. With all that being said, please comment away!

Primary Sidebar

Credit Cards

  • Best Travel Rewards Cards
  • Best Balance Transfer Cards
  • Best Cash Back Credit Cards
  • Best Business And Side Hustle Credit Cards
  • Best Student Credit Cards

Start a Blog:

How to Start a Blog that Makes Money
 

Top Posts

  • 15 Ways You Can Make Money From Your Computer Right Now
  • When You Should and Shouldn’t Refinance Student Loans
  • How Much Money You Will Need to Make $1,000 in Dividends

Free Spreadsheets & Downloads

  • Free Automated Budget Spreadsheet
  • Student Loan Repayment Spreadsheet
  • The Ultimate Personal Finance Checklist
  • 401k Spreadsheet to Analyze your Options
  • Wedding Budget Spreadsheet
  • 52 Week Money Challenge Spreadsheet and Printable

First Chapter Free!

Join our online community and receive the first chapter of Student Loan Solution absolutely FREE.

If you don't see the email in your inbox, please check your spam folder.

Connect:

Categories:

Search:

Get the New Book!

Student Loan Solution: 5 Steps to Take Control of Your Student Loans and Financial Life is available on Amazon by clicking here, or by clicking on the graphic below.

Make more. Save more. Live better.

Site Directory:

  • About
  • Contact
  • Advertise
  • Recommendations
  • Finance Tools
  • Credit Cards
  • Insurance
  • Banking
  • Investing

Disclaimer | Privacy Policy

Feedback? Questions?
Contact us and let us know what you think.

Connect:

Search This Site:

Copyright © 2012–2024 Young Adult Money, LLC / All Rights Reserved
Designed by LizTheresa.com / Developed by Nuts and Bolts Media

Manage your privacy

To provide the best experiences, we and our partners use technologies like cookies to store and/or access device information. Consenting to these technologies will allow us and our partners to process personal data such as browsing behavior or unique IDs on this site and show (non-) personalized ads. Not consenting or withdrawing consent, may adversely affect certain features and functions.

Click below to consent to the above or make granular choices. Your choices will be applied to this site only. You can change your settings at any time, including withdrawing your consent, by using the toggles on the Cookie Policy, or by clicking on the manage consent button at the bottom of the screen.

Functional Always active
The technical storage or access is strictly necessary for the legitimate purpose of enabling the use of a specific service explicitly requested by the subscriber or user, or for the sole purpose of carrying out the transmission of a communication over an electronic communications network.
Preferences
The technical storage or access is necessary for the legitimate purpose of storing preferences that are not requested by the subscriber or user.
Statistics
The technical storage or access that is used exclusively for statistical purposes. The technical storage or access that is used exclusively for anonymous statistical purposes. Without a subpoena, voluntary compliance on the part of your Internet Service Provider, or additional records from a third party, information stored or retrieved for this purpose alone cannot usually be used to identify you.
Marketing
The technical storage or access is required to create user profiles to send advertising, or to track the user on a website or across several websites for similar marketing purposes.
Statistics

Marketing

Features
Always active

Always active
Manage options Manage services Manage vendors Read more about these purposes
Manage options
{title} {title} {title}
Manage your privacy

To provide the best experiences, we and our partners use technologies like cookies to store and/or access device information. Consenting to these technologies will allow us and our partners to process personal data such as browsing behavior or unique IDs on this site and show (non-) personalized ads. Not consenting or withdrawing consent, may adversely affect certain features and functions.

Click below to consent to the above or make granular choices. Your choices will be applied to this site only. You can change your settings at any time, including withdrawing your consent, by using the toggles on the Cookie Policy, or by clicking on the manage consent button at the bottom of the screen.

Functional Always active
The technical storage or access is strictly necessary for the legitimate purpose of enabling the use of a specific service explicitly requested by the subscriber or user, or for the sole purpose of carrying out the transmission of a communication over an electronic communications network.
Preferences
The technical storage or access is necessary for the legitimate purpose of storing preferences that are not requested by the subscriber or user.
Statistics
The technical storage or access that is used exclusively for statistical purposes. The technical storage or access that is used exclusively for anonymous statistical purposes. Without a subpoena, voluntary compliance on the part of your Internet Service Provider, or additional records from a third party, information stored or retrieved for this purpose alone cannot usually be used to identify you.
Marketing
The technical storage or access is required to create user profiles to send advertising, or to track the user on a website or across several websites for similar marketing purposes.
Manage options Manage services Manage vendors Read more about these purposes
Manage options
{title} {title} {title}