Home › Templates › HSA tracker spreadsheet

HSA Tracker Spreadsheet

A free HSA tracker spreadsheet for Excel and Google Sheets: log every contribution and see it against your IRS limit (2025, 2026 and 2027 figures built in, with the 55+ catch-up and partial-year rule), keep a receipt log that totals the qualified expenses you can still reimburse yourself for later, and track cash vs invested balance by year.

Download Excel template (.xlsx) 378 KB · no macros · Excel 2016+ and Google Sheets · v1.0, 3 Nov 2026

Use it in Google Sheets: choose File → Import → Upload in Sheets and pick the .xlsx, or upload it to Google Drive and open it with Google Sheets. No sign-up and no connection to your HSA provider: you type the deposits, bills and statement balances yourself.

Preview: the Example tabs (a fictional family with family HDHP coverage, HSA opened 6 Jan 2025, data to 22 Oct 2026).
$9,000 of $9,7502026 contributions vs limit ($750 room left)
$2,745.22receipts bank: qualified bills you can reimburse yourself for later
$12,848balance on 30 Sep 2026: 74% invested
$199.99unreimbursed bills with no receipt saved yet
Date of serviceProviderPatientCategoryAmountPaid fromReceipt saved?Reimbursed?Receipts bank
3 Mar 2026Clear View OpticalMiaVision & eyeglasses$185.00Out of pocketYesNo$185.00
21 Apr 2026City PharmacyJordanPrescriptions$56.30HSAYes
11 May 2026Harbor CounselingAlexTherapy & mental health$130.00Out of pocketYesNo$130.00
25 May 2026Harbor CounselingAlexTherapy & mental health$130.00Out of pocketYesNo$130.00
30 Jun 2026Northside ImagingJordanLab tests & imaging$610.00Out of pocketYesYes
4 Aug 2026Corner DrugstoreMiaOver-the-counter medicine$31.48Out of pocketYesNo$31.48
20 Aug 2026FitLife GymAlexNon-qualified withdrawal$60.00HSAYes
14 Sep 2026QuickCare Urgent CareAlexDoctor & specialist visits$175.00Out of pocketNoNo
6 Oct 2026Kids First PediatricsMiaDoctor & specialist visits$95.00HSAYes
22 Oct 2026HomeCare SupplyJordanMedical equipment & supplies$89.99Out of pocketYesNo$89.99
Example Summary by year: 2025: contributions $7,100.00, distributions $810.90, receipts bank at year end $4,008.75; 2026: contributions $9,000.00, distributions $3,041.30, receipts bank at year end $2,745.22.Contributions (tax year)DistributionsReceipts bank at year end$0$2,000$4,000$6,000$8,000$10,000$7,100$811$4,0092025$9,000$3,041$2,7452026

Chart: the Example Summary by year, built from the same file. The workbook draws it as a native Excel chart, plus a line chart of the growth projection.

HSA limits for 2025, 2026 and 2027

The Settings tab holds the official IRS figures, so the spreadsheet can work out your limit for each year. Rev. Proc. 2025-19 says: "For calendar year 2026, the annual limitation on deductions under § 223(b)(2)(A) for an individual with self-only coverage under a high deductible health plan is $4,400", and $8,750 for family coverage. Rev. Proc. 2026-24, dated 29 May 2026 in the PDF metadata, sets 2027 at $4,500 and $9,000.

YearSelf-only limitFamily limitCatch-up (55+)HDHP min deductible (self / family)HDHP max out-of-pocket (self / family)IRS source
2025$4,300$8,550$1,000$1,650 / $3,300$8,300 / $16,600Pub. 969 (2025)
2026$4,400$8,750$1,000$1,700 / $3,400$8,500 / $17,000Rev. Proc. 2025-19
2027$4,500$9,000$1,000$1,750 / $3,500$8,700 / $17,400Rev. Proc. 2026-24

If you are 55 or older at the end of the tax year, Pub. 969 says "your contribution limit is increased by $1,000". The catch-up is $1,000 in all three years. To have an HSA you need HDHP coverage that meets the minimum deductible in the table, no other disqualifying health coverage, no Medicare enrollment, and nobody can claim you as a dependent (IRS Publication 969).

What's inside the spreadsheet

