Profit and Loss Report: Default Grouping/ Customizing Default Grouping Methods

Grouping by Rows
 
The basic Profit and Loss report groups data by Balance item.
 
Balance items are major components of the Profit and Loss determining how and in what categories, subcategories and groups accounts are organized.
 
The exact set of Profit and Loss items depends on the selected type of accounting framework.
 
By default, higher-level grouping is enabled for Balance item to organize profits and losses by major categories, subcategories and groups instead of just presenting Profit and Loss accounts in the form of a list.
 
For more details about higher-level grouping option, see Grouping 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. Profit and Loss 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.

For more details on grouping data in reports, see Grouping Report Data.

The default grouping settings are defined in the rows section of the basic Profit and Loss 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 Profit and Loss organizing accounts into categories, subcategories and groups.

The exact set of Profit and Loss items depends on the selected type of accounting framework.

Account

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

According to the structure organized by the Profit and Loss 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 Profit and Loss report, default grouping by columns is specified as a Date. Date might include year, month, day, hour and minutes. In case of necessity you may customize the column.
 
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