I have the same issues with the debits and credits being interchanged. So am awaiting an answer on that.
But regarding the 1/1000 amounts, that is due to the delimiter. While importing, select the decimal rather than the comma as a separator.
I found a work around. Moneydance now has a problem importing QFX data from TD Credit Card. It worked fine for years prior to November or December of 2019, but something has changed. Until they figure this out, I have been able to export data from TD Credit Card to a csv file. I then open it in excel, add a column to the right of the amount column, move the credit amounts into this new column and import. This gets the charges and credits into the correct columns.
I followed your instructions below and downloaded my December transactions from TD Credit Card Services but it did not fix the problem. The charges are all in the payment column and the payments, or credits are all in the charge column. Also the payments are off by a factor of 1000. A 1,000.00 payment imports as 1.00. There are other problems as well, the download included payments, divided by 1,000, from three or four prior months. It also imports duplicate transactions. Importing via QFX is not working for me at all. I am going to stick to importing by .csv file and modify it as I described below.
I am having the same issue with my TD Credit Card account. Has there been any progress on this issue? I have "Ignore Transaction Types in Favor of Amount Signs" set up in my preferences but it does not solve the issue. ALL downloaded transactions end up in the charge column, no matter what. I can use the CSV workaround, but that is extremely tedious for the volume of our transactions.
Thank you for thinking of me. I was not aware that there is a new version. I may try it. In the meantime, I am able to import transactions by exporting from TD Credit Card Services to a .csv file, adding a column for credits, moving the credits out of the charges column into the credits column and then importing. This works for now, but I would obviously rather be able to import directly.
I am still wondering why I was able to import from TD Credit Card for so many years, and then have it stop working one day. Something changed.
I will let you know how the new version works out.
I hope all is well with you.
928 Minot Avenue
Auburn, ME 04210-3719
207.786.2446 ext. 201
Some banks, in recent times, seem to be reinterpreting the OFX specification and changing the way information is presented in the OFX files you download.
Why change something that has been working who knows, it is known that at least one bank has completely broken their QIF downloads and that is despite that specification being perfectly clear about the structure.
I have the same issue, the only option from TD download (aside from csv) is QFX and it loads all charges as payments in MD. Checking Ignore trans type in favor of amount sign did not work. I have MD 2019.4 1904.
I have tried everything I have either read or can think of to import a QFX file and it just does not work. I used to work, I imported QFX to MD from TD Credit Card for probably 10 years, but it doesn't any more. MD support thinks they have fixed the problem, but they must not see the same issue when they download from the TD site as I (we) do.
Anyway, your timing is perfect, I just downloaded transactions from TD yesterday. The only way that I have found that works is to download as .csv. This gives you a table with columns labelled Date, Activity Type, Merchant Name, Merchant Category Description, Amount and Award or something, I deleted the last column. I add a column to the right of Amount and label it Payment and change the label of the Amount column to Charge. Then delete the credits from the Amount column and paste them into the Payments column and remove the minus signs. Save the modified file somewhere convenient.
Then import the file into MD and it will work. I hope this helps.