[GNC] How do you add 401K data from QFX File?

David Carlson david.carlson.417 at gmail.com
Mon Sep 6 14:06:58 EDT 2021


R C,

It appears that you have some items assigned to an incorrect account.
There is a wealth of examples in the chapter of the tutorial on investments.

Taking things slightly out of order, the total value of the securities in
each security account is the cost of the securities.  The Net Assets item
at the bottom will not reflect market values, just the cost basis. The
market value is not tracked unless you enter prices in the price database,
which can be done several different ways with varying degrees of
precision.  There is some information about that in the tutorial.  If you
choose to download prices from the Internet, you need to use a companion
program called Finance:Quote which is a little tricky to get working, many
users need to come back here with very specific questions, which someone
here will be glad to answer.

Looking at your chart of accounts, it appears that you placed your mutual
fund account under an asset top account called Stock and you made some
error under your top account named Mutual Fund.  Also, the security asset
account is best placed under a brokerage asset account which will also
contain currency transactions when they appear.  For some types of mutual
fund accounts cash transactions rarely appear in their statements.  Since
your original question contained the text '401-K'  it appears that you have
a US trustee broker handling your investment, and you can name that
brokerage asset account by that trustee's name.
Your chart of accounts is not showing the type of each account, which would
help in seeing where your errors lie.  Go to the far right edge, click on
the down arrow in the title bar, and check the Type column name.  You can
uncheck it later when you no longer need to see that information.

It also appears that you have an income account for your dividends, so you
should have used that account in the reinvestment transactions.

Going back to the market value topic, GnuCash will only show that in some
of the investment reports.

On Mon, Sep 6, 2021 at 11:12 AM R C <myplaybsemail at gmail.com> wrote:

> Thanks for the follow up David.  I woke up this morning refreshed and
> ready to go and amazingly my mind was clear and I was able to properly
> import my data.  What I still don't understand is how to input the market
> change value.
>
> I resolved the import issue by choosing the correct import at the start.
> I was choosing USD in the wizard but I changed and used FUND.  Now my data
> is in like this:
> [image: Screenshot from 2021-09-06 11-53-22.png]
> which is more accurate but this is still not correct:
>
> [image: Screenshot from 2021-09-06 12-08-13.png]
>
> $36.21 is Dividends and Earnings.  What's missing is the market change
> value.  I thought that would've been adjusted but apparently not.  Should
> it not look at the transactions dates and calculate how much it has
> increased or decreased from online data?
>
> On Sun, Sep 5, 2021 at 7:08 PM David Carlson <david.carlson.417 at gmail.com>
> wrote:
>
>> R C,
>>
>> I just took a look at a few transactions that I recently imported via OFX
>> from my brokerage house then failed to proofread after importing,  This is
>> a relatively new capability in GnuCash OFX importer, only importing
>> investment transactions in releases 3.x and 4.x.  I just started trying it
>> out recently and I apparently lost some data somewhere shortly after my
>> first trial import.
>>
>> Anyway, I found that the OFX import did make some errors that could
>> resemble your issues, so I need to suggest searching the bugzilla list for
>> issues with the OFX importer with investment transactions.
>>
>> On Sun, Sep 5, 2021 at 4:40 PM David Carlson <david.carlson.417 at gmail.com>
>> wrote:
>>
>>> R C,
>>>
>>> Have you read the help manual chapter on Investments?  Your screenshots
>>> do not show everything, but from what is visible I can offer a couple of
>>> comments.
>>>
>>> I am not sure what the account named Market Index is supposed to
>>> represent.  If it is intended to represent a real mutual fund it is
>>> remarkable that it has the value shown.  If it is an attempt to show the
>>> market value of the mutual fund, that is not needed.  You should use the
>>> Price Database to store prices which you can download from the Internet.
>>> Then there are some investment reports which can show the value on given
>>> dates.
>>>
>>> Second, if your dividends and earnings entry represents a re-investment
>>> in additional shares, there should not be an offsetting sale of shares, but
>>> instead consist of a dividend income amount to offset the cost of the
>>> shares purchased.
>>>
>>>
>>>
>>> On Sun, Sep 5, 2021 at 3:51 PM R C <myplaybsemail at gmail.com> wrote:
>>>
>>>> I have my data in a .qfx file and I'm having a hard time getting it to
>>>> show
>>>> correctly in the app.  Going through the wizard, it asks for an
>>>> Investment
>>>> account, then a Stock account for security.  It gets in and its all
>>>> wrong.
>>>> I delete all the entries and try to import again.  This time most of the
>>>> data is correct but it seems like its in the wrong place.
>>>>
>>>> [image: Screenshot from 2021-09-05 16-06-52.png]
>>>>
>>>> [image: Screenshot from 2021-09-05 16-07-49.png]
>>>>
>>>> And how would I account for "market value change"?
>>>>
>>>> --
>>>> ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
>>>> The problem isn't how much you make, it's how much you spend.
>>>> "I have not failed. I've just found 10,000 ways that won't work." -
>>>> Thomas
>>>> Edison
>>>> _______________________________________________
>>>> gnucash-user mailing list
>>>> gnucash-user at gnucash.org
>>>> To update your subscription preferences or to unsubscribe:
>>>> https://lists.gnucash.org/mailman/listinfo/gnucash-user
>>>> If you are using Nabble or Gmane, please see
>>>> https://wiki.gnucash.org/wiki/Mailing_Lists for more information.
>>>> -----
>>>> Please remember to CC this list on all your replies.
>>>> You can do this by using Reply-To-List or Reply-All.
>>>>
>>>
>>>
>>> --
>>> David Carlson
>>>
>>
>>
>> --
>> David Carlson
>>
>
>
> --
>
> ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
> The problem isn't how much you make, it's how much you spend.
> "I have not failed. I've just found 10,000 ways that won't work." - Thomas
> Edison
>


-- 
David Carlson
-------------- next part --------------
A non-text attachment was scrubbed...
Name: Screenshot from 2021-09-06 11-53-22.png
Type: image/png
Size: 38533 bytes
Desc: not available
URL: <http://lists.gnucash.org/pipermail/gnucash-user/attachments/20210906/86130d53/attachment-0002.png>
-------------- next part --------------
A non-text attachment was scrubbed...
Name: Screenshot from 2021-09-06 12-08-13.png
Type: image/png
Size: 92355 bytes
Desc: not available
URL: <http://lists.gnucash.org/pipermail/gnucash-user/attachments/20210906/86130d53/attachment-0003.png>


More information about the gnucash-user mailing list