convert qif to qfx

jayandkim, thanks for your post, but what if you do NOT have a Windows based PC to start with?  I use Quicken Essentials for Mac and do not have a PC to use the program you suggested.

To fill in missing online transactions, this is just great! The key is to create a CASH account, because friggin intuit won't allow any other types. What an arrogant company. Many banks don't export QFX, yet they make us jump through these hoops.

Also, highlight the transactions in your import account, then cut and paste into the approprate bank account.

Thanks for the tip!

I found this to be the most effective post. It works every time. I thought I would loose all of my data, but so far I have not.

Thanks a Million

I realized this is an older post, but I just discovered and I tried teendoc's solution and it works great.  With many banks abandoning or now charging for qfx downloads this is an ideal solution.

It now reads them in but they have no dates. Can any one help. If not I am going to have to ditch quicken and buy another package

 Try the method posted by DGIDan -set up a CASH account in Quicken, called "QIF Xfer" or somesuch. Quicken will import the QIF straight in. Then just select all the transactions, and paste them into the appropriate account. Don't forget to delete after copying.

It now reads the data but the dates are in US format MM/DD/YY. Is there an easy way of converting them to UK format

Below is a batch file I created for myself to convert a QIF file for a credit card account to one that the newer Quickens can at least import.  The batch file only handles Credit Card type of accounts, but that could be changed. 

The batch file expects to be in the same directory as the filename of the downloaded QIF file you are trying to convert.  The batch file prompts the user for the filename to be converted (do not include the ".gif" extension) and the name of the account in Quicken.  Make sure that what you enter here for the account name directly matches the filename in Quicken.   It will create a new file that is the "original filename".convert.qif.

@echo off
echo Convert Credit Card QIF File
REM
REM Prompt for the filename.  It should reside in same directory
REM Do not include the ".gif" extension in the filename
REM
set /p filename=What is file name you wish to convert (do not include extension):
REM
REM Prompt for the Credit Card Account Name.  This must match the name in QUicken
REM
set /p account=What is the Credit Card account name from Quicken:
REM
REM Build the converted credit card file that will work with the newer version of QUicken
REM
echo !ACCOUNT > %filename%.convert.qif
echo N%account%  >> %filename%.convert.qif
REM
REM The following limits use of this script to Credit Card Accounts
REM
echo TCcard >> %filename%.convert.qif
echo ^^ >> %filename%.convert.qif
REM
REM Put contents of original file at the end of the converted file
REM
type %filename%.qif >> %filename%.convert.qif
pause

The steps to use this are:

1. Download the QIF file from whatever source you are getting it from

2. Use the batch file above to convert the downloaded QIF file to one that the newer Quickens can handle.

3. Open Quicken

4. Do a File-->File Import-->QIF File

5. Browse to the location of the converted file (not the original file)

6. Set "Quicken account to import into" to <All Accounts>

7. Click Import and "voila" the transactions should be imported into the right quicken account.

This works with Windows 7 and Quicken 2012.  I have not tried it with any other combinations.

Jim

 FixMyQIF does what described above for you, plus fixing issues with your source QIF.

No I cant get this to work

I have a QIF file from a UK bank

i added this as the header but Quicken says it cant complete the request

!Account
NCurrent
TBank
^

Is the name of your checking account in Quicken "Current?" The N should be the name of the account in Quicken so Quicken can find the account to add the transactions to.

I'm not sure what else to advise except making sure that you do this all in notepad or another plain text editor (Word will mess it up) and being sure that there is no space between the final carat line and the original first line of the QIF file.