PatrickLung
Level 1

BELOW IS WHAT I WROTE LAST YEAR (2018 TAX) AND POSTED IN THE WEB.  SINCE PROBLEM STILL NOT SOLVED THIS YEAR (2019 TAX), I AM JUST DOING A COPY AND PASTE TO SHARE:

I have been doing my Federal and State tax returns for many years using TurboTax.  This year was the first year which I ran into a bug which prevented me from importing.  It was a painful learning experience.  So, I thought I would write it up and hopefully can be a reference for those who are still facing this problem which seems to be common for the unfortunate bunch per my googling .

 

As someone who worked 15 years in the software industry, I know a bit about software.  The most common mistake is not opening up the security of OFX which is inside the Schwab web after you log in and choose the Security Tab.  Of course, another common mistake is not using the right user ID and password.  For me, I was able to log in directly into Schwab without problem so I know they were right.

 

Writing into Schwab via secured messaging telling them this TurboTax import problem took about a week.  While waiting, I had no idea if they would reply or would they be able to solve the problem.  So, while waiting during that week, I try to do the export and import myself.  If you go into Schwab Statements, you will be able to choose one of the three file formats for you 1099s of which, CSV was one of them.  And, TurboTax only takes one import format which is TXF.  So, the question becomes how to convert from CSV to TXF.  Googling what software can do the conversion, I went into a number of them.  Problem is how do you know if it is not scam, ad cookie software?  One actually has this Chrome extension which would intercept my googling.  I installed a couple but it was a waste of time and I am still trying to figure out how to uninstall and clean up.

 

Luckily, I found a website called http://www.easytxf.com.  This one does not require you to download and install software.  Once inside their site, just browse to your CSV file, then, save the TXF output for use by Turbotax.  You do have to import the CSV file you download from Schwab into Excel and format it into six columns: Symbol, Quantity, Bought Date, Bought Amount, Sold Date, Sold Amount.  Thumbs up for this site!

 

Meantime, Schwab finally got a techie to call me back.  We spent an hour on the phone and was able to export and import in a tedious manner as a workaround.  I am using the Desktop version, which is more matured, of TurboTax.  This year, the import from Schwab function did not work.  So, the techie directly me to go Turbotax online (you don't have to pay until you file which we did not).  Surprise, Turbotax online version was able to import without any problem.  So, the root cause of why TurboTax cannot download 1099 to their DeskTop version seems to lie with TurboTax, not Schwab.  As TurboTax Online is a less matured version compared to DeskTop, you probably want to convert it back to DeskTop.  That is why, unless you have a lot of 1099 line items, might be easier to just enter it by hand 😞

 

As an $50 experimentation, I also tried to switch to H&R Block software.  As it turned out, it was much less painful for the switch then I thought.  The main reason is H&R Block allows you to import via the PDF file of your last year's return.  Then, just import this year's 1099 from Schwab into H&R Block - again, I had no problem hence another evidence that problem lies with TurboTax, not Schwab.

 

To sum it up, here is a summary of my wish list if the various companies/parties if they happen to be reading:

TurboTax: the Schwab to TurboTax problem seems to be caused by the TurboTax side.  Why?  Because TurboTax Online can import without any problem.  H&R Block software can also import from Schwab without any problem.  If TurboTax can open up for CSV import, that would solve the problem as well because exporting 1099 from Schwab in the CSV format is quite easy.  Also, once CSV goes into Excel, it would be much easier for users to format before being imported into TurboTax.

Schwab: if Schwab can export in TXF format also, that would provide another avenue for the process.  Have a task force to work with TurboTax on how to make import work and easy also.  While root cause of the problem is with TurboTax, this would ultimately saves Schwab a lot in support hours.

EASYTXF: keep up the good work.  A much better solution than having to download and install software like other apps.

H&R Block: very impressed with the fact that you can import from last year's returns via the PDF generated by TurboTax.  And, this year's 1099 import works.  Furthermore, I like the idea of if I have further questions, or if I like my returns to be reviewed before submitting to the IRS, there is a team of H&R Block tax preparers whom I can go to if I don't mind paying a bit of money.

Uncle Sam: make Flat Tax a reality.  Many other countries, their tax return is only 2-4 pages long!

 

And, to the unfortunate Schwab and TurboTax customers who are facing the importing issue, my advice would be to try to type it in by hand if not too many line items.  Or, if your tax return is not too complicated, try to use H&R Block to import from the PDF of your last year's return.  Then, import this year's 1099 from Schwab.  For those who are more technically inclined, try the EASYTXF site, it works!