Importing QIF file

0 views
Skip to first unread message

LA Brook

unread,
Dec 4, 2000, 3:00:00 AM12/4/00
to
I'm using Quicken Deluxe 2000 and am trying to import QIF file from
financial institution.
The transactions are imported fine but with one problem: today's date is
replaced for all transactions (file has correct dates), and year is
converted to 00 and shown at the beginning of the register.
Thanks.

Peter J. Ricciardiello

unread,
Dec 4, 2000, 3:00:00 AM12/4/00
to
LA Brook wrote:

I thought I read somewhere that this type of problem might be caused by
the date format as set in the operating system. Are you running Windows
NT/2000 by chance, or some other OS?

Regardless, check the date format of the OS. I apologize that I do not
have much more information than that but it might get you started.

--
Peter J. Ricciardiello (remove 'x' for email)

Typos in my post are due to my inability to type and proof-read, not my
inability to spell and construct grammatically correct sentences. :-)

LA Brook

unread,
Dec 4, 2000, 7:03:34 PM12/4/00
to
I'm using 98 SE. Date/time format has 4-digit year. Can't see any change
that would help solve this problem.


Peter J. Ricciardiello <pjr...@twcny.rrx.com> wrote in message
news:MPG.1495f117f5f42afd9898c5@news-server...

Peter J. Ricciardiello

unread,
Dec 4, 2000, 7:24:37 PM12/4/00
to
LA Brook wrote:

> I'm using 98 SE. Date/time format has 4-digit year. Can't see any change
> that would help solve this problem.

I was thinking more along the lines of the Regional Settings, Date tab
under the control panel, not the Date/Time settings. Without knowing
your OS ahead of time, I did not want to assume Windows.

Bill Hartmann

unread,
Dec 4, 2000, 11:54:28 PM12/4/00
to
Intuit screwed up the date format on Qwin 98. The format for the year
should be "/00". Look at your QIF data.

Bill


On Tue, 05 Dec 2000 00:03:34 GMT, "LA Brook" <535m...@mail.com>
wrote:

James Lavery

unread,
Dec 5, 2000, 2:02:06 AM12/5/00
to
I think Bill is right - Quicken 98's date format requirement is wierd
for qif files.

I've written a utility which you can use to bulk-change the format in
the qif file (among other features).

Details are at http://www.monthtwosys.co.uk/tffc.htm, where you can
download a trial version.

Let me know if this helps, or I need to tweak it for you.

James

In article <boUW5.3602$T43.2...@bgtnsc04-news.ops.worldnet.att.net>,


"LA Brook" <535m...@mail.com> wrote:
> I'm using Quicken Deluxe 2000 and am trying to import QIF file from
> financial institution.
> The transactions are imported fine but with one problem: today's date
is
> replaced for all transactions (file has correct dates), and year is
> converted to 00 and shown at the beginning of the register.
> Thanks.
>
>


Sent via Deja.com http://www.deja.com/
Before you buy.

James Lavery

unread,
Dec 6, 2000, 3:00:00 AM12/6/00
to
Version 1.4 of my program (The Financial File Converter) is now
available, which fixes a bug where, if converting *from* delimited,
some versions of Quicken would import with no amount in the
transactions. (It was writing a blank 'U' line in the qif file).

Apologies you've downloaded previous versions and were caught by this.

The new version is at http://www.monthtwosys.co.uk/downloads.htm

James

Han Broekman

unread,
Dec 8, 2000, 9:42:27 PM12/8/00
to

Funny, I thought that Q2K needed 11/21'00, not 11/21/00. I more or less
regularly edit the qif downloaded from Vanguard to make this change, and
for my problem at least, the editing works perfectly. If the problem
persists after I get Q2001, I might try James Lavery's utility ... Thus
far Notepad works for me (mine does global replace).
--
Best regards
Han Broekman
(Please answer to the newsgroup only, I will not answer email)

LA Brook

unread,
Dec 10, 2000, 5:03:50 PM12/10/00
to
Format for QIF data is /2000.

Bill Hartmann <bi...@birch.net> wrote in message
news:3a2c74b6...@news.birch.net...

LA Brook

unread,
Dec 10, 2000, 5:03:51 PM12/10/00
to
When I replaced /2000 with /'00, import of qif file worked fine. I used Word
to make global change.

Han Broekman <j.bro...@verizon.net> wrote in message
news:3A319C88...@verizon.net...

Han Broekman

unread,
Dec 10, 2000, 5:27:25 PM12/10/00
to
Actually the format is either 12/10/2000 or 12/10'00, but not 12/10/00.

--
Best regards
Han Broekman
(Please answer to the newsgroup only, I will not answer email)
Reply all
Reply to author
Forward
0 new messages