Advanced Portfolio Income (maybe Brokerage Fees too) incorrect in switch and multiple investments transactions

Alberto Dante alberto.dante at gmail.com
Tue Dec 20 05:52:54 EST 2016


Mistake:
In this case Advanced Portfolio income column charges 16,00 Euro both to 
FUND 3 and FUND 4; total fee = 32,00 Euro.

On 20/12/2016 11:45, Alberto Dante wrote:
> First of all, note that I've put all my investment operations (fee, 
> capital gain, dividend, ...) into Income accounts 
> (Income:Finance:...), so I can have the net finance balance directly, 
> and I can compare different types of Income (Job, Finance, ...) in a 
> glance.
> Simply, my account tree is something like that:
>
> Assets
>         Current Assets
>                 Cash
>                 Checking
>                         Bank ABC
>         Investment
>                 Broker DEF
>                         Mutual Fund
>                                 FUND 1
>                                 FUND 2
>                                 FUND 3
>                                 FUND 4
> Income
>         Job
>                 ........
>         Finance
>                 Investment
>                         Broker DEF
>                                 Mutual Fund
>                                         FUND 1
>                                                 Capital gain
>                                                 Dividend
>                                                 Fee / Commission
>                                         FUND 2
>                                                 ......
>                                         FUND 3
>                                                 ......
>                                         FUND 4
>                                                 ......
>
> Therefore, in Advanced Portfolio report I have not-zero values only in 
> Income column, while Brokerage Fees column has all zero values.
> So I couldn't check Brokerage Fees column values in Advanced 
> Portfolio, but I think it would be affected by the same problem.
> I've found two situations causes incorrect Income column values in 
> Advanced Portfolio Report:
>
> 1) Switch Investments
>
> When switching e.g. from FUND 1 (sell) to FUND 2 (buy) (without 
> involving Bank ABC account), generally you have to pay fees (e.g. 5,00 
> Euro) charged to FUND 2, while FUND 1 doesn't have any fee (sell is 
> for free); total fee = 5,00 Euro.
> In this case Advanced Portfolio income column charges 5,00 Euro both 
> to FUND 1 and FUND 2; total fee = 10,00 Euro.
>
> 2) Multiple Investments
>
> With just one operation (one transfer from Bank ABC account) you buy 
> two funds FUND 3 and FUND 4, paying 8,00 Euro fee each; total fee = 
> 16,00 Euro.
> In this case Advanced Portfolio income column charges 16,00 Euro both 
> to FUND 1 and FUND 2; total fee = 32,00 Euro.
>
> Please note that all totals in account tree (mainly 
> Income:Finance:...) are always correct; other column values in 
> Advanced Portfolio report seems to be correct too.
>
> Moreover:
> - Basis column how is calculated (when, after multiple buy operations, 
> you have a total sell and a new buy again)? Does Advanced Portfolio 
> recognize the total sell before the last buy?
> - I calculate capital gain manually; how is it possible to find it 
> automatically? Realized gain column does it already or uses my 
> manually calculated values?
>
> Thanks, Alberto
>



More information about the gnucash-user mailing list