Skip to main content

1099 Value Add — How Your 1099 Report Is Built

This article explains exactly how the 1099 Value Add is generated, including where each data point comes from, how it’s calculated, and what you can customize.

Updated over 2 weeks ago

The 1099 Value Add is designed to help clients understand which tax forms they should expect, why they’re receiving them, and what data was used to generate the report.

This article walks through every section of the 1099 Value Add, explains where each value comes from, and outlines what is automatic vs. customizable.


What Is the 1099 Value Add?

The 1099 Value Add is a client-facing summary that:

  • Lists applicable accounts for tax reporting

  • Shows which tax forms may be issued (1099, 1099-R, etc.)

  • Highlights estimated tax payments made during the year

  • Provides helpful tax-season reminders and firm-specific messaging

It is generated automatically using household, account, and transaction data, with optional firm-level customization.


1. Header & Branding

Logo

  • Pulled from your firm’s saved company logo

  • Editable under Settings → Firm Settings

  • If no logo is saved, the report displays without one

Branding Color

  • Uses your firm’s branding color

  • Default color is a dark navy

  • Controls header backgrounds and accent elements

Report Title

  • Default title: “1099 Report”

  • Can be customized at the firm level

  • Can be customized under Settings → Value Adds → 1099


2. Reported “As-Of” Date

The Reported As-Of Date reflects the most recent valuation date found across all household accounts.

How it’s determined

  • The system scans all accounts in the household

  • It checks multiple possible “as-of” date fields, including aggregator data

  • The latest valid date found is used

  • If no dates exist, today’s date is used as a fallback

Display format

  • MM/DD/YYYY (U.S. format)

This date is fully automatic and cannot be manually edited. To change this date, you would have to update the 'as of date' field on every account within that household.


3. Tax Year

The tax year controls which year’s data appears in the report.

Auto Mode (default)

  • Uses an April 15 cutoff

  • Before April 15 → previous tax year

  • On or after April 15 → current tax year

Example

  • January 7, 2026 → Tax Year = 2025

  • April 20, 2026 → Tax Year = 2026

Manual Mode

  • Firm can explicitly set the tax year

  • Overrides automatic logic

Editable under Settings → Value Adds → 1099 Settings


4. Client & Advisor Information

Client Name Line

  • Pulled from all clients linked to the household

  • Displayed as:
    First Name Last Name (Age)

  • Multiple clients are comma-separated

Advisor Line (Appears in Footer)

  • Displays assigned lead advisor(s)

  • If none are assigned, the disclaimer will clearly note:
    “NO ADVISORS ASSIGNED”


5. Intro Text

This introductory paragraph appears near the top of the report.

Customization

  • Fully editable at the firm level

  • Supports dynamic variables such as:

    • Firm name

    • Tax year

    • Estimated tax payments

    • Advisor name(s)

Default Message

“Here’s a list of your accounts with our firm and the tax forms you may receive for your tax return. Please note we may not have tax details for every account.”


6. Accounts Table

This table lists investable accounts and the tax forms clients may receive.

Columns Explained

  • Account – Account number or identifier

  • Type – Account type (IRA, brokerage, trust, etc.)

  • Owner – Individual name or “Joint”

  • Custodian – Custodian listed on the account

  • Form – Expected tax form

  • Notes – Advisor-entered notes (never auto-generated)


Which Accounts Are Included?

Included account types generally fall into:

  • Taxable / brokerage accounts

  • Retirement accounts (IRA and non-IRA)

  • Annuities

  • Other investable account types

Which Accounts Are Excluded?

Certain account types never appear in the 1099 Value Add, including:

  • HSAs

  • 529 plans

  • ESAs

  • Donor-advised funds

  • FSAs

  • Checking, savings, money markets, and CDs

These exclusions follow IRS reporting rules.


How the “Form” Column Is Determined

The form shown follows a strict priority:

  1. Manual override (if entered)

  2. Special Roth IRA logic

  3. System default by account type

Roth IRA Special Rules

  • No withdrawals → no form shown

  • Any withdrawals during the tax year → 1099-R

Withdrawals are detected using:

  • Systematic withdrawals

  • One-time withdrawal transactions within the tax year

Default Form Logic (Examples)

  • Taxable brokerage → 1099

  • Traditional / SEP / SIMPLE IRA → 1099-R

  • Employer plans (401k, 403b, etc.) → 1099-R

  • Annuities → 1099-R

If no form applies, the report displays ---.


7. Estimated Tax Payments Table

This section shows estimated tax payments made during the tax year.

What Appears

  • Account used for payment

  • Date of payment

  • Payment amount

  • Total of all payments at the bottom

Where the Data Comes From

  • One-time transactions marked as Estimated Tax Payments

  • Transaction date must fall within January 25 of the selected tax year through January 24 of the following year

Visibility Rules

  • If no estimated payments exist, this entire section is hidden


8. Tax Season Reminders

This section provides helpful tax-season guidance for clients.

Features

  • Fully customizable bullet points

  • Supports dynamic variables (tax year, totals, advisor name)

  • Defaults include reminders about:

    • 1099 availability timelines

    • Multiple forms arriving separately

    • Online delivery vs mail

    • Corrected 1099s

    • Form 5498 for IRAs


9. Closing Remarks

  • Optional closing message from the firm

  • Fully customizable

  • Supports the same dynamic variables as the intro and reminders

If left blank, this section does not appear.


10. Footer & Disclaimer

Footer

Displays firm contact details:

  • Address

  • Phone number

  • Website

Disclaimer

The disclaimer is built dynamically and includes:

  1. Lead advisor names

  2. Firm-specific disclaimer text

  3. Standard compliance language

If no advisors are assigned, the disclaimer explicitly states that.


In Summary

The 1099 Value Add is:

  • Automatically generated

  • Rules-based and consistent

  • Firm-customizable

  • Transparent by design

Every value shown can be traced back to a specific data source, rule, or configuration—ensuring clarity for advisors, clients, and compliance teams alike.

Did this answer your question?