Account statement

<< Prev   Next >>

The Account statement report shows analytical dimension details of the selected account within a certain period. With this report, you can view all relevant account details in one place.

If the Turnovers only checkbox is selected for an analytical dimension in the account settings, the Account statement report shows only debit and credit turnovers for this analytical dimension.

To view the Account statement report:

1. Go to Accounting.
2. Under Reports, click Account statement.
3. Specify the main settings of the report.
4. Click Generate.

The Account statement report is displayed. You can customize it according to your needs. See Report settings.

Report settings

You can customize the Account statement report using any of the following options:

• Edit the main report settings such as the reporting period or target account. See Main settings.
• Group the report information by subaccounts or analytical dimensions. See Grouping.
• Add filters to view only the information relevant to you. For example, view only the account balance by certain supplier or product. See Filters.
• Add more details to the report or change its display settings. For example:
  • Add amounts in transaction currency.
  • Add quantity details.
  • Add the detailed balance.
  • Highlight negative account balances in red.

  See Report details and view.

Main settings

You have the following options to fill in the main settings of the Account statement report:

• Fill in the main settings directly at the top of the report window.
• In the report window, click Settings. Then, fill in the Main tab in the report settings window.

The main settings include the following:

Grouping

Specify the Grouping settings if you want to view the Account statement report by any of the following:

• Subaccounts.
• Analytical dimensions. For example, view the account balance by product.
• Certain time span within the reporting period. For example, view the account balance by week or by day.

To specify the Grouping settings:

1. In the Account statement report, click Settings.
2. Check that an account is selected on the Main tab.
3. In the report settings window, on the Grouping tab, do the following:
   • To view subaccount details, select the By subaccounts checkbox. Then go to step 5.
   • To view analytical dimensions, go to step 4.
   • To view the account balance by certain time span within the reporting period, in the Periodicity field, select the time span. Then go to step 5.
4. To view an analytical dimension in the report, consider the following options:
   • By default, all analytical dimensions of the selected account are prefilled. To exclude any of them from the report, clear the Use checkbox next to the analytical dimension. For the analytical dimensions that you want to view, select the Grouping type.
   • To add an analytical dimension, click Add and select the following:

     Field	Description
     Use	Indicates that the settings of this line will be applied as you generate the report.
     Field	A data field applied as the analytical dimension of the selected account. To select an analytical dimension: Double-click the field and click . In the Select field window, select an analytical dimension. Click Select.
     Grouping type	A method for showing the analytical dimension in the report. Select one of the following: Without groups. Show only the analytical dimension, not the group it belongs to. With groups. Show both the analytical dimension and the group it belongs to. Only groups. Show only the group that the analytical dimension belongs to. For example, an analytical dimension is "Product" while the Products catalog includes two product groups: "Spare parts", "Raw materials". Then, if you select the With groups method, the report will show the account balance by groups "Spare parts", "Raw materials" and by products in these groups.

5. Click Close and generate.

Filters

Add filters to the Account statement report if you want to view only certain information. For example, view only the account balance by certain supplier or product.

The following options are available for you:

• Add simple filter conditions.
• Add filter groups to create complex filtering conditions. For example, use this option if you need to apply filtering conditions that are nested or connected with the OR operator.

Adding simple filter conditions

To add a simple filter condition:

1. In the Account statement report, click Settings.
2. In the report settings window, on the Filters tab, click Add filter.
3. Specify the following:

   Field	Description
   Left value	A filtering parameter. This can be any field of the report.
   Comparison type	The condition for the filtering parameter.
   Right value	The filtering parameter value associated with the specified condition.

4. Click Close and generate.

You can repeat steps 2-3 to add as many filter conditions as you need. 1C:Drive will apply them using the AND operator. This means the report will show only the information matching all the filter conditions at once.

For example, consider the following filter conditions:

These filter conditions mean that the report will show only the information about the account balances related to plastic stored in the main warehouse.

If required, include filter conditions in a group. See Adding filter groups.

To delete a filter condition, select it and click Delete.

Adding filter groups

After you add filter conditions, you can add filter groups.

To add a filter group:

1. In the report settings window, on the Filters tab, do any of the following:
   • To include filter conditions in a group, select them while holding down Ctrl or Shift.
   • To add a nested filter group to a filter group, select the filter group line or select the filter conditions in this group.
2. Click Add filter group and select the filter group type. One of the following:
   • AND group. The report must show data matching all conditions in this group.
   • OR group. The report must show data matching at least one condition in this group.
   • NOT group. The report must show data excluding items matching all conditions in this group.

To add a filter condition to a filter group, select a filter group line, click Add filter, and specify the filter conditions.

To ungroup filter conditions, right-click a filter group line and select Ungroup.

Report details and view

Specify the Report details and view settings if you want to view more details in the Account statement report or change its display settings. For example, you can view amounts in transaction currency, quantity details, detailed balance, or negative account balance highlighted in red.

To specify the Report details and view settings:

1. In the Account statement report, click Settings.
2. In the report settings window, on the Report details and view tab, select any of the following checkboxes depending on your needs:

   Checkbox	Description
   Pesentation currency (PC)	Indicates that the report shows amounts in the presentation currency of the company specified in the main settings of the report.
   Transaction currency (TC)	Indicates that the report shows amounts in the transaction currency. This applies only to the accounts where entries are posted both in the presentation and transaction currency (the Currency checkbox is selected in the account settings).
   Quantity (Qty)	Indicates that the report shows quantity details. For example, you can view the quantity of product items related to the account balance. You can select the checkbox only if the Quantity checkbox is selected in the account settings.
   Report title	Indicates that the report title is shown above report table. The title format is the following: [Report name] for [Account] for [Reporting period if specified]
   Applied filters	Indicates that the report shows the settings and filters that the report is based on. This information appears above the report table.
   Detailed balance	Indicates that the report shows both closing debit and credit balances of the account.
   Highlight negative values	Indicates that negative account balances are highlighted in red.

Note. If might select more than one of the three indicators: Presentation currency (PC), Transaction currency (TC), and Quantity (Qty). Then, the report includes the Indicator column with the selected indicators shown as PC, TC, and Qty.
3. Click Close and generate.

<< Prev   Next >>