QIF to OFX

My bank only provides .qif files for on line bill pay transactions. Does anyone know if there is a good free (or very inexpensive) converter that converts .qif to .ofx transactions? This is for Quicken 2010 with Windows 7.

I have gone looking but don't find anything satisfactory yet.

Thanks,

Gordon

Reply to
none
Loading thread data ...

[By the way: QIF files can't begin to deal with online bill pay transaction instructions. But, after online billpay instructions are executed ... there is no difference in the result of those transactions, and any other transactions.]
Reply to
John Pollard

Here's one that does what you are looking for:

formatting link
It costs $59 but may be worth it.

Reply to
Laura

What I did for a while is set up a 'dummy' asset a/c and import the qif to that, then move them to the correct bank a/c. I have Q2007 and I am moving to Moneydance which handles all file import types.

Reply to
J Anthony Clapham

Steve Jordi responded to a similar question on March 10th. I assume you do not really want to convert to OFX (or QFX) but you just want to import the data. Converting to OFX format requires that you know the transaction number.

From Steve's previous post. Which I am using for a couple of credit cards:

You can import QIF files to ANY account, but you must first edit them to change the header. It's a trick as a workaround.

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, credit 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

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

Reply to
Art McClinton

In retrospect, I guess I do not fully understand the instructions. Here is my current .qif file that I would like to import into Quicken. These are what my Credit Union provided for on-line bill pay transactions. I have been using this type of transactions for years in Microsoft Money. They could also supply comma delimited transaction files:

!Type:Bank D03/16/2010 T-38.40 NE-PMT PAARP MedicareRx Plan - Preferred ^ D03/12/2010 T-146.23 NE-PMT PAmerican Express ^ Could I prevail upon you to show me what the modified file should look like?

Also, do I keep the .qif file extension?

Thank You and Best Regards,

Reply to
none

I edit the qif file using Notepad.

Add the following 4 lines to the beginning of the file: !Account NMy Quicken Account Name TBank ^

Change "My Quicken Account Name" to be EXACTLY the name of the account within Quicken.

Within Quicken you will import the file as a QIF file. It will then place the file into the account you have listed.

Reply to
Art McClinton

OK, got that. Should I leave the !Type:Bank statement just where it is?

Thanks,

Gordon

Reply to
none

Reply to
Art McClinton

BeanSmart website is not affiliated with any of the manufacturers or service providers discussed here. All logos and trade names are the property of their respective owners.