improper basis for multiple funds purchased simultaneously
Jeffrey Bridge
jeffrey+gnucash.org at firehead.org
Fri Jan 26 18:00:51 EST 2007
Hi,
In Gnucash 2.0.1 I have tried setting up a transaction that contained
splits for the purchase of two mutual funds simultaneously. This works
without any problems, except when I try to use the Advanced Portfolio
report. Here's how my example is set up:
account debit credit
Equity:Opening Balances $20000
Assets:Brokerage Account $20000
account debit credit
Assets:Brokerage Account $20000
Assets:S&P 500 Index Fund $10000
(100 shares of FSMKX at $100 each)
Assets:Bond Index Fund $10000
(1000 shares of FBIDX at $10 each)
Then download or manually add some prices (for example FSMKX $98.32 and
FBIDX $10.80) so that there is a little bit of gain or loss. Now go to
Reports -> Assets & Liabilities -> Advanced Portfolio. Here is what I
get:
Advanced Portfolio 2007-01-26
Account
Symbol
Listing
Shares
Price
Basis
Value
Money
In
Money
Out
Realized Gain
Unrealized Gain
Total
Gain
Total
Return
Bond
Index
Fund
FBIDX
FUND
1,000.00
$10.80
$20,000.00
$10,800.00
$10,000.00
$0.00
$10,000.00
-$9,200.00
$800.00
8.00%
S&P
500
Index
Fund
FSMKX
FUND
100.00
$98.32
$20,000.00
$9,832.00
$10,000.00
$0.00
$10,000.00
-$10,168.00
-$168.00
-1.68%
_____
Total
$40,000.00
$20,632.00
$20,000.00
$0.00
$20,000.00
-$19,368.00
$632.00
3.16%
It appears as though this report uses the cash split portion of the
second transaction as the basis cost for each fund purchase, instead of
using the fund split portion of the transaction. The workaround is to
break the purchases into two separate transactions, but I would prefer
not to have to do this. Is there a good reason for using the cash split
portion of the transaction as the basis?
I can attach an example file if you don't want to enter the data
yourself.
Jeff
More information about the gnucash-user
mailing list