How to create/modify a security using CUSIPs?

WannaTheater

Hello,

In an attempt to cleanup dozens of current and past holdings, I've identified many mismatched bond transactions, which are making Holdings inaccurate. Some are named with properly associated CUSIPs. Some are named with no CUSIPS. Some are CUSIPs only as the name. In some places I have a separate CUSIP security, and a Named security, which in reality are the same.

In searching through the support forum, the solutions seem to be:

1. CUSIPS are only provided during a download and match… so just unmatch the security and redownload- This would be nice, but I am unable to uncheck the match box
2. 
   Restore from backup- This is not a viable option as it removes any recent work, and these mismatches go back a ways
3. Force a download- This doesn't seem to work, as once a transaction is downloaded, it doesn't seem to download again
4. Delete transactions, export from your financial institution, and import into Quicken- My financial institution will only allow me to download a csv… which is not in the same format as expected for import. Even if I modify the format, this seems to be no different than adding manually, which still doesn't seem to match upon the next download.

The simple, most obvious, solution is to allow the users to create a security using a CUSIP, just like we can with a stock symbol. Or allow us to manually add a CUSIP to an existing security.

Why is this basic functionality not supported? Until it is added, we are forced to deal with inaccurate Holdings data.

If someone has a solution to this issue, please share

I am using Quicken Classic Deluxe
Version R63.21
Build 27.1.63.21

Thanks!

Chris_QPW

#3. If you temporarily Deactivate the account and then add a new account, the new account will download previous transactions.

#4 Converting from CSV to QFX is probably not a good approach since part of the information in a QFX file is the financial institution, and that financial institution has to support QFX importing. Which isn't going to be true for your financial institution because if it was your financial institution would have already provided a QFX export. There are ways around this but would involve adding a new account and #3 is probably the better option.

q_lurker

My financial institution will only allow me to download a csv

Following up on Chris’s comment, how are you going from that csv file to a file you can import? Or, how did those CUSIP ids that are in your file in a CUSIP field get there? I would not expect a csv-initiated path to get that information passed along.

It is really unusual that you cannot uncheck a checked ‘Matched’ box. Can you clarify that?

Even though in path #3, transactions are not redownloaded, the CUSIP information and matching should take place, but that still requires the Path #1 repair first.

Quicken Jasmine

https://community.quicken.com/discussion/7964707/how-to-create-modify-a-security-using-cusips

Please come back and update us after following the SuperUser's advice!

Thanks!

Quicken Jasmine

https://community.quicken.com/discussion/7964707/how-to-create-modify-a-security-using-cusips

We have not heard from you yet. Are you still needing assistance?

Let us know!

Quicken Jasmine

Hello @WannaTheater,

Just checking in once more before this thread is closed due to low activity.

Let me know!

Quicken Jasmine

This thread is now closed due to low activity. If you are still needing assistance, please start a new thread.

Thanks!