After an evaluation, GNOME has moved from Bugzilla to GitLab. Learn more about GitLab.
No new issues can be reported in GNOME Bugzilla anymore.
To report an issue in a GNOME project, go to GNOME GitLab.
Do not go to GNOME Gitlab for: Bluefish, Doxygen, GnuCash, GStreamer, java-gnome, LDTP, NetworkManager, Tomboy.
Bug 463320 - Trial Balance Report: Does not add up correctly
Trial Balance Report: Does not add up correctly
Status: VERIFIED FIXED
Product: GnuCash
Classification: Other
Component: Reports
2.0.x
Other Linux
: Normal normal
: ---
Assigned To: Charles Day
Chris Lyttle
Depends on:
Blocks: backport
 
 
Reported: 2007-08-04 02:23 UTC by Tom Roeschen
Modified: 2018-06-29 21:44 UTC
See Also:
GNOME target: ---
GNOME version: ---


Attachments
Gnucash test file (2.46 KB, application/octet-stream)
2007-08-04 02:27 UTC, Tom Roeschen
Details

Description Tom Roeschen 2007-08-04 02:23:46 UTC
I've done some further investigation with regards to the trial balance being out of balance. I've entered the transactions in a separate file to drill down on the problem and make it easier to troubleshoot. My trial balance shows the following: [Price source=Most recent]
                      dr                 cr
Checking Account    47,890.00
Verasun [Stock]      2,600.00
Capital gains                         300.00
Commission              10.00
Opening Balance                    50,000.00
Unrealized Gains

Totals             50,500.00       50,650.00

The credit column shows a total of 50,650.00 but only displays credits of 50,300.00.
The actual unrealized gains are 200.00 yet none appear.
Even if the unrealized gains of 200.00 did appear the balance would still be off by 150.00.

I've attached the actual GnuCash file so that you can load it to take a look at it.
Comment 1 Tom Roeschen 2007-08-04 02:27:58 UTC
Created attachment 93075 [details]
Gnucash test file

This is my actual Gnucash test file that shows the trial balance report problem
Comment 2 Tom Roeschen 2007-09-10 14:21:30 UTC
I've updated Gnucash to version 2.2.1 on SUSE 10.2 and this bug is still present.
Comment 3 Charles Day 2008-07-01 01:02:44 UTC
I had a look at your test file. The trial balance report is figuring unrealized capital gains incorrectly. There is a thread going about this right now on the mailing list.
Comment 4 Charles Day 2008-07-16 15:34:16 UTC
There were two problems: a broken unrealized gain/loss calculation, and an unrelated display bug (always blank in the credit column).

Committed a fix for both as r17339. Requesting backport for 2.2.
Comment 5 Andreas Köhler 2008-07-22 23:00:42 UTC
Applied to branches/2.2 as r17389 for inclusion in GnuCash 2.2.6.
Thanks!
Comment 6 John Ralls 2018-06-29 21:44:50 UTC
GnuCash bug tracking has moved to a new Bugzilla host. This bug has been copied to https://bugs.gnucash.org/show_bug.cgi?id=463320. Please update any external references or bookmarks.