Incorporating month end results with independently managed portfolio.

Gordon Gardner's Avatar

Gordon Gardner

12 Aug, 2016 06:25 PM

In order to avoid adding and updating multiple holdings from a separate managed portfolio is it possible to add the balance as a single investment? The total combined monthly capital increase/decrease and income received as shown on their monthly comprehensive statements needs to be included in the Money Dance figures. This would achieve reports for the total value of assets and income The time spent in copying all the individual transactions is becoming a major problem. I have tried several different approaches by using different 'Actions" but have been unable to get both a correct combined total and accurate income for the month.
I suspect there are many others faced with this dilemma and that a solution is available.
Your assistance will be greatly appreciated
Old Goat

  1. 1 Posted by dwg on 12 Aug, 2016 09:40 PM

    dwg's Avatar

    I think you are talking about an add and remove function somewhat like Quicken has with the meaning in managed funds that the increase and decrease represents changes in value, Though this is not shown as being income in Q and I do not think it is appropriate to do so.

    Sorry to say that Moneydance does not have a function that does this sort of thing and I do not believe there is a really simple effective approach. The only way I have found of effectively showing and reporting on the investment (while treating it as an investment account) is to calculate a new share "price" each month for the total fund. To do this I had to create a spreadsheet to do the calculations.

  2. 2 Posted by Tom Freeman on 15 Aug, 2016 08:47 PM

    Tom Freeman's Avatar

    You could treat the managed investment as an asset account. You would create custom categories for increase/decrease capital and for income received.

    Tom Freeman
    Infinite Kind Support

  3. 3 Posted by Gordon Gardner on 16 Aug, 2016 02:20 PM

    Gordon Gardner's Avatar



    This is an approach I hadn’t considered. Before I make too many alterations to my original set up is it possible to create a separate duplicate and work with this until I achieve the results I am looking for? If so how do I make a complete copy?

    I’m endeavouring to reduce the time spent balancing at month end but can’t risk fouling up my Money Dance records of many years. One of the areas I am concerned about is recording monthly income from a couple of Registered Accounts.

    Your help will be gratefully appreciated.


  4. 4 Posted by dwg on 16 Aug, 2016 09:34 PM

    dwg's Avatar

    You cannot make a copy using Moneydance, however you can make a copy using whatever tools your operating system has to make a copy of a complete directory tree. The Moneydance data sets are effectively a directory tree with subdirectories and files so by simply copying the entire tree to a new name you have a complete copy of the the data with a new dataset name.

  5. 5 Posted by Tom Freeman on 24 Aug, 2016 06:23 PM

    Tom Freeman's Avatar

    I want to check in to see if you used DWG's advice on copying your data directory and were able to play with the asset class as an alternative to your investment tracking.

    Tom Freeman
    Infinite Kind Support

  6. System closed this discussion on 23 Nov, 2016 06:30 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