Trial Balance report -operator error or bug

David Carlson david.carlson.417 at gmail.com
Fri Feb 10 10:57:54 EST 2017


I have submitted Bug 778455
<https://bugzilla.gnome.org/show_bug.cgi?id=778455> which includes David
T's file and brief but incomplete description.

Now it on record.

David C

On Thu, Feb 9, 2017 at 10:36 PM, David T. <sunfish62 at yahoo.com> wrote:

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


More information about the gnucash-user mailing list