[GNC] Example of importing Stock transactions from CSV

[Jon Schewe]

My accounts were created before GnuCash defaulted to setting the top
level accounts as placeholders. So yes, my Expenses account will allow
transactions to use it.

When I get to the "Match Transactions" step, none of the transactions
have transfer accounts. When click the Add column and then try and
select an Asset account (ie. my retirement cash account for a
purchase), I get the error:
The account "401k" has a different commodity to the one required,
'Alight Equity Fund (S&P 500)'. Please choose a different account.


On Wed, 2022-08-24 at 21:47 -0500, David Carlson wrote:
> The GnuCash account structure is dictated by the program and it will
> not
> necessarily exactly match what your brokerage statement shows. As one
> of
> the previous comments noted, there are some bug reports indicating
> that the
> csv importer is not able to import some transactions .  You may need
> to
> fudge your data or manually massage it after your import.
> 
> On Wed, Aug 24, 2022, 8:55 PM Adrien Monteleone <
> adrien.monteleone at lusfiber.net> wrote:
> 
> > As for using the Expenses account, unless you intentionally made it
> > *not* a placeholder account, you can't put transactions in it. I'll
> > hazard a guess that is why the importer is not assigning it.
> > 
> > Create a sub-account of Expenses for tracking the commissions/fees
> > and
> > try to assign that one in your CSV following the other tips David
> > provided. (making the fee as a separate transaction with splits
> > between
> > an expense account and a brokerage account - *not* involving the
> > security account.) I'm also going to hazard that the Brokerage and
> > the
> > expense sub-account might need to be in the same currency, else
> > you'll
> > need Trading Accounts turned on to handle conversion splits so
> > things
> > work out properly.
> > 
> > As for why the security transaction alone won't import, I'm not
> > sure.
> > Did you try it all by itself in the CSV? (to eliminate variables)
> > 
> > Regards,
> > Adrien
> > 
> > On 8/24/22 8:32 PM, Jon Schewe wrote:
> > > I used the parent Expense account because I don't really need to
> > > track
> > > it separately. The fee is paid directly out of the stock account.
> > > I
> > > don't see how adding an additional account is going to fit the
> > > commodity problem. The second line is a purchase from a specific
> > > Asset
> > > account and that transaction won't import either.
> > 
> > 
> > _______________________________________________
> > 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
> > -----
> > Please remember to CC this list on all your replies.
> > You can do this by using Reply-To-List or Reply-All.
> > 
> _______________________________________________
> 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
> -----
> Please remember to CC this list on all your replies.
> You can do this by using Reply-To-List or Reply-All.