Yes, I know this works. I tried in two ways: 1. Record the tax split in the sell transaction directing it to the mutual fund account (with shares and price recorded as zero) and then recording a separate tax transaction in the mutual fund account (again with both shares and price set to zero) directing it to the tax expense account.
2. Record the tax split in the sell transaction directing it to a transitory asset account and then recording a separate tax transaction in the transitory account directing it to the tax expense account. They both "work", however complexity is increased and that is something I am trying to avoid in this scenario. I am just wondering if there is a more "efficient" way to do this. Thank you all for the insights. Regards. Gilberto. On Thu, Sep 14, 2023 at 12:18 AM <[email protected]> wrote: > > Gilberto, > > Instead of recording the taxes directly in the account register for mutual > fund, you have to perform an intermediate step, such as - > > In mutual fund register, record the gross sale value with appropriate income > split for capital gain, but instead of transferring the sale proceeds > directly to bank, place it in a temporary account, say $Cash. > > Now open the $Cash account register and make a transfer to your bank with the > net proceeds after including a split for the tax deducted. > > This should fix your advanced portfolio report issue. > > Cheers. > > ------------------------------ > > Date: Wed, 13 Sep 2023 19:13:19 -0300 > From: Gilberto Reis Filho <[email protected]> > To: [email protected] > Subject: [GNC] Advanced Portfolio Report - Brokerage Fees > Message-ID: > <cacuwpyyvjsp4vxb9h-mpiaoygnma7okjmckdgmjyumwelda...@mail.gmail.com> > Content-Type: text/plain; charset="UTF-8" > > Hello. > > In my country whenever a person sells shares of a mutual fund the bank > has to calculate and pay taxes, on behalf of the investor, on capital > gains before making the funds avaliable to the investor. The investor > receives the funds in the brokerage account liquid of taxes. > > I am recording these taxes in a split in the transaction where the > shares sold are recorded, however doing this makes the advanced > portfolio report recognize this tax as brokerage fees (well, they are > not fees, but taxes). > > Is there any alternative to prevent this behavior and at the same time > keep things simple preferably without having to create separate > transactions? > > Thanks. > Gilberto. _______________________________________________ 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.
