tag:infinitekind.tenderapp.com,2009-01-14:/discussions/problems/55848-import-of-ofx-duplicating-recordsInfinite Kind: Discussion 2020-04-06T01:40:25Ztag:infinitekind.tenderapp.com,2009-01-14:Comment/475401292019-08-20T15:30:07Z2019-08-20T15:30:07ZImport of OFX duplicating records<div><p>I am not support staff, just a user.</p>
<p>The OFX file should contain an account ID (ACCTID) number usually the last 4 digits of your account.</p>
<p>Extract from OFX file.</p>
<p>XXXX (XXXX last 4 digits of account number)</p>
<p>When you import the OFX file Moneydance will open a window asking you to confirm the import is going to the correct account based on the ACCTID. See screen shot. If it I not the correct account you can change it using the dropdown.</p>
<p>Also, 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>
</STMTTRN></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 a ACCTID and for each transaction a FITID.</p>
<p>Also, if you right click on a transaction imported via a 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/475401292019-08-20T19:52:46Z2020-01-06T01:12:09ZImport of OFX duplicating records<div><p>Hello,<br>
Thanks for replying.<br>
However, when I import (for instance) a file of credit card<br>
transactions into a credit card account, it is adding transactions<br>
from earlier imports which were to other accounts.<br>
I have checked the FITIDs and they are okay in the bank file, but I<br>
end up with duplicates in MD. In other words, the SAME transaction is<br>
appearing in two different MD accounts!<br>
So, MD is not preventing duplicate FITIDs! Not only that, FITIDs that<br>
are NOT in the import file are appearing in the MD accoubnt.</p>
<p>I have 700 transactions in a credit card file and the structure looks<br>
fine.<br>
When I import it into the matching MD account, I now get over 4,000<br>
transactions loaded.<br>
If I delete them all and import again, the number imported grows<br>
again.<br>
Something has gone terribly wrong with this 1880 release.<br>
I've been using MD for many years and never seen anything like this<br>
before.</p>
<p>Dave</p>
<p>On Wednesday 21/08/2019 at 1:30 am, derekkent23 wrote:</p></div>doggytag:infinitekind.tenderapp.com,2009-01-14:Comment/475401292019-08-20T20:10:50Z2019-08-20T20:10:50ZImport of OFX duplicating records<div><p>I am not support staff, just a user.</p>
<p>Hi, for info as I stated I am running 2018.4(1888) and not seeing duplicates when I import the same OFX file multiple time.</p>
<p>I reverted back to 2019.3(1880) and still don’t see an issue.</p>
<p>So, for you something strange is going on with the OFX file you are importing.</p>
<p>SUPPORT STAFF PLEASE STEP IN.</p>
<p>Hope this helps.</p></div>derekkent23tag:infinitekind.tenderapp.com,2009-01-14:Comment/475401292020-01-06T01:32:40Z2020-01-06T01:32:41ZImport of OFX duplicating records<div><p>I split the import OFX file into two parts and imported each part separately. Problem disappeared! Previously I had been importing quarters (which worked) but the whole year did not.<br>
Regds,<br>
Dave</p></div>doggy