General ledger

<< Prev   Next >>

The General ledger report shows balances of all accounts and accounting entries made in those accounts within a certain period.

To view the General ledger report:

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

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

Report settings

You can customize the General leger report using any of the following options:

• Edit the main report settings such as the reporting period. See Main settings.
• Add filters to view only the information relevant to you. For example, view information only about certain accounts. See Filters.
• Add more details to the report or change its display settings. For example:
  • Add the report title.
  • Add the details about the applied filters.
  • 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 General ledger 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 in the field and select checkboxes for the required companies in the drop-down list. If the required company is not shown in this list, then: Click Show all. In the displayed window, click Pickup. A list of all companies is displayed. Select a company line and click Select. To select multiple lines, hold down Shift or Ctrl. Close the window. The list of selected companies is displayed. Click OK. . To apply the Company setting, select the checkbox next to this field.
Chart of accounts	The chart of accounts the report is based on.
Type of accounting	The type of accounting the report is based on.
Show opening balance	Indicates whether a line with opening balance is shown for each account in the report. Select the checkbox if you want to view opening balances of accounts.

Filters

Add filters to the General ledger report if you want to view only certain information. For example, view information only about certain accounts.

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.
• Include accounts without entries

Adding simple filter conditions

To add a simple filter condition:

1. In the General ledger 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.
   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. 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 information about all accounts except account "100 Cash". The information will include accounting entries made only for company "Space electronics"

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

To delete a filter condition, select or right-click 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.

Including accounts without entries

By default, the General ledger report shows only accounts that have accounting entries. If you want to view all accounts including the ones that have no accounting entries, do the following:

1. In the General ledger report, click Settings.
2. In the report settings window, on the Filters tab, select the Show accounts with no data checkbox.
3. Click Close and generate.

Report details and view

Specify the Report details and view settings if you want to view more details in the General ledger report or change its display settings. For example, you can view applied filters or negative account balances highlighted in red.

To specify the Report details and view settings:

1. In the General ledger 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
   Report title	Indicates that the report title is shown above report tables. The title format is the following: [Report name] [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 tables.
   Highlight negative values	Indicates that negative account balances are highlighted in red.

3. Click Close and generate.

<< Prev   Next >>