Simplified Trial Balance: Default Grouping

Grouping by Rows
 
In the basic Simplified trial balance report data is grouped the same way as in the default Trial balance report. It is by Account.
 
Like in the Trial balance report, the higher-level grouping is enabled for Account grouping by rows. As a result, accounts are organized in accordance with the format of your charts of accounts: by major account categories, subcategories and groups.
 
For more details about higher-level grouping option, see Group Report Data.
 
As a result, a multi-level hierarchy is formed with links between levels being of the parent-child type. Levels of the report hierarchy according to the structure of your chart of accounts:
 
1. Major account categories
 
2. Account Subcategories
 
3. Account groups
 
4. Active accounts
 
Active accounts are displayed at the lowest level of the basic Simplified trial balance report.
 
To see sublevel details in the generated report, you have to drill down to lower levels.   
 
The default grouping settings are defined in the rows section of the basic Simplified trial balance report. To define the groupings, the field Account has been added by which data in the report has to be grouped by rows. However, you can change the pre-defined settings and choose how to group data by yourself.    
 
To do that
 
1. On the page for configuring report parameters, click the Customize button.
 
2. In the rows section, view and customize the default groupings as follows:
 
  • To add fields for grouping, click the Select an option box, and then select a field by which you want to group data from the list of options.
 
The list displays fields from the selected report type which you can use to group data y rows.
 
  • To remove fields, click the cross icon next to the field you wish to remove.
 
Fields for Grouping
 

Field

Used for grouping by

Account

Accounts having either non-zero balances or non-zero turnovers within the period covered by the report.

Currency

Currencies of balances or turnovers in each account.

 
Grouping by Columns
 
Initially, no default grouping by columns is specified for the basic Simplified trial balance report. However, you can define your own groupings, if necessary.
 
To do that, you use the columns section of the report, where you can choose how to group data by yourself as in case of the groupings by rows. You do that as follows:
 
1. On the page for configuring report parameters, click the Customize button.
 
2. Use the columns section to view and customize the default groupings.
 
As with groupings by rows, in the columns section, you add fields by which you want to group data. The set of fields available for grouping data by columns is the same as for grouping data by rows.
 
 
More information
Chart of Accounts Structure