Account analysis

<< Prev   Next >>

The Account analysis report shows the turnover of an account and its corresponding accounts. With this report, you can analyze the following:

• From which corresponding account an amount was moved to the account.
• To which corresponding account an amount was moved from the account.

To view the Account analysis report:

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

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

Report settings

You can customize the Account analysis 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 of an account. See Grouping.
• Group the report information by subaccounts or analytical dimensions of the corresponding accounts. See Grouping for corresponding accounts.
• Add filters to view only the information relevant to you. For example, view only the account details related to a certain 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 analysis 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 analysis report by any of the following:

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

To specify the Grouping settings:

1. In the Account analysis 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 details 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 details by groups "Spare parts", "Raw materials" and by products in these groups.

5. Click Close and generate.

Grouping for corresponding accounts

Specify the Grouping for corresponding accounts settings if you want to view the Account analysis report by subaccounts or analytical dimensions of the corresponding accounts.

To specify the Grouping for corresponding accounts settings:

1. In the Account report, click Settings.
2. In the report settings window, on the Grouping for corresponding accounts tab, do either of the following:
   • To view subaccount details for all corresponding accounts, select the By subaccounts checkbox. Then go to step 4.
   • To view subaccount details or analytical dimensions only for certain corresponding accounts, go to step 3.
3. Click Add and enter or select the following:

   Field	Description
   Use	Indicates that the settings of this line will be applied as you generate the report.
   Account	A corresponding account for which you want to view subaccount details or analytical dimensions. The account list includes only the accounts that belong to the chart of accounts specified in the main settings of the report.
   By subaccounts	Indicates that subaccount details are shown for the selected corresponding account.
   Analytical dimensions	The analytical dimensions that you want to view for the selected corresponding account. The field is prefilled with all analitycal dimensions of the selected corresponding account. You can edit the field. To do this: Double-click the field and click . In the Select analytical dimensions window, select the checkboxes of the analytical dimensions that you want to view. Click Select.

4. 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 details related to a certain 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 analysis report, click Settings.
2. In the report settings window, on the Filters tab, click Add filter.
3. Specify the following:

   Field	Description
   Field	A filtering parameter. This can be any field of the report.
   Comparison type	The condition for the filtering parameter.
   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 details related to the laptops 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 analysis 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 analysis 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]
   Applied filters	Indicates that the report shows the settings and filters that the report is based on. This information appears above the report table.
   Account description	Indicates that the report shows the account description.
   Detailed balance	Indicates that the report shows both closing debit and credit balances of the account. You can select the checkbox only if the "Active/Passive" normal balance is selected in the account settings.
   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 >>