Skip to main content
Administrator Guide
Last Updated: 2024-09-20
Download PDF
Steps: Set Up Consolidations in AP&C

Steps: Set Up Consolidations in AP&C

  • Create a company hierarchy that includes all companies that are part of the consolidation. See Steps: Set Up Companies in AP&C.
  • Review setup considerations for consolidations and eliminations.
In Adaptive Planning and Consolidation (AP&C), you can:
  • Set up elimination rules for intercompany and interworktag transactions, noncontrolling interest (NCI), and equity pickup rules.
  • Generate reports to view detailed information about these eliminations:
    • Intercompany and interworktag.
    • Investment in subsidiary and subsidiary equity.
    • NCI.
  1. Select the legal companies that are part of the consolidation hierarchy, and define either of these percentages:
    • Ownership.
    • Claim on assets.
    Security:
    • Set Up: Consolidation
      domain in the Financial Accounting functional area.
    • Set Up: Financial Accounting
      domain in the Common Financial Management functional area.
  2. Set up rules for using intercompany affiliate worktags to eliminate ledger accounts for the consolidation.
    Security:
    Set Up: Consolidation
    domain in the Financial Accounting functional area.
  3. Define the equity method accounting rules that consolidation investor and investee companies use to eliminate equity pickup earnings.
  4. Record the equity earnings of consolidated subsidiaries onto the books of parent companies.
  5. Set up to calculate noncontrolling interest.
  6. View these eliminations by running the standard composite consolidated trial balance report:
    • Investment in subsidiary and subsidiary equity eliminations, including any NCI portion.
    • NCI activity.
    • Equity pickup.
    You can view equity pickup journals in a:
    • Standard trial balance report.
    • Composite consolidated trial balance report.