Report to locate Unrealized Gains
John Ralls
jralls at ceridwen.us
Sun Feb 12 23:39:02 EST 2017
> On Feb 12, 2017, at 7:31 PM, John Ralls <jralls at ceridwen.us> wrote:
>
>
>> On Feb 7, 2017, at 7:38 AM, David T. via gnucash-user <gnucash-user at gnucash.org> wrote:
>>
>> I have a set of transactions from 2007: an Initial Holdings transaction of 200 shares, with a cost basis of $23.80. I sold 100 shares for $3480, with $63.99 commission and $.06 fee, with $3415.95 coming along to me. My broker statement for that transaction listed capital gains of $3404.05 (3480-63.99-.06-(23.80/2)), which is what I entered as a separate capital gains transaction on the same date. (See screen shot below)
>>
>> The Balance Sheet report for this date lists unrealized gains of $104.30 (just to be clear, this is the only transaction affecting any commodities in my data file on this date). This figure stumped for a LONG time, until I realized that
>>
>> 104.30 (Unrealized gainson report) =(63.99 [commission]+.06 [fee]-(23.80/2) [initial cost basis])*2
>>
>> In other words, the Balance Sheet report was off by the total fees, reduced by the initial cost basis
>
> What were the counter-accounts for the commissions and fees?
Never mind, based on the bug and other responses I think I already know, and I've responded in a couple of places already.
Regards,
John Ralls
More information about the gnucash-user
mailing list