Trial balance

<< Prev   Next >>

The Trial balance report shows the balances and turnovers of accounts within a certain period. This report can help you monitor account balances.

To view the Trial balance report:

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

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

Report settings

You can customize the Trial balance report using any of the following options:

• Edit the main report settings such as the reporting period or chart of accounts. 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 accounts with a certain closing balance. See Filters.
• Add currency details or change the report display settings. For example, add amounts in transaction currency or highlight negative account balances in red. See Report details and view.
• Choose to view the detailed account balance. See Detailed balance.

Main settings

You have the following options to fill in the Main settings of the Trial balance 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:

Field	Description
Period	The reporting period. The report will include the data related to this period.
Company	The company that the report is related to. To view the report on all companies, keep the field blank. To view the report on certain companies, click . Then select companies in the Company window To apply the Company setting, select the checkbox next to this field.
Type of accounting	The type of accounting the report is based on.
Chart of accounts	The chart of accounts the report is based on.

Grouping

Specify the Grouping settings if you want to view the Trial balance report by subaccounts or analytical dimensions of the accounts.

To specify the Grouping settings:

1. In the Trial balance report, click Settings.
2. In the report settings window, on the Grouping tab, do either of the following:
   • To view subaccount details for all accounts, select the By subaccounts checkbox. Then go to step 4.
   • To view subaccount details or analytical dimensions only for certain 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	An 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 account. This checkbox is selected by default if Accounting is set to Use template based types of accounting in Settings > Company. It is cleared by default otherwise.
   Analytical dimensions	The analytical dimensions that you want to view for the selected account. The field is prefilled with all analytical dimensions of the selected 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. The following rules apply: If the By subaccounts checkbox is selected for an account, the report shows the account as a group. The selected analytical dimensions are shown in this group. If the By subaccounts checkbox is cleared for an account, the report does not show the account. The selected analytical dimensions are shown in the parent account group. For example, clear the By subaccounts checkbox for account "150.3" whose parent account is "150". Then the report will show the analytical dimensions in the "150" group.

4. Click Close and generate.

Filters

Add filters to the Trial balance report if you want to view only certain information. For example, view only the accounts with a certain closing balance.

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 Trial balance 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 all accounts where entries related to laptops are recorded, except account 150.09.

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

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

Note. If you add both simple filter conditions and filter groups, 1C:Drive will apply both of them using the AND operator.

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, select filter conditions while holding down Ctrl or Shift.
2. Click Add filter group and select a 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 nested filter group to a filter group, select the filter group line or select the filter conditions in this filter group. Then click Add filter group and select a filter group type.

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 add currency details to the Trial balance report or change the report display settings.

To specify the Report details and view settings:

1. In the Trial balance 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
   Presentation 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). After you select the checkbox, the report will show the Indicator column where: PC is the amount in the company's presentation currency. TC is the amount in the transaction currency.
   Report title	Indicates that the report title is shown above report table. The title format is the following: [Report name] for [Reporting period]
   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 description of each account.
   Highlight negative values	Indicates that negative values are highlighted in red.

3. Click Close and generate.

Detailed balance

Set up the detailed balance for the Trial balance report if you want to view both closing debit and credit balances of the accounts whose normal balance type is Active/Passive.

You can customize the report for the following:

• View the detailed balance by accounts.
• View the detailed balance by subaccounts.
• View the detailed balance by subaccounts and analytical dimensions.

Viewing detailed balance by accounts

To view the detailed balance by accounts:

1. In the Trial balance report, click Settings.
2. In the report settings window, on the Detailed balance tab, add the accounts for which you want to view the detailed balance.
3. Select the Use checkbox for the added accounts.
4. Click Close and generate.

Viewing detailed balance by subaccounts

To view the detailed balance by subaccounts:

1. In the Trial balance report, click Settings.
2. In the report settings window, on the Grouping tab, above the accounts table, select the By subaccounts checkbox.
3. On the Detailed balance tab, add the accounts for which you want to view the detailed balance.
4. Select the By subaccounts and Use checkboxes for the added accounts.
5. Click Close and generate.

Viewing detailed balance by subaccounts and analytical dimensions

To view the detailed balance by subaccounts and analytical dimensions:

1. In the Trial balance report, click Settings.
2. In the report settings window, on the Grouping tab, add the accounts for which you want to view the detailed balance.
3. To view the detailed balance by subaccounts, select the By subaccounts checkbox for the accounts.
4. To view the detailed balance by analytical dimensions of the accounts, select the analytical dimensions for the accounts.
5. Select the Use checkbox for the accounts.
6. Open the Detailed balance tab, specify the same account settings as on the Grouping tab.
7. Click Close and generate.

For details on how to add accounts and specify analytical dimensions, see step 3 in the Grouping section.

<< Prev   Next >>