Rules

Key:

A = Sum of Match line amounts

B = Sum of Match With line amounts

The values of predetermined in-scope intercompany accounts are translated and compared, and a percent and/or fixed amount difference (tolerance) is calculated.

Tolerance calculation

The following formulas take into account the natural sign of each line:

Calculated percent tolerance = ((A + B)/A) * 100

Calculated fixed amount tolerance = - (A + B)

Remainders

• If the specified tolerance is 0%, any difference between A and B is captured in a remainder line.
• If the specified tolerance is 100%, no remainder is calculated (any difference between A and B is not captured in a remainder line, even if data is missing for A or B).
• If the specified tolerance is between 0% and 100%:
  • A remainder is computed if the calculated difference is greater than the specified tolerance (outside the tolerance) or if A has a non-zero value but the value of B is missing (zero or null), or vice versa.
  • No remainder is computed if the calculated difference is less than or equal to the specified tolerance (within the tolerance).
• If the specified tolerance is a fixed amount:
  • No remainder is computed if the calculated difference is within the tolerance.
  • A remainder is computed if the calculated difference is outside the tolerance or if either A or B is missing (zero or null).

Specified percent and fixed amount tolerance

• If the calculated fixed amount and percent differences are both within the specified tolerance, no remainder is required.
• If the calculated fixed amount difference is within the specified fixed amount tolerance and the specified tolerance is 100%, no remainder is required.
• If either calculated difference is outside the specified tolerance, a remainder is required.

Specified percent or fixed amount tolerance

• If either the calculated fixed amount or percent difference is within the specified fixed amount tolerance, no remainder is required.
• If the calculated fixed amount difference is within the specified fixed amount tolerance or the specified tolerance is 100%, no remainder is required.
• If both calculated differences are outside the specified tolerance, a remainder is calculated.

Default tolerance values

If values are missing or invalid for the specified tolerance, default values are determined as follows:

• The percent tolerance is used if a percent and a fixed amount are both specified but the operator is missing (the fixed amount tolerance is ignored).
• The valid tolerance is used if an operator is specified but one of the values (percent or fixed amount) is missing or invalid. For example, a non-numeric character is specified.
• 0% is used if both values are missing or invalid.