Merrill download account mix up.

Question

When transactions occur to my IRA account to The Real Estate Select SPDR Fund (XLRE) they are downloaded to Quicken as a transaction to Real Estate Securities SEP account (RE102). This has been happening for years, but the number of transactions is small, and I have learned that when my shares in Quicken don't match my Merrill shares that is the first place to look. Do you think this is something I can correct or is it a Merrill or Quicken issue?

gslaby · Answer

Thank you for the reply. I am assuming in step 1 you were referring to XLRE. When I open Edit Security Details the "Matched with Online Security" box is greyed out and unchecked. I cannot do anything with it.

Do I need to wait until I get another transaction download from RE102 (I edited or created a new transaction and deleted the others) and then go through the process with it?

Jim_Harman · Answer

The process described by @jtemplin will correct downloads going forward, but to correct previous incorrect entries, you must change any incorrect security names.

* Back up your data in case something goes wrong.
* Go to Edit > Preferences > Keyboard mappings and select Windows standard if it is not already selected
* Click on the Security header in the account’s Transaction List (Register) to sort them by name.
* Correct one of the incorrect names, then highlight the corrected name and hit Ctrl-C
* Save the edited transaction.
* Select the name of the next affected transaction to highlight it and hit Ctrl-V
* Repeat steps 4-6 for the remaining incorrect transactions.

jtemplin · Answer

It's possible it's just mismatched. The first time a downloaded transaction references a previously-unknown security, Quicken will ask if it should create a new security or match it to an existing one. The existing one it recommends is often a poor choice (often a similarly named one), and some folks probably just click through the prompt and use what Quicken recommends. To clear the match:

* From the portfolio tab, find the mismatched security in question and click on it.
* The Security Detail View window opens. Click the button "Edit Details" in the middle left of the window.
* The Edit Security Details window opens. Uncheck the check box "Matched with Online Security".

The next time that security is referenced in a download, you'll get the dialog mentioned above asking how to match it or create a new security.