Commission draw recovery · Calculation guide

Calculate total cash paid this period.

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.

cash = draw+max(0,earned-prior-draw); balance = max(0,prior+draw-earned); recovered = min(prior+draw,earned)

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

InputValue
Opening recoverable balance1,200
New draw advanced2,000
Commission earned3,700
ResultValue
Total cash paid this period2,500
Closing recoverable balance0
Draw balance recovered3,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.

InputOriginal inputNew inputAffected resultOriginal resultNew result
Opening recoverable balance1,2001,320Total cash paid this period2,5002,380
New draw advanced2,0002,200Draw balance recovered3,2003,400
Commission earned3,7004,070Total cash paid this period2,5002,870
Commission draw recovery →