How can I enter a cost basis on a bond?

Question

I downloaded my portfolio data from Fidelity.  All assets show a cost basis of "0" even though there is cost basis data in Fidelity.  WHY?  Is there a way to enter the cost basis of my stocks and bonds manually? Or is there a way to get it to download from Fidelity?

Boatnmaniac · Answer

Yes, it is unfortunate that Fidelity no longer downloads data into Quicken for the last 2 yrs but it is what it is.

Manually editing the Bought or Added transactions for the last 90 days (and also the Sold or Removed transactions) that are now shown in the register with the correct transaction information is, IMHO, the best thing you can do to get Quicken to show the correct gains, losses and cost basis.   Deleting those Add and Removed transaction and then manually entering new transactions would be another way to do that but would involve a little more effort.

For anything older than the last 90 days, if you want to show all the transactions data, you will need to manually enter it.

For both exercises you can use your old Excel spreadsheet data for doing this or you can log into your online Fidelity account and download the data from there.  On the Activities and Orders tab Fidelity allows us to download the last 2 yrs of transactions data in Excel format.  And on the Statements tab we can download up to 10 yrs of statements which will also show the transactions data in PDF and CSV formats.

Note:  There is a freeware data conversion program you can download and install called ImportQIF.  It was developed by a long-time Quicken user and still active participant in this Community.  This program can convert Excel data into a QIF file.  Quicken can import QIF files.  I know it used to be able to be used with investment accounts but I've heard that might no longer be possible.  But if you want to, you can try playing around with it to see if might help you in getting older transactions data into Quicken.  You can read up about it and download it from here:  http://www.quicknperlwiz.com/index.html.  (Perhaps @Chris_QPW would weigh in on this to confirm what I've told you or correct me.)

Rocket J Squirrel · Answer

Edit the transactions which added shares to your account. Those will be Bought or Added transactions. Both transactions types allow you to specify the cost.

Mbellaus · Answer

I corrected the simple investing button but since Fidelity only downloads 90 days of transactions and my accounts go back years the older assets do not show up on the detailed register so there is no way to enter cost data, right?  It would appear I would have to delete and then re-enter these all manually so I'm thinking my old excel spreadsheet will be my source for determining gains and losses - unless you have another idea.