In microsoft.public.money, Michael Babcock wrote:

- quote -

The OFX specifications are available at ofx.net.

- quote -

http://xl2qif.chez.tiscali.fr/links_en.php has links to conversion
utilities, but I don't see that one.

Okay, I decided to look at the specs for the QIF format.
Great, the QIF format is really the problem. No real trans
ID to go by. I also see OFX is the better format for what
I'm looking for.

Does Money 2004 support OFX? Now to just convince my bank
to offer OFX as an option! BTW, my bank does have a CSV
option, but Money won't import CSV files (yeah, I know, no
way to determine what's what). Is there any third party
utility to convert CSV to OFX?

- quote -

In microsoft.public.money, Michael Babcock wrote:

- quote -

M is the memo field.
The memo field is optional.

The aggressiveness of Money in looking for duplicates in QIF
statement download varies by version. Money 2004 is more aggressive
than I would prefer.

OFX has a mandatory transaction ID that addresses nicely.

- quote -

Don't you lose some functionality with this option?

Further, it doesn't make much sense to focus on transaction
date and amount to make a determination of duplicates. The
M field of my QIF file contains a transaction ID. Trans
IDs are unique. It would make infinitely more sense to
focus on transaction IDs to flag duplicates. Is the M
field present in all QIF files and does it always contain a
transaction ID?

- quote -

In microsoft.public.money, Michael Babcock wrote:

- quote -

You can import without the duplicate checking with
File-> Import the QIF as a new or recovered account rather than as a
statement.

I really wish it had a "Disable Duplicate Transaction
Checking" option.


- quote -

In microsoft.public.money, <anonymous[at]discussions.microsoft.comwrote:

- quote -

The problem is that newer versions of Money try hard to eliminate
duplicates. It can be too aggressive in its approach sometimes.

You can import without the duplicate checking with File-> Import the
QIF as a new or recovered account rather than as a statement.

You would want to minimize actual duplications in the QIF file, and
you would want to manually check for duplicates too, if there is a
possibility of one sneaking thru.


- quote -

Good point. That particular QIF must not be using normal crlf line
termination. The reason I suggested Notepad vs Word is that if you
save a modified version, Word would be more likely to add some
formatting characters beyond the plain ASCII.

- quote -

Yes, the amount and date do match. However, the
transaction ID is different. How can I resolve the issue?
Both transactions ARE valid. How do I get Money to import
both transactions?

BTW, my opinion is that it is MUCH easier to view the QIF
in Word versus Notepad. With Notepad, it's all strung
together, whereas with Word each entry is on a line by itself.



- quote -

In microsoft.public.money, Michael Babcock wrote:

- quote -

Do the amount and date match existing transactions?

Is the date perhaps in a different order than what you computer is
set for? mm/dd/yy vs dd/mm/yy? One way to see what Money expects
with the current settings is to File-> Export an account, and look at
that QIF file.

Notepad is usually better than Word to look at those files.

I downloaded a QIF file from my bank and imported it into
MS Money 2004 (with all of the latest updates). However,
some transactions are missing. I can look at the QIF file
in Word and I see the transactions, they appear to have the
proper codes etc., but MS Money doesn't "see" them. This
really causes me a problem.

Anyone know what's going on? Oh, the import works fine
into Quicken.