QFX imports for Investment accounts

David Carlson david.carlson.417 at gmail.com
Fri Oct 16 18:34:38 EDT 2015


On 10/14/2015 2:47 PM, Al wrote:
>   I am unable to get QFX imports to interact correctly with my existing
>   investments accounts.
>
>   Example. I have under Assets---Investments---Brokerage Accounts---Stocks------
>   "MY BROKERAGE COMPANY NAME" ; under which I have an account for each Stock (for
>   example Gnu Business Machines),  Within this account I have 2
>   historical transactions (BUY/SELL, Imported via QIF)) and the current view
>   shows.....GNU Business Machines  0 GBM...... which is correct, at
>   least the data is..
>
> My QFX file has a Buy Trade for GBM and when imported I get a New Account
> Window showing GBM as a new Account, Type= stock, Parent Account= Brokerage
> Accounts. I can change the Parent Account to indicate where my existing GBM
> account lives, but no matter, when I OK the import I have a "New" GBM account
> with the correct trade info per this QFX file. So now I have two GBM
> accounts.  Another Import generates a another New Account as a sub account of
> the prior import's new account. .  So every import creates a new account
>   rather than adding new entries to my original GBM stock account and every new
> account is a sub account of the prior import containing transaction data.
>
> I cannot seem to solve this issue on my own, your help will be greatly appreciated.
> Final comment. I also have a separate file with Bank accounts and I have no problems
> with importing QFX files.  New data is entered where old date lives and life
> is good.
>
>   Thanks   Al
> _______________________________________________
> gnucash-user mailing list
> gnucash-user at gnucash.org
> https://lists.gnucash.org/mailman/listinfo/gnucash-user
> -----
> Please remember to CC this list on all your replies.
> You can do this by using Reply-To-List or Reply-All.

Al,
I do not use the OFX/QFX import for investment transactions, but I did 
notice that you do not mention whether it is possible for you to 
manually correct those imported transactions to the correct accounts in 
a manner similar to fixing a grocery store or gasoline station 
transaction that was incorrectly guessed by GnuCash.  It seems to me 
that should work for investment transactions too.

David C


More information about the gnucash-user mailing list