How convert a .OFX file to a .QFX file?

Marchand

My bank only have the OFX format, but Quicken need a QFX format, then i need to convert the file. Thanks

questionsforever

It is very easy to convert it with some minor work.

1. download 'transactions app' from propersoft. make sure your INTU.BID code matches some canadian bank, e.g. 0002 for TD canada trust. You can edit this if its from another bank just to import it . Make sure quicken register is linked with the name TD Canada Trust or whatever FID code you use.
2. using the free trial, open the ofx and it will produce a qfx with the first 10 transactions.
3. use notepad++ to open the original ofx and copy and paste the remaining transactions to the body of the qfx generated in #2 .
4. make a few edits. for example, change the word 'POS' for transaction type to 'DEBIT'. For 'CREDIT' transactions, remove the bankid, acctid tag if any. I find this is useless.
5. import it

Works for me, although I import every 3 months to save time.

22times

I've only tested the OFX format on one vendor (Privacy.com) but I was able to use this free tool for Windows to convert the OFX to QIF.

https://www.lifeknowledge.com/free-qfx-to-qif-converter/

I was able to convert the OFX to QFX using the instructions from questionsforever, but it was a real hassle having to change the header that QFX likes and adding FID, INTU.BID, and INTU.USERID. I had to use data from a top 10 bank to make it work. So, converting to QIF is easier when I need a tx dump.

Chris_QPW

I don't think it is allowed to discuss the details on how to do such a conversion because in fact the main reason for creating a .QFX format instead of just using the .OFX format was to ensure that a financial institution be on the "participating partner's" list that Intuit has agreements with (Quicken Inc pays Intuit to maintain the "connected services" for these financial institutions).

Chris_QPW

P.S. Another way to approach this problem is a OFX to QIF converter like ImportQIF which you can get from my website:
http://www.quicknperlwiz.com/

Marchand

My financial institution have an agreement with Quicken, and my intitution have the QFX and the OFX format for particulars, but for the businesses they only offer the OFX format, thats why i need to convert the file until the QFX format will be avalaible.

Chris_QPW

Note the official Quicken Inc line would be something like this "Sorry Quicken only supports importing using QFX format, you will have to talk to the financial institution and get them to sign an agreement for those accounts."

questionsforever

It is very easy to convert it with some minor work.

1. download 'transactions app' from propersoft. make sure your INTU.BID code matches some canadian bank, e.g. 0002 for TD canada trust. You can edit this if its from another bank just to import it . Make sure quicken register is linked with the name TD Canada Trust or whatever FID code you use.
2. using the free trial, open the ofx and it will produce a qfx with the first 10 transactions.
3. use notepad++ to open the original ofx and copy and paste the remaining transactions to the body of the qfx generated in #2 .
4. make a few edits. for example, change the word 'POS' for transaction type to 'DEBIT'. For 'CREDIT' transactions, remove the bankid, acctid tag if any. I find this is useless.
5. import it

Works for me, although I import every 3 months to save time.

AGJ60

It is rather disappointing that such an expensive software blocks the usage of open source standards such as OFX. As a result banks do not offer a good experience, limiting information to the last 3 months only. I live in the U.S. but have accounts in a foreign country that is not even serviced by Quicken, but in which banks provide free OFX files since ever. [Removed-Disruptive]

22times

I've only tested the OFX format on one vendor (Privacy.com) but I was able to use this free tool for Windows to convert the OFX to QIF.

https://www.lifeknowledge.com/free-qfx-to-qif-converter/

I was able to convert the OFX to QFX using the instructions from questionsforever, but it was a real hassle having to change the header that QFX likes and adding FID, INTU.BID, and INTU.USERID. I had to use data from a top 10 bank to make it work. So, converting to QIF is easier when I need a tx dump.