On Sun, Mar 1, 2026 at 9:33 AM Jim DeLaHunt <[email protected]> wrote:
> Fred: > > On 2026-02-28 11:52, Fred Tydeman wrote: > > I am running GnuCash 5.12 on Fedora Linux 41 > > > > I am importing stock transactions from an old Quicken. > > Many of those transactions have a small commission > > (due to rounding error in price). > > Those transactions end up in GnuCash with 5 splits: > > stock > > cash > > commission > > trading (stock) > > trading (cash) > > I try to remove the commission split by deleting > > commission > > trading (stock) > > trading (cash) > > When I click on Enter, those three splits reappear. > > > > If I change the dollar amount in the trading (cash) split, > > it reverts back to the previous value when I press Enter. > > > > What is the correct way to remove the commission split? > > I suspect that the trading (stock) and trading (cash) splits are to > trading accounts. GnuCash enters them to make the sum of all stock > splits in the transaction, and of all cash splits in the transaction, > sum to zero. > Correct, they are trading accounts. > If the non-Trading splits ever sum to something other than zero, GnuCash > will add a corresponding Trading split. Thus deleting them does no good. > You must instead ensure that the other splits sum to zero. > That is what I am trying to do by deleting both trading splits and the commission split. So, all that is left is a stock split with the correct number of shares, and a cash split that is the correct total amount of money used. But, when I click Enter, the commission split comes back and the trading split with the dollar amount has the old value (total - commission). > GnuCash does not store the cash amount of a stock split. It just stores > the number of shares, and the price. It calculates the cash amount by > multiplying these two numbers. The number of shares in the transaction > is an external fact from the brokerage statement. So is the cash value > which the brokerage says you have. Thus you have to use those exact > numbers. However, the price is under your control. > I see no way to alter the price. Perhaps, it has to be deleted from the price history. I tried removing the price for that day from the price history, then removed the commission split, and two trading splits. When I click on Enter, the commission comes back as Imbalance. To drive the Trading split to zero, use the Transfer Funds dialogue, and > the "To Amount" field. This forces GnuCash to set the price to that > exact fraction which, when multiplied by the number of shares, gives you > the cash amount you want. This might well mean that the price you see > in GnuCash is different than the price reported by the brokerage. That > is fine. > I am trying to drive commission split to zero (not trading split). I tried using Transfer funds. It has nothing to do with stock price. It is just moving cash from one account to another account. > Does that help? > No. But thanks for trying. _______________________________________________ gnucash-user mailing list [email protected] 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.
