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.
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.
| Date of service | Provider | Patient | Category | Amount | Paid from | Receipt saved? | Reimbursed? | Receipts bank |
|---|---|---|---|---|---|---|---|---|
| 3 Mar 2026 | Clear View Optical | Mia | Vision & eyeglasses | $185.00 | Out of pocket | Yes | No | $185.00 |
| 21 Apr 2026 | City Pharmacy | Jordan | Prescriptions | $56.30 | HSA | Yes | ||
| 11 May 2026 | Harbor Counseling | Alex | Therapy & mental health | $130.00 | Out of pocket | Yes | No | $130.00 |
| 25 May 2026 | Harbor Counseling | Alex | Therapy & mental health | $130.00 | Out of pocket | Yes | No | $130.00 |
| 30 Jun 2026 | Northside Imaging | Jordan | Lab tests & imaging | $610.00 | Out of pocket | Yes | Yes | |
| 4 Aug 2026 | Corner Drugstore | Mia | Over-the-counter medicine | $31.48 | Out of pocket | Yes | No | $31.48 |
| 20 Aug 2026 | FitLife Gym | Alex | Non-qualified withdrawal | $60.00 | HSA | Yes | ||
| 14 Sep 2026 | QuickCare Urgent Care | Alex | Doctor & specialist visits | $175.00 | Out of pocket | No | No | |
| 6 Oct 2026 | Kids First Pediatrics | Mia | Doctor & specialist visits | $95.00 | HSA | Yes | ||
| 22 Oct 2026 | HomeCare Supply | Jordan | Medical equipment & supplies | $89.99 | Out of pocket | Yes | No | $89.99 |
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.
| Year | Self-only limit | Family limit | Catch-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,600 | Pub. 969 (2025) |
| 2026 | $4,400 | $8,750 | $1,000 | $1,700 / $3,400 | $8,500 / $17,000 | Rev. Proc. 2025-19 |
| 2027 | $4,500 | $9,000 | $1,000 | $1,750 / $3,500 | $8,700 / $17,400 | Rev. 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
| Tab | What you type | What it calculates |
|---|---|---|
| Start here | Nothing | Steps, the IRS rules the formulas follow, colour key, limits, disclaimer |
| Settings | HSA 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 |
| Contributions | Up to 300 deposits: date, tax year (only for 1 Jan to 15 Apr deposits for last year), source (payroll, employer, personal, other person, rollover), amount | Limit, 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 & receipts | Up to 500 bills: date of service, provider, patient, category, amount, paid from HSA or out of pocket, receipt saved, receipt file name, reimbursed, reimbursement date | Receipts bank (qualified, out-of-pocket, receipt saved, not yet reimbursed), missing receipts, bills before the HSA opened, distributions and non-qualified distributions |
| Investments | Statement snapshots (cash and invested), a cash target, and projection inputs: start, yearly contribution, expected return | Latest balance, invested share, cash vs target, a 30-year growth table and chart |
| Summary | Nothing | By 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 filled | 29 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:
| Category | Qualified? | What goes here |
|---|---|---|
| Doctor & specialist visits | Yes | Office visits, urgent care, telehealth |
| Dental | Yes | Cleanings, fillings, orthodontics (not teeth whitening) |
| Vision & eyeglasses | Yes | Eye exams, glasses, contact lenses |
| Prescriptions | Yes | Prescribed drugs and insulin |
| Over-the-counter medicine | Yes | No prescription needed since 2020 (CARES Act, IR-2020-122) |
| Menstrual care products | Yes | Tampons, pads, liners, cups (CARES Act) |
| Hospital & surgery | Yes | Not cosmetic surgery (Pub. 502) |
| Lab tests & imaging | Yes | Blood tests, X-rays, MRI |
| Therapy & mental health | Yes | Physical therapy, psychologist, psychiatrist |
| Medical equipment & supplies | Yes | Crutches, bandages, blood pressure monitor |
| Allowed insurance premiums | Yes | Only LTC, COBRA, coverage on unemployment, Medicare 65+ (Pub. 969) |
| Other qualified (Pub. 502) | Yes | Check Pub. 502 before you use this |
| Non-qualified withdrawal | No | Taxable; 20% additional tax unless 65+, disabled or death |
How to use it
- Open Settings. Type the date your HSA was opened (your provider's records show it). Expenses before that date never count as qualified.
- 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.
- 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.
- 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.
- 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.
- When you pay yourself back from the HSA, set Reimbursed? to Yes and type the date. The bill leaves the receipts bank.
- 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.
| Field | Formula |
|---|---|
| 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 service | Patient | Category | Amount |
|---|---|---|---|
| 22 Jan 2025 | Alex | Doctor & specialist visits | $145.00 |
| 14 Apr 2025 | Jordan | Vision & eyeglasses | $320.00 |
| 23 Jul 2025 | Jordan | Therapy & mental health | $95.00 |
| 27 Aug 2025 | Mia | Dental | $1,450.00 |
| 15 Sep 2025 | Jordan | Menstrual care products | $18.75 |
| 8 Jan 2026 | Jordan | Doctor & specialist visits | $150.00 |
| 3 Mar 2026 | Mia | Vision & eyeglasses | $185.00 |
| 11 May 2026 | Alex | Therapy & mental health | $130.00 |
| 25 May 2026 | Alex | Therapy & mental health | $130.00 |
| 4 Aug 2026 | Mia | Over-the-counter medicine | $31.48 |
| 22 Oct 2026 | Jordan | Medical 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
| Year | Contributions | Limit | Distributions | Non-qualified | Reimbursed to you | Receipts bank, 31 Dec | Book balance | Statement (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 year | Total put in | Growth | Projected 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
- Forgetting employer and payroll money. The limit covers all deposits, not just the ones you make yourself.
- Counting a year from 1 January when you started mid-year. Either use the months-eligible proration or stay eligible through the full testing period.
- Reimbursing a bill from before the HSA opened. It is not a qualified medical expense, so the withdrawal is taxable.
- Losing receipts. No receipt, no proof. Name the file the same way every time and keep a backup copy outside your email.
- Reimbursing the same bill twice, or claiming it as an itemized deduction as well. Mark it reimbursed the day the money moves.
- Using the HSA card for general health items. Pub. 502 excludes things "merely beneficial to general health"; gym fees are a common example.
Limits
- One account holder per file. Spouses with separate HSAs use one copy each and split a family limit with the share column.
- When you were not eligible on 1 December, it assumes the same coverage type in each eligible month; if you switched between self-only and family, use the Form 8889 worksheet.
- It does not cover Archer MSA reductions, qualified HSA funding distributions from an IRA, or Medicare months beyond what you type as months eligible.
- Distributions are dated by the service date for HSA-paid bills and the reimbursement date for reimbursements; your Form 1099-SA is the official figure.
- Recalculation was tested in LibreOffice; the file uses only functions that also exist in Excel 2016+ and Google Sheets.
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
- Budget spreadsheetPlan the money that funds the HSA
- Emergency fund trackerMonths of expenses covered
- Retirement planner spreadsheetWhere an invested HSA fits later
- Sinking funds trackerSave ahead for known costs
- Expense tracker spreadsheetEvery expense by category
- All templatesFree spreadsheets
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.