Skip to content
English
Sign in
  • There are no suggestions because the search field is empty.

How to create a Monthly General Ledger Summary Report

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

Steps:

  1. Navigate to ACCOUNTING > General Ledger > General Ledger Reports.
  2. Expand the Trial Balance & Summary Report section to see the list of available reports.
  3. Select the Monthly General Ledger Summary Report.
  4. Enter the following information. 
  5. There are up to 3 Grouping Options that can be selected for one report.
    Maria Large Knowledge Base Template -Jun-29-2023-06-53-44-6567-PM
  6. 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 
  7. 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.