Arrears Balance Calculator: Amounts Due and Paid
Reconcile the confirmed amount owed against payments already received.
Multiply the pay shortfall per unit by the affected units and add any confirmed adjustment. Calculate periods with different rates separately; the result is gross arrears, not the net payslip amount.
Gross back pay reconciles a confirmed pay rate with the rate actually paid over a matching quantity of hours, days or pay periods. A separate adjustment allows another established gross difference to be included without changing the rate comparison.
Subtract gross pay actually paid from the correct gross pay. This preserves a negative difference if the entered paid rate was higher.
Multiply the per-unit difference by the number of matching units. The calculation assumes that difference applies consistently across every included unit.
Apply the confirmed adjustment once to obtain total gross back pay. The result is not rounded into a payroll tax calculation or converted to take-home money.
Sample inputs demonstrate the method. They are not a forecast or product offer.
The first example should pay €20 per hour but paid €18 for 80 hours. The shortfall is €2 per hour; multiplying by 80 gives €160 gross back pay. The separate adjustment is zero, so it does not change that result.
Sample inputs demonstrate the method. They are not a forecast or product offer.
A positive result describes a gross shortfall under the supplied figures. A negative result describes the opposite numerical position, without deciding whether repayment can lawfully be required.
Use payroll records to confirm rates, units and adjustments. This arithmetic does not establish eligibility, a legal award, interest on arrears or the deductions applied when the amount is processed.
Estimate a gross pay shortfall from the correct pay per unit, the amount paid and the number of affected units.
This estimates gross arrears, not net payment or a legal award. Separate periods with different pay rates must be calculated separately. Payroll tax depends on actual processing rules.
Read our calculation and testing approach.