Simplified Trial Balance: Default Summarizing

By default, the Simplified trial balance report displays and summarizes the following:
 
  • Opening balance, if any
  • Credit turnover
  • Debit turnover
  • Closing/ending balance
 
Totals are computed by summing the original values (using the SUM function). The summarized amounts are presented in your system currency.
 
Debit and credit balances are not shown separately in different debit and credit columns, as it is the case with the Trial balance report, but are listed as positive or negative amounts in one column. So, opening debit and credit balances are both summarized and displayed in the column Opening balance, debit balances being presented as positive amounts and credit balances as negative amounts. The same rule is applicable to closing/ending debit and credit balances.
 
The default summarizing settings are defined in the values section of the Simplified trial balance report. To define the summarizing methods, the summable fields have been added and summarizing options have been specified for them.  Except for specific reports that do not provide for full customization (see Customize Reports), you can change the summable fields and the summarizing methods for your reports. In case of the Simplified trial balance report, you are allowed to do that.
 
To customize the default summarizing parameters
 
1. On the page for configuring report parameters, click the Customize button.
 
2. Use the values section to view and customize the default summable fields and summarizing methods defined for them.
 
You can delete, rearrange, add new summable fields and specify summarizing methods for them.
 
For information how to customize summarizing settings, see Summarize Report Data.
 
To add a summable field:
 
  • In the values section, click the Select an option box, and then select a summable field from the list of options.
 
The list displays summable fields from the selected report type which you can use to summarize report data in columns. For Customer balance report, there is a number of fields you can use:


Field

Used for summarizing and displaying

Opening balance

Displays balances in each account as of a period start date.  

Both credit and debit balances are summarized in this column. Debit balances are presented as positive amounts and credit balances as a negative amount.

The summarized total value is calculated as follows:

Opening balance = Debit opening balance + Credit opening balance x - 1

Turnovers Dt

Displays debit transactions in active accounts during a given period.

Turnovers Ct

Displays credit transactions in active accounts during a given period.

Closing balance

Displays balances in each account as of a period end date.  

Both credit and debit balances are summarized in this column. Debit balances are presented as positive amounts and credit balances as a negative amount.

The summarized total value is calculated as follows:

Opening balance = Debit opening balance + Credit opening balance x - 1

 
The SUM function is selected as a default summarizing method for all fields. 
 
In case it is necessary to change the summarizing method, you do that as follows:
 
  • Click the calculation option box to the right of the field, and then select one of the available summarizing options from the list.
 
For summarizing options, see Summarizing Methods.