Unrealised capital gains

phil's Avatar


16 Dec, 2019 08:07 PM

I am running the total capital gains report and focusing on unrealised. I have an unusual total which I can trace to 5 holdings which correctly show the number of shares and value but zero as the cost basis. If I go to the investment account and look at the portfolio report or security detail I see the correct cost basis. Is this an issue??

  1. 1 Posted by dwg on 16 Dec, 2019 08:24 PM

    dwg's Avatar

    I'm a fellow user.

    The report is not working correctly. This issue was raised some time ago but nothing seems to have been done about it.

    Support: This issue should have been flagged for attention some time ago. See:


  2. 2 Posted by phil on 17 Dec, 2019 12:40 PM

    phil's Avatar

    Thanks to dwg I got a pointer to check LOTS vs Average cost - sure enough all problematic securities were set to Average - once changed to LOTS the reports came out accurately! Thanks to dwg

  3. 3 Posted by phil on 17 Dec, 2019 02:15 PM

    phil's Avatar

    Thanks - your pointers solved my problem - the securities in question were set to average cost. Changing to lots generated an accurate report.

  4. 4 Posted by dwg on 17 Dec, 2019 08:08 PM

    dwg's Avatar

    The report should work no matter what costing method is used. In some Countries you need to use a specific costing method so changing it in the software to something that works in Moneydance is not a solution.

  5. phil closed this discussion on 20 Jan, 2020 08:00 PM.

Comments are currently closed for this discussion. You can start a new one.

Keyboard shortcuts


? Show this help
ESC Blurs the current field

Comment Form

r Focus the comment reply box
^ + ↩ Submit the comment

You can use Command ⌘ instead of Control ^ on Mac