How do I correct the CUSIP ID on a security?

Answers

• Sherlock SuperUser ✭✭✭✭✭

  June 2020 Accepted Answer

  The CUSIP ID is provided by the financial institution when we download transactions. The CUSIP ID is assigned to a Quicken security when we match an online security to a Quicken security.   Quicken should prompt to match an online security to a Quicken security when the financial institution provides a security with a CUSIP ID that has not been assigned to a Quicken security.  If a Quicken security has been mismatched, we may uncheck Matched with online security on the Edit Security Details window and the Quicken security will become available to be matched to an online security when Quicken next encounters an unmatched online security.
  

  Quicken user since 1997
  Premier on Windows 10

  7
• Jim_Harman SuperUser ✭✭✭✭✭

  June 2020

  I edited the title of this post from CUSPID to CUSIP ID
  

  -- Jim QWin Premier subscription

  0
• BK Member ✭✭✭✭

  June 2020

  I read @Sherlock 's response few times to fully comprehend the behavior - Thank you @Sherlock . I wish we could edit and manually enter the CUSIP ID value in Quicken (enhancement request, tho very minor). I have few instances where the FI is not providing the CUSIP ID, so it is blank. Yet I have researched and verified the correct CUSIP value and wish I could simply enter it to [wishfully] create a match. So I second the original post.

  - Q Win Deluxe user since 2010, US Subs R28.24 (still !)
  - I don't use Sync, Cloud, Mobile, Web, Bill Pay/Mgr, Tax
  - Techie, Win10 Pro x64 20H2
  

  1
• Sherlock SuperUser ✭✭✭✭✭

  June 2020

  BK said:

  I read @Sherlock 's response few times to fully comprehend the behavior - Thank you @Sherlock . I wish we could edit and manually enter the CUSIP ID value in Quicken (enhancement request, tho very minor). I have few instances where the FI is not providing the CUSIP ID, so it is blank. Yet I have researched and verified the correct CUSIP value and wish I could simply enter it to [wishfully] create a match. So I second the original post.

  @BK  If a security doesn't have a CUSIP ID, the security has not been matched to a security provided by the FI.   I suspect you may have mismatched the security.  The issue should be apparent when you compare the holdings:  select Tools > Online Center, the FI, the account, the Holdings tab, and Compare to Portfolio...

  Quicken user since 1997
  Premier on Windows 10

  0
• wilson_carter Member ✭✭

  July 2020

  The issue (which has occurred on my Brother in Law's account as well, is that a financial institution (FI) is reporting an incorrect CUSPID for two ETFs. SPYV and SPYD. When dividends are posted, dividends for SPYV show up on the register as though they were dividends for SPYD (and vice versa). When dealing with a managed account that includes both these ETFs it can obviously cause problems and confusion as the amount of the mismatch is not necessarily the amount of the transaction, it is the difference between the transactions. My question is: Can the CUSPID be edited?

  0
• Jim_Harman SuperUser ✭✭✭✭✭

  July 2020 Accepted Answer

  @wilson_carter, As explained above, you cannot edit the CUSIP ID directly.
  
  If you hold both ETFs and the dividends are being posted incorrectly, you should go to the Security Detail view for each security. Click on Edit Security Details and un-check the Matched with Online security box. This will clear out the CUSIP.
  
  The next time Quicken has a transaction to download for one of the securities, you should see a dialog asking which security the transaction should be associated with. Carefully select the correct security from the list and the CUSIP should be assigned correctly.
  
  If you haven't already, you will need to correct any transactions already in Quicken that are assigned to the incorrect security.
  
   

  -- Jim QWin Premier subscription

  2
• jbethgoss Member ✭

  July 2020

  I have seen Sherlock answer this problem in several threads with a statement that doesn't appear to be true:
  "The CUSIP ID is assigned to a Quicken security when we match an online security to a Quicken security. Quicken should prompt to match an online security to a Quicken security when the financial institution provides a security with a CUSIP ID that has not been assigned to a Quicken security. If a Quicken security has been mismatched, we may uncheck Matched with online security on the Edit Security Details window and the Quicken security will become available to be matched to an online security when Quicken next encounters an unmatched online security."
  I have several cases of securities in Quicken WITH NO CUSIP ID. I have unchecked the "match with online security" box for this security, and confirmed in the security list that the CUSIP ID field is blank. I do know the correct ticker symbol and name and other identifying information on the security. When I attempt a QIF import for what is certainly a transaction in this security, Quicken replies with "unrecognized security" but does NOT offer the choice to match with an existing Quicken security. Therefore the second sentence in the above quotation "...should prompt..." --is not true; Quicken is NOT prompting for a match. What is offered is the choice to create a new security. When I accept this choice, the security created includes a 4-digit entry in the CUSIP ID field which cannot be a real CUSIP, since real CUSIP numbers are 9-characters long.
  If Q is really using CUSIP to uniquely identify securities, it should allow users to make corrections.

  0
• Chris_QPW Member ✭✭✭✭

  July 2020 edited July 2020

  jbethgoss said:

  When I attempt a QIF import for what is certainly a transaction in this security, Quicken replies with "unrecognized security" but does NOT offer the choice to match with an existing Quicken security. Therefore the second sentence in the above quotation "...should prompt..." --is not true; Quicken is NOT prompting for a match. What is offered is the choice to create a new security. When I accept this choice, the security created includes a 4-digit entry in the CUSIP ID field which cannot be a real CUSIP, since real CUSIP numbers are 9-characters long.
  If Q is really using CUSIP to uniquely identify securities, it should allow users to make corrections.

  Importing by QIF is completely different from importing using QFX or Direct Connect.
  
  The QIF format only has a security name in transactions.  It has no ticker information or CUSIP.  The matching to a security is purely by security name and it has to be exact for one they you already have in Quicken.
  
  All the information that you are referencing has to do with QFX/Direct Connect and as such doesn't apply to your problem.

  (I'm using the latest Quicken subscription version)

  1
• Financial-Health Member ✭✭

  July 2020

  Having an issue with my 401(k). Doesn't have it's own symbol. Has a CUSIP though. My account values are incorrect because it's treating it like another security. I would like to change the CUSIP so the securities match. Doesn't appear there is a way to do that currently.

  0
• Jim_Harman SuperUser ✭✭✭✭✭

  July 2020

  You can't can't CUSIP directly, but if you de-select Matched with Online Security, the CUSIP is cleared and the next time you have transactions to download Quicken will show the Match dialog. Carefully select the correct security and you should be good to go

  -- Jim QWin Premier subscription

  0