Transaction imports from TD Ameritrade

[ketu11]

was able to import data/transactions into 'fund manager' program up to month ago from TD Ameritrade.
But about a month ago, when importing from TD Ameritrade, the transactions are all incorrect. They show wrong shares purchased, values, create new company data files instead of importing into their existing company data files.
have had no problems in importing transactions from other institutions.
any suggestions. thanks.

[Mark]

Hi ketu11,

Are you using the current version of Fund Manager (12.3) with the latest transaction module (177)? See "Help / About..." or "Help / FM on the Web / Check for Updates...".

Do the transactions look like they are maybe from another account you have? If you look in the xmldump.txt and ofxretr.txt log files, do the transactions shown in Fund Manager match what is being downloaded from TD Ameritrade? You can find these log files in the hidden folder:

C:\Users\<username>\AppData\Roaming\Fund Manager

[rdg]

This seems to be getting worse. First noticed it about a month ago.
Currently I "Update", when it stops it shows "Current Status : Complete" but the only button is "Cancel".
No transactions show up.
I press "Cancel", it defaults back to the start update screen, I hit update again and it now downloads transactions but seems to randomly double count and adds transactions ???

[Mark]

Hi rdg,

If you turn off the "Advanced Options... / Default Cash Distributions are Reinvested" in the "Retrieve Transactions" dialog, do you see a $0 distribution? We've recently found/fixed a bug where if you had a $0 distribution and this option was on, the import could hang the program. We found this with TD Ameritrade, as they do seem to report $0 cash interest distributions in some cases. I'm not sure this is what is happening with you, but if you try turning off that option, if things start working okay, that would help identify the problem.

[rdg]

Thanks Mark, It worked.
Not sure why, many of the problems transactions were "SELL" that showed as negative "Distributions".

Just redid my account and now it looks fine.

[Gary T.]

Mark,
I am having the same problem as the June 30th post when I try to retrieve transactions from TDAmeritrade. Am on FM 11.9 and Transaction Retrieve Module 177. I cannot find the choice in the Dialog you referenced. I was going to Upgrade to FM 12.4 but since format changes will occur I am concerned that I may have data base corruption.
Let me know.
Thanks again,
Gary T.

[Mark]

Hi Gary T.,

You can either turn off the option to record cash dividends as reinvested, or upgrade to 12.4, which fixes this bug. Upgrading to 12.4 should not cause any database problems. Just install 12.4 over your current 11.9 version. Do not uninstall 11.9 first. Once you start v12 it will ask you for permission to convert your files to the new format. Say "Yes to all" when prompted to give it permission.

[Gary T.]

Mark,
I have upgraded to 12.4 and removed the "Default cash Distributions are Reinvested" option. Now when I do a Transactions Retrieve the "Preview Importing Transactions" Dialog displays no content. However, there are transactions for the account that have not been downloaded. I am at a loss as to how to proceed?
Thanks,
Gary T.

[Mark]

Hi Gary T.,

That bug was fixed in 12.4, so you can turn back on that option to record distributions in cash as reinvested.

If the Preview window is empty and you are expecting transactions, check:

1) the date range of the retrieve
2) are the transactions maybe already recorded? Try temporarily turning off the option to skip transactions in FM. If that causes transactions to start appearing in the Preview window, then you already have these transactions recorded.
3) If neither of the above explain it, look in the log files, and see if there are transactions retrieved. See the "xmldump.txt" log file.

[Gary T.]

Mark,
All seems to be working as designed now with the transactions import feature. Although I was hoping that in this release that two transactions would be mapped to the correct transaction type. Right now as in the past, I have to remove the "Management Fee" and "Money Market Interest" from the import dialog and manually journal them, to Account Fee and Interest Income respectively. I am sure we had this discussion before, and thought it might be in line for resolution in a future release.
Thanks again,
Gary T.

[Mark]

Hi Gary T.,

You'll have to refresh my memory on this issue. Why are you having to manually input these 2 transactions? There is no "Management Fee" or "Money Market Interest" transaction type? There are distributions of type "Account Fee" or "Interest Income". Are you reading this from a memo or something? Maybe you can email me your ofxretr.txt log file after a retrieve of the transactions in question.

[Gary T.]

Mark,
The "Management Fee", that is imported is translated as a sell in the Preview Transactions to Import Dialog, and is posted to the Default Cash Account as a redemption. However, it is an "Account Fee" and should be posted as a Negative Distribution. The "Money Market Interest", is posted as a Dividend Distribution and not as an Interest Income Distribution. Both descriptions are from the Memo Field. Does this help?
Thanks

[Mark]

Hi Gary T.,

Yes, that helps me understand. I would need to see how TDA is reporting these transactions in your download. Can you take a look in your "xmldump.txt" log file after retrieving these transactions, and see how they are being reported? You can either email me this file, or just post the snippets from that file that describe these 2 transactions in question.

[Gary T.]

Mark,
Where do you want me to email the file?
Gary T.

[Mark]

Hi Gary T.,

I've just sent you an email, so you can reply to that with the log file attached.