bad transaction match on OFX import

[Jack]

On 2019.12.15 16:48, Jack wrote:
> 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?
Very very strange.  I started with a backup from September.  I imported  
a downloaded OFX for 11/25 for the first account.  Transaction shown up  
in the .xml file showing the correct bankid, for one of the three  
splits.  Clear that transaction, and the reconcileflag for that split  
changes from 0 to 1, but the bankid is now blank.  Also, the split  
numbers changed.  If I now import the downloaded OFX file for that date  
for the second account, the console says it matched the transaction in  
the first account.  That account now shows the bankid for the second  
account as both the bankid for the split and for the match.

I'll be glad to send a file with those three transaction versions if it  
would help.

By the way - I tried this with a clean file, and the second import did  
not match, it just imported to the second account.  I'll try a few more  
times, but this just doesn't make any sense to me.

>> 
>> Regards
>> 
>> Thomas
Thanks for any suggestions on what's going on.

Jack