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.montele...@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@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 _______________________________________________ gnucash-user mailing list gnucash-user@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.
