U.S. Treasury Obligation State Tax Exemption
Updated: 5 hours ago
TL;DR — Too Long; Didn’t Read
If your clients hold funds like SNSXX, SGUXX, IEF, IEI, SCHP, SCHO, SCHR, or SCHQ in taxable accounts, a portion of their dividend income may be exempt from state income tax — but it won’t show up on their 1099. Schwab doesn’t break it out. You have to find it, calculate it, and give it to their tax preparer — or at the very least, make them aware. This guide tells you exactly how.
Understanding the Gap
Many mutual funds and ETFs hold U.S. Treasury obligations as part of their portfolio. The income these funds distribute to shareholders is fully taxable at the federal level — but in most states, the portion of that income derived from U.S. government obligations is exempt from state income tax.
The problem is that this exemption does not appear on the 1099. The line item for “Interest on U.S. Savings Bonds and Treasury Obligations” shows $0 for these funds because they are funds holding Treasuries, not direct Treasury bonds. The pass-through exemption requires a separate calculation using supplemental data that fund companies publish each year.
Which custodians break this out on the 1099?

This is not an industry-wide gap — it is specific to the custodians fee-only RIAs tend to use. Schwab is the primary outlier. Their Supplemental Tax Information document is published at schwabassetmanagement.com each year, typically in early February.
Qualifying Funds to Watch
The following funds are commonly held in client portfolios and have meaningful U.S. government obligation percentages. This is not an exhaustive list — refer to the Schwab Supplemental Tax Information document and equivalent reports from BlackRock, Vanguard, and others for a complete listing each year.
• SWRSX — Schwab Treasury Inflation Protected Securities Index Fund — 100.00%
• SNSXX / SUTXX — Schwab U.S. Treasury Money Market Fund — 99.99%
• SCHP — Schwab U.S. TIPS ETF — 100.00%
• SCHO — Schwab Short-Term U.S. Treasury ETF — 100.00%
• SCHR — Schwab Intermediate-Term U.S. Treasury ETF — 100.00%
• SCHQ — Schwab Long-Term U.S. Treasury ETF — 100.00%
• SWSBX — Schwab Short-Term Bond Index Fund — 67.97%
• SWAGX — Schwab U.S. Aggregate Bond Index Fund — 44.06%
• SWGXX / SNVXX / SGUXX — Schwab Government Money Fund — 36.20%
• SGVT — Schwab Government Money Market ETF — 36.66%
• SCHZ — Schwab U.S. Aggregate Bond ETF — 44.18%
• IEF — iShares 7-10 Year Treasury Bond ETF — ~100%
• IEI — iShares 3-7 Year Treasury Bond ETF — ~100%
• SGOV — iShares 0-3 Month Treasury Bond ETF — ~100%
Percentages are from the 2025 Schwab Supplemental Tax Information document. iShares percentages are approximate — confirm with BlackRock’s supplemental report for exact figures. Percentages change annually.
How to Pull the Schwab Positions Report
The first step in identifying impacted accounts is exporting the firm-wide positions report from Schwab Advisor Center. Upon request, Village will grant you access to our screening tool. Follow these steps:
Important Limitation
The Schwab firm-wide positions export described in this guide reflects current holdings only. Accounts that held a qualifying fund during the year and sold out before year-end will not appear. Advisors should cross-reference transaction history to catch any liquidated positions before concluding the review.
Step 1: Export the Positions Report
1. Log in to Schwab Advisor Center and navigate to the Positions tab.
2. Select the firm level or master account level view, depending on how your firm is set up.
3. Switch to the Securities view.
4. Export the entire list. This will be uploaded into the Village screening tool to generate a PDF showing all impacted positions.
Step 2: Export the Account Level Positions Report
5. Navigate to the Accounts level in Schwab Advisor Center and export the positions data.
6. Open the exported spreadsheet. Add a new column with this formula to truncate account numbers to the last 4 digits only — do not upload full account numbers:
=RIGHT(A9, 4) — where A9 is the first cell containing account numbers. Drag the formula down to apply to all rows.
7. Highlight the new column, copy it, and Paste as Values Only to remove the formula.
8. Delete the original column containing full account numbers.
9. Save the file and upload into the Village screening tool when prompted. The tool will hide rows that do not contain qualifying tickers and filter out retirement accounts, leaving only taxable accounts with impacted positions.
Step 3: Review the Output
10. The tool generates a filtered spreadsheet formatted as a sortable, filterable table.
11. Download the output and share with your advisor for review.
12. Identify which households to prioritize for further review.
Pulling the 1099s
Once impacted households are identified, you’ll need the 1099 for each account to obtain the actual income figures. While Schwab does offer a bulk 1099 export, it is very difficult to cherry-pick only impacted accounts, so 1099s typically need to be downloaded individually per account.
1. In Schwab Advisor Center, navigate to each identified client account.
2. Download the 1099-DIV for the applicable tax year.
3. Note the Box 1a (Total Ordinary Dividends) amount for each qualifying fund held in the account.
4. Upload the 1099s into your chosen analysis tool (Fin Pods AI or MFPCO) for calculation.
Time Saving Tip
For firms with large numbers of impacted accounts, prioritize by balance size first. Accounts with larger positions in qualifying funds will generate the most meaningful state tax savings. Smaller accounts can be assessed in subsequent years once a workflow is established.
Tools for Analysis
Two tools have been validated by the RIA community for calculating state tax exemption amounts. Both serve slightly different purposes — for high-volume users, using both is recommended.
Pricing: $50/month or ~$600/year (2 months free on annual)
Data Input: Upload 1099 directly — AI extracts data automatically
Fund Database: ~5,000 funds; growing based on demand
Bulk Upload: Yes — 50+ 1099s at once; bulk export enhancement coming
Output: PDF + Excel work papers with source page citations
Security: SOC 2 Type 2, AWS-only, no external AI/LLMs, burn-after-read, zero-access sharing, post-quantum secure
Best for: High volume firms, compliance-conscious workflows, audit-ready documentation
Pricing: $150/yr (single user) | $290 (2–5 users) | $430 (6–10) | $570 (11–25) | $710 (26–50) | $850 (51–100)
Data Input: Manual entry of income figures from 1099; ticker lookup now supported
Fund Database: Broader database; industry veteran with deep fund coverage
What It Covers: Direct + indirect federal obligations, state muni percentages, AMT, Corporate DRD, foreign income
Best for: Comprehensive fund coverage, lower volume, budget-conscious firms
Disclosure: Village Financial Services has no financial relationship with either tool and receives no compensation for referrals. These tools were identified through community research and direct evaluation.
Annual CRM Workflow Template
The following task sequence is designed to be added to your CRM (Advyzon, Slant, Wealthbox, etc.) as a recurring annual workflow. Village Fractional CSAs can add this workflow to your CRM on your behalf.
1. Early February — CSA: Pull Schwab firm-wide positions export and run through screening tool to identify accounts with qualifying funds in taxable accounts.
2. Early February — Advisor / CSA: Cross-reference transaction history for accounts that held qualifying funds and sold out during the year (not captured in positions export).
3. Mid February — CSA: Share filtered positions report with advisor for household prioritization.
4. Early February — CSA: Confirm Schwab Supplemental Tax Information document has been published and save to firm file.
5. Mid–Late February — CSA: Pull 1099s for prioritized households from Schwab Advisor Center (manual, per account).
6. Late February — Advisor / CSA: Upload 1099s into Fin Pods AI and/or MFPCO for calculation; download work papers.
7. Late February – March 15 — Advisor: Prepare client communication using tax letter template; attach supplemental document and work paper as backup for tax preparer.
8. By March 15 — Advisor: Send to client and CPA/tax preparer; educate preparer if unfamiliar with the exemption.
9. Upon Completion — Advisor / CSA: Note in client file which funds were reviewed, income amounts, and state exemption calculated. Flag for following year.
10. Q4 / Annual Review — Advisor: Review fund selection annually — consider higher-Treasury-obligation funds or lower-expense alternatives.
How Village Can Help
Village Financial Services partners with independent RIA firms exclusively custodying at Schwab and Altruist to remove administrative burden and build repeatable, scalable processes. Here is what we can do for your firm on this specific workflow:
Pull the Schwab firm-wide positions export and run it through our screening tool to identify impacted accounts — at your request, at no additional charge for current Fractional CSA clients
Manually pull 1099s for prioritized households upon advisor direction
Add the annual CRM workflow template from this guide into your CRM on your behalf
Assist with client communication preparation using the email templates included in our white paper
Help evaluate and onboard Fin Pods AI or MFPCO for your practice
Frequently Asked Questions
Is income from Treasury bond funds exempt from state income tax?
In most states, yes. The portion of a mutual fund or ETF dividend that comes from U.S. Treasury and other U.S. government obligations is generally exempt from state income tax, even though it is fully taxable at the federal level. The exempt portion has to be calculated from the fund company's supplemental tax data, because it usually does not appear on the 1099.
Why doesn't my Schwab 1099 show the U.S. government obligation income?
The funds involved hold Treasuries as part of their portfolio instead of being direct Treasury bonds, so the line for "Interest on U.S. Savings Bonds and Treasury Obligations" shows $0. Custodians like Altruist and Vanguard include the breakdown on the 1099 as a service. Schwab and Fidelity publish supplemental documents instead, which leaves the calculation to advisors and tax preparers.
Where do I find Schwab's Supplemental Tax Information for U.S. government obligations?
Schwab publishes its Supplemental Tax Information document each year at schwabassetmanagement.com, typically in early February. It lists the percentage of each Schwab fund's income that came from U.S. government obligations. BlackRock (iShares), Vanguard, and other fund companies publish their own versions.
Which funds qualify for the U.S. Treasury state tax exemption?
Commonly held funds with high U.S. government obligation percentages include SNSXX, SUTXX, SWRSX, SCHP, SCHO, SCHR, SCHQ, IEF, IEI, and SGOV, and funds like SWSBX, SWAGX, SCHZ, SGVT, and the Schwab Government Money Funds qualify in part. Percentages change every year, so always confirm against the current year's supplemental tax document.
Which states don't allow the Treasury fund state tax exemption?
Most states exempt U.S. government obligation income, but a handful, including California, Connecticut, and New York, require a fund to meet a minimum threshold before the exemption passes through to shareholders. States with no income tax, like Florida and Texas, don't benefit. Always confirm the rules for the client's state of residence.
How do I calculate the state tax exemption on Treasury fund dividends?
Multiply the fund's ordinary dividends from the 1099-DIV (Box 1a) by the fund's U.S. government obligation percentage from the supplemental tax document. Two tools the RIA community uses to do this at scale are Fin Pods AI, which reads uploaded 1099s and produces work papers with source citations, and MFPCO, which uses manual entry and has broad fund coverage.
How do I explain the Treasury obligation state tax exemption to a CPA?
Send the fund company's supplemental tax document along with a work paper showing the calculation. Work papers from Fin Pods AI include source page references, which gives the tax preparer something they can verify independently. Some CPAs aren't familiar with this exemption, so expect to walk them through it the first year.
Can I amend prior year tax returns to claim the Treasury obligation exemption?
It depends on the size of the savings and what it would take to amend. For clients with meaningful positions in high Treasury obligation funds, we've seen $3,000 to $6,000 in annual state tax savings per household, and amending open tax years (generally three years back) can be worth it. For smaller amounts, the expense of amending through a tax preparer may not be justified. Start with the largest positions.
Does Altruist report U.S. government obligation income on the 1099?
Yes. We've confirmed that Altruist includes the U.S. government obligation breakdown directly on the 1099, similar to Vanguard. The advisor's role shifts from calculating it to making sure the tax preparer sees it and applies it.
What if a client sold a Treasury fund before year-end?
They may still qualify for the exemption on income earned while they held it, but they won't appear on Schwab's firm-wide positions export because it only shows current holdings. Cross-reference transaction history for the year and build that step into your annual CRM workflow.
Can a Fractional CSA handle the Treasury obligation review for my firm?
A Village Fractional CSA can pull the Schwab firm-wide positions export, run it through our screening tool, pull 1099s for the households you prioritize, and add the annual workflow to your CRM. The calculations themselves need to be completed by you or your team in Fin Pods AI or MFPCO, since that is outside a CSA's scope.
