ICB Reporting

ICB reporting allows users to list details of all inter company transactions and filter those lists based on specific criteria.

To create an ICB report select ICB Reports from the menu ribbon.

You will be asked if you want to collate the ICB information. This step gathers all the ICB transactions and matches and calculates any difference. You should run this to make sure your reports include all the latest up to date data.

!Depending on the number of ICB variables and the number of entities in your model, the collation can take a while to complete. If you are aware that there have been no changes since the last time the data was collated, or at the very least, no changes to the data you want to look at on the report, then it is not necessary to run this every time.

The ICB reports window will display.

ICB Reports Window

There are two sets of selections that can be made before this ICB report is displayed in the query results area of the window.

Modify selection

This allows you to specify which elements of the data should be included in the ICB report. i.e. which entities, which versions, which time periods and so on. By default, the selection is set for all entities, for all versions for all time periods.

Clicking on the Modify Selection button, enables you to work through each dimension in turn, selecting the members that should be included.

Within whichever Dimension required, click on the Clear All button in the centre, or highlight individual names within the Selected Members box on the right-hand side and click on the Remove button.

Highlight as many members as required from the Dimension Selection box on the left-hand side, then click on the Add button in the centre.

Once your selections have been made, click on the OK button.

Add criteria

The criteria here allows for extra filtering on the data from the selected dimension members.

Once the selections and criteria have been set, click Re-query to populate the list of ICB transactions that match the settings.

The report can be exported to an Excel worksheet by clicking on the Report to Excel button.

See Data Filtering for more information on using the Add Criteria options.

Once the selections and criteria have been set, click Re-query to populate the report.

The key columns on the report are as follows:

*Ultimately, the data that needs to balance is the Base Currency Net view. When the input view is not balanced, the adjustments are posted to the Adjust view, so even with the adjustments in, the Input view will remain unbalanced.
You might want to use the Modify Selection option to only show the Net view.

The report can be exported to an Excel worksheet by clicking on the Report to Excel button.