Home → Online Banking →

downloads aren't matched to existing securities

• Edit

Keith

17 Oct, 2025 09:41 PM

Over the years I have moved securities among institutions and now most of my investment account moneydance downloads through plaid won't match to existing securities that are already set up.

These articles don't address the issue as they seem to reference the old online banking.
https://infinitekind.freshdesk.com/support/solutions/articles/80000907695-fixing-mismatched-securities-from-downloadshttps://infinitekind.tenderapp.com/kb/investment-accounts/fixing-mismatched-securities-from-downloads

How do I get downloads to match to existing securities instead of always having to select don't exist from the prompt, going in and editing each transaction to reference the existing security and then deleting the newly created incorrect one. I've done this close to a 100 times now and it's getting very old.

1. 1 Posted by ScottA on 04 Nov, 2025 03:20 PM

   

   Same here, though I'd call 100 times a significant underestimate. There is no equivalent to the old "reset sync" button. I've tried to disconnect and reconnect and it doesn't help.

   • Edit

2. 2 Posted by chris_hardin on 04 Nov, 2025 04:40 PM

   

   Another one struggling with the same problem. The matching security is excluded from the list - I can't select it. So as Keith states above, you have to select "Don't Exist" from the list and then edit the transaction to the correct security. Getting old very fast.

   • Edit

3. 3 Posted by chris_hardin on 11 Nov, 2025 08:41 PM

   

   So I don't have a complete answer, but I feel I'm getting closer. I recently discovered the "Toolbox" extension. I had seen comments in other places that MD has an extra hidden field associated with each security that typically contains a CUSIP number. There are actually 2 fields - one that identifies the type of value in the 2nd field, and then the second field with the value. Toolbox now gives me the capability to see and even update those hidden values. What I've seen is that the newly created download securities, instead of having a CUSIP number in that hidden field, have the term "SEDOL", and then the ticker symbol in the actual field. SEDOL is a term from the London Stock Exchange - Stock Exchange Daily Official List - not sure whether it is Plaid or Moneydance that is putting that value in the field, but it seems an odd choice, since an SEDOL is very different from a ticker symbol. But I've gone through and updated several of my securities (using Toolbox) to specify SEDOL as the type and to put the ticker symbol in the value field. Now they are doing a better job of matching up during the import process. Still not fully correct - buy/sell transactions seem OK but dividend transactions keep showing "CUR:USD" in the security field.

   I'll keep poking at this to see what else I can find.

   • Edit

4. 4 Posted by K B on 13 Nov, 2025 02:41 AM

   

   The toolbox insight is interesting. I can confirm all the securities
   that don't match properly have a SEDOL entry that Moneydance is
   downloading but the correct long-time (decades plus in some cases)
   correct securities have a CUSIP entry as well. Residing in the US I have
   no idea why moneydance it now trying to download things and force a
   SEDOL match and not correctly matching to the long existing CUSIP
   securities.

   On 11/11/25 3:41 PM, chris_hardin wrote:

   • Edit

5. 5 Posted by dwg on 13 Nov, 2025 02:57 AM

   

   Moneydance does not try to selectively download data, the data downloaded is what is either provided by the aggregator in the case of Moneydance+ or by the institution in the case of Direct Connect. Hence if a different identifier is being provided it is being done upstream of Moneydance.

   • Edit

6. 6 Posted by chris_hardin on 13 Nov, 2025 01:59 PM

   

   I didn't expect that Moneydance was doing anything to the data. The real question is why is Plaid (or Schwab??) inserting that data? I don't have any way to communicate with Plaid. Does IK, as a user of their service, have any way to ask that question?

   • Edit

7. 7 Posted by KB on 16 Nov, 2025 12:10 AM

   

   This happens for securities held at etrade, vanguard, and schwab
   therefore doubtful all the institutions are doing this.

   Here is an example of exactly what is happening.

   Toolbox > Online Banking Tools > View your Security's hidden CUSIP settings

   These security entries exist

   Vanguard Extended Market ETF ^VXF VXF
    SEDOL 2835233 ** CUSIP & TICKER ARE DIFFERENT **
   Vanguard Extended Market ETF ^VXF VXF
      CUSIP 922908652 ** CUSIP & TICKER ARE DIFFERENT **

   When downloading new transactions, moneydance doesn't see a match and
   adds this entry

   Vanguard Group, Inc. - Vanguard Extended Mark ^VXF SEDOL
      VXF ** CUSIP & TICKER ARE DIFFERENT **

   Does moneydance need to update to accommodate data formatting changes in
   plaid?

   On 11/13/25 08:59, chris_hardin wrote:

   • Edit

