Merging Quicken Files

The header, so when Q06 calls home to verify the FI number it will find a match and allow the import. Without a match, there will be no import. there are other differences between the two headers, but that is the most important.

First: I believe the faq (and all my knowledge on the subject as well) relate to the US version of Quicken. (I think qif files are formatted and treated the same for all country versions of Quicken, but I am only able to speak for the US version).

Second, I don't think you read Part 10 of the faq carefully: it pertains only to security prices (the author plans to have you change fhe format of security prices from qif file format to .csv file format).

Third, where did the qif file transaction in your post come from? Are you in Canada? As far as I know, qif file dates are always mm/dd/yy (or mm/dd/yyyy) - ignoring delimiters.

Fourth, qif file transaction dates should have a different delimiter for pre-year 2000 and post-year 1999 dates. For years

1999 and earlier, the delimiter is "/", for post year 1999 dates, the delimiter is "'". So "/ 1" is 1901 and "' 1" is 2001. [Newer versions of Quicken can read 4 digit years in qif files, which I believe can all use the forward slash for a delimiter for any year.]

Finally, it is a trivial matter to test all of this; just make a New, test, Quicken file and check the results of importing your qif file.

I won't be using the Quicken Online functionality as Quicken doesn't support African banks. I have to do it all manually...

I forgot: with the possible exception of the date record, you should be able to import transactions like this:

D29/4/01 U-100.00 T-100.00 C* NP150 PSuperStore LMotor:Fuel/Car1 ^

directly into a Q2006 "cash" account. From there, you can select (as in a Windows "select") all the imported transactions, then "cut" and "paste" them into any non-investment account.

(Get rid if the leading caret ("^") that preceded your first qif file record; it was a stray from a previous transaction.)

Normally, you would change /01 to '01 or /2001 for Quicken 2006. But if you really want to import the file directly into your account, it's not the FI number you need. It's the account name.

You didn't give enough information about the QIF. But I'm assuming that it's a bank account and the file starts with !Type:Bank. Here's what you should do. First, copy your Quicken file under a new name, and test everything in a test file to make sure you are doing everything correctly. Once you feel comfortable, you can use your regular Quicken account.

Let's assume that your QIF starts with !Type:Bank and your bank account is called Checking one. You would take the QIF and add the following lines to the top:

!Option:AutoSwitch !Account NChecking one TBank ^

Then go to Quicken, click on File > Import > QIF file

Select the file you wish to import, and select for the account you wish to import into. The QIF should import just fine.

I'm assuming that your account is NOT called Checking one, so you have to change that to the EXACT name that you gave the account. And of course you need to make any date changes that are necessary.

Thanks. I managed to figure that one out after I discovered that Quicken 2006 won't import a QIF file into checking, savings and credit card accounts!

Quicken XG 2004 - the last UK version of Quicken.

No. I'm in deep dark Africa...

The qif file that I exported from Quicken XG 2004 UK is in the dd/mm/yy format (eg. 14/10/99) as used in the UK and here in South Africa.

They seem to be the same for pre and post 2000 dates in Quicken XG

2004 UK.

I've tried changing 2 character year values to their 4 character equivelants:

e.g.:

22/10/99 to 22/10/1999

and then importing that into Quicken. So far this seems to be giving me much better results.

I need to export/import all sorts of accounts: cash, cheque, credit cards and investment accounts (mutual funds).

Absolutely! I would never do anything of this sort in my "production" data file. I always play on "Dev". That way I can affort to trash the data file without giving myself a heart attack.

I'm using two versions concurrently (Q2004 contains my "production" data while Q2006 is used just for testing the conversion). Only when I'm absolutely 100% satisfied will I move to Q2006 permanently.

Thanks, I will try that...