Intercompany Reconciliation Reports

Overview

The intercompany reconciliation reports enable you to reconcile your intercompany receivables and intercompany payables accounts, and identify any missing transactions. These reports are automatically generated when you run the Prepare Intercompany Reconciliation Information process. Use the reconciliation infolet feature to run the reports. The intercompany reconciliation infolets displays the default view of the reconciliation, allows drill down to the reconciliation reports, and also lets you run the reconciliation extraction process.

To generate data that's displayed on these reconciliation reports, you must first run this scheduled process.

Prepare Intercompany Reconciliation Reporting Information

Intercompany reconciliation reports include:

Intercompany Reconciliation Period Summary Report: Includes information about the intercompany receivables and intercompany payables accounts summarized by period.
Intercompany Reconciliation Summary by Source Report: Includes information about the intercompany receivables and intercompany payables accounts summarized by journal source.
Intercompany Reconciliation Journal Lines Report: Includes information about journal lines posted to the intercompany receivables or intercompany payables account.

Note: You can't run these reports individually. They're linked together and must be run as the Prepare Intercompany Reconciliation Reporting Information process.

Key Insights

The intercompany reconciliation reports show the entered or transaction amount of the accounting entries booked to the intercompany receivables and payables accounts for a pair of provider and receiver legal entities. Since the accounted amounts may differ due to different conversion rates for the intercompany receivables and intercompany payables, you can run the reports using an additional currency and conversion rate that converts all amounts into a common currency for comparison.

The intercompany reconciliation process starts with running the Prepare Intercompany Reconciliation Reporting Information process. Select from a variety of parameters to determine the data for your reports. For example, select the provider legal entity and receiver legal entity for which you want to run reconciliation.

Once the Prepare Intercompany Reconciliation Reporting Information process completes successfully, navigate to the Intercompany Reconciliation work area to view the Reconciliation Period Summary Report. This report displays the intercompany receivables and intercompany payables balances in summary for a period, and any differences between them. Drill down to view the balances by source and journal lines. You have full drill down capabilities to the general ledger journal, subledger accounting entry, and source receivables or payables transaction.

The reports include these details:

Intercompany receivables and intercompany payables lines generated by the intercompany balancing feature
Intercompany receivables and intercompany payables lines generated for the provider and receiver of each intercompany transaction

And the reports don't include these details:

Ledger balancing lines generated when the primary balancing segment value is in balance but either the second balancing segment or the third balancing segment is out of balance
Clearing company balancing lines

Report Parameters

This table describes selected parameters of the intercompany reconciliation reports:

Name	Description
Provider Ledger	Indicate the ledger of the provider organization for reporting.
Provider Legal Entity	Indicate the legal entity of the provider organization. Select the legal entity provider for the reconciliation extract process.
Provider Accounting Period	Select the provider accounting period for which the reconciliation extract process is run for the provider ledger.
Receiver Legal Entity	Indicate the legal entity of the receiver organization. Select the legal entity receiver for the reconciliation extract process.
Receiver Ledger	Indicate the ledger of the receiver organization for reporting.
Receiver Accounting Period	Select the receiver accounting period for which the reconciliation extract process is run for the receiver ledger.
Additional Currency	Indicate the display data in a different additional currency to the ledger currency for the reconciliation extract process.
Conversion Rate Type	Indicate the conversion rate type used to convert the amounts, if the reconciliation extract process is run for an additional currency.
Conversion Date	Indicate the conversion date used to convert the amounts, if the reconciliation extract process is run for an additional currency.

Frequently Asked Questions

This table lists frequently asked questions about the intercompany reconciliation reports.

FAQ	Answer
How do I find these reports?	Schedule and run these reports from the Scheduled Processes work area on the Navigator menu.
Who uses these reports?	Intercompany Accountant
When do I use these reports?	Use these reports to: Review your intercompany balances. Determine any differences between the intercompany receivables and intercompany payables balances for a period Drill down to view the balances by source and journal lines
What type of reports are these?	Oracle Business Intelligence Publisher