Fixing mismatched securities from downloads

Transactions downloaded via OFX Direct Connect have a security ID and name attached.

If the security ID does not match the ID of the security that you have manually entered, then you will be prompted to match the downloaded security or select "None of the Above".

If you select "None of the Above", Moneydance creates a new security and all subsequent downloads match this new security.

To fix this, we must remove the security that was created when "None of the Above" was selected, reset the sync of the online download, then re-download and properly match the security.

Open the Investment account and select the Securities Detail view.

Click the drop-down menu at the top right of the account register and select the security that was automatically created.

Then select "History" - this will open a new window.
Select "Edit" at the top right of the window.

In the next window, amend the "Security Name" field.
Change the name to "REMOVE".

This will help us to ensure that we are removing the correct security.

Click OK, then close the History window to return to the Investment account.

You may see that the security name has not changed.
This is expected because you have not refreshed the page.

Select "Remove Security". This will open a new window.
Click the drop-down menu select the security we renamed to "REMOVE".

You will be prompted to confirm that you want to remove this security.
Type in yes to confirm deletion.

At this point, the security and all assigned transactions should be removed.

Select your account in the sidebar.

Then choose Online Banking > Set Up Online Banking.
Select the "Reset Sync" button.

Then download your transactions again from your broker.

Only the transactions you deleted (and any new transactions) should be downloaded.

When prompted, you can now match the downloaded security to the correct security in Moneydance.
Then subsequent downloads will match the correct security.

Recent Discussions

21 Apr, 2024 02:11 AM
21 Apr, 2024 02:09 AM
21 Apr, 2024 01:47 AM
21 Apr, 2024 01:44 AM
21 Apr, 2024 12:24 AM