QFX Import Problem

Greg dybalskigo at hotmail.com
Tue Mar 1 14:50:21 UTC 2016


I am a new user of KMyMoney and still testing the program.  As such, maybe this is not an error but user inexperience.  My question is there something that I can do so that 'Pay to' field is filled in properly.  Your insight is welcome.

After setting up two credit card accounts I downloaded transactions from the two banks in the QFX file format.  While the files were imported into KMyMoney successful, some of the data do not enter into proper fields.  Specifically, most of the time the 'Pay to' contains the single letter, E, and the memo field contains the payee information.  However, some of the time the 'Pay to' field contains the proper payee information information but so does the 'Memo' field; the payee information is duplicated in these cases. To correct the 'Pay to' field I have to manually edit most transactions by moving the 'Memo' field information to the 'Pay to' field.  As a consequence, this editing of most transactions negates the convenience of downloading the transactions.

The date and charge (amount) fields have the correct information.

I can not find anything in the QFX files that would lead to this result.  I examined the QFX files, and the payee information is always contained in the line having tag <NAME>.   To demonstrate the file information I copied a few lines where the KMyMoney successful fills in the 'Pay to' field. and a few lines showing where the it is not.

KMyMoney successful filled in the 'Pay to' field (data in the date and amount fields editied) with these lines:
<STMTTRN>
<TRNTYPE>Debit
<DTPOSTED>yyyymmdd120000
<TRNAMT>-xx.xx
<FITID>yyyymmdd0001
<NAME>Amazon.com             AMZN
</STMTTRN>
While this transaction shows an Amazon charge, other transactions from local stores are properly inserted.

KMyMoney filled in the 'Pay to' field with the letter E (data in the date and amount fields removed, and the store number and location were changed to nnn and AAAA) with these lines:
<STMTTRN>
<TRNTYPE>Debit
<DTPOSTED>yyyymmdd120000
<TRNAMT>-44.55
<FITID>yyyymmdd0002
<NAME>HARRIS TEETER #nnn     AAAA
</STMTTRN>

This problem occurs for both credit cards that are issued by two different banks.  So, I do not believe that this issue is due to a particular bank.

I am using KMyMoney version 4.7.2 on a Windows 10 system.  The program was installed a few weeks ago.

Sincerely,
Greg

-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://mail.kde.org/pipermail/kmymoney/attachments/20160301/4e44a671/attachment.html>


More information about the KMyMoney mailing list