To check the average weekly earnings in your software, follow the steps below: - Double-click the required employee to open their employee record.
- 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. | - Select OK.
Reconcile the calculation If you need to reconcile the average weekly pay, use the calculation below. - Add up any payments within the 8 week period before the absence.
- Annualise these payments based on the pay frequency. For example, to annualise two payments for a monthly paid employee, multiply by two.
- 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 calculation - 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.
- 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.
- 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.
|