[Kmymoney] Problems with Reinvest Dividends

[Bob Ewart]

Thanks Jack,

Yes, it is Merrill Lynch.

I found the third transactions in the OFX file which seem to be _totally 
ignored._

I have two questions:

1. For the two mutual funds, why do I have to enter the price/share in 
Price/share for mutual fund A and the total dividend in Price/share for 
mutual fund B?

2. Why are the TRANSFER transactions ignored?

<TRANSFER>
   <INVTRAN>
     <FITID>GBR...
     <DTTRADE>20141224110000.000[-5:EST]
     <DTSETTLE>20141224110000.000[-5:EST]
     <MEMO>Divd Reinv: MUTUAL FUND A
   </INVTRAN>
   <SECID>
     <UNIQUEID>09...
     <UNIQUEIDTYPE>CUSIP
   </SECID>
   <SUBACCTSEC>CASH
   <UNITS>2.585
   <TFERACTION>IN
   <POSTYPE>LONG
   <UNITPRICE>11.24
</TRANSFER>

and


<TRANSFER>
   <INVTRAN>
     <FITID>GBR...
     <DTTRADE>20141218110000.000[-5:EST]
     <DTSETTLE>20141218110000.000[-5:EST]
     <MEMO>Divd Reinv: MUTUAL FUND B   $225.
   </INVTRAN>
   <SECID>
     <UNIQUEID>32...
     <UNIQUEIDTYPE>CUSIP
   </SECID>
   <SUBACCTSEC>CASH
   <UNITS>10.866
   <TFERACTION>IN
   <POSTYPE>LONG
   <UNITPRICE>20.79
</TRANSFER>


On 03/23/2015 05:50 PM, Jack wrote:
> 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
> _______________________________________________
> KMyMoney mailing list
> KMyMoney at kde.org
> https://mail.kde.org/mailman/listinfo/kmymoney