6

In GnuCash, I have tried setting up a mutual fund similar to the Stock Account example in 9.4 of the GnuCash manual, but as a Mutual Fund. The account that I set up looks something like this (example values):

Account name Nasdaq 100
Account Code xxxxx
Description whatever
Account Type Mutual Fund
Security/currency USD (US Dollar)
Smallest fraction 1/10000

I bought some shares, paying for them from a "USD Checking Account". As a simplified example, let's say $10,000, 200 shares at $50.0000/share.

When I imported transactions from my "USD Checking Account", for the debit of $10,000, I was able to choose the "Nasdaq 100" account as the destination.

After importing, I opened the "Nasdaq 100" mutual fund account to find something like this:

Date Num Description Transfer R Shares Price Buy Sell Balance
2023-01-01 INVESTMENT Assets:USD Checking Account n 10,000.0000 1.0000 10,000.00 10,000.0000

I try to update the values to this:

Date Num Description Transfer R Shares Price Buy Sell Balance
2023-01-01 INVESTMENT Assets:USD Checking Account n 200.0000 50.0000 10,000.00 10,000.0000

When I tell it to save the transaction, all the numbers revert to what was previously, or values a couple percent off (e.g. $9,958.77 instead of $10,000).

If I change to Split mode and click on the "Nasdaq 100" line, the column headers change from Shares/Price/Buy/Sell to Oth. Curr/Exch. Rate/Buy/Sell, which seems suspicious. I see that the confirmed value in the "USD Checking Account" has changed to $9,958.77, messing up the balance in that account.

Some site told me to enter price history in the Tools -> Price Database, which does have some entries. It didn't seem to help, and I do not know if that is now conflicting with me entering prices or not.

I have gone back and tried variations of the numbers with slightly varying levels of failure, but can never get anything that works.

At this point, GnuCash (5.0/2023-03-25, but also on the 4.x version, all on Windows 10) on my system is not functional for entering in mutual funds. But my searches have not found other people posting about this kind of problem, so I imagine there are thousands of people using it with success, and I must be entering something wrong or maybe I configured something wrong.

1 Answer 1

15

This is the problem:

Security/currency: USD (US Dollar)

You have told GnuCash that the account holds quantities of USD, and thus it expects that the “price” is exactly 1 since you are “buying” USD with USD (i.e. transferring money from one account to another).

You need to re-create the account, and when you do so, put the mutual fund in the security/currency field. If you've been entering prices for it, then you should already have a security entry for it — if not, then press the New button when picking the security for the account.

1
  • 1
    The steps worked perfectly, and the explanation makes it obvious why. Thanks so much! I knew it would be something I was not expecting.
    – Pixel
    Apr 25 at 10:11

You must log in to answer this question.

Not the answer you're looking for? Browse other questions tagged .