Why sign in to the Community?

  • Submit a question
  • Check your notifications
Sign in to the Community or Sign in to TurboTax and start working on your taxes
Level 3
posted Feb 11, 2023 11:58:17 AM

the 1099-B import was unsuccessful fidelity

After it opens the browser it says Success! We got your tax data. You can now return to TurboTax but in turbo tax it says the 1099-B import was unsuccessful fidelity. It would take me forever to enter this manually since there are 214 Pages of data.

2 27 2679
24 Replies
Intuit Alumni
Feb 12, 2023 11:48:23 AM

Do you have more than one Fidelity account you are trying to import? 

 

Please keep in mind it will only allow the import if there are 10,000 transactions or less, otherwise, you will need to follow the instructions here to manually enter. 

 

Please click here to speak with us by phone for further assistance. 

Level 3
Feb 13, 2023 10:24:13 PM

No, there is only one Fidelity account. I opened the .csv file in exel to look and there are 4549 lines of transactions. 215 pages in pdf format.

Level 3
Feb 13, 2023 11:15:09 PM

I'm thinking of trying this place to import my .csv file into turbotax. It will convert it to .txf file for importing. https://www.investotek.com/

Level 15
Feb 14, 2023 12:05:59 AM

As an active investor, you must be aware that your category Box A or Box D sales without adjustments do not require Form 8949, so there is no reason to import or key in those transactions.
Instead use the "enter a summary" option (aggregation) to put your numbers on Schedule D Line 1a or Line 8a.
No mailing is necessary.
--
If you have wash sales, it gets more complicated since those adjusted transactions have to be itemized on Form 8949 and the summary totals adjusted accordingly.

Enter the wash sales on Form 8949, then use the subtotal results on the bottom of that form (Line 2) to know how much to subtract which gives you the Schedule D line 1a totals. Be sure to NOT check the adjustments box in the summary window.
--
Alternatively, if entry of Wash Sales is too tedious,
summarize and check the box for adjustments and enter the disallowed amount.
This summary will go on Schedule D Line 1b.
You will be making the mail-in election.

 

Note: only the wash sales details have to be mailed if you summarized wash sales separately.

You may want to get Pro Adobe Reader that lets you edit your 1099-B PDF and reduce it down to only wash sales.

It depends on how many wash sales you have to report.

 

Second Option:

use some other tax software that lets you attach the consolidated1099-B (wash sales only, or entire) as a PDF file when you e-File with aggregation.

Then no mailing is necessary.

PM me if you don't know what software will do it.

Level 3
Feb 17, 2023 5:05:39 AM

Here's a small sample of the .pdf file. It has 23 sales per page and 214 pages. Which is 4,922 sales. I do a lot of day trading so I buy and sell anywhere from 1-100 times a day. A lot of info to manually put in.

Expert Alumni
Feb 17, 2023 8:47:25 AM

There will be time involved however, you mentioned an excel file which would make it easy to summarize regular sales into long or short term, then a similar section for wash sales.

 

This could be the easiest way that would use the least amount of time if import is not working. For your convenience I will provide the wash sale rules as to when they are actually complete.  You need to continue to track the stock basis for these and the excel could be invaluable for this.

 

Wash sales can be combined into section totals.  You must track your cost basis and know when you are allowed to use the information on a final sale.

 

Wash Sale Rule Defined:

  • A wash sale occurs when an investor sells or trades a security at a loss, and within 30 days before or after, buys another one that is substantially similar.
  • It also happens if the individual sells the security at a loss, and their spouse or a company they control buys a substantially similar security within 30 days.
  • The wash-sale rule prevents taxpayers from deducting a capital loss on the sale against the capital gain.

Affect on Cost Basis:

  • The loss that occurs on a wash sale is added to the cost basis of the shares purchased that created the wash sale.
  • When all shares are sold and there is no repurchase, that increased cost basis will be used in full and used to determine gain or loss.

As long as you are tracking the wash sales and are not using them on the tax return when you are not allowed, then you can simply enter the same cost basis as the selling price. This will  reconcile your tax return with your Form 1099-B Proceeds which is what the IRS is comparing.

 

Be sure to keep good records so that you know when to add those losses for future sales.

Level 3
Feb 17, 2023 12:39:13 PM

I already know wash sale rules. I'm trying to import my file which isn't working.

Level 3
Feb 17, 2023 1:14:13 PM

Has anyone tried another software to see if it imports it? I was thinking of using H&R block software but don't want to waste time if it doesn't work either.

New Member
Feb 17, 2023 4:34:30 PM

I have tried H&R. They could not import from Fidelity either. 

Level 2
Feb 28, 2023 11:29:38 AM

I'm having the same issue, but I have more than 1 account. Because of this error, none of my accounts are being imported with no option to select which accounts to import or import the ones that can be imported without error. Is the solution to this problem to import by hand all the accounts even though not all the accounts have more than 10,000 transactions? If so, this 10,000-transaction limit needs to be fixed now or an alternative solution needs to be found and offered. Other products have solved this problem, so the limitation has a solution.

Level 2
Feb 28, 2023 11:37:54 AM

Have you tried the https://www.investotek.com/ software and did it solve the 10,000 transactions limitation? Any security concerns with using this software?

 

Thank you for sharing!

Level 2
Feb 28, 2023 11:55:18 AM

I am having the same issue. I am able to login into Fidelity and and when I return to Turbotax it give me a message that "The 1099-b import was unsuccessful" and directs me to an article dealing with having more than 10,000 transactions - which I do not.  

 

When I entered the summary data manually, it tells me that on a couple of accounts that I need to mail in statements to the IRS. I have never had this issue before.

 

Is there a bug that is being addressed?

