General Ledger Summary Report

[heatherpotter]

Can we have standard report on ERPNext (cloud) for GL Summary report? I'm looking for something high level that shows the debits/credits/total for each GL account without all the details. Many accountants just need the high level report and not all the details to do their calculations. Details are only needed when looking for something specific or digging in to the data.

Example report:

Here is the thread on the forum:
https://discuss.erpnext.com/t/general-ledger-summary-report/40748/8

[heatherpotter]

On forum, @jigneshpshah wrote this query report which is exactly what I need:
select
account AS "Account:Link/Account:150",
sum(debit)As "Debit:Currency:120",
sum(credit) AS "Credit:Currency:120",
(sum(debit) - sum(credit)) as "Net:Currency:120"
from tabGL Entry
group by account