Investment reports and analysis are a weak spot in MD. There are a bunch of bugs in the reports and I think you have found one. I hope Sean/IK respond and fix this one. I still get reports where the return is a positive amount of dollars and the IRR (or ROI as they call it, is negative). Maybe MD 2019 will have some good news?
I just came across another bug. When there are split transactions in a cash portion of the account, these transactions are not included so balance way wrong.
I tracked this down by exporting transactions and then matching them with the register and every single one that has a split is not in the exported transactions.
The register shows a balance of $0.00 but the report shows (6,200.00). This amount is the exact amount of the split transactions.
In this case try are transfers from another account with a category assigned, i.e. Dividend paid is transferred to the my checking account at a different brokerage firm. When entered the transaction is an Xfr with the security that paid the dividend to the account at the brokerage with a category of Dividend Income.
I have hundreds of these kind of transactions as I transferred my data from Quicken.
Steven, this needs to be a separate thread. If IK is to have any chance of tracking errors thread hijacking makes that impossible. It is a completely different issue and not related to the thread title. Lets not make IK's job of fixing bugs harder.
Sean Reilly on 15 Aug, 2018 10:15 PM
I just checked out the code and it looks like the transactions may have been out of order when they were grouped by account+security, which made the security that was common between those two investment accounts have extra rows in the wrong account's section. I've tweaked the transaction sorting to see if that might be the problem and build 1692 should be available on the preview site in a short while with that change. If that doesn't fix it I'll take a deeper look.
Sean preview 1693 has completely broken this report. It now creates several entries of the same security and several entries for the same Investment Account. See enclosed 'performance report.jpg and compare with performance.jpg