[GNC] Advice on investment accounts
Steve Hill
steve at nexusuk.org
Mon Jan 16 06:32:56 EST 2023
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
More information about the gnucash-user
mailing list