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.
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-down | Basis (tax-free later)? | Counts toward the $5,000 limit? |
|---|---|---|
| Parent or family (after-tax) | Yes | Yes |
| Paycheck, pre-tax (Section 125) | No | Yes |
| Employer (Section 128) | No | Yes |
| Charity or foundation | No | No |
| Federal $1,000 pilot | No | No |
| State or local government | No | No |
| Rollover from another Trump Account | Basis carries over | No |
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
- On the Summary tab, type each child’s name and birth date; the workbook works out the year they turn 18.
- On the Deposit Log, add a row for every deposit and pick its source from the drop-down.
- 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.
- Check the annual limit table on the Summary tab whenever you add a deposit.
- Once a year, update the account value on the Summary tab from the latest statement.
- Before a conversion, open the Totals tab and type the amount you are considering in row 21.
- 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.
References & Resources
- 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.
- 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.