'Re: [Kmymoney] Problems with Reinvest Dividends'

[prev in list] [next in list] [prev in thread] [next in thread] 

List:       kmymoney
Subject:    Re: [Kmymoney] Problems with Reinvest Dividends
From:       Bob Ewart <bob-ewart () bobsown ! com>
Date:       2015-03-24 15:11:17
Message-ID: 55117E95.904 () bobsown ! com
[Download RAW message or body]

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@kde.org
> > https://mail.kde.org/mailman/listinfo/kmymoney
> _______________________________________________
> KMyMoney mailing list
> KMyMoney@kde.org
> https://mail.kde.org/mailman/listinfo/kmymoney

_______________________________________________
KMyMoney mailing list
KMyMoney@kde.org
https://mail.kde.org/mailman/listinfo/kmymoney

[prev in list] [next in list] [prev in thread] [next in thread] 