Consolidations GL
Consolidations GL
Consolidations GL
Run Consolidation
Parent
Consolidation Tools
You can use the method that best suits your needs to
consolidate financial information.
Financial Statement Generator (FSG)
Global Consolidation System (GCS)
GCS FSG
Consolidating Multiple Companies
Sharing a Single Ledger
Parent
company
ledger
Interface Data Transformer (IDT) Description
L
SQ
Other Uses for
Global Consolidation System
Access all
consolidation steps
Preparation/Transfer Mapping
Mapping Set
Elimination Translation Status
Transfer
Transfer Set
Review Journal
Post
Elimination Set
Elimination
Report
Using the State Controller
Mapping
Mapping Set Blue Recommended
Translation Status
Transfer Gray Not Recommended
Transfer Set
Red Warning
Review Journal
Post
Elimination Set
Eliminate
Report
Defining a Consolidation Mapping
Mapping Rules
Subsidiary Parent
Ledgers Ledger
Mapping Rules
02.300.5410.100 01.5000.100
Low 02.400.5400.100
01.5200.100
High 02.400.6999.100
Using Segment Mapping Rules
Transfer to Parent
Mapping Set Company Ledger
Revalue balances
Translate balances
Subsidiary Run reports
Ledger
Revaluation Process
Foreign
currencies
Functional
currency
Translation
Subsidiary
functional
currency
Parent
functional
currency
Transferring Subsidiary Data
to Parent Ledger
You can transfer
data from your
subsidiary ledgers
by:
Consolidating Consolidating
balances transactions
Transferring
consolidation
sets
Consolidation Tracking and Reversals
Posting Consolidation Journal Entries
Transfer
Subsidiary
Data
Remote
Parent
Instance
Company A Company B
Formula-Based Eliminations
Source Target
Account Account in
from Parent or
Source Target Account Elimination
Subsidiary
Account in Parent or Company
from Elimination
Subsidiary Company
Defining an Elimination Set
999 Null Source accounts 100, 200, and 300 Parent Cost Center 999
(children of 999) eliminate into
individual target accounts 100, 200, and
300
A/R A/R
Subledger Subledger
Performing Consolidated
Balances Inquiry
Balances
Consolidation
Subsidiary
Source Account