Fund Manager
PORTFOLIO MANAGEMENT SOFTWARE
Contact Us

Re: Interest Income Reinvest??

[ Message Board ] [ Archives ] [ Search ]

Posted by Mark on April 25, 2007 at 13:11:33:

In Reply to: Interest Income Reinvest?? posted by Robert Schutt on April 25, 2007 at 12:34:42:

: Please excuse my lack of knowledge on Financial terminology and/or processes.

: I have FundManager v8.4. I download transactions from my JP Morgan 401k account in the form of qif files.
: Here is an example in which I am having problems with Interest Income and whether or not I should be trying to have FundManager reinvest the Interest Income items.

: D04/24/2007
: NIntInc
: YFE Overseas-A
: I26.88
: Q 000000.0000
: T69.97
: MPre-tax
: ^
: The above lines show exactly what is in the qif file. Notice there is no share number (Q).
: After I try to edit this item that shows up in the Data Register for reinvestment, the Share Number, Dollar Amount is greater than what is displayed on the JPMorgan web site.
: If I leave these items unaltered FundManager and JPMorgan web site match.

: Should I be trying to manually edit these Interest Income items to show up as reinvested?
: Have you had experience with such qif files containing “phantom Interest Income” data that should not be reinvested.
: Possibly JPMorgan handles these some other way or they really should not be listed?
: Could these be listed indiscriminately for tax purposes in taxable and non-taxable accounts even though this is a 401k?

: ****************************************************************
: Dividends do not need to be edited and show up as reinvested in the Data Register.
: Here is an example of a Sell and Buy that shows the number of shares.

:
: D03/23/2007
: NReinvDiv
: YAF Wash Mutual-R4
: I35.29
: Q 000000.0170
: T0.6
: MPre-tax
: ^

: D04/24/2007
: NSell
: YFE Overseas-A
: I26.88
: Q -000013.3858
: T-359.81
: MPre-tax
: ^
: ****************************************************************

Hi Robert,

Is there some reason you are manually editing this file? Normally, you would just import it, and everything should import fine.

The transaction type is shown on the line beginning with "N". The "IntInc" transaction is a distributed interest payment. This means it was not reinvested, it was money paid out, so you shouldn't end up with more shares after this transaction.

The "ReinvDiv" transaction on the other hand was a reinvested dividend. For that transaction, you would end up owning another 0.017 shares, that were acquired when you reinvested the dividend.

Thanks,
Mark
--
Fund Manager - Portfolio Management Software



Replies:


 

FundManagerSoftware.com | Search | Site Map | About Us | Privacy Policy