Intuit Alumni
Feb 28, 2023 12:08:19 PM

If you are using TurboTax Online, you may want to try a different browser or try clearing out your browser's cache and cookies. Please see How do I delete cookies? and How to clear your cache for more information.

 

Please see What if I can't import my 1099? for instructions. Additionally, please keep in mind that if you have to enter a Document ID that it is case sensitive. 

 

If you need additional assistance, please feel free to contact Customer Support so you can speak with a TurboTax representative who can assist you. 

@gaga542 
 

Level 3
Feb 28, 2023 12:15:35 PM

Yes, I used https://www.investotek.com/ full service. I emailed them the .cvs file and they converted it to .txf file which did import into turbotax without a problem. I'm still going to wait before filing to see if TT gets this problem fixed.

Level 3
Mar 7, 2023 6:47:16 PM

same. 1099B seems KO

3k trx only so far from limit. 

see several reddit post too. seems broken...

Intuit Alumni
Mar 8, 2023 12:24:03 PM

Please review the proposed solution regarding screen resolution in this thread.

Level 2
Mar 22, 2023 4:48:21 PM

Since I got no response and/or solution to this problem from TurboTax, I did more research and found the following:

 

-The limit of 10,000 transaction is incorrect, I had 2,064 entries to import and it failed. So, the limit is less than 2064.

-I used Excel to massage the .csv file from Fidelity to get the following 6 column headers in another tab with equations to get the stock symbol out of the first string:
Symbol, Quantity, Opening Date, Opening Net Amount, Closing Date, Closing Net Amount
then removed the rows with empty summary and saved the file as .csv with only the 6 columns
Note: Many other steps but a brief overview.

 

I then used https://easytxf.com/ to import the .csv file and output the resulting .txf file which I imported to TurboTax which will complain about more than 1,000 entries will slow down the performance of the program and machine. I don't own or have affiliation with easytxf.com and this is not a recommendation but it worked for me and it was free but I did donate since it saved me a lot of work. Perhaps TurboTax should buy the company or create a similar converter. There are other paid products that do the same conversion, some that can work with the .pdf file(s). However, since I like saving money and this is a once per year task, I chose the freeish path.

 

The following isn't consistent with previous posts. If I use the summary technique without the detailed transactions as suggested in other posts that I don't need to send in the detail to the IRS but the TurboTax program states the following from "What You Need to Mail" on page 1 of the Turbo Tax generated instructions:
Mail Form 8453 promptly after your return is accepted with attached forms and supporting documents listed on Form 8453.
Attach the following items to Form 8453: Form 8949 or an acceptable Continuation Sheet for Schedule D.

 

What is the final answer, I do or don't need to mail in the form 8453? If it is the later, then update the program's mailing instructions.

 

Hopefully this helps folks with similar issues.

Level 2
Mar 30, 2023 8:09:32 AM

I have the same problem where I get the message "This 1099-B import was unsuccessful" when trying to bring in from Fidelity (I have ~2000 transactions, not 10000). Worse, I get the same message when trying to import my 1099-R from Fidelity - it still says "1099-B import was unsuccessful" even though I'm trying to import a 1099-R! (And 1099-DIV and 1099-INT also fail.) Is there an alternative to typing it (summary of 1099-B, and the other forms) by hand? Do I have to physically mail some forms afterward? Clarity would be appreciated! Thanks. 

Expert Alumni
Mar 30, 2023 8:45:07 AM

If uploading is not an option, then you can enter your transactions manually.  If you have sales identified on your 1099-B statement as Box A or Box D sales, and they don't include any adjustments to the gain/loss (e.g., a Disallowed Wash Sale amount), then you should simply enter a summary for these sales.  You'll only need to enter the total sales proceeds, total cost basis, and sales category.  In the section where you enter your stock transactions, TurboTax will ask you whether you want to enter a summary versus one at a time.  

 

If there are transactions that require some adjustment, you can report those sales that require adjustments and then report the remaining transactions in summary fashion as described above.  In other words, you can combine both types of reporting on the same return.    

 

@elinderca 

Level 2
Mar 30, 2023 9:07:42 AM

Thanks @GeorgeM777 that's what I did. As unpleasant as having to entering the 1099-B data manually was (rather than TurboTax importing it as it always has in previous years), I was further surprised that TurboTax then failed to import the 1099-R, 1099-DIV, and 1099-INT from Fidelity - always giving the error that "1099-B import was unsuccessful" even though these were not 1099-Bs! So everything had to be entered manually. 

 

My remaining question is whether I indeed need to mail a couple of hundred pages in the physical mail now as well, or are the summaries I put in sufficient?

Expert Alumni
Mar 30, 2023 9:32:26 AM

Yes, following the advice given by JohnB5677 in the Turbo Tax post, you will need to send the IRS the brokerage statements listing the individual sales if you summarized the sales. If the details involve a couple of hundred pages, then these will need to be included in the mailing.

 

If you e-file using summary totals, TurboTax will produce a Form 8453. You print the Form 8453 and attach the brokerage statement(s) to it. 

 

@elinderca 

 

 

Level 2
Mar 30, 2023 9:39:08 AM

Thanks @DaveF1006 for the very clear response. Not the answer I was hoping for (would be better if TurboTax fixed the import problem) but clear. Thanks. 

 

Just to double check: there is no way to upload the PDF 1099-B's to IRS (or TurboTax to include with the e-file) - they really have to be printed and physically mailed?

Expert Alumni
Mar 30, 2023 11:49:23 AM

These do need to be printed and mailed because Turbo Tax does not have the ability to efile pdf attachments with the return.

Level 2
Apr 1, 2023 12:17:33 PM

Why doesn't TT fix the problem?