Hi AliBright - thanks for providing the details.
The Annual holidays ($) and Holiday pay due ($) amounts in the Leave Liability report are separate calculations:
The report is calculated using recorded pays with a pay-period end date on or before the report date. It doesn’t simply show the amount still to be paid after subtracting the final-pay amount. So, when you run the report as at 31/08 and include inactive employees, it can recalculate a Holiday pay due amount for the terminated employee even though their Annual holidays balance is zero.
This also explains why the figure changed from $9,920.00 on 27/08 to $11,245.29 on 31/08. If the final pay’s pay-period end date falls after 27/08 but on or before 31/08, that pay is included in the 31/08 report calculation but not the 27/08 calculation. The payment date of 25/08 and termination date of 28/08 don’t determine whether the pay is included—the pay-period end date does.
The $11,245.29 should therefore not be treated as an additional amount to pay the employee. It is the Holiday pay due result calculated by the report for the selected date. The $10,412.31 paid in the final pay is the final-pay calculation, while the report is a point-in-time liability calculation and does not show the final-pay amount as a separate offset in that row.
To confirm the source of the difference, check the final pay’s pay-period end date and the employee’s gross earnings included in the report up to 31/08. The figures provided here aren’t enough to identify the individual pay lines that make up the $11,245.29.
I hope this helps!
Adrian
