[GNC] Advanced Portfolio Report - Brokerage Fees

[devaps at asia.com]

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.