Use Account Groups in General Ledger Reports

Account groups enable you to group related accounts on your general ledger reports.

Pre-requisites: On the Chart of Accounts form (Settings > General Ledger > Chart of Accounts), set up account group names and then set up account group tables that list the accounts or ranges of accounts in each account group.

The Account Analysis report and the Trial Balance report do not display data at the summary account group level.

To use account groups in your general ledger report:

1. On the Navigation menu, click My Stuff > Reporting.
2. On the Reports tab, select the General Ledger report.
3. Click the Options tab and do the following:
   • Select an option in the Account Group Table. If you select a summary account group, you are selecting both the summary account group and detail account groups associated with it.
   • If you are generating a Balance Sheet, Income Statement, or Profit Planning Monitor, use Hide Account Number to specify whether or not the account number is displayed. If you hide the account number, Vantagepoint sorts the data by account number but displays the account name in place of the account number.
4. In the Grouping and Sorting section of the Columns and Groups tab:
   • Account Number and Account Type are selected by default.
   • Select the for Account Group to move it up in the list so that the sort order is as follows: Account Type, Account Group, Account Number.
   • Account Type must always be the first sort option.
5. Click Save to save your report.
6. Click Run on the toolbar to generate and view the report with your new sorting and grouping options.