Early Life Investments, LLC
Follow on X
Early Life Investments
Early Life Investments
A Family Financial Head Start

“The best time to build lifelong money habits is when you are young. The second-best time is today.”

Educational only: The author of Early Life Investments is not a Certified Financial Planner. The content here reflects the author's personal opinions and experience and is for general educational purposes only. Read the full disclaimer.

Workbook — Trump Accounts · Created November 14, 2026 · 4 min read

Trump Account Basis Tracker

Which dollars come out tax-free, which are taxed, and what a conversion will cost your child.

Money goes into a Trump Account from up to six different places, and the IRS treats them differently when your child converts the account to a Roth IRA after 18. Only the after-tax money you and your family put in comes out tax-free. This workbook records every deposit by source, keeps that tax-free share in view, and shows what any conversion would add to your child’s taxable income.

Download: TrumpAccountBasisTracker.xlsx — free, no email required, and it opens in Excel, Numbers or Google Sheets.

What This Workbook Does

  • A deposit log for up to three children, with a drop-down for where each dollar came from and a column for where you saved the proof.
  • Automatic marking of which deposits are basis — after-tax money that comes out tax-free — and which count toward the $5,000 yearly limit.
  • An annual limit check that turns a year red when family, employer and paycheck deposits go over the limit.
  • A Totals tab that splits each account by type of money and shows what share is tax-free.
  • A conversion preview: type an amount and see how much of it would be tax-free and how much would be taxable income for your child.
  • A conversion log for the years after 18 that tracks how much basis is left.

Which Deposits Are Basis

The drop-down uses the categories the IRS uses. Here is how each one is treated:[1][2]

Source in the drop-downBasis (tax-free later)?Counts toward the $5,000 limit?
Parent or family (after-tax)YesYes
Paycheck, pre-tax (Section 125)NoYes
Employer (Section 128)NoYes
Charity or foundationNoNo
Federal $1,000 pilotNoNo
State or local governmentNoNo
Rollover from another Trump AccountBasis carries overNo

Investment growth — interest, dividends and gains — is never basis. The paycheck and employer rows together are capped at $2,500 a year per employee, not per child, and only if the employer has set up a Trump Account contribution program.[2]

How to Use It

  1. On the Summary tab, type each child’s name and birth date; the workbook works out the year they turn 18.
  2. On the Deposit Log, add a row for every deposit and pick its source from the drop-down.
  3. In the Receipt column, note where the proof is saved: bank confirmations for family deposits, box 12 code TA on your W-2 for employer and paycheck money, and the account statement for anything else.
  4. Check the annual limit table on the Summary tab whenever you add a deposit.
  5. Once a year, update the account value on the Summary tab from the latest statement.
  6. Before a conversion, open the Totals tab and type the amount you are considering in row 21.
  7. After each conversion, log it on the Conversion Log and update the account value.

An example. The sample rows in the workbook add up to $2,000 of family deposits, $1,000 of pre-tax paycheck money, $250 from an employer and $250 from a foundation. With $150 of growth, the account is worth $3,650.

Basis is $2,000 of the $3,650, or about 55%. Convert $1,000 and about $548 comes out tax-free; the other $452 is taxable income to your child that year. Every later conversion uses the basis that is left.

What It Will Not Do

The split is an estimate. It uses the account value you enter, and the official taxable amount is figured on your child’s tax return for the year of the conversion. Treasury and the IRS have said more guidance is coming on how basis is allocated, so treat the numbers as a planning check and confirm them with a tax preparer before a large conversion.[1] The workbook also cannot see the $2,500 Section 128 cap across several children, because that limit follows the parent’s paycheck, not the account.

Every workbook on this site is free. The full set — budgeting, debt, career, real estate and the kids’ sheets — is on the Worksheets & Planners page.
Where to go next: 529 vs. Custodial vs. Roth vs. Trump Account — when the Trump Account is the right home for a dollar, and the pre-tax payroll route; the account picker — which account fits the dollar in your hand today; Roth IRA for Kids — where converted money ends up.

References & Resources

  1. IRS Notice 2025-68: Guidance on Trump Accounts — Contribution sources, which contributions create basis, which count toward the $5,000 annual limit, the proportional split of basis in conversions and withdrawals, and further guidance still to come.
  2. Treasury and IRS: Proposed regulations on employer contributions to Trump Accounts (REG-101355-26), Federal Register, August 11, 2026 — Section 128 employer contributions and pre-tax paycheck deposits through a Section 125 cafeteria plan, the $2,500 per-employee limit, and W-2 reporting.

Rules are as of November 2026 and subject to change; confirm current figures with the IRS or a qualified professional.