Merrill download account mix up.
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?
Answers
-
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.
1 -
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.
QWin Premier subscription0 -
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?
0