Intercompany Elimination Details and Reclassification

The Unwanted Intercompany Affiliate report is meant to help determine where there’s intercompany affiliate tagging on P&L accounts that cause the intercompany affiliate to become present on Retained Earnings. The report will require that the ledger accounts used in the Intercompany Elimination Rules should be filtered out. This report can be used at the end of each period, year, or before the roll-forward to create adjusting journals to remove the unwanted intercompany affiliate tagging as needed. You can refer to Using Intercompany Affiliates for Reference Purposes without Risking Unwanted Eliminations contributed solution for an automated alternative of creating these entries.

A summary version of the report can be created using a matrix report and can provide a high-level overview of where there are unwanted intercompany affiliate taggings. The delivered detail version will provide a more in-depth overview of the journal lines where there are unwanted intercompany affiliate taggings. 

The Elimination Journal Lines report is meant to help provide details on the journal lines that make up elimination amounts within financial reports. Since eliminations occur at the time of the report being run and no journal entries are generated in this process, this report can help provide those details to auditors on what makes up those elimination entries. The report should be filtered on the ledger accounts found within the Intercompany elimination rules. 

Before migrating this package:

1. Familiarize yourself with these concepts: Object Transporter (OX), the Configuration Catalog in Customer Central, and how to Migrate Configuration Catalog Content with Object Transporter.
2. Verify you have a Customer Central User ID to access the Configuration Catalog and that it corresponds to the user ID in your Sandbox or Implementation tenant. 

Tenant prerequisites:

1. Account Set: Standard
2. Account Translation Rule Set called: Standard
3. Fiscal Schedule ID: YE_DEC
4. Ledger Type: Actuals
5. Account Set ID: Standard
6. Journal Source: Beginning Balance

Additional Information

Once you've successfully created or migrated the reports using Customer Central, you can follow the suggested setup steps listed below to update the report based on the desired report output:

• Update default prompts for the Intercompany Elimination Rule ledger accounts.
• Update default prompts for the Ledger Account Type to filter on the P&L ledger account types (ex: Expense and Income).
• Add details within the report's row grouping, drill down, or columns for other worktags. Ex: Cash Flow Code for equity pickup journal lines.
• Reformat the report to facilitate EIB population.

Characteristics

Customer Central Package

RPT Consolidations

The Customer Central package listed above ties to the name of the Configuration Catalog package where the corresponding reports are located. Once loaded into your tenant, you can find the reports in the table below using a Report Tag that matches the Customer Central name or simply by searching for the custom report. The Prerequisites listed below are the security domains needed to be able to run the report. For more reports within the package, see RPT Consolidations.

Pattern

These report templates support one key pattern: Foundational.

We deliver these templates to give you a starting point for other reports. You'll need to review the templates to determine if this out-of-the-box version will work for your intercompany affiliate and elimination reporting needs. If so, you can use the template to create minor changes to it or copy it for other reporting needs. The level of effort will vary depending on the level of modifications needed.