Intercompany reconciliation

With intercompany reconciliation in IBM® Controller Web, you can reconcile transactions between a company and all the counter companies where intercompany transactions exist. The purpose of the intercompany reconciliation is to provide a quick way of tracing differences before consolidation calculations are performed.

This feature is intended for a reporting site user who needs to reconcile intercompany balances for one company at a time against other group companies.

Amounts in the respective local reporting currencies are translated into your reporting, local currency, using the currency rates that have been entered for the period in IBM Cognos Controller. Note that the period average rate (D rate) is not supported in the intercompany reconciliation in Controller Web. Accounts with D rate will be converted at the closing rate.

For an intercompany account of type J (with transaction currency), the differences can be viewed in the user's local currency or in the transaction currency. The selection is made via the filter icon filter icon.

Intercompany tab showing currency options

Also, you can specify here if you want to show only differences higher than the specified value.

The initial view is meant to give an overview of all the differences you have to deal with. One record for each combination of counterpart and category (control table) and with the largest difference at the start of the list.

All categories and all journal types are included. As soon as numbers affecting your reconciliation are changed, for example your counterpart changes values, then Controller Web updates to reflect the change.

When you select one of the transactions, Controller Web displays the following items:

  • My transactions

    All existing transactions that are reported by your company and that are included in the calculation of the selected difference.

  • Counterpart transactions

    All existing transactions that are reported by other group companies that have your company as counterpart and that are included in the calculation of the selected difference. Amounts in other currencies are translated into your local currency.

  • Difference

    The difference between my transactions and counterpart transactions in the transaction currency and in my currency.