Statistics Reporting

Overview

Employers can be required to provide a breakdown of wages earned by employees, split by both engagement (full time, part time, and casual) and work classification (ordinary or overtime hours).

The Reports > Management > Statistics Report summarises employee hours and earnings by both engagement type and the classification you assign to each of the Pay Items used in an employee’s pay.

Configure Pay Items with a Statistic Classification

For data to be included in the Statistics Report, you will need to configure how each Pay Item in your portal should be classified.

This is set in the Statistic Classification field when adding a new pay item or allowance.

1. Go to Config > Payroll > Pay Items.
2. Click into a pay item or allowance to edit its settings.
3. Assign a Statistics Classification from the drop-down list:
   • Ordinary
   • Overtime
   • Excluded
   • None
4. Click Save.

The Statistics Classification setting will determine how hours worked and totals paid to employees using this pay item are reported in the Statistics Report. This field is not mandatory.

Data related to pay items or allowances with no Statistic Classification set will not appear in the Statistics Report.

Access the Statistics Report

The Reports > Management > Statistics Report summarises the hours worked and total paid for all employees that are included in a Paid pay run that falls during the filtered Pay Dates that you set.

Total Ordinary Hours	Reported as the sum of all hours worked by an employee using  pay items with a Statistics Classification of ‘Ordinary’
Total Ordinary Pay	Reported as the total amount paid to an employee using pay items with a Statistics Classification of ‘Ordinary’
Overtime Hours	Reported as the sum of all hours worked by an employee using pay items with a Statistics Classification of Overtime
Total Overtime Pay	Reported as the total amount paid to an employee using pay items with a Statistics Classification of Overtime

Employee data will be reported regardless of whether the employee is active, inactive, locked, or archived.

On-screen Columns

The Statistics Report will include a Report Summary that shows totals for all employees included in the report, with a breakdown of data split by employee underneath.

The Report Summary includes:

• Period
• Employees
• Total Ordinary Hours
• Total Ordinary Pay
• Total Overtime Hours
• Total Overtime Pay
• Salary Sacrifice Amount

The Details for each employee include:

• Employee
• Engagement
• Gender
• Total Ordinary Hours
• Total Ordinary Pay
• Overtime Hours
• Total Overtime Pay
• Salary Sacrifice Amount

Export Options

You can export the on-screen view in .pdf format or a summary of the report in .csv format. csv format. The .csv file contains the following columns:

• MID
• Employee
• Employee Remote ID
• Employee Type
• Engagement
• Gender
• Total Ordinary Hours
• Total Ordinary Pay
• Overtime Hours
• Total Overtime Pay
• Salary Sacrifice Amount
• Pay Date