Inputting Intercompany Data

The Intercompany Input App allows you to review and adjust intercompany transactions in the system for a selected entity and time period.

To input intercompany data:

1. In the Longview Client, open the Consolidate module.
2. Select Data Collection and expand Input.
3. Select an entity.
4. Click Intercompany Input.
5. Select a time period (default is current period). If you did not select an entity in step 2 you can select it now.
6. Click OK. A table displaying intercompany transactions appears.

You can add, delete, and modify intercompany transactions.

Adding intercompany detail

1. Click Add to add line of intercompany detail data. Data is not uploaded until you click Submit.

Note: You can add a line of intercompany detail that has a similar intersection as another row by selecting the existing row and clicking duplicate.

2. For each line of intercompany detail, fill in the following fields:

   1. Account: Select the account to submit the intercompany data to.

      Note: Only the accounts that have an offset account (where ZElimAccountsOffset is set to an offset account symbol) will be listed.

   2. Entity: Select the contra entity to submit the intercompany data to.

      Note: Only the entities that allow Intercompany transactions to be recorded against them (where attribute ZElimAllowICTransactions is set to TRUE) will be listed.

   3. Data View: Select the Data view symbol to submit the intercompany data to.

      Note: The Data views available for selection are child symbols of NOCORP_Total.

   4. Scenario: Select the Scenario symbol to submit the intercompany data to.

      Note: This column will only display if you have more than one leaf scenario under the Scenarios_Actual hierarchy.

   5. Additional Dimension: Select a symbol from any additional dimension to submit the intercompany data to.

      Note: Additional Dimension columns will only display if your system has any custom dimensions, and the associated ASICD(X)INPUT attribute is set to a parent symbol. For more information, see “Updating the intercompany input symbols for custom dimensions” in the Solutions Administrator Guide

   6. I/C Balance: Enter the intercompany balance for the specified intersection.

Deleting intercompany detail

Delete intercompany detail by selecting the row and clicking delete. Alternatively, you can zero out the balance for the row. The intercompany detail is not deleted until you click Submit.

Editing intercompany detail

You can change the symbols the intercompany detail is submitted to by changing the symbols in the intercompany input view. You can change the amount of the intercompany balance by changing the balance field. No changes are applied until you click Submit.

Applying changes

To apply changes to the intercompany details, click Submit.

Note: Any symbol intersections that exist multiple times will be initially duplicated in the table view. Once you have submitted and refreshed the data, the balance for any duplicate intersections in the intercompany input view will be aggregated.

Importing into the intercompany input view

1. Click Import to import from a .csv file into the intercompany input view.
2. Select the file to import. See .csv file example:
3. You may select one of the following options to replace existing rows:

   1. Replace Existing Rows: If this option is checked, all rows in the table view will be cleared and replaced with the intercompany data in the import file.

      Note: Upon submission, this will also delete these intercompany values from the database.

   2. Do Not Replace Existing Rows: If this option is unchecked, all entries in the import file will be appended to the table view.

      Note: Any symbol intersections that exist multiple times will be initially duplicated in the table view. Once you have submitted and refreshed the data, the balance for any duplicate intersections in the intercompany input view will be aggregated.

4. Click OK. The file will be imported into the table. 
5. Click Submit to submit the data.

.CSV File Example:

Note:

• Account and Data view must be surrounded by brackets [] in your .csv file.

• Your .csv import file should match the columns in the intercompany input view. If additional dimension columns are visible in your view, these dimension symbols would need to be added to the import .csv file surrounded by brackets [].

Validating Intercompany Detail Against Trial Balance

The intercompany data entered into the intercompany input view should match the corresponding intersections in the trial balance.

To validate the intercompany data against the trial balance:

1. From within the Intercompany Input View, click Validate Against Trial Balance
2. The validation view will open displaying the following:

   1. Account: Any intercompany account that has an intercompany or Trial Balance amount loaded.

   2. Intercompany Input: The total intercompany amount entered to the intersection.

      Note: For any non-standard dimensions, the total amount as determined by the ASICD(X)INPUT attribute will be displayed.

   3. Trial Balance Data: The Trial Balance amount entered to the intersection.

   4. Variance: The difference between the Trial Balance Data - Intercompany Input.

   5. Data View: Any Data View that has an intercompany or Trial Balance amount loaded.

   6. Scenario: Any Scenario that has an intercompany or Trial Balance amount loaded.

      Note: This column will only display if you have more than one leaf scenario under the Scenarios_Actual hierarchy.