Investment Report Functionality
nancy
via web
I just entered 12 years' worth of dividends for two Vanguard mutual funds so that I could have accurate investment reports with information I used to have in Quicken.
Does MD provide:
- CostBasis/Share
- Amount Invested
- Gain/Loss
- Return
- ROI (as percentage)
All I see in MD is:
- Shares
- Price (Daily Closing Price)
- Current Value (Market Value)
- Cost Basis (looks like Amount Invested but it's off because of
problems with lots*)
- % change (not ROI because it isn't including dividends and interest)
I'm wondering in particular why MD is showing a loss for a particular fund when there actually is a gain, but only if dividends have been included. (IOW, my cost basis/share is lower than the current cost per share, but the real return over time (interest and dividends) should be a positive ROI rather than a loss.)
*I am also having trouble choosing lots when there are small sales each year to meet fees.
Thx.
Support Staff 2 Posted by Tom Freeman on 28 Jul, 2010 07:53 PM
Have you checked out the reports section. Most of what you are asking for is in the investment performance report. The cost basis per share is lacking and I am putting a ticket in to the developers about that. You can access the total cost basis and share count in both the security detail window and the cost basis report. The cost basis report has a breakdown of each purchase including dividends.
The showing a loss on dividend stocks is normal if the share price falls below the dividend reinvestment price. A dividend reinvestment is considered a buy and affects the cost basis of the stock. Dividends are taxable and so are the cap gains on the reinvestment when sold. So if the dividend reinvestment share price is greater than the current price, then it can appear as a loss even though the current total is greater than the initial buy. The idea is that if you had kept the dividends in cash would the combination of dividends plus initial investment be the same, less, or greater than the reinvested total.
As to matching lots you can choose the "avg cost" option. If you are an active trader this does lessen your ability to manage your taxable income through lot matching.
tom
3 Posted by frankrader on 13 Sep, 2011 02:54 PM
I need a report showing dividends received over several years from one security of several. The dividend entries are within the ABC Broker Investment account and were automatically reinvested. What I have I can see on the screen "Investments>ABC Stockbroker>WXY Stock>Securities Detail" is what I need to print.
4 Posted by zeke on 13 Sep, 2011 04:31 PM
FYI
The inaccuracy in various investment performance reports is one of the glaring annoyances with Moneydance. See for example
http://help.infinitekind.com/discussions/questions/2767-portfolio-r...
and
http://help.infinitekind.com/discussions/md2010-beta/108-incorrect-...
As far as I can tell a fix for these issues does not appear to be a high priority as they've been around for awhile.
Support Staff 5 Posted by Tom Freeman on 19 Sep, 2011 03:33 PM
Frank,
I've been looking for a way to report the data as you wish and can't find a solution. I agree this would be a good utility. I am putting in a suggestion ticket to allow editing for security and action in the investment transaction report.
Tom
Support Staff 6 Posted by Tom Freeman on 19 Sep, 2011 04:17 PM
Frank,
A new extension has been created that allows a raw dump on investment transactions to a spreadsheet. This may allow you to gather the information you wish.
From the toolbar, go to extensions > manage extension. Scroll down until you get to the investment report extension and install it.
You should then be able to dump your investment activity into a spreadsheet and sort for the dividends and security.
Tom
7 Posted by frankrader on 19 Sep, 2011 07:24 PM
Where?
I ran MoneyDance and dropped down Extensions and do not see manage extension.
I went to Add and do not see Investment Report in the list.
Moneydance 2010r3 (757)
8 Posted by frankrader on 19 Sep, 2011 07:27 PM
Thanks for the quick fix, when I find. it.
My preferred solution would be an individual securities report within Moneydance.
Support Staff 9 Posted by Ben Spencer on 20 Sep, 2011 11:17 AM
On Moneydance build 757 select Extensions->Add...
Select "From the internet" and click "Next"
The item is called "Extra Investment Reports"
Ben Spencer
Moneydance Support
10 Posted by frankrader on 26 Sep, 2011 08:04 PM
Thanks.
This report gets me where I want to be, but with more hoops than wanted.
I get a report of all transactions between dates then need to cull the data not wanted. It assumes I have a spreadsheet program (I do) and it assumes I am able to use it (I am).
Because it assumes use of another program the solution is not efficient, but works.
11 Posted by Sara on 26 Apr, 2012 10:03 PM
First, I used the extension, it allowed me to specify a folder for the reports, and told me that they were run. However, for the life of me I cannot find them. It's actually a bit spooky since I was running a program/applet or whatever that accesses sensitive information and I cannot tell what it did. Please let me know it is safe and how to find the report!
Secondly, I agree that we really need the ability to generate investment reports from within MD. This, as many of noted, is a glaring problem with MD. enlywI notice that the last activity here was last Sept. I hope that we will see improvements in this area before too many more moons.
12 Posted by frankrader on 27 Apr, 2012 02:06 AM
This is a repeat statement, but belongs here. Capital Gains and losses marked long term and short term and netted in each category should be a part of a proper Income & Expenses report in Moneydance.
To do this report proper handling of cost basis is basic.
I agree with Moneydance explaining that purchasing a new lot of a stock, or a Fund, through dividend reinvestment changes the cost basis. Two things. First I have an tax event receiving a dividend. Second, I have a cost basis for that purchase of the stock or fund.