TabWhat you typeWhat it calculates
Start hereNothingSteps, the IRS rules the formulas follow, colour key, limits, disclaimer
SettingsHSA opened date; one row per tax year: coverage (self-only or family), age 55+, eligible on 1 Dec, months eligible, share of a family limit; the IRS limits table (2025-2027 filled in)Your limit for each year (IRS limit + catch-up, full year or months ÷ 12), with a check on each row; the dropdown lists
ContributionsUp to 300 deposits: date, tax year (only for 1 Jan to 15 Apr deposits for last year), source (payroll, employer, personal, other person, rollover), amountLimit, counted total, room left and status for the tax year shown; running total and an over-limit flag on every row; Form 8889 line 2 vs line 9 split
Expenses & receiptsUp to 500 bills: date of service, provider, patient, category, amount, paid from HSA or out of pocket, receipt saved, receipt file name, reimbursed, reimbursement dateReceipts bank (qualified, out-of-pocket, receipt saved, not yet reimbursed), missing receipts, bills before the HSA opened, distributions and non-qualified distributions
InvestmentsStatement snapshots (cash and invested), a cash target, and projection inputs: start, yearly contribution, expected returnLatest balance, invested share, cash vs target, a 30-year growth table and chart
SummaryNothingBy year: contributions vs limit, distributions, non-qualified, out-of-pocket, reimbursed, receipts bank at year end, book vs statement balance; a native chart
Example tabs (5)Already filled29 fictional deposits, 26 bills and 5 statement snapshots, so every formula has something to show

The expense categories follow the IRS lists and say whether each one is qualified:

CategoryQualified?What goes here
Doctor & specialist visitsYesOffice visits, urgent care, telehealth
DentalYesCleanings, fillings, orthodontics (not teeth whitening)
Vision & eyeglassesYesEye exams, glasses, contact lenses
PrescriptionsYesPrescribed drugs and insulin
Over-the-counter medicineYesNo prescription needed since 2020 (CARES Act, IR-2020-122)
Menstrual care productsYesTampons, pads, liners, cups (CARES Act)
Hospital & surgeryYesNot cosmetic surgery (Pub. 502)
Lab tests & imagingYesBlood tests, X-rays, MRI
Therapy & mental healthYesPhysical therapy, psychologist, psychiatrist
Medical equipment & suppliesYesCrutches, bandages, blood pressure monitor
Allowed insurance premiumsYesOnly LTC, COBRA, coverage on unemployment, Medicare 65+ (Pub. 969)
Other qualified (Pub. 502)YesCheck Pub. 502 before you use this
Non-qualified withdrawalNoTaxable; 20% additional tax unless 65+, disabled or death

