1099Q distribution states does not add up but it does?

[MarilynG1]

If your 1099-Q distribution was entirely used for qualified education expenses (including room and board), you don't need to enter it in TurboTax.  Keep records of what expenses were paid with the distribution.

Here's more detailed info on Form 1099-Q.

@august051981 

[j0mike1993]

Even if you used your ESA distribution for education expenses, you should still enter your 1099Q with expenses especially if you’re receiving any education credit. Turbo Tax calculates your cost basis and earned income every year. You will eventually have to go back and figure out. I do not recommend skipping this step. Your financial institution does not report those amounts on your 1099Q, you get them from your tax return. Years ago turbo tax told me I didn’t have to enter 1099Q since I used distribution for education expenses. When I rolled over, I had to go back and recalculate. 

[MarilynG1]

If you rolled over your some or all of your balance in a 529 plan, your financial institution should be able to tell you your earnings, which is the only amount that may be taxable.

They should also have records of your contributions made (if you don't), which is your Cost Basis.  Box 2 (earnings) and Box 3 (Cost Basis) should add up to Box 1 (Distribution) amounts.

Here's more detailed info on Form 1099-Q.

@j0mike1993

[j0mike1993]

I have been receiving 1099Q’s for distributions for education expenses for over a decade and they have NEVER had an amount for box 2 and 3. In the fall I had to roll one over because my son was turning 30. I researched with Vanguard for hours, and the final answer is they don’t keep track of basis or earnings. All my funds (4 kids) basis’ are calculated on our tax return and forwarded to the next year’s return. The calculation is taken from publication 970 and factors in expenses + taxable amount. There is no way the financial institution would have access to your basis without you annually notifying them. That is why my 1099Q’s box 2 and 3 have always been blank. After rolling over ESA, I had to write a letter to give them my basis from my taxes. Turbo Tax needs to remove the mandatory input for boxes 2 & 3 because I can’t proceed without inputting. I thought I could probably figure out since I’ve been doing my taxes for years, but that’s why I buy Turbo Tax, so they can do the calculations. I’m a little concerned to put in an amount that isn’t on my 1099Q.  

[AmyC]

Many older Coverdell ESA's do not track the basis, it was on your shoulders for years and you were able to send numbers when needed. There have been a lot of nonqualified errors so the program is trying to correct the issue for those not as savvy as you. You have two options:

1. You can truthfully enter the correct numbers from your records. Box 3 is how much you put in through the years towards this distribution. Box 2 is the earnings or difference between the basis and distribution.

2. The IRS instructions for Form 1099-Q, About Publication 970, Tax Benefits for Education state: "Nontaxable distributions from CESAs... are not required to be reported on your income tax return."

I understand you want to continue tracking with your return. So using your numbers may be the best option for you.

@j0mike1993

[j0mike1993]

I love your response of not adding the 1099Q's for my 3 dependent children (which Turbo Tax will not let me add 1099Q's if I select the recipient and beneficiary are dependents. I've been receiving the message Great news! You don't need to report this form {I do they are my dependents on my return}, so I've been having to update their school expenses using the forms option). I never liked how the taxman figured out our Coverdell basis, and am fine deciding myself. 

Unfortunately, I see 2 of my children have access distributions after receiving the American Opportunity credit of $2,500. When you are also receiving education credits, you can't figure out you have excess distributions without entering the 1099Q's. Are you telling me I don't have to pay the tax on my access distributions? When I read pub 970, it sounded like I would have to because there is no double dipping on expenses. If you don't enter the 1099Q, you will not see the excess distributions when taking education credits (someone really needs to fix this). 

[AmyC]

Excess distributions beyond room and board along with education expenses is taxable for a 529. You do need to enter the Q and have the excess taxed. The IRS says you don't need to enter if all of the Q went to qualified expenses. In your case, if you had more taken than spent qualified education expenses, you do need to report the Q.

I find people often forget to use the 529 for Room and Board or don't realize that off-campus living can be included with a 529.

You are clearly very good at math- in the future,  you can add room and board costs, additional supplies and (tuition-4k for credit) to see if the Q is over or under that amount. If under, no need to worry about it or enter it. If over, enter the Q and pay tax on the excess.

@j0mike1993 Well done!

[j0mike1993]

Do you work for Turbo Tax? My information is coming from pub 970 worksheet 6-3 (pages 47-48). Your response about the 529 applies the same to the Coverdell. Our oldest son was taxed on excess distributions (after taking an education credit) because he was living at home, and I didn't account for his living expenses from cost of attendance, so he had less expenses to deduct. Turbo Tax has taxed us on excess distributions a few times.

Up until this year Turbo Tax has had me input our children's 1099Q's, and calculated the worksheets to figure out if we have excess distributions or not (if you are taking an education credit and didn't account for the expenses the credit uses, you may have excess distributions that are TAXABLE). You have to account for the expenses the education credit uses in addition to deducting your expenses from your distribution - there is no double dipping on expenses. Turbo tax has also calculated the Coverdell's basis from year to year, and I need them to continue doing that, so I don't pay tax on the basis.  You wrote if over, enter the Q and pay tax on excess. This is my problem!!! Turbo tax is telling me I don't need to input my children's 1099Q's. I receive a message Great news! You don't need to report this form, BUT YES I DO. This is the only reason I am on this chat is to get someone to fix turbo tax skipping1099Qs. When I try to work around this error by stating I'm the recipient (which I am not - it changes the tax), Turbo Tax is requiring input from 1099Q's box 2 and 3, and Coverdell's 2 and 3 are always blank because the earnings and basis are calculated yearly on you tax return worksheets. Your financial institution does not know you basis. Without inputting box 2 and 3 I can't proceed or do I want to because I'm not the recipient. NO ONE should be skipping worksheet 6-3 if they are taking the education credit

If I wanted to do all these calculations myself, I wouldn't purchase Turbo Tax. Someone please HELP. I know I have excess distributions after taking the education credit, and right now I have no way to add my children's 1099Q's to my tax return to PAY THE TAX because Turbo Tax is SKIPPING! I cannot proceed without inputting!!! Or give me a refund, and I will take my business somewhere else.

Below Publication 970 Worksheet 6-3

Coverdell ESA—Taxable Distributions and Basis
Complete Part I, lines A through H, on only one worksheet.
Complete a separate Part II, lines 1 through 15, for each of your Coverdell ESAs.
Complete Part III, the Summary (line 16), on only one worksheet.

Caution. If you had a distribution from a qualified tuition program (QTP), see Coordination With Qualified Tuition Program (QTP)
Distributions.
Part I. Qualified Education Expenses (Complete for total expenses.)
A. Enter your total qualified education expenses for 2025 . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . A.
B. Enter those qualified education expenses paid for with tax-free
educational assistance (for example, tax-free scholarships, veterans’
educational benefits, Pell grants, employer-provided educational
assistance) . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . B.
C. Enter those qualified higher education expenses deducted on
Schedule C (Form 1040), Schedule F (Form 1040), or Schedule 1 (Form
1040), line 12 . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . C.
D. Enter those qualified higher education expenses on which
an American opportunity or lifetime learning credit was based . . . . . . . D.
E. Add lines B, C, and D . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . E.
F. Subtract line E from line A. This is your AQEE for 2025 . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . F.
G. Enter your total distributions from all Coverdell ESAs during 2025. Don’t include rollovers
or the return of excess contributions. See instructions . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . G.
H. Divide line F by line G. Enter the result as a decimal (rounded to at least 3 places). If the
result is 1.000 or more, enter 1.000 . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . H. .
Part II. Taxable Distributions and Basis (Complete separately for each account.)
1. Enter the amount contributed to this Coverdell ESA for 2025, including contributions made for 2025
from January 1, 2026, through the due date (not including extensions) for filing your 2025 return. Don’t
include rollovers or the return of excess contributions . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 1.
2. Enter your basis in this Coverdell ESA as of December 31, 2024. See instructions . . . . . . . . . . . . . . . 2.
3. Add lines 1 and 2 . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 3.
4. Enter the total distributions from this Coverdell ESA during 2025. Don’t include rollovers
or the return of excess contributions. See instructions . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 4.
5. Multiply line 4 by line H. This is the amount of AQEE attributable to this
Coverdell ESA . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 5.
6. Subtract line 5 from line 4 . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 6.
7. Enter the total value of this Coverdell ESA as of December 31, 2025,
plus any outstanding rollovers. See instructions . . . . . . . . . . . . . . . . . . 7.
8. Add lines 4 and 7 . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 8.
9. Divide line 3 by line 8. Enter the result as a decimal (rounded to at least
3 places). If the result is 1.000 or more, enter 1.000 . . . . . . . . . . . . . . . 9. .
10. Multiply line 4 by line 9. This is the amount of basis allocated to your distributions, and is tax
free . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 10.
Note. If line 6 is zero, skip lines 11 through 13, enter -0- on line 14, and go to line 15.
11. Subtract line 10 from line 4 . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 11.
12. Divide line 5 by line 4. Enter the result as a decimal (rounded to
at least 3 places). If the result is 1.000 or more, enter 1.000 . . . . . . . . . 12. .
13. Multiply line 11 by line 12. This is the amount of qualified education expenses allocated to your
distributions, and is tax free . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 13.
14. Subtract line 13 from line 11. This is the portion of the distributions from this Coverdell ESA in
2025 that you must include in income . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 14.
15. Subtract line 10 from line 3. This is your basis in this Coverdell ESA as of December
31, 2025 . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 15.
Part III. Summary (Complete only once.)
16. Taxable amount. Add together all amounts on line 14 for all your Coverdell ESAs. Enter here
and include on Schedule 1 (Form 1040), line 8z, listing the type and amount of income . . . . . . . . . 16.
48