[GNC] Example of importing Stock transactions from CSV

[Adrien Monteleone]

Unless I've confused something, purchasing or selling a stock/fund/etc. 
should be between 2 asset accounts. Considering a split for a commission 
or such, (like the first line of your CSV) it would be a *specific* 
expense account, not the parent and placeholder "Expenses" account.


Regards,
Adrien

On 8/24/22 6:23 AM, Jon Schewe wrote:

> Given the attached CSV file
> The AMOUNT column is dollars. The FUND UNITS column is in shares.
> 
> Skip 1 row, use m-d-y for Date format
> 
> Column Name -> GnuCash field
> POSTING DATE -> Date
> ACTIVITY TYPE -> Description
> FUND -> Account
> FUND UNITS -> Deposit
> FUND NAV/PRICE -> Price
> Transfer Account -> Transfer Account
> Fund Commodity -> Transaction Commodity
> 
> When I use those mappings GnuCash has the correct amounts in the "Match
> transaction" view, however it doesn't have a transfer account
> specified. When I try and specify an account I'm told that the
> Transaction Commodity doesn't match the commodity of the selected
> account, which is Expenses.