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

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

Best Answers

  • questionsforever
    questionsforever Member ✭✭✭
    edited October 2021 Answer ✓
    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
    22times Member ✭✭
    Answer ✓
    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.

Answers

  • Chris_QPW
    Chris_QPW Member ✭✭✭✭
    edited August 2021
    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).
    Signature:
    (I'm always using the latest Quicken Windows Premier subscription version)
    This is my website: http://www.quicknperlwiz.com/
  • Chris_QPW
    Chris_QPW Member ✭✭✭✭
    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/
    Signature:
    (I'm always using the latest Quicken Windows Premier subscription version)
    This is my website: http://www.quicknperlwiz.com/
  • Marchand
    Marchand Member
    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
    Chris_QPW Member ✭✭✭✭
    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."
    Signature:
    (I'm always using the latest Quicken Windows Premier subscription version)
    This is my website: http://www.quicknperlwiz.com/
  • questionsforever
    questionsforever Member ✭✭✭
    edited October 2021 Answer ✓
    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
    AGJ60 Member
    edited December 2021
    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
    22times Member ✭✭
    Answer ✓
    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.
This discussion has been closed.