Payroll commission draw reconciliation calculator

Calculate closing recoverable balance by period and cash paid by period 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 closing recoverable balance by period and cash paid by period to compare changes to your inputs. The method and limits below explain the scope.

Examples

Examples

Try the starting example

Opening recoverable draw balance ($)
50
Periods: name, cash draw $, earned commission $
P1,100,120 P2,100,200
Draw treatment: recoverable or guaranteed
recoverable
Closing recoverable balance by period ($)
P1: 30.00; P2: 0.00
Cash paid by period ($)
P1: 100.00; P2: 170.00
Cash beyond each stated draw ($)
P1: 0.00; P2: 70.00
Total cash paid ($)
$270.00
Final recoverable balance ($)
$0.00

Try another scenario

Opening recoverable draw balance ($)
0
Periods: name, cash draw $, earned commission $
P1,100,120 P2,100,200
Draw treatment: recoverable or guaranteed
guaranteed
Closing recoverable balance by period ($)
P1: 0.00; P2: 0.00
Cash paid by period ($)
P1: 120.00; P2: 200.00
Cash beyond each stated draw ($)
P1: 20.00; P2: 100.00
Total cash paid ($)
$320.00
Final recoverable balance ($)
$0.00
Calculation method

Calculation method

Closing recoverable balance by period ($)

Recoverable: max(0,prior balance+draw−earned commission). Guaranteed: no balance is carried.

Cash paid by period ($)

Recoverable: draw+max(0,commission−prior balance−draw). Guaranteed: max(draw,commission).

Cash beyond each stated draw ($)

Period cash−draw.

Total cash paid ($)

Sum period cash.

Final recoverable balance ($)

Final carried balance; guaranteed mode requires zero opening balance.

Symbols and units
a
Opening recoverable draw balance ($)
b
Periods: name, cash draw $, earned commission $
c
Draw treatment: recoverable or guaranteed

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

  • An explicit draw ledger using already determined commissions. It does not decide whether a draw is recoverable, enforceable or compliant with wage rules.
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

US Department of Labor: pay/time recordkeeping background; actual rules vary ↗

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.