Balance Sheet: Default Grouping

Grouping by Rows
 
The basic Balance sheet report groups data by Balance item.  
 
Balance items are major components of the balance sheet determining how and in what categories, subcategories and groups accounts are organized.
 
The exact set of balance sheet items depends on the selected type of accounting framework.
 
By default, higher-level grouping is enabled for Balance item to organize assets, liabilities and shareholders’ equity by major categories, subcategories and groups instead of just presenting balance sheet accounts in the form of a list.
 
For more details about higher-level grouping option, see Group Report Data.
Note: It is highly advisable to always activate higher-level grouping for Balance item grouping to ensure the properly structured presentation of accounts in the report.
As a result, a multi-level hierarchy is formed with links between levels being of the parent-child type. Levels of the report hierarchy:
 
1. Selected balance type
 
2. Balance sheet items 
 
3. Account categories
 
4. Account Subcategories
 
5. Account groups
 
Specific active accounts are not displayed in the 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 Balance sheet report. To define the grouping, the field 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

Balance item

Balance items are major components of the balance sheet organizing accounts into categories, subcategories and groups.

The exact set of balance sheet items depends on the selected type of accounting framework.  

Financial data is grouped according to balance sheet items distinguished by the selected balance type.

Balance items are major components of the balance sheet determining how and in what categories, subcategories and groups accounts are organized.

The exact set of balance sheet items depends on...

  • It is highly recommended to enable a higher-level grouping for Balance item. Otherwise, only account groups containing active accounts will be displayed instead of the complete hierarchical structure of the balance sheet.

Account

Accounts having ending balance as of the dates indicated in the report.

According to the structure organized by the balance sheet items, active accounts having ending balance are displayed in the report being listed under relevant categories, subcategories and groups.

 
Grouping by Columns
 
In the basic Balance sheet report, no default grouping by columns is specified. However, you can define your own groupings, if required.
 
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
Balance Type
Balance Item
Chart of Accounts Structure