Cannot import fidelity netbenefits QIF or CSV into Quicken 2019

Quicken 2019 R.18.16.
I've download a QIF and a CSV from fidelity netbenefits.
When trying to import either into Quicken, I get "File not found or
unreadable." The QIF looks fine, to my untrained eye.....: !Type:Invst D10/04/2018 NBuy YVANG INST TR 2040(OV6T) I24.32000 Q6.149 U149.55 T149.55 MContribution ^ D10/17/2018 NBuy YVANG INST TR 2040(OV6T) I23.65000 Q6.327 U149.64 T149.64 MContribution ^ <Etc>
The CSV file says no valid prices found to import:
Plan name:,<NAME> Date Range,04/17/2017 - 04/18/2019,,,,
Date,Investment,Transaction Type,Amount,Shares/Unit 04/16/2019,VANG INST TR 2040,CONTRIBUTION,"149.64","6.173" 04/03/2019,VANG INST TR 2040,CONTRIBUTION,"149.64","6.227"
Am I missing something?
Thanks :)
--
To reply via e-mail, remove The Obvious and .invalid from my e-mail address.

Add pictures here
<% if( /^image/.test(type) ){ %>
<% } %>
<%-name%>
Add image file
Upload
On 2019-04-19 15:07:27 +0000, Evan Platt said:

The QIF file is missing the account name and type. See: https://community.quicken.com/discussion/7150541/faq-is-there-a-way-that-will-allow-you-to-import-transactions-from-qif-csv-excel-ofx-files-into-qui
Quicken uses a different CSV layout to import security price history.
Add pictures here
<% if( /^image/.test(type) ){ %>
<% } %>
<%-name%>
Add image file
Upload
"Evan Platt" wrote
Quicken 2019 R.18.16.
I've download a QIF and a CSV from fidelity netbenefits.
When trying to import either into Quicken, I get "File not found or unreadable." The QIF looks fine, to my untrained eye.....: !Type:Invst D10/04/2018 NBuy YVANG INST TR 2040(OV6T) I24.32000 Q6.149 U149.55 T149.55 MContribution ^ D10/17/2018 NBuy YVANG INST TR 2040(OV6T) I23.65000 Q6.327 U149.64 T149.64 MContribution ^ <Etc>
The CSV file says no valid prices found to import:
Plan name:,<NAME> Date Range,04/17/2017 - 04/18/2019,,,,
Date,Investment,Transaction Type,Amount,Shares/Unit 04/16/2019,VANG INST TR 2040,CONTRIBUTION,"149.64","6.173" 04/03/2019,VANG INST TR 2040,CONTRIBUTION,"149.64","6.227" ---------------------------------------------------------- If you get "file not found", that can't be a problem with the contents of the file.
I was able to import your QIF file into Q2019 R18.15 with no change to the QIF file. During the import, Quicken asked if I wanted it to create a new security for the one in the QIF file; after I answered Yes, the import completed and the two transactions were in the investment account I had selected in my test file.
Your .CSV file isn't close.
First get rid of everything before the "Date,Investment,Transaction ...." heading text.
Once I did that and tried to import the resulting file, I got: "No valid prices to import".
As Sherlock suggested, your format still seems wrong.
To get an idea what Quicken expects, you can try a couple of things. 1.) Quicken Help has info on the format of a .CSV price import file. Check that and try adjusting your .CSV file accordingly. 2.) Create a (test) portfolio/watchlist at Yahoo - you only need one security. Then Export that portfolio/watchlist which will create a .CSV file. While there will be many more fields in that file than in yours, Quicken can import the data from that file, so you should be able to get an idea where your problem lies.
I believe the first thing to look at is the ticker symbol, which I do not see in your .CSV data.
Add pictures here
<% if( /^image/.test(type) ){ %>
<% } %>
<%-name%>
Add image file
Upload
Evan Platt wrote:

Is this the first time you've tried to import NetBenefits into Quicken? Reason I ask is that I simply have Fidelity NetBenefits as a normal financial institution inside my OSU and the info comes thru just like any other FIs to update my various mutual funds inside the 401K. No need to actually "import' via QIF or CSV. The key is that one needs one's Fidelity "Account number" which is a 5 digit numeric and your userid you use to log into the NetBenefits website is your "Customer ID" on the Quicken Account details panel when setting up NetBenefits for the OSU.
--
-------------------------------------------------------------
Regards -
  Click to see the full signature.
Add pictures here
<% if( /^image/.test(type) ){ %>
<% } %>
<%-name%>
Add image file
Upload

BeanSmart.com is a site by and for consumers of financial services and advice. We are not affiliated with any of the banks, financial services or software manufacturers discussed here. All logos and trade names are the property of their respective owners.

Tax and financial advice you come across on this site is freely given by your peers and professionals on their own time and out of the kindness of their hearts. We can guarantee neither accuracy of such advice nor its applicability for your situation. Simply put, you are fully responsible for the results of using information from this site in real life situations.