In microsoft.public.money, Chris Crites <Chris
Crites[at]discussions.microsoft.com> wrote:

- quote -

Well next time you do two ATM withdrawals on the same day, make them
for different amounts. If you have two cups of coffee on the credit
card, make them at different shops, or have a differently-priced
item. ;-)




- quote -

Thank you for your response Cal. This issue was such a big deal because I was
starting from scratch in Money but wanted the history from my bank so I could
start creating a budget and determine my spending habits.

Unfortunately my bank does not support OFX files.

"Cal Learner-- MVP" wrote:

- quote -

In microsoft.public.money, Chris Crites <Chris
Crites[at]discussions.microsoft.com> wrote:

- quote -

I assume that each also had the same payee (line that begins with P
in the QIF file).

- quote -

At this point, enter the missing transactions by hand. QIF
statements use an aggressive duplicate-elimination algorithm when
imported as a statement. The source of this is the theory that
people will enter at least some of the transactions by hand, or that
successive QIF files will include the same transaction. So
additional transactions that look identical are ignored.

Money could have made an exception if the apparent duplicates were
in the same QIF file, but it doesn't.

If you import as a recovered account, Money will turn off the
duplicate-elimination checking. However at this point, re-importing
that way would produce duplicates. So enter the duplicates
manually.

OFX files are more sophisticated, and do not have this problem. In
OFX each transaction from a given institution have a transaction ID
that is unique. So Money knows whether it has seen that transaction
already or not, and does not have to resort to a duplicate-removal
algorithm.

I downloaded a QIF file from my bank dating back to 01/01/2004. When I
imported this file into Money 2005 the balance was way off compared to the
bank's website. In comparing each tranaction I noticed some were missing in
Money. Each group of missing transactions were all on the same day and for
the same amount. Also, for each group one transaction would be in Money and
the others missing (ex. There are 5 transactions according to the bank but
only 1 shows in Money). I opened the QIF file in Notepad and can see the
multiple transactions that were missing in Money. Based on this information I
am assuming that Money merged these similar transactions. How do I fix this?