tag:infinitekind.tenderapp.com,2009-01-14:/discussions/online-banking/14898-td-credt-card-data-imports-incorrectlyInfinite Kind: Discussion 2020-09-14T10:40:23Ztag:infinitekind.tenderapp.com,2009-01-14:Comment/479222622019-12-15T19:27:24Z2019-12-15T19:27:26ZTD Credt Card Data Imports Incorrectly<div><p>I have the same issues with the debits and credits being interchanged. So am awaiting an answer on that.<br>
But regarding the 1/1000 amounts, that is due to the delimiter. While importing, select the decimal rather than the comma as a separator.</p></div>wadivkartstag:infinitekind.tenderapp.com,2009-01-14:Comment/479222622019-12-15T20:09:25Z2019-12-15T20:09:25ZTD Credt Card Data Imports Incorrectly<div><p>Wadivkarts:</p>
<p>I am importing QXF data and do not recall having any option to modify how the records are delimited. Am I missing something?</p>
<p>Thanks for any direction you can offer on this in advance.</p>
<p>Sent from my Verizon, Samsung Galaxy smartphone</p></div>lrochetag:infinitekind.tenderapp.com,2009-01-14:Comment/479222622020-01-21T11:35:57Z2020-01-21T11:35:57ZTD Credt Card Data Imports Incorrectly<div><p>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.</p></div>lrochetag:infinitekind.tenderapp.com,2009-01-14:Comment/479222622020-01-21T12:17:34Z2020-01-21T12:17:34ZTD Credt Card Data Imports Incorrectly<div><p>Hi,</p>
<p>Within the latest version, Moneydance 2019.3 (1880) you can find a feature called</p>
<p><strong>"Ignore Transaction Types in Favor of Amount Signs"</strong>, in the Network tab of the settings, which should fix the problem for you.</p>
<p>Please let me know if you have further questions or need any assistance.</p>
<p>--<br>
Maddy, Infinite Kind Support</p></div>Maddytag:infinitekind.tenderapp.com,2009-01-14:Comment/479222622020-01-25T14:54:30Z2020-01-25T14:54:30ZTD Credt Card Data Imports Incorrectly<div><p>Maddy:</p>
<p>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.</p>
<p>Thanks,</p>
<p>Chip Roche<br>
Newfab Inc.<br>
928 Minot Avenue<br>
Auburn, ME 04210-3719<br>
Phone: 207.786.2446. Ext. 201<br>
Website: <a href="http://www.newfabinc.com">www.newfabinc.com</a><a href="http://www.newfabinc.com/">http://www.newfabinc.com/</a></p></div>lrochetag:infinitekind.tenderapp.com,2009-01-14:Comment/479222622020-03-18T23:28:37Z2020-03-19T09:58:02ZTD Credt Card Data Imports Incorrectly<div><p>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.</p></div>Laceytag:infinitekind.tenderapp.com,2009-01-14:Comment/479222622020-03-19T14:49:09Z2020-03-19T14:49:09ZTD Credt Card Data Imports Incorrectly<div><p>Hi Chip,</p>
<p>Did you try upgrading to the latest free preview version?<br>
Moneydance 2019.4 (1904) is available to download from <a href="https://infinitekind.com/preview">this page</a></p>
<p>For a full list of improvements in the preview version, please refer to <a href="https://infinitekind.com/previewdl/current/changelog.txt">this page</a>.</p>
<p>Please keep us posted on your progress, Thank you!</p>
<p>--<br>
Maddy, Infinite Kind Support</p></div>Maddytag:infinitekind.tenderapp.com,2009-01-14:Comment/479222622020-03-19T14:54:58Z2020-03-19T14:54:58ZTD Credt Card Data Imports Incorrectly<div><p>Maddy:</p>
<p>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.</p>
<p>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.</p>
<p>I will let you know how the new version works out.</p>
<p>I hope all is well with you.</p>
<p>Thanks again,</p>
<p>Chip Roche<br>
Newfab, Inc.<br>
928 Minot Avenue<br>
Auburn, ME 04210-3719<br>
207.786.2446 ext. 201</p></div>lrochetag:infinitekind.tenderapp.com,2009-01-14:Comment/479222622020-03-19T20:10:55Z2020-03-19T20:10:55ZTD Credt Card Data Imports Incorrectly<div><p>I'm a fellow user.</p>
<p>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.</p>
<p>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.</p></div>dwgtag:infinitekind.tenderapp.com,2009-01-14:Comment/479222622020-06-15T03:12:49Z2020-06-15T03:12:50ZTD Credt Card Data Imports Incorrectly<div><p>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.</p></div>Dantag:infinitekind.tenderapp.com,2009-01-14:Comment/479222622020-06-15T10:30:44Z2020-06-15T10:30:44ZTD Credt Card Data Imports Incorrectly<div><p>Dan:</p>
<p>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.</p>
<p>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.</p>
<p>Then import the file into MD and it will work. I hope this helps.</p></div>lroche