QFX Import Issues
I've got Quicken version R6628 all updated and having trouble importing a file I downloaded from my bank and a current Quicken subscription
When I got to File/Import/data.qfx, Quicken seems to process it but the transactions aren't added and I receive no error message.
When I go to the account and edit account details / online services and select download and import transactions, the system processes the file and displays 'Imported 0 transactions'
If I open the qfx file in notepad, everything looks fine.
Suggestions?
Comments
-
What's the name of the bank?
Some banks, that previously supported Q. have been know to continue to provide Q downloads … but since they voided the contract with Q/Intuit they're no longer "Participating Financial Institutions" and thus those downloaded QFX files can't be imported.
Q user since February, 1990. DOS Version 4
Now running Quicken Windows Subscription, Business & Personal
Retired "Certified Information Systems Auditor" & Bank Audit VP0 -
Truist
0 -
It makes sense that the second import reported 0 transactions since Quicken won't import a transaction twice , to prevent duplicates. I don't have an explanation for the first failure.
You could try editing the .QFX file using a text editor like Notepad (not a word processor like Word) and add a "A" to the value in each transaction's FITID field. You can add anything, you just need to make the FITID different. Then use the second method to do the import.
NOTE: Make a backup first in case something goes wrong.
-splasher using Q continuously since 1996
- Subscription Quicken - Win11 and QW2013 - Win11
-Questions? Check out the Quicken Windows FAQ list1 -
I made a backup. Thanks for the reminder. I downloaded a qfx file with two transactions and added an "A".
It didn't add the transactions, but I did notice it added an 'Adjusting Transaction' with todays date. I have two from today since I tried importing it twice and three from yesterday. The number are negative and getting very large.
0 -
How many characters are in the value that Truist is putting in the file for FITID?
If it is really long, maybe it is longer than Quicken can deal with and didn't "see" the added "A". You could try changing a character at the beginning of it.
-splasher using Q continuously since 1996
- Subscription Quicken - Win11 and QW2013 - Win11
-Questions? Check out the Quicken Windows FAQ list0 -
<FITID>3455805630
<REFNUM>3455805630I tried shortening <FITID> and adding the A. No change.
I noticed FITID and REFNUM were the same number, so I shortened both and added the A to make them match and no luck.
The two transactions are in my test file are transfers between accounts in Quicken.
Thanks for your ideas!
0 -
I think my next step will be to create a new instance of Quicken and the account and see if imports to 'clean' data set.
0 -
In the header records of your QFX file, what numbers are shown next to either <FID>xxxxx or <INTU.BID>xxxxx?
There are a number of banks listed in the FIDIR.TXT file, formerly independent ones, now merged into Truist. Not all appear to support Webconnect / QFX file downloading.
0 -
Interesting. I've never had issues in the past.
<FID>BB&T
</FI>
<INTU.BID>155620 -
And in the last few months a number of banks made changes to their download support, apparently "for security reasons". This included removal of support for Webconnect / QFX file downloading.
AFAIK, <FID>xxxxx should be the same 5-digit number as <INTU.BID>xxxxx but I don't know if that's what causes your problems.
The entry for "Truist Online Banking - WC", 15562, in the FIDIR.TXT configuration file does support WebConnect … so, poof! goes my theory. QFX Import should have worked at least once.Try changing the number to 10898 (Chase Bank) and see if you can import into a new (temporary) account register. If that's successful, block-select the transactions you need and MOVE them into the real register where you need them. When done, delete the temporary register.
0 -
The identity of the financial institition should have these fields:
<FI>
<ORG>xxxx
<FID>nnnnn
</FI>
<INTU.BID>nnnnnOnly the last two have been mentioned in this discussion. Doesn't the "xxxx" of the <ORG> have to match what is in the FIDIR.TXT as well? "xxxx" is the full text less trailing blanks from the fidir.txt file.
E.g.: "15562 15562 15562 Truist Online Banking - WC https://www.truist.com/ 888-228-6654…"
The above is from my current fidir.txt and would translate to:
<FI>
<ORG>Truist Online Banking - WC
<FID>15562
</FI>
<INTU.BID>15562On the other hand, my experience has been that, when there are issues with the FI's identity in the QFX file, you get some kind of error message not just no transactions processed.
Jim
0
