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

R C myplaybsemail at gmail.com
Mon Sep 6 12:12:33 EDT 2021


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
-------------- 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/deb2f211/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/deb2f211/attachment-0003.png>


More information about the gnucash-user mailing list