[Kmymoney] Problems with Reinvest Dividends

[Jack]

This doesn't happen to be from Merrill Lynch does it?  They actually  
use three separate transactions for a reinvest dividends.  Two of them  
(dividend, and buy, I think) import to the investment account and one  
imports to the brokerage account.  I convert the dividend (manually)  
into a reinvest dividend, and manually delete the other two.  The only  
problem I have had with this is that if the same items get imported  
again, I have to delete them, since they are not recognized as  
duplicates of the one I kept.  (I'm currently, if slowly, debugging an  
issue where investment accounts set to download transactions since the  
last download don't set the download date, and so by default always  
download 60 days of transactions.)  It's been a while since I actually  
looked at the OFX I get, but I've given up on dealing with this in any  
reasonable automated way, without writing a very serious OFX filter,  
which I doubt is worth the effort.

Jack


On 2015.03.23 16:10, Bob Ewart wrote:
> I'm running KMyMoney 4.7.1 on openSUSE 13.2 (64).
> 
> I have a number of mutual funds that reinvest dividends in December.   
> Some how I got it to work last year.
> 
> When I imported the .ofx file, the investment account showed all the  
> dividends.  The associated brokerage account showed the dividends as  
> income and the re-investments as expenses with flags showing missing  
> a category assignment.  OK
> 
> When I converted two of the dividends to Reinvest Dividends, things  
> got a little strange.  I had to enter the price per share in the  
> Price/share field for the first one. I had to enter the total  
> dividend in the Price/share field for the second one.  Both showed  
> the correct Value and incremented the number of shares correctly. And  
> both are flagged as missing assignment of xxxxx nn.nnnnn. Furthermore  
> both the income and expense are now flagged in the brokerage account.
> 
> I will welcome any suggestions as to how to handle this.  As I said,  
> I did get it to work last year somehow.
> 
>-- 
> Bob
> 
> -------------------------------------------------------------------------------------------------------------------------------------------------
> 
> This is an edited excerpt from the .ofx file for the first fund.
> 
> <INCOME>
>   <INVTRAN>
>     <FITID>GBR...
>     <DTTRADE>20141224110000.000[-5:EST]
>     <DTSETTLE>20141224110000.000[-5:EST]
>     <MEMO>Sh Tm Cap Gain: MUTUAL FUND A
>   </INVTRAN>
>   <SECID>
>     <UNIQUEID>09...
>     <UNIQUEIDTYPE>CUSIP
>   </SECID>
>   <INCOMETYPE>CGSHORT
>   <TOTAL>29.06
>   <SUBACCTSEC>CASH
>   <SUBACCTFUND>CASH
> </INCOME>
> 
> <INVBANKTRAN>
>   <STMTTRN>
>     <TRNTYPE>DEBIT
>     <DTPOSTED>20141224110000.000[-5:EST]</DTPOSTED>
>     <TRNAMT>-29.06
>     <FITID>GBR...
>     <NAME>MUTUAL FUND A
>   </STMTTRN>
>   <SUBACCTFUND>CASH
> </INVBANKTRAN>
> 
> Reinvestment amount $29.06 for 2.585 shares at $11.24
> Share/Price entered is $11.24
> Flagged as: Transaction has a missing assignment of xxxxx 29.0600
> 
> <INCOME>
>   <INVTRAN>
>     <FITID>GBR...
>     <DTTRADE>20141218110000.000[-5:EST]
>     <DTSETTLE>20141218110000.000[-5:EST]
>     <MEMO>Sh Tm Cap Gain: MUTUAL FUND B
>   </INVTRAN>
>   <SECID>
>     <UNIQUEID>32008F804
>     <UNIQUEIDTYPE>CUSIP
>   </SECID>
>   <INCOMETYPE>CGSHORT
>   <TOTAL>225.91
>   <SUBACCTSEC>CASH
>   <SUBACCTFUND>CASH
> </INCOME>
> 
> <INVBANKTRAN>
>   <STMTTRN>
>     <TRNTYPE>DEBIT
>     <DTPOSTED>20141218110000.000[-5:EST]</DTPOSTED>
>     <TRNAMT>-225.91
>     <FITID>GBR...
>     <NAME>MUTUAL FUND B
>   </STMTTRN>
>   <SUBACCTFUND>CASH
> </INVBANKTRAN>
> 
> Reinvestment amount $225.91 for 10.866 shares at $20.79
> Share/Price entered as $225.91
> Flagged as: Transaction has a missing assignment of yyyyy 225.91
> 
> _______________________________________________
> KMyMoney mailing list
> KMyMoney at kde.org
> https://mail.kde.org/mailman/listinfo/kmymoney