[GNC] Example of importing Stock transactions from CSV

Adrien Monteleone adrien.monteleone at lusfiber.net
Wed Aug 24 21:54:40 EDT 2022


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.




More information about the gnucash-user mailing list