Account by period (GL402000)
You can use this window to easily obtain all information about a selected account by financial period. By using the Subaccount field, you can select either one subaccount or a group of subaccounts and view the related transactions.
The window toolbar
| Button | Description |
|---|---|
| Account details | Navigates to the Account by subaccount (GL403000) window. |
| Account by subaccount | Navigates to the Account details (GL404000) window. |
The top part
In this area, you can specify criteria to narrow the information displayed in the table. In the Subaccount field, you can select one particular subaccount or select a group of subaccounts by specifying values for only some of the segments. You also can view the currency details if any currencies other than the base currency were used in the transactions related to the account.
| Element | Description |
|---|---|
| Branch | The branch of the company whose 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 of the accounts you want to review. |
| Financial year | The financial year whose periods you want to view. |
| Account | The account whose balance you want to view through all the financial periods of the selected financial year. |
| Subaccount | A subaccount or a group of subaccounts. If the field is left blank, all the transactions for the selected account in the specified period will be listed. If the values for only some segments are specified, this defines a group of subaccounts with the specified values as well as all the different values in the segments that were left blank. |
| Show currency details | A check box that indicates (if selected) that the additional columns related to the currency will be displayed. |
The table
This table contains the account balances for all the financial periods of the selected financial year. The account balances are calculated for the group of subaccounts specified in the Subaccount field in the top part.
| Column | Description |
|---|---|
| Period | The financial period of the year. |
| Beg. balance | The balance of the account, calculated for the selected subaccounts, at the beginning of the financial period. |
| Debit total | The debit total charged to the account during the specified period. The amount is calculated for the selected subaccounts only. |
| Credit total | The credit total charged to the account during the specified period. The amount is calculated for the selected subaccounts only. |
| Ending balance | The balance of the account, calculated for the selected subaccounts, at the end of the specified period. |
The additional table columns
The following columns also appear if the Show currency details check box is selected.
| Column | Description |
|---|---|
| Currency | The currency of transactions in the account. If it is not specified, the balance is in the base currency. |
| Curr. beg. balance | The account balance in the selected currency at the start of the selected period. |
| Curr. debit total | The debit total in the selected currency for the specified account over the selected period. |
| Curr. credit total | The credit total in the selected currency for the specified account over the selected period. |
| Curr. ending balance | The account balance in the selected currency at the end of the selected period. |
Parent topic: General ledger windows - overview
Related concepts
Related reference