Harvey i agree with you , if you want to measure using IRR. You can extract the data and do the review in a sheet.
GNUCash asset report is straight forward https://cvs.gnucash.org/docs/C/gnucash-help/report-assets.html 9.2. Assets & Liabilities - GnuCash<https://cvs.gnucash.org/docs/C/gnucash-help/report-assets.html> The display is in the form of either a stacked barchart or simple barchart with an option to display a table of the values. This report calculates and displays a default of 8 bars or up to 24 separate asset accounts value at the end of the day on several dates through a specified time period. cvs.gnucash.org Saludos Cordiales Murugan ________________________________ From: A Harvey <gah1...@gmail.com> Sent: Monday, January 16, 2023 6:10 PM To: Murugan Muruganandam <m.muruganan...@hotmail.com> Cc: Steve Hill <st...@nexusuk.org>; gnucash-user@gnucash.org <gnucash-user@gnucash.org> Subject: Re: [GNC] Advice on investment accounts Calculating the performance of an investment is not simple if cash/shares/etc. are added to and/or removed from the account during the period of interest. For example, see https://en.wikipedia.org/wiki/Internal_rate_of_return. -Arthur On Mon, Jan 16, 2023 at 12:39 PM Murugan Muruganandam <m.muruganan...@hotmail.com<mailto:m.muruganan...@hotmail.com>> wrote: hi Steve Gnucash supports pension funds tracking fully. and i handle the pension investment as a mutual fund and register my monthly contribution as units invested by the pension operator. (not sure how it is done at your place). The fund prices are always published by companies and you can use the Price database under tools to update the pricing. You can use the Advanced Portfolio Report to view your fund performance. if you want for a specific date, you can click on opitons and choose the date you want to view the results. The loss or profit on the fund is always un realised and should not be taken to Income or Expense account unless you are drawing down any units. Saludos Cordiales Murugan ________________________________ From: gnucash-user <gnucash-user-bounces+m.muruganandam=hotmail....@gnucash.org<mailto:hotmail....@gnucash.org>> on behalf of Steve Hill <st...@nexusuk.org<mailto:st...@nexusuk.org>> Sent: Monday, January 16, 2023 8:32 AM To: gnucash-user@gnucash.org<mailto:gnucash-user@gnucash.org> <gnucash-user@gnucash.org<mailto:gnucash-user@gnucash.org>> Subject: [GNC] Advice on investment accounts At the moment, I handle investments (e.g. my pension) as normal bank accounts. At the end of each year I receive a statement and I add a transaction into the account such as "Interest (5.05%)" which transfers the interest from an Income account (or to an Expense account in the event of a loss). I calculate the interest rate that I have received and add it into the transaction description (e.g. "5.05%" in the example above). This means that I can easily see how the account has performed, irrespective of how much I have deposited over the year by looking at the % interest rate that I have noted in the description. I can also see how much (in my currency, GBP) the account was worth at the end of each year. I want to switch over to using Gnucash's "Mutual Fund" and "Stock" account types. But there doesn't seem to be equivalent functionality: 1. Since the security isn't actually being bought/sold at the end of each year, the gains/losses for the year are unrealised so there won't be an "Interest" transfer. I guess I could add a blank transaction to note down the % interest that they year's gains/losses equates to, but is there a better way? 2. I can't see an easy way to see what the account was worth (in GBP) at a specific point in the past. I can add a "Total (GBP)" column to the main accounts page, which would tell me how much it is currently worth, but not how much it was worth in the past. It seems that an extra column in the account itself showing its total value at the time of each transaction would be a solution, but there doesn't seem to be a way of doing this? I presume this functionality is buried somewhere in reports - seems significantly more clunky and hard to use than it just being available on the account's own tab? Many thanks. -- - Steve _______________________________________________ gnucash-user mailing list gnucash-user@gnucash.org<mailto:gnucash-user@gnucash.org> To update your subscription preferences or to unsubscribe: https://lists.gnucash.org/mailman/listinfo/gnucash-user ----- Please remember to CC this list on all your replies. You can do this by using Reply-To-List or Reply-All. _______________________________________________ gnucash-user mailing list gnucash-user@gnucash.org<mailto:gnucash-user@gnucash.org> To update your subscription preferences or to unsubscribe: https://lists.gnucash.org/mailman/listinfo/gnucash-user ----- Please remember to CC this list on all your replies. You can do this by using Reply-To-List or Reply-All. _______________________________________________ gnucash-user mailing list gnucash-user@gnucash.org To update your subscription preferences or to unsubscribe: https://lists.gnucash.org/mailman/listinfo/gnucash-user ----- Please remember to CC this list on all your replies. You can do this by using Reply-To-List or Reply-All.
