[GNC-dev] tb, gnc or me? my trial balance is wrong and I think it is gnc not me

John Ralls jralls at ceridwen.us
Sun Feb 10 11:54:03 EST 2019


The "Average Cost" price source creates a price based on the actual transaction prices and is designed for the TB report, see the thread beginning with https://lists.gnucash.org/pipermail/gnucash-devel/2008-July/023297.html. I broke it for 2.6.13-2.6.21, see https://bugs.gnucash.org/show_bug.cgi?id=775368. The "Average Cost" and note that even 2.6.21 didn't fully fix it; that didn't happen until 3.2.

Average cost is the *only* price source that works for the Trial Balance Report. In particular the "Nearest in Time" and "Most Recent" sources will take prices from the price database that are unlikely to reflect the actual prices for the transactions and will vary depending on the date of the report. I agree with Adrien that we should consider removing the price source option from that report and hard-wire it to average cost.

Regards,
John Ralls

> On Feb 10, 2019, at 12:56 AM, Adrien Monteleone <adrien.monteleone at lusfiber.net> wrote:
> 
> I’m in agreement on that note. I understand why someone who doesn’t close books would like a report that shows a current position. But the Trial Balance report is really only useful for the close books crowd. It should only reflect actual transactions in the various registers. In the case of assets then, it shouldn’t be estimating based on any user choice of average, nearest date or such, it should be taking actual purchase price just like you would if you did it on paper.
> 
> Regards,
> Adrien
> 
>> On Feb 10, 2019, at 2:47 AM, D via gnucash-devel <gnucash-devel at gnucash.org> wrote:
>> 
>> Ok. I'll preface my comments with the note that every time I try to understand how the trial balance report works, someone on the list points out how misguided my understanding is....
>> 
>> That being said, I don't understand how a trial balance of completed transactional history could change value based on a change in price history settings. The euros I bought last week might be worth more this week, but I'd expect the report to be based on what was real, versus the imaginary value those euros have gained or lost since then.
>> 
>> David T.
>> 
>> On February 10, 2019, at 2:40 AM, David Carlson <david.carlson.417 at gmail.com> wrote:
>> 
>> Following up on my last email, in version 2.6.17 the Trial Balance report does default to nearest in time as the default valuation procedure.   I don't know what happens in 3.4.
>> 
>> 
>> David Carlson
>> 
> 
> _______________________________________________
> gnucash-devel mailing list
> gnucash-devel at gnucash.org
> https://lists.gnucash.org/mailman/listinfo/gnucash-devel



More information about the gnucash-devel mailing list