Converting .qif Files to .qfx Files

Oct 09, 2008 11 Replies

Is there and easy way of Converting .qif files to .qfx files?



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....

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