GL Account Reporting Groups

Body

Overview 

GL Account Reporting Groups are used to group GL Accounts together for financial reports on a Custom Financial Report Row. For example:

  • On your Balance Sheet, you could create a GL Account Reporting Group with the title of Current Assets.
  • Next would be to add all your GL Accounts that fall under Current Assets into the GL Account Reporting Group.  
  • For your Financial Report, this allows the ability to add the new Current Assets group to a report row.
  • It will then sum the balances for all of those accounts into one line. 

Create a GL Account Reporting Group

  1. Navigate to Accounting Home and click the Run Reports tab. Then, under the Custom menu, click GL Account Reporting Groups.
  2. Click New.
  3. Enter the GL Account Reporting Group Name.
  4. Select the Type from the drop-down list. It can be either:
    Balance Sheet (for Asset, Liability, and Equity accounts)
                                        -OR-
    Income Statement (for Revenue and Expense Accounts).
  5. Click Save. The GL Account Reporting Group screen displays. 
  6. From the GL Account Reporting Group Lines related list, click New. 

    GL_Account_Reporting_Group_01.png
    Note: Click here to view the above image in full screen. 

  7. Search for and select a GL Account.
  8. Click Save & New.
  9. Repeat this process for as many accounts as desired. Then, after adding the final account to include, click Save.

Note: Once GL Account Reporting Groups are defined, you can upload the 'component' GL Accounts to the GL Account Reporting Group. Refer to the Financial Statement Row article.

Include a GL Account Reporting Group on a Financial Report

  1. Select a Report Definition.
  2. Click the Definition Criteria tab. 
  3. Under the Financial Report Rows related list, click New.  The New Financial Statement Row dialog box displays. 

    New_Financial_Statement_Row.png

  4. Select Reporting Group from the Type drop-down list.
  5. (Optional) Enter a Row Label.
  6. Enter a Position. 
  7. Click the Lookup icon to search for and select the GL Account Reporting Group look up that is needed for the particular report.
  8. Click Save. 

____________________

 

 

Title
GL Account Reporting Groups
URL Name
818071087
ReportingCustom Financial Reports
Skip Feed

  1. rebecca.ralls1.5642179659911167E12 (Customer)

    April 3, 2018 at 9:21 PM

    Is there a way to specify a group as a RANGE of GL Accounts instead of a collection of Specific GL Accounts? This would make Custom report groups a lot less brittle.  It's frustrating that you have to remember to maintain your custom reports & groups every time you make a change or an addition to your chart of accounts.

    • 2 views
    david.flowers and User16904726688268936503 like this.

End of Feed
1 Chatter Feed Items