Viewing Trial Balances

This section provides an overview of the Trial Balance component and discusses how to:

Select trial balance criteria.
View a trial balance.
Set options for how to display account balances.
Specify the accounts to include in the trial balance.
Include additional dimensions.
View ledger balance details for an account.

Pages Used to View Trial Balances

Page Name	Definition Name	Navigation	Usage
Trial Balance Inquiry	GC_TB_INQ_SEL	select Global Consolidations, then select Consolidation Analysis, then select Consolidation Inquiries, then select Trial Balance	Select criteria for the Trial Balance Inquiry pages.
Trial Balance	GC_TRIAL_BAL	Click Go on the Trial Balance Inquiry page. Click the Trial Balance link from various pages.	Access the Trial Balance selection page to enter parameters for viewing a trial balance of the consolidation ledger.
Balance Options	GC_TRIAL_OPT_SEL	Click the Options link on the Trial Balance page.	Specify whether to view separate columns for debit and credit amounts, and whether amounts include activity for only the specific period or are cumulative to date.
Account Selection	GC_TRIAL_ACCT_SEL	Click the Account link on the Trial Balance page.	Specify which accounts to include in the trial balance.
Select Dimension	GC_SEL_DIMENSION	Click the Dimension link on the Trial Balance page.	Select which information appears when you view balance amount details.
Ledger Balance for Selected Account	GC_TRIAL_BAL2	Click the Ledger Balance by Account link on the Trial Balance page or the Proforma Trial Balance page.	View the ledger balance for a specific account grouped by selected dimensions.

Understanding the Trial Balance Component

The Trial Balance component enables you to view ledger balances and determine whether you need to make further adjustments. Use the pages in the Trial Balance component to:

See both a summarized and detailed view of the data.
Select which accounts to include.
View ledger amounts summarized by another dimension.
View activity for the specified period only, or view cumulative activity from the beginning of the fiscal year through the specified period, or view a mix of cumulative and period activity, based on account type.
Specify whether to combine debit and credit balances in a single column, or view them in separate columns.
View ledger balances by account.
View ledger balances by book code.

Selecting Trial Balance Criteria

Use the Trial Balance Inquiry page (GC_TB_INQ_SEL) to select criteria for the Trial Balance Inquiry pages.

Navigation

select Global Consolidations, then select Consolidation Analysis, then select Consolidation Inquiries, then select Trial Balance

Image: Trial Balance Inquiry page

This example illustrates the fields and controls on the Trial Balance Inquiry page. You can find definitions for the fields and controls later on this page.

This page functions like the Ledger Inquiry page, except that you are working with trial balance ledger balances. Complete the following fields, and click Go to view the results.

Preference

Displays the selected preference. If you want to use previously saved selection criteria, select Get Preference and select the preference. If you want to save the selection criteria that you enter on this page, select Save Preference.

Business Unit, Scenario, Fiscal Year, Period

Specify the common consolidation business unit on which to inquire and the associated scenario, fiscal year, and accounting period.

Amount Type

Select how to summarize amounts for ledger balances. Options are:

End of Period / Period Activity:Select to view end of period balances for balance sheet accounts, and period activity for income statement accounts.

End of Period / Year to Date:Select to view end of period balances for balance sheet accounts, and YTD activity for income statement accounts.

Period Activity: Select to view period activity for all accounts. This option is available only for trial balance format ledgers.

Drill Type

The Drill Type field determines which tree level information appears in the grid. Select from these options:

Get All Lowest Level Nodes Displays the information for the children (direct or indirect) at the lowest level of the tree for the selected node.

Get Next Level Nodes Displays the information for the direct children of the selected node within the grid. When you select this option, you must navigate through the tree nodes to eventually view the lowest level details.

Tree Node

Select a node from the consolidation tree by which you want to further filter trial balance results.

Book Code Group

Select the book code group by which you want to further filter the inquiry report data. This is an optional field and is only available if you turn on book code functionality on the General Options page and you create book code values with the Book Codes and Book Code Group pages. Book code is an additional dimension on which you can report. If book code functionality is available, you can select this option and the Ledger Inquiry report displays separate amounts by book code when drilling down from inquiries on the consolidation audit.

Viewing Results

Click Go to view the Trial Balance page.

Trial Balance Page

Use the Trial Balance page (GC_TRIAL_BAL) to access the Trial Balance selection page to enter parameters for viewing a trial balance of the consolidation ledger.

Navigation

Click Go on the Trial Balance Inquiry page.
Click the Trial Balance link from various pages.

Image: Trial Balance page

This example illustrates the fields and controls on the Trial Balance page. You can find definitions for the fields and controls later on this page.

Informational Fields

These fields display information about the trial balance data that you are viewing:

Business Unit

The common consolidation business unit.

Amount Type

How amounts are summarized for ledger balances.Values are:

End of Period / Period Activity:Amounts displayed as end of period balances for balance sheet accounts, and period activity for income statement accounts.