How to use it

  1. Open Settings. Type the date your HSA was opened (your provider's records show it). Expenses before that date never count as qualified.
  2. Add one row per tax year: coverage on 1 December, whether you are 55+ by 31 December, whether you were eligible on 1 December, and the months you were eligible if not. Check that the last column says OK and Your limit shows a number.
  3. Open Contributions. Add every deposit: payroll, employer, your own, anyone else's, and rollovers. Leave Tax year blank unless a deposit made between 1 January and 15 April is meant for last year.
  4. Watch the top of the tab: limit, counted, room left and status. A red Over limit flag marks the first deposit that went past the limit.
  5. Open Expenses & receipts. Add every medical bill, whether you paid from the HSA or not. Save the receipt as a PDF or photo and type the file name in column H.
  6. When you pay yourself back from the HSA, set Reimbursed? to Yes and type the date. The bill leaves the receipts bank.
  7. After each statement, add a row on Investments with the cash and invested balances. The Summary fills itself.

The IRS rules the spreadsheet follows

Partial years: the last-month rule and the testing period

Pub. 969: "Under the last-month rule, if you are an eligible individual on the first day of the last month of your tax year (December 1 for most taxpayers), you are considered an eligible individual for the entire year." The catch is the testing period, which runs from that month "and ends on the last day of the 12th month following that month (for example, December 1, 2025, through December 31, 2026)". If you lose eligibility in that window for reasons other than death or disability, the extra contributions are added to income and "also subject to a 10% additional tax".

If you were not eligible on 1 December, the Form 8889 instructions send you to the Line 3 Limitation Chart and Worksheet: in effect, the limit for each eligible month added up and divided by 12. The spreadsheet does the same with (limit + catch-up) × months eligible ÷ 12, assuming the same coverage type in each eligible month.

Every deposit counts, from any source

Pub. 969 says "the employee, the employee's employer, or both may contribute" and "you must reduce the amount you or any other person can contribute to your HSA by the amount of any contributions made by your employer that are excludable from your income. This includes amounts contributed to your account by your employer through a cafeteria plan." The Form 8889 instructions add that payroll contributions through a salary reduction agreement (a cafeteria plan) "are treated as employer contributions and are not included on line 2". The Contributions tab therefore splits the total into line 2 (you and others) and line 9 (employer and payroll) of Form 8889. Rollovers from another HSA are not contributions and are left out of the limit.

Prior-year deposits: the Form 8889 instructions allow contributions "for 2025 made in 2026 by the unextended deadline for filing your 2025 federal income tax return, April 15, 2026". Type the tax year on those rows; a prior-year deposit dated after 15 April gets a warning.

Going over the limit

Pub. 969: "Generally, you must pay a 6% excise tax on excess contributions", for each year the excess stays in the account. You can avoid it on the amount withdrawn if you take out the excess and its earnings "by the due date, including extensions, of your tax return for the year the contributions were made". The flag tells you which deposit crossed the line; the fix is between you and your HSA provider.

Qualified expenses and the HSA opened date

IRS Publication 502 defines the base: "Medical expenses are the costs of diagnosis, cure, mitigation, treatment, or prevention of disease and for the purpose of affecting any part or function of the body." It also says they "don't include expenses that are merely beneficial to general health, such as vitamins or a vacation". For HSAs, two additions came with the CARES Act; the IRS release IR-2020-122 says "the cost of menstrual care products is now reimbursable" and "over-the-counter products and medications are now reimbursable without a prescription".

The date matters too. Pub. 969: "For HSA purposes, expenses incurred before you establish your HSA aren't qualified medical expenses. State law determines when an HSA is established." Bills dated before the opened date on Settings are marked Before HSA opened and kept out of the receipts bank.

Reimbursing yourself later: the receipts bank

You don't have to take money out the year you pay a bill. Pub. 969 says "You don't have to make withdrawals from your HSA each year", and IRS Notice 2004-50, Q&A 39, is direct: a distribution "can be used to pay or reimburse expenses incurred in any prior year as long as the expenses were incurred after the HSA was established. Thus, there is no time limit on when the distribution must occur."

The condition is records. Pub. 969: "You must keep records sufficient to show that: The distributions were exclusively to pay or reimburse qualified medical expenses, The qualified medical expenses hadn't been previously paid or reimbursed from another source, and The medical expenses hadn't been taken as an itemized deduction in any year." So the receipts bank counts a bill only when it is qualified, paid out of pocket, dated on or after the HSA opened, has a saved receipt and is not yet reimbursed. Bills without a receipt show in their own total until you find one.

Non-qualified withdrawals

Pub. 969: "There is an additional 20% tax on the part of your distributions not used for qualified medical expenses", on top of income tax. "There is no additional tax on distributions made after the date you are disabled, reach age 65, or die." Log a non-medical withdrawal with the Non-qualified withdrawal category; the Summary totals it by year.

The formulas, explained

Exact formulas from the file (row 10 on Settings, row 8 on the logs, row 15 for the first year on Summary). On Contributions, A is the date, B the optional tax year, C the source, D the amount and K the row check. On Expenses, A is the date of service, D the category, E the amount, F paid from, G receipt saved, I reimbursed, J the reimbursement date and L the row check.

FieldFormula
Settings: your limit (I10)=IF(J10<>"OK","",IF(D10="Yes",G10+H10,ROUND((G10+H10)*E10/12,2)))
Settings: IRS limit used (G10)=IF(J10<>"OK","",IF(B10="Family",INDEX($C$23:$C$30,MATCH(A10,$A$23:$A$30,0))*IF(F10="",1,F10),INDEX($B$23:$B$30,MATCH(A10,$A$23:$A$30,0))))
Contributions: tax year used (F8)=IF(K8<>"OK","",IF(B8<>"",B8,YEAR(A8)))
Contributions: counts toward limit (G8)=IF(K8<>"OK",0,IF(INDEX(Settings!$B$34:$B$41,MATCH(C8,Settings!$A$34:$A$41,0))="Yes",D8,0))
Contributions: running total for the tax year (H8)=IF(K8<>"OK","",SUMIFS(G$8:G8,F$8:F8,F8))
Contributions: limit flag (J8)=IF(K8<>"OK","",IF(I8="","Add "&F8&" on Settings",IF(H8>I8+0.005,"Over limit",IF(AND(F8<YEAR(A8),A8>DATE(YEAR(A8),4,15)),"After 15 Apr: check deadline",""))))
Contributions: status (E4)=IF(B4="","Add "&B3&" on Settings (check must say OK)",IF(B5>B4+0.005,"Over limit by "&TEXT(B5-B4,"$#,##0.00"),IF(B5>=B4-0.005,"At the limit","Within limit")))
Expenses: qualified, out of pocket, receipt saved (N8)=IF(AND(L8="OK",F8="Out of pocket",G8="Yes"),IF(INDEX(Settings!$F$34:$F$53,MATCH(D8,Settings!$E$34:$E$53,0))="Yes",E8,0),0)
Expenses: receipts bank, not yet reimbursed (O8)=IF(I8="Yes",0,N8)
Expenses: HSA distribution (Q8)=IF(OR(L8="OK",L8="Before HSA opened"),IF(OR(F8="HSA",I8="Yes"),E8,0),0)
Expenses: non-qualified distribution (S8)=IF(N(Q8)=0,0,IF(L8="Before HSA opened",Q8,IF(INDEX(Settings!$F$34:$F$53,MATCH(D8,Settings!$E$34:$E$53,0))="Yes",0,Q8)))
Summary: receipts bank at year end (K15)=IF($A15="","",SUMIFS(Expenses!$N$8:$N$507,Expenses!$M$8:$M$507,"<="&$A15)-SUMIFS(Expenses!$N$8:$N$507,Expenses!$I$8:$I$507,"Yes",Expenses!$R$8:$R$507,"<="&$A15))
Summary: book balance at year end (L15)=IF($A15="","",N(Settings!$B$5)+SUMIFS(Contributions!$D$8:$D$307,Contributions!$K$8:$K$307,"OK",Contributions!$M$8:$M$307,"<="&$A15)-SUMIFS(Expenses!$Q$8:$Q$507,Expenses!$R$8:$R$507,"<="&$A15))
Investments: latest snapshot in its year (H8)=IF(I8<>"OK","",IF(COUNTIFS($G$8:$G$67,G8,$J$8:$J$67,">"&A8)=0,1,0))
Investments: projection end balance (P10)=M10+N10+O10

Your limit. INDEX/MATCH looks up the IRS figure for the year and coverage; family limits are multiplied by your share when spouses split one. If you were eligible on 1 December you get the full figure plus catch-up; otherwise the total × months ÷ 12, rounded to cents.

Running total and flag. Each counted deposit adds to a SUMIFS from the first row down to its own row for the same tax year, so the flag lands on the deposit that crossed the limit, in the order you typed them.

Receipts bank at year end. Every bank-eligible bill up to that year, minus the ones reimbursed by the end of that year. A bill from 2025 reimbursed in 2026 is in the 2025 year-end bank and out of the 2026 one.

Book vs statement. Book balance = opening balance + money in − money out. The statement column shows the latest snapshot you typed in that year; the gap is investment gains or losses, fees and timing.

Worked example from the sample data

The fictional family has family HDHP coverage, opened the HSA on 6 Jan 2025 and the account holder turns 55 in 2026. Everything below comes from the Example tabs.

Limits and contributions

2025: family limit $8,550, no catch-up. Deposits counted for 2025 total $7,100.00, including a $2,500 personal deposit made on 10 Mar 2026 with tax year 2025 typed in, so $1,450.00 of room went unused.

2026: $8,750 + $1,000 catch-up = $9,750. Counted so far: $9,000.00 (Form 8889 line 9, payroll and employer: $5,000; line 2, personal: $4,000), leaving $750.00. Payroll puts in $400 a month; two more deposits in November and December would bring the total to $9,800, $50 over the limit. That is the moment to lower the payroll election, not April.

The receipts bank

These out-of-pocket bills have a saved receipt and have not been reimbursed, so the family can pay itself back from the HSA in any later year:

Date of servicePatientCategoryAmount
22 Jan 2025AlexDoctor & specialist visits$145.00
14 Apr 2025JordanVision & eyeglasses$320.00
23 Jul 2025JordanTherapy & mental health$95.00
27 Aug 2025MiaDental$1,450.00
15 Sep 2025JordanMenstrual care products$18.75
8 Jan 2026JordanDoctor & specialist visits$150.00
3 Mar 2026MiaVision & eyeglasses$185.00
11 May 2026AlexTherapy & mental health$130.00
25 May 2026AlexTherapy & mental health$130.00
4 Aug 2026MiaOver-the-counter medicine$31.48
22 Oct 2026JordanMedical equipment & supplies$89.99
Total$2,745.22

Three bills are left out on purpose. The $180 dental bill from 12 Dec 2024 predates the HSA. Two out-of-pocket bills ($199.99 in total) have no receipt yet, so they sit in the missing receipt total. And the $1,980 hospital bill from 30 Oct 2025 was reimbursed on 12 Jan 2026: it was in the 2025 year-end bank ($4,008.75) and left it in 2026.

Year by year

YearContributionsLimitDistributionsNon-qualifiedReimbursed to youReceipts bank, 31 DecBook balanceStatement (latest)
2025$7,100.00$8,550.00$810.90$0.00$210.00$4,008.75$3,789.10$4,099.10
2026$9,000.00$9,750.00$3,041.30$60.00$2,590.00$2,745.22$12,247.80$12,847.80

The $60 gym fee paid with the HSA card on 20 Aug 2026 shows as a non-qualified distribution for 2026. The statement balance of $12,847.80 on 30 Sep 2026 is $600.00 above the book balance: fictional investment gains.

Cash, investments and the projection

On 30 Sep 2026 the account holds $3,400 in cash, equal to the $3,400 cash target (the family's deductible in this example), and $9,447.80 invested. The projection starts from the latest balance of $12,847.80, adds $9,000 a year at an example return of 5%:

End of yearTotal put inGrowthProjected balance
2031$57,848$8,280$66,128
2036$102,848$31,281$134,129
2046$192,848$138,835$331,683
2056$282,848$370,629$653,477

The return is an input you choose, not a forecast. Real returns vary, can be negative for years, and fees reduce them. Change the inputs to see how sensitive the result is.

Common mistakes

Limits

FAQ

How do I keep track of HSA receipts?

Log every medical bill in one place with the date of service, provider, patient, amount, whether the HSA or you paid, and whether you have reimbursed yourself. Save each receipt as a file with a consistent name (for example 2026-03-03_clear-view_mia.pdf) and type that name next to the bill. IRS Publication 969 says you must keep records sufficient to show that distributions were exclusively to pay or reimburse qualified medical expenses, that the expenses hadn't been paid or reimbursed from another source, and that they hadn't been taken as an itemized deduction.

Is there a time limit to reimburse yourself from an HSA?

No time limit is set, as long as the expense was incurred after the HSA was established. IRS Notice 2004-50 (Q&A 39) says a distribution in the current year "can be used to pay or reimburse expenses incurred in any prior year as long as the expenses were incurred after the HSA was established. Thus, there is no time limit on when the distribution must occur." You still need the records to prove it, which is why the receipts bank counts only bills with a saved receipt.

What is the HSA contribution limit for 2026?

For 2026 the limit is $4,400 for self-only HDHP coverage and $8,750 for family coverage (Rev. Proc. 2025-19). For 2027 it is $4,500 and $9,000 (Rev. Proc. 2026-24). If you are 55 or older at the end of the tax year, add $1,000. If you were not an eligible individual all year and not on 1 December, the limit is prorated by the months you were eligible.

Do employer contributions count toward the HSA limit?

Yes. Pub. 969 says you must reduce the amount you or any other person can contribute by the employer contributions that are excludable from your income, including amounts contributed through a cafeteria plan. That is why the Contributions tab adds payroll, employer and personal deposits together; only rollovers from another HSA are left out.

What happens if I use my HSA for non-medical expenses?

The amount is added to your income and, under Pub. 969, there is an additional 20% tax on the part of your distributions not used for qualified medical expenses. The 20% does not apply to distributions after you are disabled, reach age 65, or die. The spreadsheet totals non-qualified distributions by year so they are easy to find for Form 8889.

Can I use this HSA tracker in Google Sheets?

Yes. In Google Sheets choose File → Import → Upload and pick the .xlsx, or upload it to Google Drive and open it with Google Sheets. The formulas use IF, AND, OR, NOT, N, INT, ISNUMBER, IFERROR, COUNTA, COUNT, COUNTIF, COUNTIFS, SUMIFS, SUMPRODUCT, SUM, MAX, LEN, LEFT, TEXT, ROUND, INDEX, MATCH, DATE, YEAR and TODAY, which work in Excel 2016+, Google Sheets and LibreOffice. No macros, no dynamic arrays.

Related tools and templates

Educational template only, not tax, legal or financial advice. Example data is fictional: the family, providers, amounts, balances and returns are made up to show the formulas. IRS figures come from Publication 969 (2025), Rev. Proc. 2025-19 and Rev. Proc. 2026-24; IRS material was retrieved on 3 November 2026. Rules can change; check IRS.gov or a tax professional for your situation.