QFX Import Problem

[Jack]

On 2016.03.01 09:50, Greg wrote:
> 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.

Greg,

Welcome to KMyMoney.  Yes - this is something you should be able to  
configure.  However, right now, I can only find the way to do this if  
you have mapped the account to an online acccount.  (OFX and QFX are  
treated exactly the same by KMM).  In this case, with the ledger open  
for the account (you probably have to do it for each account for which  
you import) click the Edit Account button (or select the Account/Edit  
Account... menu item) then select the Online Settings tab, and then the  
Import Details subtab.  There is a dropdown at the bottom labelled  
"Payee's name is based on contents of the OFX tag" with possible values  
PAYEEID, NAME, MEMO.

Question to the developers:  is there an equivalent mapping for  
aqbanking, and for libOFX, is there a way to configure it for file  
import?  I would expect this shouldn't matter whether the OFX comes  
from a file or from a direct connect.

Jack