The General Ledger Transactions Report shows all transactions (by Account) with a DR and CR column. The DR and CR column is totalled for each Account. However, to be really useful, this report should also show a NET BALANCE for each Account and show that balance under either the DR column or the CR column (depending on whether the net result is DR or CR). The General Ledger Summary Report does show these balances, but not the transactions. The General Ledger Transaction Report also really needs to show a REFERENCE number for each transaction … that would make it so much easier to “audit” the system. That an individual account be able to be selected, or, only balance sheet accounts or only profit & loss accounts [image]

the last request , if we can balance as below [111111]

@lubos any news about this small modification?

It would be great if the Supplier Name could be joined to the Purchase Invoice fields in the General Ledger Transactions for custom reports, similar to how Customer Name is joined to Sales Invoice fields. Any idea when that might be done?

Yup its needed badly. You can make use of custom report builder for the time being. [image] [image]

Thank you. I was using Supplier Name instead of Contact in the custom report. Works now that I use Contact.

MANY thanks. That makes the report far more useful and more typical of “traditional” G/L reports. That said, as well as Opening Balances, is it also possible to include CLOSING BALANCES in that report … it would simply be the difference between the Debit and Credit Totals (which are already shown). The Totals shown for each G/L account (under Debit and Credit columns) aren’t anywhere as useful (IMHO) as a Closing Balance would be. The modification that you just made makes it a lot easier for Accountants (say) to use this report rather than needing the the Summary G/L Report as well … however, to work out the Closing balance for each G/L account still requires the “manual” subtraction of Debits - Credits … if the system did that and showed it as the Closing balance, then no “manual intervention” would be required.

[image] lubos: latest version (18.10.78) adds opening balances to general ledger transactions report I did not see the point of balances in a transactions report to begin with. Now that I’ve seen the result, they still seem inappropriate. Nevertheless, if you’re going to have them, the program should produce consistent results. They appear only when there is a non-zero balance on the opening date. While I understand the logic of the program, many report readers will not, including the accountants and auditors people are so worried about. The report will look incomplete or faulty, casting doubt on its accuracy. Likewise, opening balances without closing balances conveys the impression of incompleteness.

[image] lubos: So the latest version (18.10.78) adds opening balances to general ledger transactions report instead. Great to know that this request has been added @lubos thank you. But to add to @Tut’s comment, we accountant know that when there is an opening balance a closing balance is sure to follow. Every report with opening balance have closing balances. Thank you again for working on the GL transactions report we await the conclusion.

For what it concerns the actual structure I find the document coherent and consistent without the closing balance (by the way you have it splitted in CT and Dr). I see way @lubos designed it this way and I’m with him. The only way to add a closing balance is to have an additional column on the right end side but I find it redundant.

General Ledger Transaction Report (Suggested Modifications)

Uncategorized

lubos October 20, 2018, 9:38pm 49

I came to conclusion that opening balances are not suitable for custom reports.

So the latest version (18.10.78) adds opening balances to general ledger transactions report instead.

The General Ledger Transactions Report includes the opening balance in the totals of the Debit and Credit column

Topic		Replies	Views
Request - General Ledger Transactions Report Modification Uncategorized	3	628	October 12, 2017
General Ledger Report Uncategorized	15	5360	August 4, 2019
Making the General Ledger Transactions report more useful Uncategorized	35	7451	May 8, 2018
General Ledger Transactions report Uncategorized	7	1888	May 6, 2016
General Ledger Transaction report Uncategorized	4	1466	April 8, 2016

General Ledger Transaction Report (Suggested Modifications)

Related topics