Understanding Data Preparation

After your source ledger data resides in the PeopleSoft EPM database, you need to prepare the data before you can use it as input for any consolidation processes. Because the subsidiary ledgers may use different accounting calendars, account structures, and store amounts in different base currencies, they must be transformed to a common structure prior to consolidations. Data that has been transformed to this common structure resides in the consolidation ledger.

To prepare the subsidiary ledger data for the consolidation ledger, you define a series of mapping rules, add them to ledger preparation rules, and then run the ledger preparation process. After the ledger preparation processes are completed, the source ledger data is converted to the common structure, based on your mapping rules, and moved into the consolidation ledger. The data in the consolidation ledger is subsequently used as input for consolidation processes.

If your source subsidiary ledger data is in the same format as the consolidation ledger, when you define its ledger preparation rule, you can indicate that no preparation is required.

See Using the No Preparation Option.

Prerequisites

Before you can establish the mapping rules used for ledger preparation, you must define this supporting data:

Calendars: detail and summary.
Currency rates, currency codes, currency quotation methods.
Market rate definitions, market rate indexes, market rate types, and market rates.
Warehouse business unit definitions for subsidiary, elimination, and common consolidation business units.
Ledger templates, source ledgers, and consolidation ledger definitions.
Metadata and PeopleSoft Application Designer records for your subsidiary ledger records, source staging ledger records, mapping ledger records, and the consolidation ledger record.
Tree metadata for the trees used in consolidations.

See Understanding PeopleSoft EPM Business Rule Setups

See Understanding Metadata

and

See Understanding Organizational Structure Requirements

Ledger Preparation Processing Phases

The ledger preparation processing phases are:

Ledger Verification.

Verifies source data prior to running the Ledger Preparation process.
Calendar Mapping.

Maps subsidiary source data to a common accounting calendar, removes unnecessary keys to improve processing times, and populates the source staging ledger.
Ledger Data Mapping.

Maps ledger accounts to a common account structure and populates the mapping ledger.
Currency Mapping.

Maps monetary amounts a common consolidation ledger currency and updates the mapping ledger
Loading the Consolidation Ledger.

Moves data into the consolidation ledger.

These naming conventions identify the records used at each phase of ledger preparation processing; if customizing, replace XXX with the unique identifier that you have established for each record:

GC_SLED_XXX_TBL

The name for the ledger record after the calendar mapping phase. This is the source stage ledger, or SLED. The delivered record for the source stage ledger, PS_LEDGER_F00 is GC_SLED_PGL_TBL.

GC_MLED_XXX_TBL

The name for the ledger record after mapping rules have been applied. This is the mapped ledger, or MLED. The delivered record for the mapping ledger is GC_MLED_MGT_TBL.

GC_CLED_XXX_F00

The name for the resulting ledger record after ledger preparation is complete. This is the consolidation ledger, or CLED. The delivered record for the consolidation ledger is GC_CLED_MGT_F00.

Image: Ledger Preparation processes

This diagram depicts the ledger preparation processing flow:

The format of the consolidation ledger impacts ledger preparation processing:

For trial balance format consolidation ledgers, the system processes both current period activity and year-to-date (YTD) activity (period end balances) from the source ledgers.

The system converts any YTD amounts to current period activity.
For financial statement format consolidation ledgers, the source ledger data must also be in financial statement format.

No conversion occurs.

The consolidation ledger is balanced after currency conversion by using the balancing account type rule defined for the consolidation model.