[GNC] Example of importing Stock transactions from CSV

[David Carlson]

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


-- 
David Carlson