PeopleSoft Global Consolidations

PeopleSoft Global Consolidations

• Getting Started with PeopleSoft Global Consolidations

  • Global Consolidations Overview

  • Common Elements Used in PeopleSoft Global Consolidations

  • Global Consolidations Integrations

  • Global Consolidations Implementation

• Understanding PeopleSoft Global Consolidations

  • PeopleSoft Global Consolidations Overview

  • PeopleSoft Global Consolidations Components

  • PeopleSoft Global Consolidations Phases

  • PeopleSoft Global Consolidations Processes

  • PeopleSoft Global Consolidations Data Flow

  • PeopleSoft Global Consolidations Security

• Loading Ledger Data and Establishing Required Record Objects

  • Understanding the PeopleSoft Global Consolidations Architecture

  • Loading Ledger Data into the Operational Warehouse Staging (OWS) Tables

  • Loading Ledger Data into the Operational Warehouse Enriched (OWE) Tables

  • Establishing Required Record Objects

• Defining Your Organizational Structure

  • Understanding Organizational Structure Requirements

  • Setting Up General Options

  • Defining Business Units

  • Defining Elimination Entities

  • Defining Account Types, Accounts, and Account Nodes

  • Defining Ledger Templates

  • Establishing Ledgers

  • Defining Models and Scenarios

  • Creating Trees

• Establishing Consolidation Options and Supporting Objects

  • Defining System-Wide Security and Processing Options

  • Establishing Book Code Functionality

  • Defining User Preferences

  • Defining ChartField Value Sets

• Preparing Data for Consolidations

  • Understanding Data Preparation

  • Defining Ledger Verification Rules

  • Defining Calendar Mapping Rules

  • Defining ChartField Mapping Rules

  • Defining Currency Mapping Rules

  • Defining Ledger Preparation Rules and Groups

  • Running Ledger Preparation

  • Running Currency Adjustments

• Defining Required Consolidation Rules

  • Understanding Consolidation Rules

  • Defining Balancing Account Type Rules

  • Defining Tolerance Rules

  • Defining Ownership Rules

  • Defining Close Process Rules

  • Establishing Consolidation Models

• Defining Elimination, Non-Controlling Interest, and Equitization Rules

  • Understanding Elimination, Non-Controlling Interest, and Equitization Rules

  • Defining Elimination Rules

  • Defining Non-Controlling Interest Rules

  • Defining Equitization Rules

• Managing Journals

  • Understanding Journal Management Features

  • Understanding Allocations

  • Establishing Journal Approval Processing

  • Creating, Editing, Copying, and Approving Manual Journals

  • Posting and Unposting Journals

  • Publishing Journals

• Using Spreadsheet Journal Import

  • Understanding Spreadsheet Journal Import

  • Setting Up and Importing Spreadsheet Journals

• Defining and Managing Flows

  • Understanding Data Flows

  • Setting Up Flow Processing

  • Managing Source Flow Inputs

  • Managing Journal Flow Inputs

  • Processing Source and Journal Flows

  • Viewing Data Flows

• Processing Consolidations

  • Understanding Consolidation Processing

  • Validating the Consolidation Setup

  • Processing Eliminations

  • Processing Equitization

  • Locking Scenarios

  • Processing Close

  • Running Tree Flattener

  • Reviewing Application Engine Messages

  • Running Related Processes

• Monitoring Ledger Preparation and Consolidation Processes

  • Understanding Global Consolidations Monitoring Tools

  • Configuring the Ledger Preparation Manager, Ledger Enrichment Manager, and Consolidation Manager Pages

  • Managing Ledger Preparation Processing

  • Managing Ledger Enrichment Processing

  • Managing Consolidation Processing

  • Analyzing and Updating Processing Results

• Analyzing Consolidations

  • Understanding the Analysis and Monitoring Tools

  • Reviewing Ledger Balances

  • Comparing Ledger Balances

  • Viewing Trial Balances

  • Viewing Proforma Trial Balances

  • Auditing Consolidation Data

  • Viewing Ownership Hierarchies

  • Analyzing the Impact of Changes to Consolidation-Dependent Rules

  • Analyzing Consolidation Runs

  • Matching Intercompany Balances

  • Generating Consolidation Reports

• Global Consolidations Sources

  • Global Consolidations Source Codes

• PeopleSoft Global Consolidations Reports

  • PeopleSoft Global Consolidations Reports: A to Z

  • Report Samples