How to create a Monthly General Ledger Summary Report

Build and report a summary of monthly GL data into defined groupings.

Steps:

Navigate to ACCOUNTING > General Ledger > General Ledger Reports.
Expand the Trial Balance & Summary Report section to see the list of available reports.
Select the Monthly General Ledger Summary Report.
Enter the following information.
There are up to 3 Grouping Options that can be selected for one report.

Choose a different option for each group.

Grouping Option	Office
	GL Account
	GL Account Type
	Client
	Master Client
	Client Type
	Product
	Job
	Job Type
	Task Type
	Supplier
	Master Supplier
	Supplier Type
	Transaction Type
	Department
	Employee

Select EXCEL, EXPORT, or PREVIEW to view the report

By default, the amounts will be displayed each month according to their accounting value – e.g., debit minus credit.

If users wanted to analyze the amounts posted to revenue amounts (which are normally credit/negative accounting postings to the GL) – select the option GL ACCOUNT TYPE NATURE – that way, a credit amount posted to a negative nature GL account (e.g., Liabilities, Revenue, Shareholders Funds) will display as a positive amount on the report.