Skip to content
logo Knowledgebase

The Average Earnings & Working Hours report

Created on  | Last modified on 

Summary

How to export the Average Earnings and Working Hours report in Sage Payroll.

Resolution

Use this report to help you calculate your employee's average earnings. This can help when:

  • Calculating redundancy payments
  • Reconciling statutory payments
  • Holiday entitlement
  • Working out pay for government help schemes

This is a generic report, so always seek guidance from ROS to make sure the report supports what you need.

You can export the report, so you can save it, edit the information and share it.

Generate the report

  1. From Reporting, select Average Earnings and Working Hours.

  2. 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

NOTE:

 Figures for pay periods that are partially covered by the date range you select are fully included. 

 

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.
Gross Pay (excluding BIK/Shares)

The total gross pay for the periods covered by the date range you entered for the report.

Gross Pay includes:

  • Regular Payments (normal earnings subject to all legislative deductions)
  • Overtime
  • Other Pay
  • Regular Bonus
  • Commission
  • Holiday Pay
  • Expenses
Total Hours

The number of work hours in the pay periods covered by the date range you entered for the report.

Total Hours will include any payments using an hourly holiday payment.
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.

The full pay period will include the average earnings and average hours if you select a date range that falls part-way through an employee's 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 Pay €4,000.00
Total Hours 300
Average Earnings €2,000.00
Average Hours 150

Exporting the Report

You can export the report to PDF or CSV. To do this:

  1. Run the report as normal.
  2. Select Export.
  3. Select the type of file you want to create, either PDF or CSV.
  4. Select the name of the file and the location you want to save it.

 



View More...