Use this report to help you calculate your employee's average earnings. This can help when with: - Redundancy payments
- Reconciling statutory payments
- Holiday entitlement
- Working out pay for government help schemes.
This is a generic report, so always seek guidance from HMRC to make sure the report supports what you need. If you need more help, read the HMRC holiday entitlement article. You can export this report, so you can save it, edit the information and share it. Generate the report- From Reporting select Average Earnings & Hours.
Enter the Start Date and End Date for the report then select Generate.  TIP: The dates must be after 1 January 2019 and within pay periods you have completed in Sage Business Cloud Payroll.
What the report shows| Employee | The name of your employee. | | Pay Frequency | The employee's pay frequency. | | Total Periods Paid | The number of pay periods covered by the date range you entered for the report.  NOTE: The figures for partially covered pay periods will include the full amount.
| | Total Gross Taxable Pay | The total gross pay for the periods covered by the date range you entered for the report. NOTE: The figures for partially covered pay period will include the full amount. Gross Pay includes: - Regular Payments (normal earnings subject to all legislative deductions)
- Overtime
- Other Pay
- Regular Bonus
- Commission
- Holiday Pay
- Expenses
- Statutory payments like SMP, OSPP, ASPP, SAP, SHPP, SPBP and SSP
| | Total Hours | The number of hours worked in the pay periods covered by the date range you entered for the report. NOTE: The figures for partially covered pay periods will include the full amount. | | Average Earnings | This is the total earnings divided by the number of pay periods. | | Average Hours | This is the total hours divided by the number of pay periods. |
What if I have different pay frequencies for my employees?You can run the report for any combination of pay frequencies. Selecting a date range that falls part-way through an employee's pay period, means the values calculate on the full pay period For example, your employee Jane works 150 hours per month, with a monthly salary of £2,000.00. When you run the report from 1 September to 12 October, it returns the following information: | Employee | Jane | | Pay Frequency | Monthly | | Total Periods Paid | 2 | | Total Gross Taxable Pay | £4,000.00 | | Total Hours | 300 | | Average Earnings | £2,000.00 | | Average Hours | 150 |
Exporting the ReportYou can export the report to PDF or CSV To do this: - Run the report as normal.
- Select the export option above the top-right of the report headings.
- Select the type of file you want to create, either PDF or CSV.
- Select the name of the file and the location you want to save it.
[BCB:299:UKI - Personal content block - Dane:ECB]
[BCB:304:UKI - Search override - Payroll UK:ECB]
[BCB:276:UKI - hide back button:ECB]
|