8. 8 Posted by george.dobbs on 01 Dec, 2025 10:20 PM

   

   For what its worth, this is also happening to me with Merrill Lynch / Moneydance+.
   In my case I also see the SEDOL records being created. In all cases the ticker is placed in the ID field (where cusip normally goes).

   • Edit

9. 9 Posted by george.dobbs on 05 Dec, 2025 03:20 PM

   

   I'm wondering if anyone can comment on the following approach.
   Would it work? Would it cause other problems?

   The idea is to add the SEDOL scheme to the existing securities.
   The theory is that would allow the Plaid data to be matched correctly to existing securities..
   When new securities are encountered they would get added without CUSIP

   To make this more tangible, below is a script and sample data from my system.
   The Plaid data has the names in mixed case.
   The original data is all caps.

   book = moneydance.getCurrentAccountBook()
   currencies = book.getCurrencies()
   
   count=0
   
   
   mylist = currencies.getAllCurrencies()
   for sec in mylist:   
       id = sec.getID()
       stock_id = sec.getIDString()
       ty= sec.getCurrencyType().code()
       na= sec.getName()
       ticker = sec.getTickerSymbol()
       show = not sec.getHideInUI()
       cusip=sec.getIDForScheme("CUSIP")
       sedol=sec.getIDForScheme("SEDOL")
       inspect=("GM","TSM","C","TSMC")
       if (ty==1) and ((ticker in inspect) or (sedol in inspect)):
           s='%8d %10s %10s %10s %10s %45s'% (id,stock_id,ticker,cusip,sedol,na)
           print (s)
           count = count + 1
   

   7674010 ^874039100        TSM  874039100       None                      TAIWAN S MANUFCTRING ADR
    8888952         ^C                  None          C                                 Citigroup Inc
    9219360 ^37045V100         GM  37045V100       None               GENERAL MOTORS CO COMMON SHARES
    6288026        ^GM                  None         GM                        General Motors Company
    3114501 ^172967424          C  172967424       None                         CITIGROUP INC COM NEW
    5509181       ^TSM                  None        TSM      Taiwan Semiconductor Manufacturing - ADR
   

   • Edit

10. 10 Posted by chris_hardin on 07 Dec, 2025 04:38 PM

    

    That's essentially what I did, although I did it a little more manually using the Toolbox extension. I added an "SEDOL" entry to the hidden fields for each security, although the value of the entry is the ticker symbol and not the real SEDOL numeric code. (That's the way Plaid was generating the records.) Things are generally working better for me now - I haven't run into any significant problems. I still have a separate problem where some register entries come in with a security name something like "Curr:USD" and that won't match to anything. Those are still getting fixed manually.

    • Edit

11. 11 Posted by Stuart Beesley ... on 07 Dec, 2025 05:12 PM

    

    Toolbox 🧰 +1 😃

    • Edit

12. 12 Posted by dtd on 07 Dec, 2025 08:00 PM

    

    @chris_hardin
    I added CUR:USD as an actual security with the appropriate matching SEDOL, These usually occur on dividend transactions in cash accounts so don't really end up anywhere but in cash, at least for me and primarily in schwab

    i also did what you did by adding the "incorrect" but used by plaid sedol of the ticker itself.

    Toolbox +1 :smiley:

    • Edit

13. 13 Posted by dtd on 07 Dec, 2025 08:29 PM

    

    Conversely, you could create a

    'security" called anything, like CASH TRANSACTION and give it the CUR:USD SEDOL to catch them.

    • Edit

14. 14 Posted by chris_hardin on 08 Dec, 2025 01:26 AM

    

    @dtd
    That CUR:USD entry comes through on the dividend entries for multiple securities, and I need them assigned to the correct security in order to track return on investment properly. So just creating one and assigning everything to that one is not really a solution for me.

    That one still seems like something is screwed up in Plaid's system, and the wrong fields are matched up somehow, so we're getting the wrong values. Still looking for IK to work with Plaid and resolve that one.

    • Edit

15. 15 Posted by dtd on 09 Dec, 2025 01:18 AM

    

    @Achris - oh yes, got one of those today... i just almost automatically change that to the appropriate security ... don't even think about those anymore,

    • Edit

16. 16 Posted by george.dobbs on 10 Dec, 2025 04:33 PM

    

    Shout out to Chris Hardin and Stuart Beesley

    Toolbox was definitely useful.

    If anyone is interested I have a script that wholesale puts tickers into the sedol scheme.

    Unfortunately, I had to stop with Moneydance+ for Merrill Lynch (for now), since it also was missing transactions. I'll probably try again in the future, especially if IK reports progress.

    I was successful in getting my November data loaded. Happy to share script that I am using to load my ML accounts from the CSV files they offer.

    /george

    • Edit

17. 17 Posted by Stuart Beesley ... on 10 Dec, 2025 05:20 PM

    

    Toolbox 🧰 +2 😃

    • Edit