Sample qif statement that doesn't import easily

[James A. Treacy]

When importing qif from my bank (Canada Trust) there are two
problems, both of which are shown by the sample below:

!Type:Bank
D01/29/01
MCheque
N293
P
T-1.00
^
D01/28/01
MMortgage Payment
NMTG
P
T-1.00
^
D01/27/01
MBill Payment
NBIL
PSCHED PAYMENT   #18924 THE BAY
T-1.00
^

The first problem has already been discussed with grib on #gnucash.
The first two entries above have a blank payee line. Thus, when you
get to the 'Match payees/memos to GnuCash accounts' screen in the
import dialog, all such transactions are lumped together under a 'QIF
payee/memo' entry of ''. The proper behavior when finding a blank
payee line in this case would be to use the memo line so the
transactions can be associated with the proper account.

The second problem (shown in the third entry above) is that many
transactions are listed in the qif with a transaction number. This
means that the payee line changes from month to month which messes up
the association between transaction and gnucash account. Perhaps
the user could be allowed to specify a substring to use for the match.
More generally, the user could specify a regex. There is probably no
easy way to fix this in general. :(

Keep up the good work. This program is already extremely useful. Can't
wait to see what the future will bring.

-- 
James (Jay) Treacy
treacy@debian.org