Retroactive salary arrears · Calculation guide

Calculate gross arrears due.

Calculation guide

Use annual salaries on the same full-time basis, the number of affected monthly periods and the employment fraction. Subtract prior arrears payments.

due = (new-old)*months*fraction/1200-prior; monthly = (new-old)*fraction/1200

Inputs

Prior full-time annual salary

Example entry 48000 (in the selected currency).

Revised full-time annual salary

Example entry 54000 (in the selected currency).

Affected monthly periods

Example entry 6.

Employment percentage

Example entry 80 %. Allowed range 0.0 to 100.0.

Arrears already paid

Example entry 250 (in the selected currency).

Worked example

InputValue
Prior full-time annual salary48,000
Revised full-time annual salary54,000
Affected monthly periods6
Employment percentage80%
Arrears already paid250
ResultValue
Gross arrears due2,150
Monthly gross adjustment400

Calculation steps

Gross arrears due = (((((Revised full-time annual salary − Prior full-time annual salary) × Affected monthly periods) × Employment percentage) ÷ 1,200) − Arrears already paid)

(((((54,000 − 48,000) × 6) × 80) ÷ 1,200) − 250) = 2,150

Monthly gross adjustment = (((Revised full-time annual salary − Prior full-time annual salary) × Employment percentage) ÷ 1,200)

(((54,000 − 48,000) × 80) ÷ 1,200) = 400

How each input affects this example

Each row starts from the worked example and changes one input.

InputOriginal inputNew inputAffected resultOriginal resultNew result
Prior full-time annual salary48,00052,800Gross arrears due2,150230
Revised full-time annual salary54,00059,400Gross arrears due2,1504,310
Affected monthly periods67Gross arrears due2,1502,550
Employment percentage80%88%Gross arrears due2,1502,390
Arrears already paid250275Gross arrears due2,1502,125
Retroactive salary arrears →