Report to locate Unrealized Gains

John Ralls jralls at ceridwen.us
Sun Feb 12 22:31:28 EST 2017


> 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?

Regards,
John Ralls



More information about the gnucash-user mailing list