Bank unable to verify a QFX file
I have several hundred credit card transactions from a year ago that were not downloaded into Quicken at the time. The bank statements however are still accessible. So I have used Docuclipper to create a QFX file from these bank statements. However when I attempt to import the QFX file into Quicken (Home and Business) I receive a "unable to verify the financial institution information. What can I do to resolve this?
Comments
-
Quicken checks to see if the financial institution is a licensed participating Quicken partner and that is the check that is failing. That test could fail if you have the FI identified incorrectly or if indeed they are not a partner.
I'd convert your .QFX file into a .QIF style file and load it that way.
-splasher using Q continuously since 1996
- Subscription Quicken - Win11 and QW2013 - Win11
-Questions? Check out the Quicken Windows FAQ list0 -
Since this appears to be a one-time import of data into Quicken and not a repeat occurrence, please try this:
Before you begin create a backup of your Quicken data file.
Use Notepad (Mac: TextEdit) or any other available ASCII text editor (not Word!) to edit your QFX file.
Replace the bank ID number in two of the header records of the file with the number shown here:
<FI>
<ORG>???? (leave unchanged whatever it is)
<FID>10898
</FI>
<INTU.BID>10898
<INTU.USERID>???? (leave unchanged whatever it is)
(10898 = Chase Bank. Canadian users try 00005 instead (CIBC))
Don't change anything else. Just those two numbers. And verify the period in both <INTU.BID> and <INTU.USERID> clauses. If the period is missing, the download won't work
Save the QFX file to a different file name and import it into Quicken into a new, temporary account register.
Once imported, select to highlight all transactions in the new register except the Opening Balance transaction.
Windows: Right-click a selected transaction. Select "Move transactions" from the popup and select the destination register, your real bank account register.
Mac: Drag the entire block of transactions into your real account register in the Account sidebar.
In the real register, if necessary, edit the existing Opening Balance transaction to the desired (oldest) date and set the amount to the same day's paper statement Ending Balance.
Now you're ready to compare your register to the bank statements and fix any discrepancies.
You can delete the temporary account register now.0

