Account summary (GL401000)
By using this window, you obtain summary information about all accounts of a specific class for the selected financial period. You can easily drill down to every document detail.
The window toolbar
| Button | Description |
|---|---|
| Go to previous record | Changes to the last selected record. If the From period and To period fields are not the same period, this button will change both to and from periods one period back. |
| Go to next record | Changes to the next selected record. If the From period and To period fields are not the same period, this button will change both to and from periods one period forward. |
| Account details | Navigates to the Account details (GL404000) window. |
| Account by subaccount | Navigates to the Account by subaccount (GL403000) window. |
| Account by period | Navigates to the Account by period (GL402000) window. |
The top part
By using the elements in this part, you can narrow the accounts for which summaries are displayed. Also, you can specify a subaccount, or select a group of subaccounts by specifying a mask in the Subaccount field.
| Field | Description |
|---|---|
| Company: | The company for which data you want to view. To be able to view the account summary by branches, leave this field empty. |
| Branch | The branch of the company for which data you want to view. You can select a required branch, or clear this field. If the field is left empty, information on all branches is shown. This field is available only if the Multi-branch support functionality is enabled in your system in the Enable/disable functionalities (CS100000) window. |
| Ledger | The ledger for the accounts you want to review. |
| From period | The start period for which you want to display summaries and the period for the beginning balance. |
| To period | The end period for which you want to display the summaries and the period for the ending balance. |
| Account class | Optional. The account class for which you want to display summaries. For the selected class, all the account activities matching the selected subaccount or subaccount group will be displayed in the table. If this element is left blank, accounts of all classes will be displayed. The available account classes are defined in the Account classes (GL202000) window. |
| Subaccount | A subaccount or a mask for a group of subaccounts. If the field is left blank, all the transactions for the selected account or accounts in the specified period will be listed. If values only for some segments are specified, this defines a group of subaccounts with the specified segment values and various values in any segments that you left blank. |
| Show currency details | A check box that indicates (if selected) that the additional columns related to the currency used in accounts will be displayed. Note! Only accounts defined as currency accounts will have a value in the currency columns. |
| Show only accounts with activity | Selecting this check box will display a list of accounts with only a debit or credit transaction in the specified period. Accounts with only Beginning balance / Ending balance but with no debit or credit values will be excluded from the list. |
| Group by public code 1 | A check box that will group the lines by the defined Public code 1 on the Chart of accounts. If some accounts are missing a value, they will be summarized on an empty line. |
| Group by branches | A check box that (if selected) will display the summary grouped by branches. |
The table
This table lists the summary balances for general ledger accounts and subaccounts that meet the criteria you entered in the top part.
| Column | Description |
|---|---|
| Branch | The branch of the company. |
| Account | The specific account. |
| Type | The type of the account, which is one of the following values: Expense, Asset, Income, or Liability. |
| Description | The user-defined description of the account. |
| Beg. balance | The balance of the account at the beginning of the selected From period. |
| Debit total | The total of debits posted to the account during the selected financial periods. |
| Credit total | The total of credits posted to the account during the selected financial periods. |
| Ending balance | The balance of the account at the end of the selected To period. |
| Consolidation account | The consolidation account of the parent company for this account. |
| Account class | The account class of this account. |
| Last activity | The period of the most recent transaction posted to the account. After you close the last period of a financial year, the column shows the first period of the next financial year by default (even if there is no transaction posted to this account in this period yet). |
The additional table columns
The following columns also appear if the Show currency details or the Group by public code 1 check box is selected.
| Column | Description |
|---|---|
| Currency ID | The currency of transactions in the account. If it is not specified, the balance is in the base currency. |
| Beg. balance (currency) | The account balance in the selected currency at the start of the selected period. |
| Debit total (currency) | The debit total in the selected currency for the specified account over the selected period. |
| Credit total (currency) | The credit total in the selected currency for the specified account over the selected period. |
| Ending balance (currency) | The account balance in the selected currency at the end of the selected period. |
| Public code description | This field contains the description of the Public code. This column will only appear if the check box Group by public code 1 is selected. |
Parent topic: