bad transaction match on OFX import

[Thomas Baumgart]

Jack,

On Montag, 16. Dezember 2019 01:29:32 CET Jack wrote:

> 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.

Yes, very strange. What do you mean by "the split numbers changed"? Do you refer to
the ID of the split? That is not important as long as the number of splits remains.
Seeing the bankId vanishing may explain the problem as it is now available for
matching to other transactions. 

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

Yes, please. Send to me as PM. Also, the version you do this with is important.

Can you duplicate the problem with the bankId disappearing? Maybe in an anonymized version
of your file? Then you can provide that file to me and I can take a look.

> 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 Baumgart

https://www.signal.org/       Signal, the better WhatsApp
-------------------------------------------------------------
An optimist laughs to forget.
A pessimist forgets to laugh.
-------------------------------------------------------------
-------------- next part --------------
A non-text attachment was scrubbed...
Name: signature.asc
Type: application/pgp-signature
Size: 868 bytes
Desc: This is a digitally signed message part.
URL: <http://mail.kde.org/pipermail/kmymoney-devel/attachments/20191216/d6e01dae/attachment-0001.sig>