Schedules

A schedule is a breakdown of one or multiple accounts into individual movements for a certain period.

Schedules categorize financial data into, for example, assets (gross value and depreciation), receivables, payables, equity, and accruals.

Schedule details provide details of financial data.

You can define schedule details for each schedule. For example, increases, decreases, and other details according to your GAAP requirements. Schedule details are typically used to split data into movements, write-offs, or corrections. In Financial Consolidation, schedules have a system-created opening balance and closing balance, but only if the use of opening balances is configured for schedules.

Schedules can be aging schedules or development schedules. Aging schedules present the maturity structure of an account. Development schedules present the development from the opening balance to the closing balance.

Development schedules require these elements:

  • Closing balance
  • Opening balance
  • Currency translation difference

Aging schedules require at least a total element and one base element.

In Financial Consolidation, one account can be assigned only to one schedule.

Statistical Opening Balance

Opening balances are not directly imported from the source system to Financial Consolidation but they are derived through the Carry Forward Schedules process. If opening balance values are not provided in the source system, you can use the Data Import feature for entities to import the values separately as a Statistical Opening Balance.

You can use Statistical Opening Balances to compare their values with the Opening Balance values that are generated by the Carry Forward Schedules process and verify whether the values match. The comparison results in specific checks that are created on the Status Monitor tab and on the Trial Balance card on the Entity tab on the Landing Page. Statistical Opening Balances are not part of schedules that are used in financial statements.

When you create a schedule with opening and closing balances, schedule details are generated with the STAT_*_OB name. In the name, * stands for a schedule or schedule detail name. Those details are not part of actual schedules and are not used in the consolidation processes.

To view the STAT_*_OB element, perform these steps:

  1. Select EPM Administration > Dashboards > OLAP > Edit Database.
  2. In the Database Structure panel, select DEPMAPPS and expand the Dimensions node.
  3. Expand the DDETAIL node and click DDETAIL.
  4. Click the Elements tab.

    The STAT_*_OB element is displayed under the STAT_OB element.

You can view the values of the STAT_*_OB schedule details at these levels in Financial Consolidation:

  • Entity level
    1. On the Landing Page, click the Status Monitor > Entity Status tabs and click Check Report.
    2. In the Check Report dialog box, disable zero suppression on rows and columns, and expand the context pane, All Checks and Checks Data Import Opening Balances columns.

      The imported values of Statistical Opening Balances are displayed in the expanded columns.

    You can also verify the status of the Check Data Import Opening Balances for the specific schedule directly on a card on the Landing Page. Click the Entity tab, then click the status icon on the Trial Balance card and select Check Summary.

  • Account level
    1. Select Self-Service > Explore Your Data > FinCon Entity Schedules – DEPMAPPS_DEPM > OK.
    2. Specify the context, including Adjusted Entity Data as the adjustment level.
    3. Configure the view to verify whether the imported data of statistical opening balances matches the opening balances that are generated by the Carry Forward Schedules process.
Related topics