Download transactions from Fidelity to Quicken/Moneydance

[tulak]

I use Moneydance to download transactions from Fidelity, but it's not working right now. I went to the Fidelity website and see that you can only download transactions in CSV format. I thought there was a way in Fidelity to download transactions directly to Quicken, using QFX files, but I can't find it on their website and from what I've been able to find, it looks like this is no longer supported?

I'm wondering, how do others downloads their transactions from Fidelity into Quicken/Moneydance?

 

[Alex The Great]

I use my own home-grown spreadsheets and a script to import CSV data into the sheets. It works fine but sometimes Fidelity make a little change in the format which break my script and I have to fix it.
But even with incorrect CSV format, there is always a way to copy the data in web (html) format using a clipboard and then convert it into correct CSV with some free tool like groupdocs for example: Free Online Document Manipulation Apps
Never used Quicken or Moneydance but I believe the same may happen to them as well. You can wait for a while for Fidelity to fix it, or use other ways as I mentioned. Does Quicken allow to import CSV data?

 

[flyingout]

Grrrr. I hate when this happens. Moneydance in my case. It was working fine earlier today but I just tried and got an authentication dialog that doesn't work.

These outages happen. I'd just be patient for now.

 

[tulak]

Yeah, I’m hoping it’ll be good tomorrow. But I was surprised at the lack of a download option.

Vanguard discontinued their direct connect, but they offer the ability to export transactions for all accounts in a single QFX file. It works great. If Fidelity offered something similar, I’d start using that since it’s more secure.

 

[skipro33]

Fidelity downloads to my Quicken same as always

 

[Pasha]

I'm wondering, how do others downloads their transactions from Fidelity into Quicken/Moneydance?

Moneydance user for the last 9 years.
Direct downloads from Fidelity and Vanguard accounts work most of the time for me, however there are temporary "connection issues" from time to time, probably due to database maintenance. The next day everything returns to normal.

 

[audreyh1]

I use Moneydance to download transactions from Fidelity, but it's not working right now. I went to the Fidelity website and see that you can only download transactions in CSV format. I thought there was a way in Fidelity to download transactions directly to Quicken, using QFX files, but I can't find it on their website and from what I've been able to find, it looks like this is no longer supported?

I'm wondering, how do others downloads their transactions from Fidelity into Quicken/Moneydance?

No, Fidelity doesn’t provide QFX files, neither does Schwab. I suspect it’s that brokerage transactions are far more complex than regular banking or CC transactions and QFX files don’t accommodate them.

However I’m not comfortable providing login credentials to be “securely stored on Intuit servers” so I enter brokerage transactions manually.

 

[audreyh1]

Vanguard discontinued their direct connect, but they offer the ability to export transactions for all accounts in a single QFX file. It works great. If Fidelity offered something similar, I’d start using that since it’s more secure.

That’s interesting, so my above post is incorrect regarding QFX not handling brokerage accounts or even multiple accounts. I’d love if Fidelity provided that option since I won’t use direct connect.

But overall it’s not a great inconvenience to me since I don’t spend a lot of time entering transactions manually from Fidelity, just once at end of month for most of them and very few outside that window. And anything to do with bill pay or transfers is already in my scheduled transactions list.

All my other accounts provide QFX files and that does save a great deal of time since there are usually many transactions, especially the CCs.

 

[jollystomper]

I only download my Fidelity portfolio in CSV format, then use Python to crate a CSV format for import into Fidelity. On my list of "fun programming things to try at some point in time" is implementing RPA software to automate the entire login/download/reformat/import process.

I am still entering transactions manually, as that is my current audit method. But we do not do tons of transactions, so time is not an issue.

 

[2017ish]

I use Direct Connect to download Fidelity account activity to Quicken. The only problems I've run into have been when we were out of the country for months--but those were applicable to quicken downloads as a whole, not Fidelity specific. (We'll soon see if VPN routed through the USA takes care of that....)

 

[tulak]

Fidelity downloads to my Quicken same as always

Is it working for you now?

I just tried it and it's still down. I'm going to try calling Fidelity later today.

That’s interesting, so my above post is incorrect regarding QFX not handling brokerage accounts or even multiple accounts. I’d love if Fidelity provided that option since I won’t use direct connect.

But overall it’s not a great inconvenience to me since I don’t spend a lot of time entering transactions manually from Fidelity, just once at end of month for most of them and very few outside that window. And anything to do with bill pay or transfers is already in my scheduled transactions list.

All my other accounts provide QFX files and that does save a great deal of time since there are usually many transactions, especially the CCs.

I was surprised Vanguard had this too. I don't know how long they had it because I always used Direct Connect with them until it stopped working. I think they pulled the plug on Direct Connect (I didn't look), but I found the ability to download everything as a QFX, so I do that once a week to reconcile everything. Works really well.

I always assumed Fidelity, and all of the other brokerages, offered the same service, but I guess not. That's a bummer, since it seems easy enough to support and it would save a good amount of time.

Just looking at what others are doing to download this info is puzzling. 3rd party scripts to convert CSV files to QFX? Why? This isn't a new file format we're talking about.

 

[audreyh1]

It is indeed a bummer since it clearly works well with Vanguard

 

[skipro33]

Is it working for you now?

I just tried it and it's still down. I'm going to try calling Fidelity later today.

Yes. I just this moment clicked on the "One Step Update" button and both mine and my wife's Fidelity accounts updated just fine.

Checking the account details in Quicken;
Financial Institution; Fidelity Investments
Connection Method: Direct Connect

Maybe try this:
click on the 'Edit/Delete Account' for one of your Fidelity accounts in Quicken.
click on the 'Online Services' tab.
click on the 'Reset Account' button.
This will cause Quicken to deactivate, then reactivate your account. Your existing data will remain and nothing will be deleted.

 

[tulak]

I tried to reset in Moneydance and it’s not working. I’m going to call them.

 

[tulak]

And magically, it started working again, right before I was going to call.

Glad that's fixed, but when I get the opportunity, I'm going to mention that one of their competitors (Vanguard) has a convenient feature to export transactions for all accounts into a single QFX file and why doesn't Fidelity offer the same?

Thanks all!

 

[indiajust]

I downloaded .qif and .qfx files for import and balancing for years. No more.
My direct indexing accounts with schwab generate thousands of transactions per year. the encrypted quicken handoff handles all but one problem area. perhaps 10 transactions a month need manually tweaked. All the rest of my accounts work flawlessly. as i beta test with quicken, i routinely bug them to fix the one transaction type that does not import clean. likewise, i bug schwab too.

 

[indiajust]

I was recently Volun-told to be treasurer of a local non profit. I linked to the bank with quicken, then got help from the bank with a .csv, which I massaged into a mint format and imported. 5 hours work for 5 years transactions.

 

[sengsational]

You all are downloading transactions, not statements from Fidelity, right? When I go to statements, it doesn't show anything except PDF format.

 

[indiajust]

I download and save pdfs of the formal legal stuff: confirmations, trades, statements. They are the governing docs in event of errors and problems. Folders by year, by account. The advantage of having the raw transaction data is it can be tagged and labeled and searched much easier. I can pull a report on my auto expenses by year from quicken in a few minutes at most. It would take some time to do that from statements.

Before adobe and the pdf format existed, i had a rollfeed scanner from La Cie. Just before implosion, they released a mac based convert-to-pdf for their proprietary file format. I ran it inside an emulator for the old OS to convert and re-save my original scans to pdf. a godsend.