Limited-Release Version
About Tax Supplement Toolkit
Fund-company tax supplement data, organized into practical worksheet calculations.
App version v6.03.09-dev · Data version 2025-data-r009
A practical starting point for fund tax workpapers
Tax Supplement Toolkit helps turn fund-company tax supplement percentages into consistent worksheet calculations. The current development version supports U.S. government obligation / PIQGO, municipal state or territory, and Foreign Source Income calculations, while also using other included tax data to help recognize funds across worksheet categories.
The tool is designed to organize published source information and the arithmetic that follows from it. It does not determine the final tax treatment of an amount, interpret every state rule, or replace review of the fund company’s source material.
Using a worksheet
Start with an internal Worksheet ID, choose the tax year and worksheet type, then search by ticker or fund name. After selecting the fund, enter the amount requested by the active worksheet and calculate it. USGO / PIQGO and Foreign Source Income share the ordinary-dividend amount; Municipal uses a separate exempt-interest-dividend amount. Review the result, any source notes, and the printable workpaper before using the amount in a return.
- Select the fund result that matches the taxpayer’s holding.
- Enter the amount to which the published percentage should be applied.
- Calculate only after every non-empty row is complete.
- Use the workpaper as support, not as a substitute for source-document or state-law review.
Understanding fund matches
A Selected fund is a fund identity the user selected with sufficient Toolkit context to carry it as a confirmed worksheet fund. Funds listed in included Toolkit tax source data remain Selected even when the worksheet currently open has no reported percentage. The “Listed in … source data” line shows the included tax-data categories in which that fund is known; it confirms source presence, not calculability.
A fund identified only from SEC registration reference data remains a Recognized fund when the Toolkit cannot make a definitive statement about the selected company/year/category coverage. If the SEC identity confidently identifies a fund family whose selected company/year/category source is explicitly marked complete, the fund may be carried as Selected and the Result field can state that it was not reported by that fund company for the year. A placeholder or unresolved entry remains non-calculating.
Identity belongs in the fund card; worksheet-specific tax-data availability belongs in the Result column. A selected fund can therefore be confidently recognized even when a particular tax percentage was blank or not reported.
What these worksheets do not decide
This toolkit does not verify Form 1099 amounts, decide whether a state permits a subtraction, apply state-specific thresholds, or select a reporting position. Coverage is limited to the source documents and tax years currently bundled with the application, and fund-company reporting formats vary.
Review the applicable fund-company materials and state guidance before relying on a final treatment. The calculator’s output is a workpaper aid, not tax advice.
Please keep personally identifiable information (PII) out of the worksheets
Please use only internal worksheet or job identifiers as Worksheet IDs. Do not enter client names, Social Security numbers, addresses, email addresses, phone numbers, account numbers, or other personally identifiable information.
Sending useful feedback
For a display or workflow issue, describe what you were trying to do, what happened, and what you expected. For a missing fund or data issue, include the tax year, fund company, fund name, ticker, worksheet type, and a source document or link when available. Screenshots are useful when they contain no client information.