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
| Input | Value |
|---|---|
| Entity row number | 1 |
Entities
| Gross receipts | Gross payments |
|---|---|
| 80,000 | 50,000 |
| 50,000 | 80,000 |
| Result | Value |
|---|---|
| Selected entity net receipt | 30,000 |
| Group cash settlement volume | 30,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.
