Free HSA Receipt Tracker Spreadsheet

Made for the pay now, reimburse later strategy. It keeps a running total of what you could take out of your HSA tax-free, and flags any expense that's missing a receipt. No signup, no email.

An Excel file (.xlsx, 80 KB). Google Sheets (File, then Import) and Apple Numbers can open it too.

What the Receipts tab looks like

DateWhat it was forPaid withAmount paidStill reimbursableCheck
3/14/2026Dental cleaningOut of pocket$145.00$145.00OK
8/9/2025GlassesOut of pocket$300.00$200.00OK
2/3/2025PrescriptionOut of pocket$40.00$40.00Save the receipt
5/5/2024Lab workHSA directly$80.00-Paid from HSA, nothing to reimburse

Example rows, made up. The glasses were partly reimbursed already, so $200 of the $300 is left.

What's in it

  • Receipts: one row per expense, with who it was for, where you saved the receipt, and when you reimbursed yourself. A Check column flags expenses from before your HSA opened, missing receipts, and reimbursements larger than what you paid.
  • Summary: what you've paid out of pocket, what you've reimbursed, what's still reimbursable, and how much of that has no receipt behind it yet, in total and by year.
  • Start here: how to use it, and what the IRS expects you to keep.

How to use it

  1. Enter the date your HSA was established. Expenses from before that date can't be reimbursed.
  2. Add each medical expense you pay out of pocket, and save the receipt somewhere you'll still have it in 20 years.
  3. Paste the link or folder path to that receipt into the row.
  4. When you reimburse yourself, fill in the date and amount.

There's no deadline for that last step. IRS Notice 2004-50, Q&A 39, lets you reimburse a qualified expense years later, as long as it came after your HSA was established and you can show it. Expenses you pay with your HSA card need the same proof, so log those too.

What to keep for each row

Publication 969 says you need records showing that a distribution paid for qualified medical expenses, that those expenses weren't already paid or reimbursed from another source, and that you didn't deduct them. In practice that means an itemized receipt or bill, plus your insurer's explanation of benefits when there is one. A card statement alone doesn't show what you bought. Our guide to HSA reimbursement records goes through it, and how long to keep HSA receipts covers the timing.

Where a spreadsheet falls short

A spreadsheet holds the list, not the receipts. The files live somewhere else, links break when you change accounts, and thermal paper fades. Typing in every receipt by hand is the part most people stop doing.

Curious what keeping it up is worth? The HSA shoebox calculator estimates it from your own numbers. For a look at the apps that do this, including free ones, see our comparison of HSA receipt apps.

Rather not type it all in?

Shoebox reads a receipt you forward by email or upload as a photo, and stores the file with the details. It's free for 30 days with no card, then $60/year if you keep it. You can still view and download your receipts if you stop paying.

The spreadsheet is for record keeping, not tax advice. Shoebox sells HSA receipt software, so factor that in.