Beta testing version

About Tax Supplement Toolkit Beta

Fund-company tax supplement data, organized into practical worksheet calculations.

App version v6.02.06-dev · Data version 2025-data-r003

A practical starting point for fund tax workpapers

Tax Supplement Toolkit helps turn fund-company tax supplement percentages into consistent worksheet calculations. The current beta supports U.S. government obligation / PIQGO and municipal state or territory 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 base amount and calculate the worksheet. Review the result, any source notes, and the printable workpaper before using the amount in a return.

  1. Select the fund result that matches the taxpayer’s holding.
  2. Enter the amount to which the published percentage should be applied.
  3. Calculate only after every non-empty row is complete.
  4. Use the workpaper as support, not as a substitute for source-document or state-law review.

Understanding fund matches

A Selected fund has data that can be used in the worksheet currently open. A Recognized fund is known from included fund-company tax data, but the selected worksheet may not have a reported value for it. The “Found in …” line shows the included tax-data categories in which the fund is known.

An SEC reference fund is a registration-data match used only to help identify the fund; it does not mean a tax supplement value is included. A placeholder or unresolved entry is retained for the workpaper but cannot produce a calculated tax-data result.

It is important to note these fund match types since a fund can exist in one included source or category without appearing—or without receiving a reportable value—in another.

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.