TD Credt Card Data Imports Incorrectly

lroche's Avatar


15 Dec, 2019 05:23 PM

When importing transactions from TD Credit Card Services website, all of the charges end up in the payments column and all of the payments import into the charges column. All of the payments also import as the 1/1000 times the actual amount. 1,247.24 imports as 1.24. Also four transactions from past periods keep importing over and over. Two of these are charges, and two are payments. All four are divided by 1000. Lastly, each time the prior month's transactions are imported, the number of transactions multiplies by the number of imports. There are 117 transactions in the month so the first time they imported, 117 transactions appeared in Moneydance. After deleting and trying to reimport the same data, 234 transactions appear in Moneydance. On the seventh import, 819 transactions appear. I downloaded the trial version that is available on the Infinitekind website and have unchecked the "Ignore transaction types..." box as instructed, but did not notice any improvement.

I do not know where to go from here, any assistance would be appreciated.

  1. 1 Posted by wadivkarts on 15 Dec, 2019 07:27 PM

    wadivkarts's Avatar

    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.

  2. 2 Posted by lroche on 15 Dec, 2019 08:09 PM

    lroche's Avatar


    I am importing QXF data and do not recall having any option to modify how the records are delimited. Am I missing something?

    Thanks for any direction you can offer on this in advance.

    Sent from my Verizon, Samsung Galaxy smartphone

  3. 3 Posted by lroche on 21 Jan, 2020 11:35 AM

    lroche's Avatar

    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.

  4. Support Staff 4 Posted by Maddy on 21 Jan, 2020 12:17 PM

    Maddy's Avatar


    Within the latest version, Moneydance 2019.3 (1880) you can find a feature called

    "Ignore Transaction Types in Favor of Amount Signs", in the Network tab of the settings, which should fix the problem for you.

    Please let me know if you have further questions or need any assistance.

    Maddy, Infinite Kind Support

  5. 5 Posted by lroche on 25 Jan, 2020 02:54 PM

    lroche's Avatar


    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.


    Chip Roche
    Newfab Inc.
    928 Minot Avenue
    Auburn, ME 04210-3719
    Phone: 207.786.2446. Ext. 201

  6. 6 Posted by Lacey on 18 Mar, 2020 11:28 PM

    Lacey's Avatar

    This comment was split into a new private discussion: TD Credt Card Data Imports Incorrectly

    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.

  7. Support Staff 7 Posted by Maddy on 19 Mar, 2020 02:49 PM

    Maddy's Avatar

    Hi Chip,

    Did you try upgrading to the latest free preview version?
    Moneydance 2019.4 (1904) is available to download from this page

    For a full list of improvements in the preview version, please refer to this page.

    Please keep us posted on your progress, Thank you!

    Maddy, Infinite Kind Support

  8. 8 Posted by lroche on 19 Mar, 2020 02:54 PM

    lroche's Avatar


    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.

    Thanks again,

    Chip Roche
    Newfab, Inc.
    928 Minot Avenue
    Auburn, ME 04210-3719
    207.786.2446 ext. 201

  9. 9 Posted by dwg on 19 Mar, 2020 08:10 PM

    dwg's Avatar

    I'm a fellow user.

    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.

  10. 10 Posted by Dan on 15 Jun, 2020 03:12 AM

    Dan's Avatar

    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.

  11. 11 Posted by lroche on 15 Jun, 2020 10:30 AM

    lroche's Avatar


    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.

Reply to this discussion

Internal reply

Formatting help / Preview (switch to plain text) No formatting (switch to Markdown)

Attaching KB article:


Attached Files

You can attach files up to 10MB

If you don't have an account yet, we need to confirm you're human and not a machine trying to post spam.

Keyboard shortcuts


? Show this help
ESC Blurs the current field

Comment Form

r Focus the comment reply box
^ + ↩ Submit the comment

You can use Command ⌘ instead of Control ^ on Mac