[GNC] Example of importing Stock transactions from CSV

[Jon Schewe]

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.

On Wed, 2022-08-24 at 09:41 -0500, David Carlson wrote:
> Jon,
> 
> My example that I gave earlier deliberately ignored commissions.  I
> assumed
> the simpler method, as described somewhere in the help manual, that
> net
> prices were used instead.  This will better match your broker's
> statements
> when you review the cost basis.  If your first line is supposed to
> indicate
> a sale that is then applied to a (monthly?) fee, you should split it
> into a
> sale for cash, then use the cash to pay the fee.  It would be
> necessary to
> import the fee expense payment into the brokerage account rather than
> the
> security account.
> 
> 
> On Wed, Aug 24, 2022 at 8:35 AM Adrien Monteleone <
> adrien.monteleone at lusfiber.net> wrote:
> 
> > 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.
> > 
> > 
> > _______________________________________________
> > 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.
> > 
> 
>