Very strange problems with OFX imported dividend reinvestment transactions from Fidelity

Jack Ostroff ostroffjh at aya.yale.edu
Sat Aug 31 20:22:23 BST 2024


I've been having problems with consistency check for a long time, but  
never bothered to track down the cause.  I'm trying to do that now, and  
everything I see just confuses me more.  I do assume that the initial  
issue is introduced with the ofx import from Fidelity, but I also think  
KMM is doing something funny here.

For one transaction, consistency check says:
  * Split S0002 in transaction 'T000000000000000258' contains different  
signs for shares and value. Please fix manually

This is a dividend reinvestment transaction, and the ledger shows the  
shares $149.44, price $1.00, and value $-149.44 (all in US Dollars, no  
currency conversions involved.)  However, there is no error icon on  
that entry.  Showing the transaction details matches these numbers in  
the stock account, and all are positive in the interest/dividends  
category,  If I then edit the transaction, all values show positive.   
If I then click the enter button without changing anything, the  
transaction shows an error icon with a missing assignment of $298.88.   
At that point, transaction details shows the same for the stock  
account, but shares and value both negative in the category account.   
Editing the transaction again shows all numbers positive, but Enter  
does not change anything.  If I then edit and change the shares to  
negative, the ledger looks the same, but transaction details shows  
negative shares and values in both accounts.  Another edit to remove  
the minus sign on the number of shares clears the error in the ledger  
and the transaction is no longer listed in the consistency report.

This all makes no sense to me, since my edits add then remove a minus  
sign on the number of shares, I would not expect any net change, but at  
the end, both shares and value show negative in the category in the  
transaction details, although in the category ledger, it does show as  
income, not expense.

Just to make things worse, if I start by looking at one of these  
transaction (I have several) in the category ledger, the amount is  
shown in the Expense coulumn, which is clearly wrong.  Transaction  
details, as above, show positive shares and negative value in the stock  
account but both positive in the category.  Editing and saving with no  
changes seems similar to doing so in the investment account ledger,  
with the error icon showing the missing assignement of twice the value  
and transaction details showing positive shares and negative vlue in  
the stock account, and both items negative in the category.  However,  
if I then  edit the transaction, it shows as a Buy, with no Security  
shown, and 0 for shares and price.

Since I never seem to notice this until long after I actually download  
those transacations, and I don't save the download file (web connect  
download) I'll have to find time to download a small sample and see if  
I can reproduce the problem in a smaller test file.

Any other suggestions before I can create a small test case?

Jack


More information about the KMyMoney-devel mailing list