Intercompany balance matching calculator

Calculate signed residual by unordered entity pair and sum of absolute pair residuals with your own figures.

Your numbers

Use the units shown. Results update as you change valid inputs.

Choose the currency for these amounts. Changing it keeps your numbers and does not convert exchange rates.

Use signed residual by unordered entity pair and sum of absolute pair residuals to compare changes to your inputs. The method and limits below explain the scope.

Examples

Examples

Try the starting example

Balances in one currency: entity, counterparty, signed balance $
A,B,100 B,A,-90 A,C,50 C,A,-50
Allowed absolute residual per pair ($)
0
Signed residual by unordered entity pair ($)
A/B: 10.00; A/C: 0.00
Sum of absolute pair residuals ($)
$10.00
Pairs beyond entered tolerance
1
Overall signed residual ($)
$10.00

Try another scenario

Balances in one currency: entity, counterparty, signed balance $
A,B,100 B,A,-100 A,C,50 C,A,-50
Allowed absolute residual per pair ($)
0
Signed residual by unordered entity pair ($)
A/B: 0.00; A/C: 0.00
Sum of absolute pair residuals ($)
$0.00
Pairs beyond entered tolerance
0
Overall signed residual ($)
$0.00
Calculation method

Calculation method

Signed residual by unordered entity pair ($)

Group reciprocal entries by unordered entity pair and sum signed balances.

Sum of absolute pair residuals ($)

Sum absolute pair residuals; opposing errors do not cancel.

Pairs beyond entered tolerance

Count pairs whose absolute residual exceeds the supplied cent tolerance.

Overall signed residual ($)

Sum all entered signed balances.

Symbols and units
a
Balances in one currency: entity, counterparty, signed balance $
b
Allowed absolute residual per pair ($)

Use the units shown. A list keeps the order in which you enter its values. The symbol ^ means “raised to the power of”.

Assumptions & limits

Assumptions & limits

  • A signed reciprocal-balance check in one already reconciled currency and reporting cutoff. It flags differences but does not create elimination journals or resolve missing transactions.
Are these inputs private?

These calculations run in your browser. A shared link contains the values you choose to share. Only questions submitted to the separate AI finder are sent to OpenAI.

Further reading

OpenStax: financial-accounting model background ↗

Background reading; this does not imply endorsement or independent review of SumFizz.

Share this page
Share this calculator

Leave unchecked to share the page without your entered values.