Creating Profiles for Variance Analysis

To create profiles for variance analysis:

  1. From Home, select Application, and then Profiles.
  2. ClickNew (+) to create a New Profile.
  3. On the Properties tab, enter:
    • Account ID—The combination of segment values must be unique across profiles. The number of segments available is defined in system settings.

    • Name—A second way to identify the profile. Names do not need to be unique. As a best practice, Oracle suggests using the name associated with the natural account segment and some other descriptor that identifies ownership of or responsibility for the profile.

    • Description

    • Active—Selected by default for profiles manually entered or imported. Clear this check box if you do not want this profile copied to a period.

    • Summary Profile—If selected, then the Profile is a Summary Profile.

    • Organizational Unit — Represents a hierarchical entity-type structure that you can use to model your organization. Define a separate organizational unit for each entity for which separate reporting is required, or for entities that require different configurations for any of the following: holidays, work days, or viewer or commentator assignments. Organizational Units are defined in system settings.

    • Format—Associates the profile with a format created by an administrator, determining the method of reconciliation and the information that the preparer must provide.

    • Method—The method associated with the format assigned to the profile.

    • Process—Associates the profile with a specific reconciliation process, for example, the balance sheet reconciliation process or the local GAAP reconciliation process. Processes are defined in system settings.

    • Risk Rating—Associates the profile with a risk rating. Risk ratings are defined in system settings, for example, High, Low, or Medium.

    • Account Type—Associates the profile with an account type. Risk Rating and Account Type are attributes that facilitate reporting – the values are defined by administrators and can be used on dashboards and list views to filter reconciliations.

    • Normal Balance—Identifies whether the profile is expected to contain a debit balance, a credit balance, or a debit or a credit balance. If the balance is different from the normal balance, then a warning is set on the reconciliation.

    • Manually Enter Balances—Determine whether the preparer enters the current period balances and/or the variance period balances. Check these boxes only if balances are not being imported for the profile. Select one or both:

      • Enter current period balances

      • Enter variance period balances