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.

Re: QIF Import missing Transactions by via_newsgroup

via_newsgroup
Sat Aug 14 09:17:59 CDT 2004

In microsoft.public.money, Michael Babcock wrote:

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

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.


Re: QIF Import missing Transactions by anonymous

anonymous
Sat Aug 14 11:42:08 CDT 2004


>-----Original Message-----
>In microsoft.public.money, Michael Babcock wrote:
>
>>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.
>
>Do the amount and date match existing transactions?
>

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.



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

Re: QIF Import missing Transactions by via_newsgroup

via_newsgroup
Sat Aug 14 12:00:07 CDT 2004

In microsoft.public.money, <anonymous@discussions.microsoft.com>
wrote:

>
>>Do the amount and date match existing transactions?
>>
>
>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?

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.


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

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.


Re: QIF Import missing Transactions by Michael

Michael
Mon Aug 16 15:09:55 CDT 2004

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


>-----Original Message-----
>In microsoft.public.money,
<anonymous@discussions.microsoft.com>
>wrote:
>
>>
>>>Do the amount and date match existing transactions?
>>>
>>
>>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?
>
>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.
>
>
>>
>>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.
>>
>
>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.
>
>.
>


Re: QIF Import missing Transactions by via_newsgroup

via_newsgroup
Mon Aug 16 15:25:21 CDT 2004

In microsoft.public.money, Michael Babcock wrote:

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

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


Re: QIF Import missing Transactions by Michael

Michael
Fri Aug 20 16:08:05 CDT 2004

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?

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

Re: QIF Import missing Transactions by via_newsgroup

via_newsgroup
Fri Aug 20 16:22:34 CDT 2004

In microsoft.public.money, Michael Babcock wrote:

>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?

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.

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


Re: QIF Import missing Transactions by Michael

Michael
Sat Aug 21 07:39:56 CDT 2004

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?

>OFX has a mandatory transaction ID that addresses nicely.
>
>>
>>>
>>>You can import without the duplicate checking with
>>>File->Import the QIF as a new or recovered account rather
>>than as a
>>>statement.
>>>
>>>.
>>>
>
>.
>

Re: QIF Import missing Transactions by via_newsgroup

via_newsgroup
Sat Aug 21 10:36:25 CDT 2004

In microsoft.public.money, Michael Babcock wrote:

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

The OFX specifications are available at ofx.net.

>
>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?

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