Check an employee's average earnings for Statutory Sick Pay
Description

Your software calculates your employees' average weekly pay for SSP using the payment values you've processed.

Find out below where you can check and reconcile this information.

Cause
Resolution

To check the average weekly earnings in your software, follow the steps below:

  1. Double-click the required employee to open their employee record.
  2. Go to the Absence tab then select the S.S.P. button.
    Start of P.I.W.

     

    The date of the employee's first day of sickness absence.

     

     

     

    If the employee returned from a period of absence then is off again within 8 weeks, it's a linked period of sickness. In this case, this date is for the original start of the leave.

    Payment History table

    The table here details the payments you processed for each period in Sage 50 Payroll.

    8 Weeks Average Earnings If you have information entered in the 8 weeks gross table, the average value appears here. Alternatively, if you've calculated this value yourself, enter it here.
    No. of Payments The number of payments you processed within the 8 week period.
    Total Payments The total value of the payments made within the 8 week period.
  3. Select OK.

Reconcile the calculation

If you need to reconcile the average weekly pay, use the calculation below.

  1. Add up any payments within the 8 week period before the absence.
  2. Annualise these payments based on the pay frequency. For example, to annualise two payments for a monthly paid employee, multiply by two.
  3. Divide the annualised value by 52 to get the average weekly amount.
▼ Click here to view an example.

This example is for a monthly paid employee, with two payments within the eight-week period.

The employee received £2,000 gross pay in each of the two periods, and the software calculated their average weekly pay as ▼ £461.53846.

The paternity pay 8 weeks gross view in Sage 50 Payroll.

 The calculation

  1. Add together any payments paid in the 8 week period. In this example that's £2,000 in month 7 and £2,000 in month eight, totalling £4,000.
  2. Annualise this value. In this case, there are two monthly pay periods so we multiply by 6 to get a 12-month figure of £24,000.
  3. Divide the annual figure by 52 to get the average weekly gross amount. In this example that's £24,000/52 = £461.53846, matching the calculated value in the screenshot.

 

Steps to duplicate
Related Solutions