Members in Equity Pickup refer to the specific components or line items of a subsidiary's equity that are included in the consolidated financial statements of the parent company.

Member names with leading zeroes aren't supported, for example, 0001.

Create a separate account, Investment in Equity Pickup under the parent Investments account to store the results of the Equity Pickup calculation.

AccountCategory
InvestmentsInvestments
   1800Investment in subsidiaries
   1810Investment in Equity Pickup

Your provisioned system contains the Equity Method and Equity Pickup members. These members store the results of the Equity Pickup calculation. 

Move these members to different parents if needed. You can rename these members, but the consolidation rules must be updated.

Equity Pickup membersAudit hierarchy
Statutory ReportingStatutory Reporting
  Management ReportingManagement Reporting
    Local ReportingLocal Reporting
      Import and InputImport and Input
      Local AdjsutmentsLocal Adjsutments
        Manual Local JEManual Local JE
        ReclassificationReclassification
        Manual IntercoManual Interco
        Auto Interco bookingAuto Interco booking
        Equity PickupEquity Pickup
    Corporate AdjustmentsCorporate Adjustments
    Consolidation AdjustmentsConsolidation Adjustments
      Manual Consolidation JEManual Consolidation JE
      Goodwill and PPAGoodwill and PPA
      Total IntercompanyTotal Intercompany
      Total Other AutomaticTotal Other Automatic
         Stock Holder EquityStock Holder Equity
         Equity MethodEquity Method

Normally customers want to import 100% of the Trial Balance for Equity Pickup entities. For consolidation purposes, 100% of the Trial Balance must be removed since it can't be consolidated. 

The Equity Method member is used to reverse the Trial Balance amounts imported for the Equity Pickup entity. This reversal is done using the elimination entities.

It's one of the only rules that doesn't apply to a specific account because the rule applies to all Trial Balance accounts.

After loading the Trial Balance:

  1. Navigate to Explorer.
  2. Expand the Root folder > Global > Consolidation > Reports > Web Reports
  3. Double-click the Consolidated Financials – By Entity report.
  4. Select an Entity, Currency, Period, and Scenario.
  5. Select OK.

Review the Entities owned by another and the Equity Method, Audit member used to reverse the Trial Balance.

Equity method

The Equity Pickup Audit member is used to record the Equity Pickup amounts as specified in the consolidation rules. The Equity Pickup amount is often recorded in the Holding company. In the example below, the Equity Pickup amounts are stored in Houston, the Holding company for New York. 

After loading the Trial Balance:

  1. Navigate to Explorer.
  2. Expand the Root folder > Global > Consolidation > Reports > Web Reports
  3. Double-click the Consolidated Financials – By Audit Report.
  4. Select an Entity, Currency, Period, and Scenario.
  5. Select OK.

Review the Equity Pickup amounts stored in the entity that is a holding company for another Entity. 

Equity pickup by audit
Equity pickup by audit