Merging Quicken Files


L

Luis

Part 10 of the 'Merging Quicken Files' document on the msn.com
QuickenUsers group has the following section:

iii. All of the years beyond 1999 are messed up in the file. To
change each year use the Find and Replace feature of WORD to fix each
year.

Ex. ' 00 to /00 will give the correct format.

' 01 to /01


Does this mean that I must search for all instances of ' 01 and
replace it with /01 ?

There are no ' 01 instances in my .qif file. My dates are already in
the /01 format (I think!). Eg.:

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

What must I change in the above sample so that I can import the .qif
file into Quicken 2006 Deluxe?
 
Ad

Advertisements

D

Disciple

Part 10 of the 'Merging Quicken Files' document on the msn.com
QuickenUsers group has the following section:

iii. All of the years beyond 1999 are messed up in the file. To
change each year use the Find and Replace feature of WORD to fix each
year.

Ex. ' 00 to /00 will give the correct format.

' 01 to /01


Does this mean that I must search for all instances of ' 01 and
replace it with /01 ?

There are no ' 01 instances in my .qif file. My dates are already in
the /01 format (I think!). Eg.:

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

What must I change in the above sample so that I can import the .qif
file into Quicken 2006 Deluxe?
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.
 
J

John Pollard

Luis said:
Part 10 of the 'Merging Quicken Files' document on the msn.com
QuickenUsers group has the following section:

iii. All of the years beyond 1999 are messed up in the file.
To
change each year use the Find and Replace feature of WORD to
fix each
year.

Ex. ' 00 to /00 will give the correct format.

' 01 to /01


Does this mean that I must search for all instances of ' 01
and
replace it with /01 ?

There are no ' 01 instances in my .qif file. My dates are
already in
the /01 format (I think!). Eg.:

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

What must I change in the above sample so that I can import
the .qif
file into Quicken 2006 Deluxe?
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.
 
L

Luis

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.
I won't be using the Quicken Online functionality as Quicken doesn't
support African banks. I have to do it all manually...
 
J

John Pollard

Luis said:
What must I change in the above sample so that I can import
the .qif
file into Quicken 2006 Deluxe?
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.)
 
W

Wai Doan Hsu

Luis said:
Part 10 of the 'Merging Quicken Files' document on the msn.com
QuickenUsers group has the following section:

iii. All of the years beyond 1999 are messed up in the file. To
change each year use the Find and Replace feature of WORD to fix each
year.

Ex. ' 00 to /00 will give the correct format.

' 01 to /01


Does this mean that I must search for all instances of ' 01 and
replace it with /01 ?

There are no ' 01 instances in my .qif file. My dates are already in
the /01 format (I think!). Eg.:

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

What must I change in the above sample so that I can import the .qif
file into Quicken 2006 Deluxe?
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 <all accounts> 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.
 
Ad

Advertisements

L

Luis

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.
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!
 
L

Luis

Third, where did the qif file transaction in your post come
from?
Quicken XG 2004 - the last UK version of Quicken.
Are you in Canada?
No. I'm in deep dark Africa...
As far as I know, qif file dates are
always mm/dd/yy (or mm/dd/yyyy) - ignoring delimiters.
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.
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.
They seem to be the same for pre and post 2000 dates in Quicken XG
2004 UK.
[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.]
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.
 
Ad

Advertisements

L

Luis

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.
I need to export/import all sorts of accounts: cash, cheque, credit
cards and investment accounts (mutual funds).
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.
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.
Once you feel comfortable, you can use your regular Quicken
account.
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.
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
^
Thanks, I will try that...
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads


Top