Tracking HSA Transactions in Quicken

A couple of people have asked how I keep track of Health Savings Account (HSA) transactions; so here’s how I do it in Quicken.

But you do need to keep good records. In Quicken, there are a few ways to accomplish this. Here’s my way (which is the right way):

Create the following accounts in Quicken:

“Fidelity HSA”, “AR HSA”, “AP HSA Liability”.

  1. [Fidelity HSA] – This is the physical HSA account, I used Fidelity as an example because their HSA offering is widely regarded as the best option. Unfortunately Quicken does not have an HSA Account type (Quicken team: please add this!), but it is a brokerage account that can behave like a retirement account, and when used properly probably behaves most like a Roth, so I set the type to Roth IRA.
  1. [AR HSA] – This is used as an asset account. This is how much I’m allowed to collect from the HSA. I’ll debit this whenever I make an eligible HSA expense and credit it when I reimburse myself. The balance is how much I’m allowed to withdraw without tax penalties.
  1. [AP HSA Liability] – This is a liability account that mirrors the [AR HSA] asset account. This is necessary because Quicken is a double-entry accounting system behind the scenes. It seems weird that you need a mirrored account, but this is the correct way to set it up. It is true that [AR HSA] is a receivable but you owe it to yourself, meaning it needs an offsetting liability. Don’t blame me, I’m not an accountant. 🤷‍♂️

Entering HSA Transactions

So–let’s say I go to the doctor and insurance covers most of it (haha). The portion that insurance covers is not eligible for HSA reimbursement. But I get a $5,000 bill that’s my portion to pay. First check Publication 969 and Publication 502 (by the time you read this, all the publication numbers and rules may have changed so do your own research) to make sure the medical expense is an eligible medical expense. If not, though beans 🫘.

But if it is eligible, I pay the doctor like normal, credit my Doctor expense category like normal. But I also split the transaction to track how much I’m allowed to withdraw from the HSA to reimburse myself later. Let’s say I pay the doctor from my Credit Card account (which we usually do since we can range anywhere from 2.5-4% cash back–$200 may not seem like much on a $5K transaction but we’ll take it!); I’ll create a split transaction with the following entries:

Now, in Quicken you can look at the [AR HSA] asset balance, $5,000, and whatever is there is how much you’re allowed to withdraw from your HSA Account. You can take it out now, or leave it in and continue to let it grow. You’ll also see a negative $5,000 balance on [AP HSA Liability] which is how much you owe yourself.

Whenever you decide to reimburse yourself, you simply do the reverse, but instead of the payee being your doctor, it’s your HSA Account. Here’s what it would look like on your Checking Account receiving an HSA Reimbursement:

You’ll note this doesn’t actually hit any expense accounts, and that’s expected. As far as you’re concerned nothing impacted your net worth.

With this method you can use Quicken to keep accurate records and quickly see how much you have available to reimburse yourself from your HSA at any moment in time.

The same method can be used with similar accounts such as state MSAs (Medical Savings Accounts).

It seems like a lot of work, and it is, but the tax savings is well worth the effort.

Leave a Comment