tag:infinitekind.tenderapp.com,2009-01-14:/discussions/online-banking/14000-downloading-transactionsInfinite Kind: Discussion 2020-06-07T16:40:24Ztag:infinitekind.tenderapp.com,2009-01-14:Comment/475467872019-08-22T06:35:49Z2019-08-22T06:35:49ZDownloading transactions<div><p>I am not support staff, just a user.</p>
<p>It depends, what file formats does your bank provide, OFX, QFX, OFC, QIF or CSV?<br>
What version and build of Moneydance are you running 2019.4(1888)?</p></div>derekkent23tag:infinitekind.tenderapp.com,2009-01-14:Comment/475467872019-08-22T17:20:03Z2020-03-02T15:59:43ZDownloading transactions<div><p>The file is OFX.Version is 2019.3 (1880)<br>
Thanks</p></div>sgermain1966tag:infinitekind.tenderapp.com,2009-01-14:Comment/475467872019-08-22T18:36:48Z2019-08-22T18:36:48ZDownloading transactions<div><p>I am not support staff, just a user.</p>
<p>The OFX files should contain a "Unique Transaction ID" (FITID) for each transaction. Moneydance uses this ID to prevent duplicates.</p>
<p>The following is an extract of one transaction from my credit card downloaded OFX file. Note the FITID number.</p>
<pre>
<code><TRNTYPE>DEBIT</TRNTYPE>
<DTPOSTED>20190806000000</DTPOSTED>
<TRNAMT>-2.90</TRNAMT>
<FITID>20190806000000001</FITID>
<NAME>Southend On Sea Boroug, Southend</NAME>
<CARD>Visa</CARD>
<MEMO>On S XXXX/2.90 POUND STERLING GREAT BRITAIN</MEMO></code>
</pre>
<p>I am running Moneydance 2019.4(1884). It does not matter how many times I import this file the transaction only appears once.</p>
<p>Worth opening your OFX file from your bank in a text editor to make sure they have included for each transaction a FITID.</p>
<p>Also, if you right click on a transaction imported via an OFX file and select “Show transaction details” it should include the FITID</p>
<p>Hope this helps.</p></div>derekkent23tag:infinitekind.tenderapp.com,2009-01-14:Comment/475467872019-08-26T14:42:51Z2020-03-02T15:59:44ZDownloading transactions<div><p>it worked. Thank you much</p>
<p>I am having to reconcile every transaction and I was wondering if there is<br>
a way for money dance to recognize transactions from the same vendor and<br>
categorize them automatically<br>
thanks</p></div>sgermain1966tag:infinitekind.tenderapp.com,2009-01-14:Comment/475467872019-08-26T14:50:18Z2019-08-26T14:50:18ZDownloading transactions<div><p>Hi Stephan,</p>
<p>The automatic assignment of categories relates to the 'confirmation process'. This is detailed in <a href="https://infinitekind.tenderapp.com/kb/online-banking-and-bill-pay/confirm-downloaded-data">this article</a> from the Knowledge Base.</p>
<p>When transactions have been downloaded from the bank, they'll be 'unconfirmed' which is signified by a blue dot in the account register.<br>
To begin the confirmation process, select the first transaction in the register with a 'blue dot'. A panel will appear on the right of your screen which shows the 'Current Transaction' details. You should amend the category within this panel, then select 'Confirm'.<br>
You'll see the solid blue dot change to a blue circle. Moneydance will then move to the next unconfirmed transaction in the register.<br>
As you go through this process it will become quicker and easier. Moneydance will begin to recognise the information you have previously confirmed, and start to suggest the correct categories within 'Similar Payees' in the panel on the right.<br>
The next time you download from the bank many of the correct categories will automatically be assigned, and this will improve and you confirm more transactions.</p>
<p>I hope this information is helpful. 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/475467872019-08-26T19:36:15Z2020-03-02T15:59:44ZDownloading transactions<div><p>Thank you very much</p></div>sgermain1966tag:infinitekind.tenderapp.com,2009-01-14:Comment/475467872019-08-31T14:09:18Z2020-03-02T15:59:44ZDownloading transactions<div><p>Hello again,<br>
I want to manage my credit cards accounts with Moneydance as well.<br>
American Express only gives me options to download as Quicken, Quickbooks<br>
or CSV. Those options do not seem to be available with Money dance<br>
please advise<br>
Thank you<br>
SG</p></div>sgermain1966tag:infinitekind.tenderapp.com,2009-01-14:Comment/475467872019-08-31T14:20:05Z2019-08-31T14:20:05ZDownloading transactions<div><p>I am not support staff, just a user.<br>
Hi stephan</p>
<p>If you download the the file described as Quicken does it turn a to be a QFX file, it not what is its file type.<br>
Moneydance can import QFX files.</p>
<p>As a last best option Moneydance can import CSV files if they are correctly formatted using its own importer or there is a third party importer that more flexible.</p>
<p>Hope this helps.</p></div>derekkent23tag:infinitekind.tenderapp.com,2009-01-14:Comment/475467872019-08-31T15:43:26Z2020-03-02T15:59:44ZDownloading transactions<div><p>it did, thank you very much</p>
<p>new question, how do i enter credit card payments from my bank account ?<br>
I am having problems doing this as it doubles transactions on the receiving<br>
account</p>
<p>hope this makes sense</p></div>sgermain1966tag:infinitekind.tenderapp.com,2009-01-14:Comment/475467872019-08-31T16:39:00Z2019-08-31T16:39:00ZDownloading transactions<div><p>I am not support staff, just a user.</p>
<p>If you are making a payment from your bank account to your credit card to reduce the credit card debt all you need to do is in the bank account register set the category to your credit card account and enter the payment value in the payment box.</p>
<p>I assume one you import the QFX file you are following the Confirm process see <a href="https://infinitekind.tenderapp.com/kb/online-banking-and-bill-pay/confirm-downloaded-data">https://infinitekind.tenderapp.com/kb/online-banking-and-bill-pay/c...</a> to merge duplicate transactions.</p>
<p>Hope this help.</p></div>derekkent23tag:infinitekind.tenderapp.com,2009-01-14:Comment/475467872020-03-08T14:44:34Z2020-03-08T14:44:35ZDownloading transactions<div><p>my dowloaded transactions appear 3 times on the ledger<br>
Please help<br>
I have tried all extensions available from Chase bank.</p></div>sgermain1966tag:infinitekind.tenderapp.com,2009-01-14:Comment/475467872020-03-08T16:37:10Z2020-03-08T16:37:10ZDownloading transactions<div><p>I am not support staff, just a user.<br>
Hi sgermain1966</p>
<p>Again its not a good idea to ask the same question twice or more<br>
See <a href="https://infinitekind.tenderapp.com/discussions/online-banking/15507-issue-with-downloading">https://infinitekind.tenderapp.com/discussions/online-banking/15507...</a></p>
<p>Hope this helps.</p></div>derekkent23