Calculation guide
A recoverable draw is cash advanced this period. Earned commissions offset the prior balance and the new draw before additional cash is paid.
Inputs
Opening recoverable balance
Example entry 1200 (in the selected currency).
New draw advanced
Example entry 2000 (in the selected currency).
Commission earned
Example entry 3700 (in the selected currency).
Worked example
| Input | Value |
|---|---|
| Opening recoverable balance | 1,200 |
| New draw advanced | 2,000 |
| Commission earned | 3,700 |
| Result | Value |
|---|---|
| Total cash paid this period | 2,500 |
| Closing recoverable balance | 0 |
| Draw balance recovered | 3,200 |
Calculation steps
Total cash paid this period = (New draw advanced + max(0, ((Commission earned − Opening recoverable balance) − New draw advanced)))
(2,000 + max(0, ((3,700 − 1,200) − 2,000))) = 2,500
Closing recoverable balance = max(0, ((Opening recoverable balance + New draw advanced) − Commission earned))
max(0, ((1,200 + 2,000) − 3,700)) = 0
Draw balance recovered = min((Opening recoverable balance + New draw advanced), Commission earned)
min((1,200 + 2,000), 3,700) = 3,200
How each input affects this example
Each row starts from the worked example and changes one input.
| Input | Original input | New input | Affected result | Original result | New result |
|---|---|---|---|---|---|
| Opening recoverable balance | 1,200 | 1,320 | Total cash paid this period | 2,500 | 2,380 |
| New draw advanced | 2,000 | 2,200 | Draw balance recovered | 3,200 | 3,400 |
| Commission earned | 3,700 | 4,070 | Total cash paid this period | 2,500 | 2,870 |
