Codejig Reference

Bank Account Balances Report: Default Grouping

Grouping by Rows

By default, the Banking report groups data only by bank accounts.

The default grouping by bank accounts is defined in the rows section of the basic Bank account balances report. To set it up, 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:

On the page for configuring report parameters, click the Customize button.
In the rows section, view and customize the default grouping 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 by rows.

To remove fields, click the cross icon next to the field you wish to remove.

You can use the following fields from the selected report type to group report data by rows:

Field	Used for grouping by
Bank account	User-defined bank accounts set up with the bank account directory.
Account	Input and output bookkeeping accounts specified for relevant bank accounts.
Type of payment	User-defined types of payments set up with the type of payment directory.
Currency	System currency set up with the currency directory.

Grouping by Columns

In the basic Bank account balances report, by default grouping by columns is made for currencies. 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:

On the page for configuring report parameters, click the Customize button.
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.

Note: The report makes use of user-defined currency exchange rates set up with the Currency exchange rate directory.

More information

Generate Bank Account Balance Report

Bank Account Balances Report: Default Summarizing