How to upload an excel Investment file into Quicken?
Between Quicken and Fidelity Investments, one of my investment accounts is filled with inputs that are not as I originally entered them regarding the use of Cash. Fidelity uses a government type mutual fund to account for cash, and I have used the Quicken Core account information to account for Cash. For some reason the Quicken Program or Fidelity have now decided to use some type or placeholder for cash. I would like to upload the Relevant Fidelity account that is in an Excel file format into Quicken (I would make it an additional investment account) so that I can review and modify the actual trading from the last 14 months and then adjust the cash/mutual fund amounts to more accurately account for the "cash" within the account. Please advise if this type of uploading is possible because the current account information in Quicken is not accurate or useful. Thank you for your help with this issue.
John Ketterl -[e-mail address removed for your protection]
Answers
-
Hello @jketterl,
Thank you for reaching out! Unfortunately, there isn't a direct way to import an Excel file into Quicken for Windows. You would need to import one of the file types that Quicken supports. For more information, please see our article on importing data into Quicken for Windows:
I hope this helps!
Quicken Kristina
Make sure to sign up for the email digest to see a round up of your top posts.
0 -
@jketterl In a recent enhancement to Quicken, you can now import investment transactions from a CSV file, which Excel can easily produce. Go to File > Import > Investment transactions for more information.
Unfortunately there currently are rounding errors in the import process, which limits its usefulness. See this discussion for more information on the import issues
@Quicken Kristina the Support article you referenced needs to be updated.
QWin Premier subscription0 -
Hello @Jim_Harman,
Thank you for letting me know! To clarify, do you want it updated to state that Excel files can be imported, but only if they are first converted to CSV and properly formatted?
I look forward to your reply!
Quicken Kristina
Make sure to sign up for the email digest to see a round up of your top posts.
0 -
@Quicken Kristina The link near the beginning of the Support article only describes importing banking account transactions, not investing transactions, which is what @jketterl asked about.
I was not able to locate any Help or Support articles on this, although the capability has been available since late last year.
If this capability is officially available, the article should describe or have a link to importing investing transactions from a CSV file, and as you suggest, a mention that if necessary you can use Excel to format the data and save the the file in a CSV format.
See this discussion and the one I linked above for information on the issues users have been having with this
QWin Premier subscription1 -
Thank you for the clarification,
I forwarded this to the proper channels to get the article updated.
Thank you!
Quicken Kristina
Make sure to sign up for the email digest to see a round up of your top posts.
0 -
Thanks @Quicken Kristina
I should also have mentioned that it would sure be nice if Development fixed the rounding errors described in the discussions I linked above. I and several others have reported the problem, and the issue is CTP-15583.
QWin Premier subscription1 -
Thank you for your reply,
I can see that the issue (CTP-15583) is still open and being worked on. We don't have an ETA.
Thank you!
Quicken Kristina
Make sure to sign up for the email digest to see a round up of your top posts.
0
