Establishing Ledgers

This section provides an overview of ledgers and discusses how to define consolidation ledgers or consolidation source ledgers.

Pages Used to Establish Ledgers

Page Name	Definition Name	Navigation	Usage
Detail Ledger - Definition	LEDGER_DETAIL1	select EPM Foundation, then select EPM Setup, then select Ledger Setup, then select Ledgers, then select Detail Ledger, then select Definition	Create a detail ledger and associate it with its ledger template.
Detail Ledger - Consolidations	GC_LED_DEFN_TBL	select EPM Foundation, then select EPM Setup, then select Ledger Setup, then select Ledgers, then select Detail Ledger, then select Consolidations	Indicate if the ledger should be a balanced ledger, if any account type balances are in YTD format, and establish contact information for the different phases of consolidations.

Understanding Ledgers

After you have defined ledger templates for your consolidation ledger, spreadsheet/manual entry ledgers, and consolidation source ledgers, you create the ledgers with which to associate them. These ledgers are always detail ledgers. When establishing a ledger, you indicate whether it must balance. For trial balance format ledgers, you also need to specify the format in which the data is received, by account type.

The rules that apply to the relationship between the source subsidiary ledgers and the consolidation ledger are:

If your consolidation ledger is in the financial statement format, then source data maps to balance forward account types must contain period end balances, and source subsidiary ledger data that maps to non-balance forward account types must contain period activity.
If your consolidation ledger is in the trial balance format, the source subsidiary ledger data can be either period end balances (also referred to as YTD balances) or period activity; indicate on the ledger definition for each source subsidiary which account types are received as YTD amounts.

During ledger preparation processing, the YTD amounts are converted to current period activity. If none of the account types are received as YTD, then the system assumes that the source subsidiary ledger balances are for period activity.
Period 0 is required for trial balance format ledgers.

Account balances are stored in the consolidation ledger as debit (positive) or credit (negative) values. You must load the source ledger into the warehouse with the account balances as debit or credit amounts.

Detail Ledger - Definition Page

Use the Detail Ledger - Definition page (LEDGER_DETAIL1) to create a detail ledger and associate it with its ledger template.

Navigation

select EPM Foundation, then select EPM Setup, then select Ledger Setup, then select Ledgers, then select Detail Ledger, then select Definition

Image: Detail Ledger - Definition page

This example illustrates the fields and controls on the Detail Ledger - Definition page. You can find definitions for the fields and controls later on this page.

Enter the description, and select the ledger template used by this ledger.

Optionally, complete the remaining fields on this page, which vary depending on the EPM ledger type of the associated ledger template (specified on the Ledger Template page):

Ledger

Enter the name of the detail ledger. This field acts as a filter, and associates only the subset of data from the database ledger record defined by the specified ledger to this ledger. This field is available when the EPM ledger type is a non-EPM source ledger, such as Standard General Ledger, or when the EPM ledger type is set to Consolidation Source.

Budgeting Scenario

Indicate to which budgeting scenario this ledger is associated. (Applies only when the EPM ledger type is set to one of the budget ledger types.) This field acts as a filter, and associates only the subset of data from the database ledger record defined by the specified budgeting scenario to this ledger.

Scenario ID

Specify a scenario for this ledger. The scenario acts as a filter, and associates only the subset of data from the database ledger record defined by the scenario to this ledger. This option applies only to these EPM ledger types: consolidation ledger, performance management ledger, and planning ledger. If the EPM ledger type is Consolidation Ledger, you typically leave the Scenario ID blank. For consolidation source ledgers based on an EPM ledger (the EPM ledger type is Performance Management or Planning Ledger and the Used in Consolidations field is selected), enter a scenario ID to use the data defined by that scenario as input for consolidations.

Use the Detail Ledger - Consolidations page (GC_LED_DEFN_TBL) to indicate if the ledger should be a balanced ledger, if any account type balances are in YTD format, and establish contact information for the different phases of consolidations.

Navigation

select EPM Foundation, then select EPM Setup, then select Ledger Setup, then select Ledgers, then select Detail Ledger, then select Consolidations

Image: Detail Ledger - Consolidations page

This example illustrates the fields and controls on the Detail Ledger - Consolidations page. You can find definitions for the fields and controls later on this page.

Balanced Ledger

Select if you require that accounting entries balance for this ledger. If this check box is not selected, the system permits unbalanced accounting entries.

Account Type

If any of the balances for the various account types in the ledger are received as YTD amounts, select the account type in the Account Types Received as YTD grid, adding rows as needed.

In the Contact List for Consolidation Processes region specify who to contact for information about the different phases of consolidations, by ledger business unit.

For each row, indicate the Ledger Business unit, the Employee ID of the contact person, and the Functional Area for which the contact person is responsible. Select the Work Number and Email tab, then enter the contact person's Work Phone number and Email Address. Select the Department and Location tab and enter the Department, Location, and any Comments.

Note: You associate a consolidation ledger with a common consolidation business unit when you establish a consolidation model.