Generate the Intercompany Reconciliation Report
Use the Reconciliation Report to reconcile your inner company accounts.
Perform the following steps to generate the Intercompany Reconciliation Report:
-
Navigate to the Springboard items from the landing page.
-
Click General Accounting Infolets.
-
On the IC Reconciliation infolet, click Reconcile Intercompany Accounts to start the Extract Intercompany Reconciliation process.
-
Click Actions and then click Run.
-
Select the value for the report parameters: Provider Ledger, Provider Accounting Period, and Additional Currency.
Note: Ensure that the entries in the fields Provider Ledger and Provider Accounting Period match the ledger on the dashboard. The Additional Currency must also match the currency of the ledger on the dashboard. -
Select Conversion Rate Type and Conversion Date. These two parameters are enabled after you select the Additional Currency.
-
Click Submit.
-
Click Refresh until you see the report.
Note: The Period summary report is displayed only after the Extract Intercompany Reconciliation process is completed. -
Click Actions drop-down list and select History to view previously run reports in the Period Summary. If the Provider Legal Entity or Receiver Legal Entity is displayed as 'unassigned', it means the primary balancing segment value on the balancing line isn't assigned to a legal entity.
-
Select an item under Entered Amount Difference in Transaction Currency column to view the Summary by Source report.
-
Review Intercompany Receivables GL Balance and Intercompany Payables GL Balance in the Summary by Source report. Identify the roles which have a higher balance and the journal lines that are in one, but may not be in the other balance.
Note: If there is a difference between the Intercompany receivables and payables amounts, drill down further on both intercompany receivables and payables amounts to identify the journal lines that appear in one but not the other.