bad transaction match on OFX import

Jack ostroffjh at users.sourceforge.net
Sun Dec 15 21:48:01 GMT 2019


On 2019.12.05 10:15, Thomas Baumgart wrote:
> On Montag, 2. Dezember 2019 21:24:31 CET Jack wrote:
> 
>> I'm reconciling my Merrill Lynch accounts, and in one account, one  
>> transaction shows in my statement but not in the account.  I finally  
>> ran KMM from command line and got
> >
> > Processing transactions (Account Name)
> > Process on: '2019-11-25', id: 'ID 20191125CA051143461091498',  
> amount:
> > '68.00', fees: '0.00'
> > Looking for a match with transaction:  "2019-11-25" , "" , "-68.00"
> > (referenced account:  "Dividends" )
> > Considering 1 existing transaction(s) for matching
> > Detected transaction duplicate
> > Processing transactions done (Account Name)
> > Importing statement for 'Account Name' done
> >
>> The problem is that it matched against an otherwise identical  
>> transaction in a different account (also Merrill Lynch Investment  
>> account.)
> >
>> It turns out I own the same number of shares of the same stock in  
>> both accounts, but I would not have expected to match a transaction  
>> in a different account.  Should I open a bug report for this?
> 
> Before you do, I have some more questions:
> 
> - what type of matching do you use on both accounts (FITID or hash)?
FITID (and I'm quite sure these are consistent with Merrill Lynch)
> - in either case, what is the FITID/hash of the stored and the  
> imported transaction   (I agree the hash for the imported transaction  
> can become tricky, but you can    look into the kmm-statement....txt  
> file)
Unfortunately, I had done some more work after the problem showed up  
and before I started checking.  I do have an automatic save of 10  
versions, but I really couldn't make any sense of what I was seeing.  I  
haven't given up on this, but at some point, I'm going to have to find  
my most recent backup prior to the problem, do an import including the  
first account with that transaction, then import for the other account,  
keeping careful track of the actual transaction records in the file at  
each step.   I'll post back when I have something to act on.
> 
> Is there a match?
> 
> Regards
> 
> Thomas


More information about the KMyMoney-devel mailing list