The Trial Balance View (25.15.2.9) lets you view balance details for combinations of analytical elements that meet the selection criteria. You can use the view to ensure that the total of the debit balances equals the total of the credit balances for the selected GL periods.

As shown in Filtering, the Trial Balance View contains some additional filtering options relative to GL Transactions View Extended.

The Opening Balance BC column can have two values, depending on the GL account. If the GL account is a Balance Sheet account, the Opening Balance BC column contains the Life To Date (LTD) balance. The LTD balance is the sum of all transactions for all years and months prior to the selected GL period.

If the GL account is a P&L account (also called an Income Statement account), the Opening Balance BC column contains the Year To Date (YTD) balance. The YTD balance is the sum of all transactions in the selected year for the months prior to the selected GL period. For example, if the selected GL period is 2014/11, the YTD balance includes all transactions from January 2014 until the end of October 2014.

If the selection criteria includes the last GL period of the previous year and contains all accounts, and if the year-end closing is not finalized, the view displays the Result of Previous Year value.

The Period Debit BC and Period Credit BC columns contain the sum of all transactions in the selected period. In addition, the Balance BC column contains the closing balance at the end of the selected period. This value is calculated as:

Trial Balance View Filters and Columns lists the columns and filters in the Trial Balance View.

Right-Click Options shows the related views that are available as right-click options from the Trial Balance View.

The Trial Balance View contains many of the same right-click options as the GL Transactions View Extended. See GL Transactions View Extended Right-Click Options for information on these options. The following option is unique to the Trial Balance View:

The Trial Balance View contains a number of summarization filters, such as Summarize Sub-Account, Summarize Cost Center, Summarize Project, Summarize SAFs, and Summarize Daybook.

The summarization filters determine the level of analytical information that the search results display. The results are summarized to exclude the level of analytical detail that you have selected to summarize on. Using the example in Summarize Filters, if you select Summarize Sub-Account, the detail lines display data for entities, GL accounts, and cost centers only.

A company has two cost centers (CC1 and CC2) and three projects (Prj1, Prj2, and Prj3). At the end of last month, the following cost data is returned:

To view the cost-control performance of each cost center, and to ignore project information, select Summarize Projects. The results are as follows:

Similarly, you can see the performance by project by choosing Summarize Cost Centers. The results are as follows:

If you want to see the total performance on cost control, select Summarize Cost Centers and Summarize Projects. The results are as follows:

When filtering on SAF codes, all positions of a SAF structure (GL SAF, cost center SAF, and project SAF) are searched. The system searches using the SAF codes provided, and their corresponding SAF concepts; for example, SAF 1 and SAF Concept 1.