Open calculator ↗

Intercompany netting settlement amounts · Calculation guide

List each entity's gross intragroup receipts and payments in one settlement currency.

Calculation guide

Group receipts must reconcile to group payments. Positive net amounts are received.

settle = receipts − payments · volume = Σ max(0,receipts − payments)

Inputs

Entity row number

Example entry 1.0. Minimum 1. Use whole numbers.

Gross receipts

Example entry 80000.0 (in the selected currency).

Gross payments

Example entry 50000.0 (in the selected currency).

Worked example

InputValue
Entity row number1

Entities

Gross receiptsGross payments
80,00050,000
50,00080,000
ResultValue
Selected entity net receipt30,000
Group cash settlement volume30,000

Interpreting the result

A negative entity settlement is paid into the netting pool. Group volume counts each transfer once.

In this example, changing “Entity row number” from 1 to 2 moves “Selected entity net receipt” from 30,000 to -30,000. All other inputs stay the same.

Intercompany netting settlement amounts →

Sources