Trial Balance report -operator error or bug

[David T.]

I attach a simple gnucash file that contains one commodity account with an initial holdings and two sells with manually-entered capital gains values. The Chart of Accounts clearly shows $0 present, but the balance sheet shows unrealized gains.

David

-------------- next part --------------
A non-text attachment was scrubbed...
Name: UnrealizedGainsTest.gnucash
Type: application/octet-stream
Size: 3154 bytes
Desc: not available
URL: <http://lists.gnucash.org/pipermail/gnucash-user/attachments/20170210/8e7acd76/attachment.obj>
-------------- next part --------------



> On Feb 10, 2017, at 4:42 AM, david.carlson.417 <david.carlson.417 at gmail.com> wrote:
> 
> 
> 
> It looks like anyone who tracks (un)realized gains should run their reports in an older version of GnuCash before adopting release 2.6.15.  
> I think there is a bug, but it must be a subtle one.  If anyone can build a small sample file to illustrate the issue, it would be helpful.
> I will try to remember  to do that before I update but it may take me a couple of months to get to that priority. 
> David  C
> 
> 
> Sent via the Samsung Galaxy S? 5 ACTIVE?, an AT&T 4G LTE smartphone
> 
> -------- Original message --------
> From: Michael via gnucash-user <gnucash-user at gnucash.org> 
> Date: 2/9/17  1:13 PM  (GMT-06:00) 
> To: gnucash-user at gnucash.org 
> Subject: Re: Trial Balance report -operator error or bug 
> 
> Hi hppweu,
> 
> I have had the same experience with 2.6.15 vs 2.6.14.  I certainly don't 
> know what the problem is, but I have spent a lot of fruitless time 
> trying to figure out what might be happening.  I believe at least one 
> other person has had the same problem.  I believe he switched to 
> 2.6.12.  Anyway, I have kept a version 2.6.14 around just for this 
> reason.  Mike Churchill
> 
> 
> On 02/09/2017 09:25 AM, hppweu wrote:
>> I have been tracking my brokerage accounts and personal finances in gnucash for a couple of years now.  Last year I had some problems and found out what the statement:  "GnuCash does not automatically calculate your net capital gains" really meant.  I asked and got help from the list (thanks David Carlson).
>> 
>> 1.  I started tracking all of my individual stock, mutual fund, and unit trust transactions in a spread sheet to calculate gross & net gains.  (Some have commissions, others do not, some dividends are reinvested, some are not, etc.)
>> 2.   I used the Transaction Report to ensure that the total value debits and credits were equal, after all shared had been liquidated.
>> 
>> After getting  out of the weeds, so to speak, with the above process I was good for year end 2015.  The trial balance report balanced, the balance sheet balanced, all transaction reports for liquidated investments balanced.
>> 
>> Now I am trying to do the same for 2016.  Low and behold 2016 doesn't balance.  In tracking down where the error happened, I went back & back, and I finally tracked the imbalance to a sale of some Microsoft shares in July 2013. That didn't seem correct, since everything had balanced at the end of 2015.  I had updated to gnucash version 2.6.15 in January.  I saw one of the changes was Bug 775368.  Long story short, I have run several reports against the same data using gnucash ver. 2.6.14 & 2.6.15 with different results.  I realize that the default for the commodity price source was changed between ver. 2.6.14 & 2.6.15, so I also ran each report using average cost and nearest in time.  I have attached a file showing the results.
>> 
>> The results showed that using version 2.6.14 my trial balance is still equal for year end 2015.  Using version version 2.6.15, my trial balance is off beginning with a sale of some Microsoft shares in July 2013.
>> For the trial balance report:
>> On 7/15/13 the debits = credits for nearest in time & for average cost for both versions of gnucash.
>> On 7/16/13 the debits = credits for nearest in time & average cost for 2.6.14.  But in version 2.6.15 the credit is greater than debit by $3.35 for nearest in time & average cost.
>>    For the Balance Sheet report:
>> On 7/15/13 the assets = total equity (liabilities = 0) for nearest in time & for average cost for both versions of gnucash.
>> On 7/16/13 the assets = total equity (liabilities = 0) for nearest in time for both versions of gnucash and for average cost in version 2.6.14.  But for average cost in version 2.6.15, there is an unrealized loss of $3.35, and the assets are not equal to the total equity.
>> 
>> I have double checked my gain calculations for the stock sale that appears to have caused the issue in version 2.6.15.
>> 
>> My question is whether there is a bug in version 2.6.15 or did those changes highlight a bug in my process?
>> 
>> Thanks in advance for any help,
>> Pam
>> 
>> 
>> _______________________________________________
>> gnucash-user mailing list
>> gnucash-user at gnucash.org
>> https://lists.gnucash.org/mailman/listinfo/gnucash-user
>> -----
>> Please remember to CC this list on all your replies.
>> You can do this by using Reply-To-List or Reply-All.
> 
> _______________________________________________
> gnucash-user mailing list
> gnucash-user at gnucash.org
> https://lists.gnucash.org/mailman/listinfo/gnucash-user
> -----
> Please remember to CC this list on all your replies.
> You can do this by using Reply-To-List or Reply-All.
> _______________________________________________
> gnucash-user mailing list
> gnucash-user at gnucash.org
> https://lists.gnucash.org/mailman/listinfo/gnucash-user
> -----
> Please remember to CC this list on all your replies.
> You can do this by using Reply-To-List or Reply-All.