Creating reusable settings for account analysis

Account Analysis Settings

Provide the name and description of the account analysis settings.

Reporting Basis

Select the reporting basis to determine the chart and structure to use for the account analysis.

Scenario

Select the scenario for the account analysis, for example, actuals, encumbrances, commitments, or budget. If you select a budget scenario, then the Analyze Budget button is available when the account analysis is saved.

Account

Select the chart account level for the account analysis. When you select a summary level account, the account and any child accounts are displayed. If this field is blank, then the top level of the structure that is assigned to the selected reporting basis is used.

System

Select a system to return records for a single system. If this field is blank, then all system codes are displayed.

Use LTD Beginning Balance

Select this check box to include life-to-date beginning balance to calculate life-to-date totals.

Year

Optionally, select the year for the account analysis. Selecting the year limits the periods returned for the period filters.

Period

Select a reporting period, including year and month or year and quarter.

Thru Period

Select a through period. Use this field when the period range is not available as an existing calendar group. We recommend that a through period is used when the same results can be achieved by selecting a quarter period or a year period. For example, Period 1 through Period 3 should be Quarter 1.

Accounting Entity

Select an accounting entity to filter the totals that are displayed. If this field is blank, then all accounting entities that are assigned to the basis are displayed.

User Dimensions

Additional user dimensions that are defined in the finance enterprise group are displayed as separate fields. Select a value for each of the dimensions to filter the totals that are displayed. If this field is blank, then the top level of the structure that is assigned to the selected reporting basis is used.

Reporting Currency

Select a reporting currency for the account analysis. All amounts are displayed in the report currency. If Functional, Alternate, Alternate 2 or Alternate 3 is selected, then a warning is displayed when Accounting Entity is blank.

Suppress Zero Rows

Select this check box to exclude posting accounts with zero amounts.

Detail Trial Balance

If this check box is selected, the debit activity balances and credit activity balances are displayed. Only the Functional or Report Amount 1 provide data.

Show Period Balance

To show the period balances for a specific Display Account, select this check box. A list of periods and balances are displayed in the lower pane. If you select the Charts icon in the lower pane, the list can be displayed as a bar chart or a pie chart instead of the list.

To open the analysis using the saved settings, Click Analyze Accounts, Analyze Budget, or Trial Balance.