• Page :
  • 1
  • Text Only
Voting History
rated:
A few months ago, there was a thread about someone creating an Excel Conversion tool to move old QIF fomat files over to the new QFX format files. At the end of that discussion, things were pretty much left in Limbo, so here is my attempt to re-visit the issue and hopefully get a better answer.

I recently upgraded from Quicken 2004 to 2006 so that I would be able to download dat from a new bank account, but when I did so I didn't realize that my old (but still current) bank was only able to provide .qif files.

SO... being poor and in need, I am looking for a quick and (not so) dirty conversion tool that can take the .QIF files from my old bank and convert them to the newer .QXF format so that I can then use the data that I CAN get from my old bank.

I do know about the "BIG RED Consultants" conversion tool, but as I said earlier, I'm pretty poor right now and the paltry purchase of Quicken STANDARD has put a huge dent into my discretionary funds.

Any help on this would be GREATLY appreciated!!!

Member Summary
Quick Summary is created and edited by users like you... Add FAQ's, Links and other Relevant Information by clicking the edit button in the lower right hand corner of this message.
Thanks for visiting FatWallet.com. Join for free to remove this ad.

I didnt use any conversion tool but I did the following work around
1) Create a dummy CASH account since The cash account can download the .quif files in Quicken 2006.
2) download/import the .qif files into the above dummy/bogus cash account.
3) Press Ctrl+A in the above dummy cash account log, right click, selet "Move Transactions to" and select the "REAL ACCOUNT" to where these transactions to be posted..
4) You are done, <img src="i/expressions/face-icon-small-smile.gif" border=0> your .qif file is into your *Required* account <img src="i/expressions/face-icon-small-smile.gif" border=0>
-SB

Phraedrique said: [Q]A few months ago, there was a thread about someone creating an Excel Conversion tool to move old QIF fomat files over to the new QFX format files. At the end of that discussion, things were pretty much left in Limbo, so here is my attempt to re-visit the issue and hopefully get a better answer.

I recently upgraded from Quicken 2004 to 2006 so that I would be able to download dat from a new bank account, but when I did so I didn't realize that my old (but still current) bank was only able to provide .qif files.

SO... being poor and in need, I am looking for a quick and (not so) dirty conversion tool that can take the .QIF files from my old bank and convert them to the newer .QXF format so that I can then use the data that I CAN get from my old bank.

I do know about the "BIG RED Consultants" conversion tool, but as I said earlier, I'm pretty poor right now and the paltry purchase of Quicken STANDARD has put a huge dent into my discretionary funds.

Any help on this would be GREATLY appreciated!!!

Quicken is like $20-$40 is it put that big of a dent in your funds you should consider cutting other costs.

We are already down pretty much to the bare bones. There are araes to cut back on, but as for Discresionarymoney, that is at a bare minimum. Bills, Rent, Food, Savings - These are not discresionary.

<img src="i/expressions/face-icon-small-smile.gif" border=0><img src="i/expressions/face-icon-small-happy.gif" border=0>

If I accidenatlly grab duplicates of the "good" account, Will this overwrite or add duplicated within the actual account?

If you can get an OFX (Microsoft Money) file download from your institution, you can edit it to become a QFX file that Quicken can import. The steps are:

1. Download OFX (Microsoft Money) file.
2. Change the file extension from OFX to QFX.
3. Open the QFX file in Notepad and make the following changes:
a. add <INTU.BID>3000 after <LANGUAGE>ENG
b. change <BANKID> to 00000001
c. change <TRNUID> to 0
4. Open Quicken and choose Insert, Web Connect and it will trick Quicken into letting you import your transactions.

Hope you find that helpful.

Phraedrique said: [Q]We are already down pretty much to the bare bones. There are araes to cut back on, but as for Discresionarymoney, that is at a bare minimum. Bills, Rent, Food, Savings - These are not discresionary.

<img src="i/expressions/face-icon-small-smile.gif" border=0><img src="i/expressions/face-icon-small-happy.gif" border=0>

If you $20 is a big hit for you, maybe you should drop the internet connection you are typing your messages on. Or are you doing this at work? <img src="i/expressions/face-icon-small-smile.gif" border=0>

pjhartman:
Many Thanks for the info on the OFX/QFX conversion. I had seen something like this a week or so ago, but at the time aI had thought that all I had access to was the old QIF files. It was just yesterday that i noticed that my CU DOES have the OFX files, so things are looking happier there.

I will give this conversion method a try tomorrow when i get back in from the field...

pjhartman said: [Q]If you can get an OFX (Microsoft Money) file download from your institution, you can edit it to become a QFX file that Quicken can import. The steps are:

1. Download OFX (Microsoft Money) file.
2. Change the file extension from OFX to QFX.
3. Open the QFX file in Notepad and make the following changes:
a. add <INTU.BID>3000 after <LANGUAGE>ENG
b. change <BANKID> to 00000001
c. change <TRNUID> to 0
4. Open Quicken and choose Insert, Web Connect and it will trick Quicken into letting you import your transactions.

Hope you find that helpful.

pjhartman said: [Q]If you can get an OFX (Microsoft Money) file download from your institution, you can edit it to become a QFX file that Quicken can import. The steps are:

1. Download OFX (Microsoft Money) file.
2. Change the file extension from OFX to QFX.
3. Open the QFX file in Notepad and make the following changes:
a. add <INTU.BID>3000 after <LANGUAGE>ENG
b. change <BANKID> to 00000001
c. change <TRNUID> to 0
4. Open Quicken and choose Insert, Web Connect and it will trick Quicken into letting you import your transactions.

Hope you find that helpful.

This is great! I tried this with Presidential and found you only need to make one change to import the OFX file (the other changes make it not work). Here are the revised instructions for Presidential:

1. Download OFX (Microsoft Money) file.
2. Change the file extension from OFX to QFX.
3. Open the QFX file in Notepad and make the following changes: add <INTU.BID>3000 after <LANGUAGE>ENG
4. Open Quicken and choose Insert, Web Connect and it will trick Quicken into letting you import your transactions.

Quicken will detect the transfer as a Wells Fargo Import but after selecting the Presidential account to import, the entries will be inserted with no problem.



Disclaimer: By providing links to other sites, FatWallet.com does not guarantee, approve or endorse the information or products available at these sites, nor does a link indicate any association with or endorsement by the linked site to FatWallet.com.

Thanks for visiting FatWallet.com. Join for free to remove this ad.

TRUSTe online privacy certification

While FatWallet makes every effort to post correct information, offers are subject to change without notice.
Some exclusions may apply based upon merchant policies.
© 1999-2014