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

By default, Profit and Loss report calculates and summarizes amounts of a certain balance item for a set time period.
However, since there are two dates as of which the report summarizes your company’s financial position, the report displays data in columns, each column containing data as of the set date. For Profit and Loss report, there will be a number of such columns for each specified period – either year, month, day etc. By default, the report uses year in a Date field.
The amounts are worked out by summing the original/primary values (using the SUM function). The summarized amounts are presented in your system currency.
Note: Summary values are displayed at each level of detalization and at the grand total level. If no summary value is available for a certain level, nothing is displayed for it.
The default summarizing settings are defined in the values section of the Profit and Loss 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 Customizing Reports), you can change the summable fields and the summarizing methods for your reports. In case of profit and Loss 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 Summarizing 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.

More Information