Page Comparison

The report will use the As At Date to identify Payees who worked in a Pay Period that covers that date. The report will then display Pay Data for that Pay Period as well as Pay Data for the 12 Months prior, where the Payee Worked a Pay Period that covers the As At Date.

Grouped By

N/A

Filter By

As At Date

Pay Company

Report Fields

Pay Company

ABN

Payee No

Year Of Birth

GenderpayGender

Industry Name

Employment Type

Pay Group

Start Date

Snap Shot Period

Ordinary Hours

Overtime Hours

Ordinary Pay

Overtime Pay

Allowance Pay

Total Pay

12 Month Period

Ordinary Hours

Overtime Hours

Ordinary Pay

Overtime Pay

Allowance Pay

Total Pay

Super

Report Status

Updated Report October 2020

The report allows users to export data to csv to allow for required grouping to output data to the employer’s website. Once the report renders to the screen, the user will need to export to csv.

In order to process this report, pay code groups need to be set up to define what data is output into the columns.

Ordinary pay - To identify the pay codes that are classified as ordinary pay.

Bonus pay - To identify the pay codes that are classified as bonus payments.

Exclusion of Pay Codes for Full-Pay Relevant Payees - To identify pay codes that exclude payees as being full-pay payees. If in the relevant period a payee has a pay code in this filter, they will not have the category of full-pay relevant payee.

Hours Worked - To identify the pay codes for the units to include for the determination of hours worked.

Grouped By

Filter By

Snapshot Date - Identifies the date on which the report should be run from.

Select the Pay Company that the report should be run for.

Select the Pay Code Group that defines Ordinary Earnings.

Select the Pay Code Group that defines Bonus Payments.

Select the Pay Code Group that defines Hours Worked.

Select Relevant Payee Pay Code Group. This defines those pay codes that should not be considered for the definition of Full-Pay relevant employees. Where a payee is not paid their usual rate such as people on unpaid compassionate leave or unpaid sabbaticals, they would not be considered a Full-pay relevant employee. 

If an employee is on any kind if leave and not being paid their full usual amount in the pay period, they are not full-pay relevant employees e.g. on SSP, SMP. 

If a person was paid less than usual in the pay period for reasons other than leave, they are still counted as full-pay employees.

You can exclude payees from the report by defining a conditional variable to exclude them. If you don’t have special circumstances to exclude payees, the filters ‘Select the Conditional Variable to Exclude Payees with this value’ and ‘Enter the Conditional Variable Value to Exclude’ can be left blank.

Enter the number of weeks to determine average pay and hours.

If payees should be excluded from the report, select the types or if you want to include all, select the option of 'None'.

Report Fields

Payee ID

Payee Type

Payee Category

Gender

Ordinary Pay

Bonus Pay

Bonus Pay Previous 12 Months

Total Working Hours

Average Weekly Hours

Normal Working Hours - This field is the value on the payee entry screen where you can enter the normal weekly hours if the payee is daily rate driven.

Hourly Rate