[GNC] Advanced Portfolio Report - Brokerage Fees

[Gilberto Reis Filho]

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 <devaps at asia.com> 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 <gilberto.reis.filho at gmail.com>
> To: gnucash-user at gnucash.org
> Subject: [GNC] Advanced Portfolio Report - Brokerage Fees
> Message-ID:
>         <CACUWPYyVjsp4vXb9h-mPiaOyGNMA7oKjMcKDGMJyumwELdAGNA at 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.