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 :)
Reply to
Evan Platt
"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.
Reply to
John Pollard
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.
Reply to
Andrew

Site Timeline Threads

BeanSmart website is not affiliated with any of the manufacturers or service providers discussed here. All logos and trade names are the property of their respective owners.