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

[David Carlson]

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