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