[GNC] Example of importing Stock transactions from CSV

[David Carlson]

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.
>