I noticed that the General Ledger Transaction report randomly, in only some accounts, skips opening and closing balance.

The latest version (20.8.38) is adding Balance column to the report. This makes closing balances to be shown for all accounts.

It is not random, and it is not a bug. Opening and closing balances are shown when they exist for the time period of the report. If zero, nothing appears.

Happy to know it’s not a bug but I think that is a little misleading. I think that they should be always shown: opening and closing balance for balance sheet and closing balance for P&L.

If closing balance = 0 it is not mentioned.

I understand it. But think of an auditor that sees a list of movements that doesn’t have a closing total… I don’t even know if this kind of report can be considered compliant to the law.

[image] Tut: Opening and closing balances are shown when they exist for the time period of the report. A balance of $0.00 is a numerical result just as a $0.01 balance is a numerical result, therefore exist. If you had 86 transactions, it is inconsistent for Manager to display a balance of $…

Thanks a lot! I foresee a lot of potential functionalities for Balance columns in Custom Reports… if it will be dynamic ie linked to the data displayed on Custom Report and not to the General Ledger Transactions.

GL Transactions report inconsistent with opening / closing balances

Uncategorized

VACUUMDOG June 11, 2020, 2:03am 4

I noticed this also. Using 20.5.20.

Has an opening balance but no closing balance, which should be 0.00
I know my version is out of date, but there was an issue there then.

Total Missing in "General Ledger Transactions - Report"

Topic		Replies	Views
Opening Balance shows different between reports Uncategorized	5	214	May 20, 2024
General Ledger Transaction Report (Suggested Modifications) Uncategorized	112	7307	November 6, 2018
Trial Balance Report inconsistent with General ledger transactions report Uncategorized	4	490	February 18, 2021
General Ledger Transaction report Uncategorized	4	1431	April 8, 2016
Opening balances for P&L accounts on general ledger summary ideas	14	7058	September 6, 2022

GL Transactions report inconsistent with opening / closing balances

Related topics