Report on Intercompany Eliminations in OfficeConnect

Use OfficeConnect’s Financials data source to report on intercompany transactions and eliminations — with options to include or exclude eliminations from consolidated views.
Tags:

Intercompany eliminations remove transactions between entities in a consolidated group — preventing double-counting of intercompany revenue and expenses. OfficeConnect’s Financials data source surfaces these as data you can include or exclude in your reports.

How eliminations appear in OfficeConnect

When you report against a parent company (consolidated entity) in OfficeConnect, the data you see depends on your Workday Financial Management configuration:

  • If elimination journals are posted in Workday, they are included in consolidated totals automatically
  • The Exclude Elimination option (available in Financials data source reports) lets you toggle whether elimination entries are included in your totals

Note: The Exclude Elimination option is a Financials-only feature — it is not available in Adaptive Planning reports. See Adaptive Planning vs. Financials Data Source.

View intercompany eliminations separately

To see elimination amounts on their own:

  1. Open your OfficeConnect workbook and click the OfficeConnect tab.

  2. Add a column for the elimination company — in Workday Financial Management, eliminations are typically posted to a dedicated elimination entity (often named Eliminations, Elim, or prefixed with E_). Drag this entity from the Company dimension in the Reporting pane.

  3. Add your ledger account rows and refresh. The elimination column shows only the elimination journal entries for each account.

Exclude eliminations from a consolidated report

  1. In your consolidated report (with a parent company element), look for the Exclude Elimination checkbox in the Reporting pane or report settings.

  2. Check Exclude Elimination to see gross consolidated data without eliminations applied. This is useful for understanding the total volume of intercompany activity.

  3. Uncheck it to return to standard consolidated totals with eliminations included.

Common intercompany reporting layouts

Column A (Accounts)Column BColumn CColumn D
RevenueCompany ACompany BEliminations
Intercompany RevenueCompany A ICCompany B ICElim entry
Consolidated RevenueSum of B+C+D

Building this layout in OfficeConnect requires one column per entity plus one for the elimination company, with Excel SUM formulas for consolidated totals.