Analytics columns

Analytics displays any variance between the translated line total for the specifying unit and the translated line total for the affiliated unit. These values are displayed in all categories of the report except for the "Intercompany Activity Not Eliminated" category.

Key:

A = (Sum of the translated Match lines * consolidation percent of specifying unit) + sum of calculated third-party amounts, if any

B = (Sum of the translated Match With lines * consolidation percent of specifying unit) + sum of calculated third-party amounts, if any

Sums column

For each specifying unit in a transaction, there is one total amount in the Sums column.

Difference column

The difference between A and B are calculated as follows (taking into account the natural sign of each line):

- (A + B)

These amounts post to a remainder line and are eliminated during a consolidation when the calculated difference, expressed as a percent or fixed amount, is outside the requested percent or fixed amount tolerance.

% Diff. column

The percent difference between A and B is calculated as follows (taking into account the natural sign of each line):

((A + B)/A*100)

If the calculated percent difference is outside the percent tolerance specified for the journal, a remainder line is required for the transaction. The amount in the Difference column is used as the remainder.