End of Period / Year to Date:Amounts displayed as end of period balances for balance sheet accounts, and YTD activity for income statement accounts.

Period Activity: Amounts displayed as period activity for all accounts. This option applies to only trial balance format ledgers.

Fiscal Year

The fiscal year being viewed.

Period

The accounting period being viewed.

Scenario

The scenario being viewed.

Currency Code

The base currency of the consolidation model.

Primary Book Code Balance

Shows the primary book code balance.

Secondary Book Code Balance

Lists the secondary book code balance.

Book Code Group

Lists the Book Code Group

Total Balance or Balance DR, Balance CR

The total proforma balance for the accounts.

Account Balances

The trial balance lists the accounts and descriptions and the ledger balance amount for the selected tree node. If you've set the options to display separate debit (DR) and credit (CR) amounts, the ledger balance column headings are Ledger Balance DR and Ledger Balance CR.

If you specify a book code group, the trial balance grid lists the primary book code balances and secondary book code balances. The column headings are defined by the primary description and secondary description fields on the book code group definition.

Expand or collapse tree nodes, as needed, and click a node to view the balances for that node.

Links to Other Pages

Options

Click to access the Trial Balance Options page, where you can specify how to display the amounts within the Trial Balance grid.

Accounts

Click to access the Account Selection page, where you can specify which accounts to include.

Dimensions

Click to access the Dimension Selection page, where you can indicate what dimensions to view when you navigate to details.

Ledger Balance

Click a ledger balance amount within the grid to access the Ledger Balance for Selected Account page, where you can view the ledger balance details by dimension.

Book Code Group

If you specify a book code group, you can click the name of the book code group definition to view that book code group definition on the setup page.

Balance Options Page

Use the Balance Options page (GC_TRIAL_OPT_SEL) to specify whether to view separate columns for debit and credit amounts, and whether amounts include activity for only the specific period or are cumulative to date.

Navigation

Click the Options link on the Trial Balance page.

Image: Balance Options page

This example illustrates the fields and controls on the Balance Options page. You can find definitions for the fields and controls later on this page.

Amount Type

Select how to summarize amounts for ledger balances. Options are:

End of Period / Period Activity:Select to view end of period balances for balance sheet accounts, and period activity for income statement accounts.

End of Period / Year to Date:Select to view end of period balances for balance sheet accounts, and YTD activity for income statement accounts.

Period Activity: Select to view period activity for all accounts. This option is available only for trial balance format ledgers.

Account Selection Page

Use the Account Selection page (GC_TRIAL_ACCT_SEL) to specify which accounts to include in the trial balance.

Navigation

Click the Account link on the Trial Balance page.

Image: Account Selection page

This example illustrates the fields and controls on the Account Selection page. You can find definitions for the fields and controls later on this page.

You can view a trial balance for all accounts, or for a subset of accounts.

All Accounts

Select to include all accounts. Specify the tree name of the consolidation ledger account tree.

To view a subset of accounts, select an account selection type to define which accounts to include, and enter the account criteria, which depends on the account selection type. Use one of these options:

Select by Tree Nodes

Select to specify the accounts that use a tree, and then specify the tree name.

In the Account Criteria grid, add rows as needed and specify the tree node to use. You can also navigate through the tree viewer to select the node that contains the group of accounts; the system inserts the node into the Account Criteria grid when you click it.

Select by Account Ranges

Select to specify one or more ranges of accounts to include.

In the Account Criteria grid, add rows as needed, and complete the Range From and Range Through fields to define the account range for each row.

Select by Account Types

Select to specify one or more types of accounts to include.

In the Account Criteria grid, add rows as needed and select an account type.

Select by Account Values

Select to specify a list of one or more accounts to include. In the Account Criteria grid, add rows as needed and select the account.

Select Dimension Page

Use the Select Dimension page (GC_SEL_DIMENSION) to select which information appears when you view balance amount details.

Navigation

Click the Dimension link on the Trial Balance page.

Image: Select Dimension page

This example illustrates the fields and controls on the Select Dimension page. You can find definitions for the fields and controls later on this page.

Select

Select this check box to view the dimension values.

Show Description

Select to view the dimension descriptions.

This option is especially useful for dimensions that contain numeric values, such as the source process dimension.

Ledger Balance for Selected Account Page

Use the Ledger Balance for Selected Account page (GC_TRIAL_BAL2) to view the ledger balance for a specific account grouped by selected dimensions.

Navigation

Click the Ledger Balance by Account link on the Trial Balance page or the Proforma Trial Balance page.

Image: Ledger Balance for Selected Account page

This example illustrates the fields and controls on the Ledger Balance for Selected Account page. You can find definitions for the fields and controls later on this page.

The total balance listed is for this specific consolidation ledger account. The details show the balance broken down by the dimensions specified on the Selected Dimension page. Click a specific ledger balance amount to view the Consolidation Audit page for that balance and navigate to the source stage data.