[GNC] Incorrect Trial Balance Amounts

John Ralls jralls at ceridwen.us
Tue Jun 15 11:43:31 EDT 2021


That would suppose that there's more documentation for the Trial Balance Report than the single sentence in https://www.gnucash.org/docs/v4/C/gnucash-guide/rpt_standardrpts.html#rpt_grp_incexp. Perhaps you'd like to write some?

John Ralls

> On Jun 15, 2021, at 12:12 AM, David Carlson <david.carlson.417 at gmail.com> wrote:
> It would be nice if that method were described accurately in the documentation, because going by the name it sounds like something completely different and wrong if it  is using incorrectly estimated prices instead of actual transaction prices.  I would make the same mistake if I were doing what volker was doing.
> On Tue, Jun 15, 2021 at 1:02 AM Volker Englisch <volker at englisch.us> wrote:
> Thank you for the explanation, John!  I did have the price source for 
> the report set to "Nearest in time".  After setting the source to 
> "Average Cost" the numbers came out as expected.
> Regarding your question about the proper recording of the capital gains, 
> I'm still going through the documentation to set up the accounts as 
> listed. My initial problem was that the numbers didn't add up even 
> before I sold anything.
> -- 
> Volker Englisch
> phone: (240) 343-5343 (mobil)
> mailto:Volker at Englisch.us
> On 6/14/21 12:06 PM, John Ralls wrote:
> >> On Jun 13, 2021, at 5:39 PM, Volker Englisch <volker at englisch.us> wrote:
> >>
> >> Hi there,
> >>
> >> I would like to check if I'm doing something wrong or if I'm correct in my assumption that the Trial Balance report isn't displaying correct amounts in all cases.
> >>
> >> I'm using Ubuntu 20.04.2 LTS with GnuCash 3.8.
> >>
> >> I started keeping track of some stock and entered the number of shares on Jan. 1, 2021, for example.  Let's say I have 100 shares worth $2 each.
> >>     Asset:Investment:MyStock                200 (for 100 shares at $2)
> >>                 Equity:Opening Balance                    200
> >>
> >> After a while (April 1st) I sell all shares and enter the corresponding transaction.  The price for the shares increased to $3 since I started tracking (I wish!):
> >>      Asset:Current Asset:Checking Account        300
> >>                  Asset:Investment:MyStock 300 (for 100 shares, $100 realized gains)
> >>
> >> When I run the trial balance report for the day I first entered MyStock everything looks good: $200 debit / $200 credit.  The same is true for the day I sold MyStock: $300 debit / $200 credit, the difference is my gain.  However, when I run the trial balance for 03/01 for instance, the trial balance shows $300 debit / $300 credit with $100 listed as unrealized gains.
> >>
> >> What seems to be happening is that the TB calculates the value of the stock based on the last price entered in the price editor rather than using the last price prior to the date for which the TB is run.  With two entries in the price editor DB, one for 01/01 and one for 04/01 I would expect the price for 01/01 to be used until 03/31.
> >>
> >> Am I doing something wrong?  It's possible I'm not understanding precisely how the TB is coming up with the numbers.
> >>
> >> Thank you!
> > Did you record an income split for the capital gain? You mention the gain but I don't see the split for it in your example transaction. See https://www.gnucash.org/docs/v4/C/gnucash-guide/chapter_capgain.html for details about how to record capital gains/losses and why you should do so.
> >
> > As for price, the default in the Trial Balance Report is Average Cost (which isn't really, but the algorithm behind it is tailored specifically for the Trial Balance Report). That looks at the actual amounts and values in the splits; the Nearest in Time and Latest Price price sources consult the pricedb and won't balance, so don't use them.
> >
> > Regards,
> > John Ralls
> >
> _______________________________________________
> gnucash-user mailing list
> gnucash-user at gnucash.org
> To update your subscription preferences or to unsubscribe:
> https://lists.gnucash.org/mailman/listinfo/gnucash-user
> If you are using Nabble or Gmane, please see https://wiki.gnucash.org/wiki/Mailing_Lists for more information.
> -----
> Please remember to CC this list on all your replies.
> You can do this by using Reply-To-List or Reply-All.
> -- 
> David Carlson

More information about the gnucash-user mailing list