Account Summary

Form ID: (GL401000)

On this form, you can obtain summary information about all accounts for the selected financial period and any other criteria you specify.

Form Toolbar

The form toolbar includes standard and form-specific buttons and commands. For the list of standard buttons, see Form Toolbar and More Menu. The form-specific commands are listed in the following table.

Button Description
Account Details Navigates to the Account Details (GL404000) form, on which you can view all activities during the selected financial period in the selected account. You click the table row of the account for which you want to view information, and then you click this button. By default, the first row of the table is selected.
Account by Subaccount

Navigates to the Account by Subaccount (GL403000) form, on which you can view all activities by subaccount during the selected financial period in the account of the selected table row. You click the row of the account for which you want to view information, and then you click this button. By default, the first row of the table is selected.

This button appears on the form only if the Subaccounts feature is enabled on the Enable/Disable Features (CS100000) form.

Account by Period Navigates to the Account by Period (GL402000) form, on which you can view all activities by financial period in the account of the selected row in the table of the current form. You click the row of the account for which you want to view information, and then you click this button. (By default, the first row of the table is selected.)

Selection Area

In this area, you can specify criteria to narrow the accounts for which summaries are displayed.

Button Description
Company/Branch

The company or branch for which you want to view information. By default, the current company or branch is selected.

Ledger Required. The ledger for the accounts you want to review.
Period Required. The financial period for which you want to display summaries.
Account Class The account class for which you want to display summaries. For the selected class, all the account activities will be displayed in the table. If this element is left blank, accounts of all classes will be displayed.
Subaccount

The subaccount or the group of subaccounts whose data you want to view. To view data for a group of subaccounts, specify the values for only some segments; this defines the group of subaccounts with the specified values (and with different values in the segments that were left blank). To view data for the selected account (with all subaccounts) in the specified period, leave the box blank.

This box appears on the form only if the Subaccounts feature is enabled on the Enable/Disable Features form.

Show Currency Details

A check box that indicates (if selected) that the columns showing the currency details of the transactions will also be displayed. If the check box is cleared, all transactions are shown in the base currency.

This check box appears on the form only if the Multicurrency Accounting feature is enabled on the Enable/Disable Features form.

Use Master Calendar

A check box that indicates (if selected) that the data in the table will be consolidated by the master calendar. That is, the table will show the transactions posted for the master calendar. If the check box is cleared, the table will show the transactions consolidated by the company calendar. If the Company box is blank, this check box is selected by default.

This check box appears on the form only if the Multiple Calendar Support feature is enabled on the Enable/Disable Features form.

For details on running consolidated reports and inquiries, see Consolidated Reports for Companies with Different Calendars.

Table

This table lists the summary balances for General Ledger accounts and subaccounts that meet the criteria you entered in the Selection area.

Table 1. Table Columns
Column Description
Branch

The branch of the company.

This column appears on the form only if the Multibranch Support feature is enabled in your system on the Enable/Disable Features (CS100000) form.

Account The specific account.
Type The type of the account, which is Expense, Asset, Income, or Liability.
Description A user-defined description of the account.
Beg. Balance The balance of the account, calculated for the selected subaccount or subaccounts (if applicable), 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 subaccount or subaccounts (if applicable) only.
Credit Total The credit total charged to the account during the specified period. The amount is calculated for the selected subaccount or subaccounts (if applicable) only.
Ending Balance The balance of the account, calculated for the selected subaccount or subaccounts (if applicable), at the end of the specified 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).
Table 2. Additional Table Columns The following columns also appear after the columns listed above if the Show Currency Details check box is selected.
ColumnDescription
Currency IDThe currency of denomination used for the account.
Curr. Beg. BalanceThe account balance in the currency of denomination at the start of the selected financial period.
Curr. Debit TotalThe debit total in the currency of denomination for the specified account over the selected financial period.
Curr. Credit TotalThe credit total in the currency of denomination for the specified account over the selected financial period.
Curr. Ending BalanceThe account balance in the currency of denomination at the end of the selected financial period.