Intercompany Elimination Report

The Intercompany Elimination report provides an audit trail of intercompany eliminations for a period. Run this report after posting intercompany elimination for a period. This report provides the source transactions marked for elimination, and the generated elimination journal entries.

If you use the Multi-Book Accounting feature, you can run the Intercompany Elimination report for any accounting book enabled for consolidation.

To view the Intercompany Elimination Report:

Go to Reports > Financial > Intercompany Elimination.

The following filters are available in the report footer:

• Date Range -view results for transactions in a date range or period range

• Subsidiary Context -view results for all subsidiaries or one subsidiary

  To filter the report by subsidiary, select an elimination subsidiary with posted elimination journal entries.

A message appears indicating that your report is loading. The status bar in the footer of the report indicates the progress as your report loads. You can click Cancel Report next to the status bar to stop the report from loading.

The Intercompany Elimination report displays source transactions and elimination lines. It groups the data by elimination subsidiary, then by sales order and purchase order pair. Source transactions include sales invoice, vendor bill, credit memo, vendor credit, journal entry, advanced intercompany journal entry. Transactions from the same paired transaction are grouped. For example, all invoices and vendor bills that originate from the same sales order, purchase order pair are grouped together.

The Intercompany Elimination report displays the following columns:

• Source Trans Type

• Subsidiary -the subsidiary where the transaction is created:

  • the selling subsidiary for a sales invoice

  • the purchasing subsidiary for a vendor bill

  • the From subsidiary for an advance intercompany journal entry (AICJE)

• Paired Subsidiary -the subsidiary the transaction targets

  the Other subsidiary for AICJE

• Source Trans Date

• Source Trans Account -the account on the source transaction marked for intercompany elimination

• Source Trans Amount (Trans Currency) -source transaction line amount in transaction currency. Shows as positive for a debit, negative for a credit. For A/R and A/P accounts, this is the open balance after month-end revaluation.

• Source Trans Currency

• Source Trans Amount (Base Currency) -source transaction line amount in base currency. Shows as positive for a debit, negative for a credit. For A/R and A/P accounts, this is the open balance after month-end revaluation.

• Subsidiary Base Currency

• Consolidated Exchange Rate -the consolidated exchange rate used to translate the source subsidiary base currency to elimination subsidiary base currency

• Elimination JE -links to the elimination journal entry

• Elimination JE Date

• Elimination JE Amount

• Elimination Subsidiary Currency

General Notices