Is there and easy way of Converting .qif files to .qfx files?
Converting .qif Files to .qfx Files
Oct 09, 2008
11 Replies
I guess that you need this in order to be able to import your QIF files into all of your accounts in Quicken. This latter refuses to do so for saving, checking, credi card accounts etc. Isn't it?
If I'm correct, qfx is a licensed format from Intuit and you have to pay $$$ if you want the specifications.
The workaround to still be able to work with QIF files is to simply modify their headers.
ADD The Following to the HEAD of the QIF file
!Account Naccountname Ttype ^
The date format of each transaction should also be MM/DD/YYYY
As an example, if you have an account called "My American Express Gold" that would give !Account NMy American Express Gold TCCard ^
Or a bank account called "My savings" !Account NMy savings TBank ^
For the type next to the "T" you have the following options: Bank, CCard, or Invst
Next to the "N" you add your account name
Actually you even can be more detailed by adding extra information: Field Indicator Explanation N Name T Account type (Bank, CCard, Invst) L Credit limit (for credit cards) D Description ^ End of entry
Hope that this helps.
Sincerely, Steve JORDI
(Remove the K_I_L_LSPAM from my email address)
------------------------------------------------
1197 Prangins Email: stevejordiK_I_L snipped-for-privacy@hotmail.com Switzerland WWW:
formatting link
------------------------------------------------ Volcanoes at
formatting link
MovieDB at
formatting link
------------------------------------------------
Oh man, are you kidding? Perfect info!!! Many thanks!!! I have only .qif files for the first part of '07, after the switch to the new format. So I needed this info to be able toi finish 2007, I'm cool from 07/07 on with the new format files. Thanks so much for the help!!!
OK at the top of the .qif file there is the line:
"!Type:Bank"
Does that stay? and the other stuff just goes ahead of it?
Glad to be of any help :-)
Actually, do you already have this at the top of your QIF file? In that case it's for a banking account. Not a credit card one or any other one.
In my case, I have a QIF file to which I just added the 4 line header as described before, but I left the entire rest of the file as is.
Is "!Type:Bank" already in your QIF before you touched it? Should be "TBank" (without the quotes of course). I guess it's a different Quicken version flavor. From what I know this kind of "!Type:Bank" tag appears when your QIF file has been created within Quicken itself.
For more information you should maybe check
formatting link
Sincerely, Steve JORDI
(Remove the K_I_L_LSPAM from my email address)
------------------------------------------------
1197 Prangins Email: stevejordiK_I_L snipped-for-privacy@hotmail.com Switzerland WWW:
formatting link
------------------------------------------------ Volcanoes at
formatting link
MovieDB at
formatting link
------------------------------------------------
As long as the Quicken account type is bank (not credit card or investment, etc.), then I think you can just add the other 4 lines before the "!Type..." line. And in some situations, you may actually need that "!Type..." line.
KeithGrill had written this in response to
formatting link
: Hope this question isn't too stupid, but what program are you using to modify/ADD to the .qif file headers?
Keith Grill
------------------------------------- Steve JORDI wrote:
##-----------------------------------------------## Newsgroup Access Courtesy
formatting link
Tax and Accounting Software ForumsWeb and RSS access to your favorite newsgroup - alt.comp.software.financial.quicken - 22615 messages and counting! ##-----------------------------------------------##
KeithGrill had written this in response to
formatting link
: Hope this question isn't too stupid, but what program are you using to modify/ADD to the .qif file headers?
Keith Grill
------------------------------------- Steve JORDI wrote:
##-----------------------------------------------## Newsgroup Access Courtesy
formatting link
Tax and Accounting Software ForumsWeb and RSS access to your favorite newsgroup - alt.comp.software.financial.quicken - 22615 messages and counting! ##-----------------------------------------------##
you can always just use NOTEPAD for editing any plain text data markup files like these....
Notepad is a safe bet.
formatting link
-------------------------------------
formatting link
responding to
formatting link
propersoft wrote:
formatting link
- will make your QIF files loadable to Quicken
-------------------------------------
formatting link
Join the Discussion
Have something to add? Share your thoughts — no account required.
Didn't find your answer?
Ask the community — no account required