Versions Compared

Version Old Version 27 New Version 28
Changes made by

Fiona Sims

Miriam Cox

Saved on

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.

...

Expand
title12 Month Tenure Report - Easily Identify A Payee's Tenure over the previous 12 months

Report lists Hours, Days and Weeks worked by a Payee over 12 months prior to a user defined Date. Report also filters by Employment Start Date (Defaulted to 1 year) and Pay Company. 

 The report has 2 date filters the first filter is the as at date.  This is the date the report is run from.  The report will return a summary of all Hours, Days and Weeks worked within the 12 month period prior to the as at date.  The Pay Period/ Adjustment Period End Date is use to determine what falls within this time frame.  Hours are calculated based on the Pay Code Type of Hours only.  If a Pay Code is set as Units it will not appear in the calculation. Days are calculated based off distinct Days worked where a pay code has been paid with the Pay Code Type of Hours has been paid.  Weeks Worked are calculated based off distinct Weeks worked.

 The Employed Before date is used to filter out Employees based on their Employment Start date.  This date Default to 1 year prior to the time of running the report.  If an employee is employed after this date they will not show on this report.

 As each Pay Company has it’s own ABN the report is grouped by Pay Company.  If a Payee works across multiple Pay Companies then the calculations are only based for hours worked under that Pay Company, the calculations are not combined.

Grouped By

N/A

Filter By

As At Date (12 months prior to this date)

Employed Before (defaults to 1 year prior to current date)

Pay Company

Report Fields

 

Payee

Pay Company

Payee Number

Candidate Number

Employment Start Date

Last Worked Date

Tax Type

Hours Worked

Days Worked

Weeks Worked

Taxable Earnings

Report Status

Updated Report October 2020

Office
Expand

Grouped By

titleBSB Not Found Report - Check Payees for BSB / Branch Not Found List
Image Removed

Report lists all Payee Bank Accounts that have a BSB Number that is not in the system. 

GST/VAT Paid Report - High Level grouped view of GST/VAT paid by Type
Image Added

Report details all GST paid for a user defined Payment date Period. Data is Grouped by Country, Pay Company, Brand, Region, Office and Item Type.

Grouped By

Country

Pay Company

Brand

Region

Office

Item Type

Filter By

Country

Brand

Region

Office

Payment Date Range

Report Fields

 

Payee No

Country

Payee

Pay Company

Account

Brand Name

Branch Number

Region Name

Branch

Report Status

Office Name

Account Number

Item

Amount Paid

GST Paid

Total Paid

Report Status

Updated Report October 2020

Payee

Payee No

Candidate No

Tax Type

Days Worked

Hours Worked

Units Paid

Gross Pay

Non Taxable Allowance

Reimbursement

Gross Deduction

Taxable Wage

Tax

Net Deductions

Net Pay

GST

Super 
Expand
titleDetailed Grouped Pay Code by Pay Batch Report - Detailed Pay Batch Report Grouped to give total for user defined periods
Image Removed

Report lists detailed Pay Batch Information for Payees.  Report is similar to the Detailed Pay Batch Report but rather than showing a line for each pay Batch per Payee, all Pay Batched are grouped together per Payee.

Grouped By

Payee

Filter By

See all Deductions set up on a Payee at a given time
Image Added

This report will total Pay Codes paid in a pay batch by Candidate and pay rate.  The report allows for a user to run report by Pay Batch range or Payment Date to get an understanding of all pay codes being paid.  The report is Grouped by Country and Pay Code.

Grouped By

Country

Pay Code

Filter By

Country

Brand

Region

Office

Pay

Batch No

Code Type

Pay Code Name

Pay Batch From

Pay Batch

No

To

Payment Date From

Payment Date To

Report Fields

 

Country

Pay Code Name

Payee First Name

Payee Surname

Candidate No

Payee

No

Report Fields

 

Number

Candidate Number

Pay Quantity

Pay Rate

Pay Total

Report Status

Updated

New Report October 2020

BSB Number

Account Number

Candidate Name

Payee No

Candidate No 
Expand

Report Fields

 

titleDuplicate Bank Details (AU) - Identify potentially suspect Payee Bank Account Details for Australia
Image Removed

Report returns a list of records where the same bank details are recorded against different Candidates. It is possible to have the same bank details recorded against the same Candidate Number across multiple Payee Records, so these results are excluded.

Grouped By

N/A

Filter By

N/A

Pay Code Group - Pay Code Report - Easily see all Pay Codes linked to a Pay Code Group - Great for updating
Image Added

Report lists all pay codes linked to a Pay Code Group (both Rates and Rules and Payroll) at a given point and time.  Where a Paycode is linked because it belongs to a linked Pay Code Type then the Pay Code name will appear with the Linked Pay Code Type in brackets.

Grouped By

Pay Code Group

Filter By

Country

Pay Code Group Name

Pay Code Group Type

As at Date

Report Fields

Pay Code Group Name

Pay Code Group Type

Pay Code Name

Report Status

Updated Report October 2020

N/A
Expand

Filter By

titleDuplicate Bank Details (NZ)- Identify potentially suspect Payee Bank Account Details for New Zealand
Image Removed

Report returns a list of records where the same bank details are recorded against different Candidates. It is possible to have the same bank details recorded against the same Candidate Number across multiple Payee Records, so these results are excluded.

Grouped By

N/A

Payee Deductions Report - See all Deductions set up on a Payee at a given time
Candidate
Image Added

Report lists all Payees with an active deduction on or after a selectable date. Handy report to see what Deductions are outstanding especially useful for Rolling deductions and Over payments

Grouped By

Office

Filter By

Country

Brand

Region

Office

Deduction Name

As At Date

Report Fields

 

NCC

Account Number

Account Suffix

Office Name

Payee No

Candidate No

Report Status

Updated Report October 2020

Expand
titleGST Paid Report - High Level grouped view of GST paid by Type
Image Removed

Report details all GST paid for a user defined Payment date Period. Data is Grouped by Country, Pay Company, Brand, Region, Office and Item Type.

Grouped By

Country

Pay Company

Brand

Region

Office

Item Type

Payee Name

Deduction Name

Calculation Type

Calculated On

Apply To

Deduction Start Date

Deduction End Date

Rolling Deduction Flag

Outstanding Balance (Rolling Deductions Only)

Net Protected Amount

Deduction Reference

Report Status

Updated Report October 2020

Payroll -> AU

Expand
titleBSB Not Found Report - Check Payees for BSB / Branch Not Found List
Image Added

Report lists all Payee Bank Accounts that have a BSB Number that is not in the system. 

Grouped By

Office

Filter By

Country

Brand

Region

Office

Payment Date Range

Report Fields

 

Country

Payee No

Pay Company

Payee

Brand

Account Name

Region Name

Branch Number

Office

Branch Name

Item

Amount Paid

GST Paid

Total Paid

Account Number

Report Status

Updated Report October 2020

Candidate Details

Candidate ID

First Name

Middle Name

Surname

Salutation

Previous Name

Gender

Marital Status

DOB

Address Line One

Address Line Two

Address Line Three

City

Suburb

Postcode

Country

Mailing Address Line One

Mailing Address Line Two

Mailing Address Line Three

Mailing City

Mailing Suburb

Mailing Postcode

Mailing Country

Mobile#

After Business Phone#

After Hours Phone#

Email One

Email Two

Preferred Contact Method

Emergency Contact Name

Emergency Contact Phone

Emergency Contact Relationship

Passport Number

Social Security Number

Drivers Licence

Linkedin URL

Facebook URL

Twitter URL

Place of Birth

 Nationality

 Portal Username

 Height

 Weight

File Attachment

File Name

Attachment Type

Comment Details

Created Date

Standard Description

Comment

Custom Field Details

Field Type

Field Label

Field Value

Leave Request Details

Leave Type

Status

Start Date

End Date

Attachments Name

Comments

Payee Details

Payee ID

IRD Number (NZ only)

NI Number (UK only)

Employment Start Date

Employment End Date

Company Name

Company Identifier

UTR Number (UK only)

Partnership UTR Number (UK only)

VAT Registration Number (UK only)

Company Address Line One

Company Address Line Two

Company Address Line Three

Company Suburb

Company City

Company State

Company Postcode

Company Country

Termination Reason

Bank Details

Payee ID

Account Name

Account Number

BSB Number (AU only)

NCC Number (NZ only)

Account Reference

Account Suffix (NZ only)

Sort Code (UK only)

Building Society Number (UK only)

BIC Code (UK only)

Pension Details

Payee ID

Pension Name (UK only)

Superannuation Fund Name (AU only)

USI (AU only)

Policy Number

Opt In Notice Received Date (UK only)

Opt Out Notice Received Date (UK only)

Opt Out Reference (UK only)

Registration Date (UK only)

Withdraw Date (UK only)

Postponement Type (UK only)

Postponement Start Date (UK only)

Postponement End Date (UK only).

Expand
titleIndividuals Right to Data Extract Report

This report can be used to extract a candidate’s data if the candidate requests their data under privacy by design/individuals right to data provisions.

The report is designed to be extracted into a Microsoft Excel file and will extract each set of details onto a separate datasheet.

Grouped By

Candidate Details

File Attachment

Comment Details

Custom Field Details

Leave Request Details

Payee Details

Bank Details

Pension Details

Filter By

Candidate ID

Report Fields

 

Report Status

Updated Report July 2022

Expand
titleJobKeeper Reference Period Hours Report - This report can be used to identify payees who are eligible for Job Keeper Payment and to establish if they meet the threshold for the tier 1 payment.
Image Removed

The report will return any PAYG Payees who have an employment Start Date on or prior to the 1st of July 2019.  The report then associates the Pay Group they belonged to at the end of the Pre March and Pre July periods.  The report will then total all hours of Paycodes of the Type of Ordinary, Overtime and Leave and with the Unit Type of Hours earned within each of the 28 day reference periods. Note the 28 Days is calculated from the last full payment period for both Pre March and Pre July periods.

 If the Payee has worked 80 hours or more for either the Pre March Or Pre July period they will identify as meeting the threshold.

Expand
titleNZ Stats Report - A handy Report For Statistical Reporting
Image Removed

Report has been created to assist with compiling data for Statistics New Zealand. A number of assumptions have been made and data should be check prior to using this information for reporting. An Employees Employment type will populate as Full Time if the average weekly hours are 30 hours or greater. if hours are less than 30 then Part Time will be populated. Ordinary Hours will only populate if the Pay Code is of the Pay Code Type of Ordinary or Leave and of the unit type of hours. Ordinary Wage is inclusive of taxable allowances. Overtime hours and wage will only include those pay items of the Pay Code type of Overtime.

Grouped By

Pay Company

Office

Filter By

Brand

Region

Office

Pay Company

Item Date Range

Report Fields

 

Pay Company

Office

Employment Type

Gender

Employee Count

Ordinary Time Pay

Ordinary Time Hours

Overtime Pay

Overtime Hours

Duplicate Bank Details (AU) - Identify potentially suspect Payee Bank Account Details for Australia
Image Added

Report returns a list of records where the same bank details are recorded against different Candidates. It is possible to have the same bank details recorded against the same Candidate Number across multiple Payee Records, so these results are excluded.

Grouped By

N/A

Filter By

N/A

Report Fields

 

BSB Number

Account Number

Candidate Name

Payee No

Candidate No 

Report Status

Updated Report October 2020

Expand
titleDetailed Grouped Pay Batch (AU) Report - Detailed Pay Batch Report Grouped to give total for user defined periods
Image Added

Report lists detailed Pay Batch Information for Payees.  Report is similar to the Detailed Pay Batch Report but rather than showing a line for each pay Batch per Payee, all Pay Batched are grouped together per Payee.

Grouped By

Payee

Filter By

Brand

Region

Office

Pay Batch No From

Pay Batch No To

Payment Date From

Payment Date To

Payee First Name

Payee Surname

Candidate No

Payee No

Report Fields

 

Payee

Payee No

Candidate No

Tax Type

Days Worked

Hours Worked

Units Paid

Gross Pay

Non Taxable Allowance

Reimbursement

Gross Deduction

Taxable Wage

Tax

Net Deductions

Net Pay

GST

Super 

Report Status

Updated Report October 2020

Expand
titleJobKeeper Reference Period Hours Report - This report can be used to identify payees who are eligible for Job Keeper Payment and to establish if they meet the threshold for the tier 1 payment.
Image Added

The report will return any PAYG Payees who have an employment Start Date on or prior to the 1st of July 2019.  The report then associates the Pay Group they belonged to at the end of the Pre March and Pre July periods.  The report will then total all hours of Paycodes of the Type of Ordinary, Overtime and Leave and with the Unit Type of Hours earned within each of the 28 day reference periods. Note the 28 Days is calculated from the last full payment period for both Pre March and Pre July periods.

 If the Payee has worked 80 hours or more for either the Pre March Or Pre July period they will identify as meeting the threshold.

Expand
titlePay Code Group - Pay Code Report - Easily see all Pay Codes linked to a Pay Code Group - Great for updating
Image Added

Report lists all pay codes linked to a Pay Code Group (both Rates and Rules and Payroll) at a given point and time.  Where a Paycode is linked because it belongs to a linked Pay Code Type then the Pay Code name will appear with the Linked Pay Code Type in brackets.

Grouped By

Pay Code Group

Filter By

Country

Pay Code Group Name

Pay Code Group Type

As at Date

Report Fields

Pay Code Group Name

Pay Code Group Type

Pay Code Name

Report Status

Updated Report October 2020

Expand
titlePay Code Wage Oncost Report - All Wage Oncosts linked against a Paycode
Image Added

Report lists all Pay Codes and their associated Wage Oncosts as at a point in time defined by the user.  As Pay Code Groups are configurable in Pay Maintenance the report has been configured to use predefined Pay Code Group Names of Payroll Tax, Workers Compensation, Superannuation and Employee Benefits.  If configuration is different to this or additional groups have been created, then this report will need to be modified by FastTrack to support your configuration. 

Grouped By

N/A

Filter By

As at Date

Report Fields

Pay Code Name

Pay Code Type

Unit Type

Active Status

Payroll Tax Linked

Worker Compensation Linked

Superannuation Linked

Employee Benefits Linked

Report Status

Updated Report October 2020

Expand
titlePayee Grouped Earnings Report - Detailed Earning Report for a Payee - Handy for Centerlink Reporting
Image Added

Report details all earnings (Pay Elements) for a Payee within a user defined Payment Date Time Period.

Grouped By

Payee

Filter By

Brand

Region

Office

Pay Batch Range

Candidate No

Payment Date Range

Payee No

Payee First Name

Payee Surname

Report Fields

 

Payee No

Payee Name

Date of Birth

Tax Type

Main Address

Pay Company

Employment Start Date

Employment End Date

Payment Dates

Pay Code

Pay Code Type

Qty

Hours

Units

Rate

Total

Gross Wages

Non Taxable Allowance

Reimbursement

Non Taxable Wages

Tax

Net Deductions

Net Wages

Superannuation 

Report Status

Updated Report October 2020

Expand
titlePayee Record Detail Export Report (AU) - Export New Payee Details for easy data checking
Image Added

Report lists all Payees created within a selectable date range and provides a detailed report designed to be exported containing all relevant Payee information, including but not limited to Bank, Tax and Super.  Report is designed to check data entry of Payee information. 

Grouped By

N/A

Filter By

Brand

Region

Office

Creation Date

Report Fields

All relevant Payee Record details

Report Status

Updated Report October 2020

Pay Code Group Name

Pay Code Group Type

Pay Code Name
Expand
titleNZ 12 Month Average Hours Payee Super Check Report - Easily Identify A Payee's Average Hours over the previous 12 months
Image Removed

Report lists Hours, Days and Weeks worked by a Payee over 12 months prior to a user defined Date. Report also filters by Last Worked Date and Pay Company.  

The report has 2 date filters the first filter is the as at date.  This is the date the report is run from.  The report will return a summary of all Hours, Days and Weeks worked within the 12 month period prior to the as at date.  The Report Calculates how many weeks Payee was Employed in the 12 month period. The Pay Period/ Adjustment Period End Date is use to determine what falls within this time frame.  Hours are calculated based on the Pay Code Type of Hours only.  If a Pay Code is set as Units it will not appear in the calculation. Days are calculated based off distinct Days worked where a pay code has been paid with the Pay Code Type of Hours has been paid.  Weeks Worked are calculated based off distinct Weeks worked. 

The Average Weekly Hours are calculated by dividing the number of Hours worked by the number of week Employed. Average Weekly Gross Wage is calculated by dividing the Taxable Earnings in the period by the number of Employed Weeks. 

If the Average Hours worked per week is less than 20 hours they will be classified as Part Time. If they are 20 or above they will be classified as Full Time. 

The Last worked date filter is used to filter out Employees based on when the Payee last worked.  If an employee last worked date is not within the date range they will not show on this report. 

As each Pay Company has it’s own ABN the report is grouped by Pay Company.  If a Payee works across multiple Pay Companies then the calculations are only based for hours worked under that Pay Company, the calculations are not combined.

Grouped By

N/A

Filter By

As At Date

Last Worked

Pay Company

Report Fields

 

Payee First Name

Payee Surname

Pay Company

IRD Number

Date Of Birth

Payee Number

Candidate Number

Employment Start Date

Last Worked Date

Tax Type

Weeks Employed

Hours Worked

Days Worked

Weeks Worked

Taxable Earnings

Average Weekly Hours

Average Weekly Gross Wage

Classification

Report Status

Updated Report October 2020

Expand
titlePay Code by Pay Batch Report - See all Deductions set up on a Payee at a given time
Image Removed

This report will total Pay Codes paid in a pay batch by Candidate and pay rate.  The report allows for a user to run report by Pay Batch range or Payment Date to get an understanding of all pay codes being paid.  The report is Grouped by Country and Pay Code.

Grouped By

Country

Pay Code

Filter By

Country

Brand

Region

Office

Pay Code Type

Pay Code Name

Pay Batch From

Pay Batch To

Payment Date From

Payment Date To

Report Fields

 

Country

Pay Code Name

Payee First Name

Payee Surname

Payee Number

Candidate Number

Pay Quantity

Pay Rate

Pay Total

Report Status

New Report October 2020

Expand
titlePay Code Group - Pay Code Report - Easily see all Pay Codes linked to a Pay Code Group - Great for updating
Image Removed

Report lists all pay codes linked to a Pay Code Group (both Rates and Rules and Payroll) at a given point and time.  Where a Paycode is linked because it belongs to a linked Pay Code Type then the Pay Code name will appear with the Linked Pay Code Type in brackets.

Grouped By

Pay Code Group

Filter By

Country

Pay Code Group Name

Pay Code Group Type

As at Date

Report Fields

Find possible Payee Super Configuration errors at the push of a button
Image Added

Using the current date, this report checks for possible Payee Super Errors. When a Payee has more than one Super Rate Rule assigned to their record and error will be returned. The Report also lists PAYG Candidates who are exempt or have no Super Rule. 

Grouped By

N/A

Filter By

N/A

Report Fields

Office

Payee No

Candiate No

Candidate

Tax Type

Employment Type

Super Fund

Rate Rule

Super Exempt Flag

Error

Report Status

Updated Report October 2020

Expand
titleSuper Fund USI Search Report - Use the USI to search for Super Funds
Image Added

Report has been created to allow a user to search for a Super Fund based on the Super Fund USI. Report can be used to return all configured Super Fund Information.

Grouped By

N/A

Filter By

Contribution Period

Fund Name

USI

Report Fields

Fund Name

Reporting Name

SPIN

ABN

SFN

USI

Contribution Period

Report Status

Updated Report October 2020

Expand
titleTaxable Payments Annual Report (TPAR)

The TPAR reports payments that have been made to company contractors during the financial year that has concluded. If you are required to lodge a TPAR you can now generate a TPAR from FastTrack360 in a format that will allow you to upload the report to the via the file transfer function in the ATO Business Portal.

The TPAR is generated in an ATO-specified format that is not designed to be human readable. You can check the contractor gross and GST amounts that will be reported via the TPAR by running the Contractor Payments report, which will present the data in a user-friendly format.

When saving the report file from the Reports module so that it can be uploaded to the ATO, please note the following:

  • The file must be saved as Text, as shown in the example below.

Image Added

  • In the Export Settings, you must select the US-ASCII encoding option, as shown below.

Image Added

Grouped By

N/A

Filter By

Pay Company Name

Payment Date From

Payment Date To

Report Fields

N/A

Report Status

Updated Report June 2021

Payroll → NZ

Expand
titleDuplicate Bank Details (NZ)- Identify potentially suspect Payee Bank Account Details for New Zealand
Image Added

Report returns a list of records where the same bank details are recorded against different Candidates. It is possible to have the same bank details recorded against the same Candidate Number across multiple Payee Records, so these results are excluded.

Grouped By

N/A

Filter By

N/A

Report Fields

 

NCC

Account Number

Account Suffix

Candidate Name

Payee No

Candidate No

Report Status

Updated Report October 2020

Expand
titleNZ Stats Report - A handy Report For Statistical Reporting
Image Added

Report has been created to assist with compiling data for Statistics New Zealand. A number of assumptions have been made and data should be check prior to using this information for reporting. An Employees Employment type will populate as Full Time if the average weekly hours are 30 hours or greater. if hours are less than 30 then Part Time will be populated. Ordinary Hours will only populate if the Pay Code is of the Pay Code Type of Ordinary or Leave and of the unit type of hours. Ordinary Wage is inclusive of taxable allowances. Overtime hours and wage will only include those pay items of the Pay Code type of Overtime.

Grouped By

Pay Company

Office

Filter By

Brand

Region

Office

Pay Company

Item Date Range

Report Fields

 

Pay Company

Office

Employment Type

Gender

Employee Count

Ordinary Time Pay

Ordinary Time Hours

Overtime Pay

Overtime Hours

Report Status

Updated Report October 2020

Payee
Expand
Image Removed

This report has been created to assist reconciling the deduction amounts that are required to be paid forward to the New Zealand IRD for each filing period.

Grouped By

N/A

Filter By

Payment Date From

Payment Date To

Report Fields

Pay Batch No

Payment Date

Gross Earnings

ACC Levy Exempt Earnings

Tax

Child Support

Student Loan

SLCIR

SLBOR

Employer KiwiSaver

Employee KiwiSaver

Payroll Donation Tax Credit

ESCT

Report Status

New Report July 2022

Expand
titlePayee Deductions Report - See all Deductions set up on a Payee at a given time
Image Removed

Report lists all Payees with an active deduction on or after a selectable date. Handy report to see what Deductions are outstanding especially useful for Rolling deductions and Over payments

Grouped By

Office

Filter By

Country

Brand

Region

Office

Deduction Name

As At Date

Report Fields

 

Office Name

Payee No

Payee Name

Deduction Name

Calculation Type

Calculated On

Apply To

Deduction Start Date

Deduction End Date

Rolling Deduction Flag

Outstanding Balance (Rolling Deductions Only)

Net Protected Amount

Deduction Reference

Report Status

Updated Report October 2020

Expand
titlePayee Grouped Earnings Report - Detailed Earning Report for a Payee - Handy for Centerlink Reporting
Image Removed

Report details all earnings (Pay Elements) for a Payee within a user defined Payment Date Time Period.

Grouped By

titlePay Code Wage Oncost Report - All Wage Oncosts linked against a Paycode
Image Removed

Report lists all Pay Codes and their associated Wage Oncosts as at a point in time defined by the user.  As Pay Code Groups are configurable in Pay Maintenance the report has been configured to use predefined Pay Code Group Names of Payroll Tax, Workers Compensation, Superannuation and Employee Benefits.  If configuration is different to this or additional groups have been created, then this report will need to be modified by FastTrack to support your configuration. 

Grouped By

N/A

Filter By

As at Date

Report Fields

Pay Code Name

Pay Code Type

Unit Type

Active Status

Payroll Tax Linked

Worker Compensation Linked

Superannuation Linked

Employee Benefits Linked

Report Status

Updated Report October 2020

Expand
titlePayday Reconciliation Report (NZ)
NZ 12 Month Average Hours Report - Easily Identify A Payee's Average Hours over the previous 12 months
Image Added

Report lists Hours, Days and Weeks worked by a Payee over 12 months prior to a user defined Date. Report also filters by Last Worked Date and Pay Company.  

The report has 2 date filters the first filter is the as at date.  This is the date the report is run from.  The report will return a summary of all Hours, Days and Weeks worked within the 12 month period prior to the as at date.  The Report Calculates how many weeks Payee was Employed in the 12 month period. The Pay Period/ Adjustment Period End Date is use to determine what falls within this time frame.  Hours are calculated based on the Pay Code Type of Hours only.  If a Pay Code is set as Units it will not appear in the calculation. Days are calculated based off distinct Days worked where a pay code has been paid with the Pay Code Type of Hours has been paid.  Weeks Worked are calculated based off distinct Weeks worked. 

The Average Weekly Hours are calculated by dividing the number of Hours worked by the number of week Employed. Average Weekly Gross Wage is calculated by dividing the Taxable Earnings in the period by the number of Employed Weeks. 

If the Average Hours worked per week is less than 20 hours they will be classified as Part Time. If they are 20 or above they will be classified as Full Time. 

The Last worked date filter is used to filter out Employees based on when the Payee last worked.  If an employee last worked date is not within the date range they will not show on this report. 

As each Pay Company has it’s own ABN the report is grouped by Pay Company.  If a Payee works across multiple Pay Companies then the calculations are only based for hours worked under that Pay Company, the calculations are not combined.

Grouped By

N/A

Filter By

As At Date

Last Worked

Pay Company

Report Fields

 

Payee First Name

Payee Surname

Pay Company

IRD Number

Date Of Birth

Payee Number

Candidate Number

Employment Start Date

Last Worked Date

Tax Type

Weeks Employed

Hours Worked

Days Worked

Weeks Worked

Taxable Earnings

Average Weekly Hours

Average Weekly Gross Wage

Classification

Report Status

Updated Report October 2020

Expand
titlePayday Reconciliation Report (NZ)
Image Added

This report has been created to assist reconciling the deduction amounts that are required to be paid forward to the New Zealand IRD for each filing period.

Grouped By

N/A

Filter By

Payment Date From

Payment Date To

Report Fields

Pay Batch No

Payment Date

Gross Earnings

ACC Levy Exempt Earnings

Tax

Child Support

Student Loan

SLCIR

SLBOR

Employer KiwiSaver

Employee KiwiSaver

Payroll Donation Tax Credit

ESCT

Report Status

New Report July 2022

UK Statutory Parameters - Attachment of Earnings Orders
Expand
titlePayee Detailed Export Report (NZ) - Export New Payee Details for easy data checking
Expand
title
Image Added

Report lists all Payees created within a selectable date range and provides a detailed report designed to be exported containing all relevant Payee information, including but not limited to Bank, Tax and Super.  Report is designed to check data entry of Payee information. 

Grouped By

N/A

Filter By

Brand

Region

Office

Pay Batch Range

Candidate No

Payment Date Range

Payee No

Payee First Name

Payee Surname

Report Fields

 

Payee No

Payee Name

Date of Birth

Tax Type

Main Address

Pay Company

Employment Start Date

Employment End Date

Payment Dates

Pay Code

Pay Code Type

Qty

Hours

Units

Rate

Total

Gross Wages

Non Taxable Allowance

Reimbursement

Non Taxable Wages

Tax

Net Deductions

Net Wages

Superannuation 

Report Status

Updated Report October 2020

Expand
titlePayee Record Detail Export Report (AU) - Export New Payee Details for easy data checking
Image Removed

Report lists all Payees created within a selectable date range and provides a detailed report designed to be exported containing all relevant Payee information, including but not limited to Bank, Tax and Super.  Report is designed to check data entry of Payee information. 

Grouped By

N/A

Filter By

Brand

Region

Office

Creation Date

Report Fields

All relevant Payee Record details

Report Status

Updated Report October 2020

Expand
titlePayee Detailed Export Report (NZ) - Export New Payee Details for easy data checking
Image Removed

Report lists all Payees created within a selectable date range and provides a detailed report designed to be exported containing all relevant Payee information, including but not limited to Bank, Tax and Super.  Report is designed to check data entry of Payee information. 

Grouped By

N/A

Filter By

Brand

Region

Office

Creation Date

Report Fields

All relevant Payee Record details

Report Status

Updated Report October 2020

Expand
titlePayee Super Check Report - Find possible Payee Super Configuration errors at the push of a button
Image Removed

Using the current date, this report checks for possible Payee Super Errors. When a Payee has more than one Super Rate Rule assigned to their record and error will be returned. The Report also lists PAYG Candidates who are exempt or have no Super Rule. 

Grouped By

N/A

Filter By

N/A

Report Fields

Office

Payee No

Candiate No

Candidate

Tax Type

Employment Type

Super Fund

Rate Rule

Super Exempt Flag

Error

Report Status

Updated Report October 2020

Expand
titleSuper Fund USI Search Report - Use the USI to search for Super Funds
Image Removed

Report has been created to allow a user to search for a Super Fund based on the Super Fund USI. Report can be used to return all configured Super Fund Information.

Grouped By

N/A

Filter By

Contribution Period

Fund Name

USI

Report Fields

Fund Name

Reporting Name

SPIN

ABN

SFN

USI

Contribution Period

Report Status

Updated Report October 2020

Expand
titleTaxable Payments Annual Report (TPAR)

The TPAR reports payments that have been made to company contractors during the financial year that has concluded. If you are required to lodge a TPAR you can now generate a TPAR from FastTrack360 in a format that will allow you to upload the report to the via the file transfer function in the ATO Business Portal.

The TPAR is generated in an ATO-specified format that is not designed to be human readable. You can check the contractor gross and GST amounts that will be reported via the TPAR by running the Contractor Payments report, which will present the data in a user-friendly format.

When saving the report file from the Reports module so that it can be uploaded to the ATO, please note the following:

  • The file must be saved as Text, as shown in the example below.

Image Removed

  • In the Export Settings, you must select the US-ASCII encoding option, as shown below.

Image Removed

Grouped By

N/A

Filter By

Pay Company Name

Payment Date From

Payment Date To

Report Fields

N/A

Report Status

Updated Report June 2021

Creation Date

Report Fields

All relevant Payee Record details

Report Status

Updated Report October 2020

Payroll → UK

Expand
titleAllowances (UK) - Lists all allowances paid to a payee
Image Added

Report will list all Allowance payments that have been paid to a payee within a user defined date period.

Grouped By

Payee

Filter By

Pay Company

Brand

Region

Office

Pay Group

Employment Type

Pay Batch type

Tax Type

Pay Batch number range

Pay Period End Date range

Payment Date range

Report Fields

 

Payee First and Surname

Payee Number

Tax Type/Payee Type

Employment Type

Pay Group

Allowance Name

Taxable value

Non taxable value

Total value

Report Status

Expand
titleGender Pay Gap Report
Image Added

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

Expand
titleAWR Report (UK)

Image Added

The report outputs a clock history for each candidate for each job. This is a report that is available to help manage AWR.

Grouped By

Candidate No

Job No

Filter By

Brand Name

Region Name

Office Name

Client Name

Candidate Number

As At Date - Retrieves jobs that have an active job on or after this date and where timesheet data data exists on or prior to this date. If the job does not last for 12 weeks or more, the job will not be output.

Clock Count From

Clock Count To

Report Fields

Job Start Date

Job End Date

Rate - This is the pay code defined as included in Job Rate Estimate. If that has not been configured against the pay code, the value will be 0.00.

Uplift - This is a value entered into a Job Custom Field that is defined with the word ‘Uplift’ to enter the value of the parity rate.

Enhanced Holiday % - This is a value entered into a Job Custom Field that is defined with the word ‘Additional’ within it to enter the enhanced holiday percentage.

Timesheet Start

Clock Count

Hours Worked - If the payee has not worked, this will be output as ‘Not Worked’

Expand
titleUK Statutory Parameters - Attachment of Earnings Orders Rate Table

Displays the earning thresholds and rates for rate based AEOs.

...

Expand
titleVariance Report - Compare Current and Previous Periods

Report compare a user defined period with a previous period of the same length. For example if the report is run for 7 days then it will be compared to the previous 7 days. Based on Payment, the report will group and compare all candidates worked, hours worked, invoiced revenue, uninvoiced revenue and total revenue per client and office.

Grouped By

Office

Client Name

Filter By

Country

Brand Name

Region Name

Office Name

Payment Date Range

Report Fields

Office Name

Client Name

Current Period

Current Candidates Out

Current Hours

Current Invoiced

Current Uninvoiced

Current Total Revenue

Previous Candidates Out

Previous Hours

Previous Invoiced

Previous Uninvoiced

Previous Total Revenue

Variance Candidate

Variance Hours

Variance Revenue

Report Status

Updated Report October 2020

Compliance

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

Job Start Date

Job End Date

Rate - This is the pay code defined as included in Job Rate Estimate. If that has not been configured against the pay code, the value will be 0.00.

Uplift - This is a value entered into a Job Custom Field that is defined with the word ‘Uplift’ to enter the value of the parity rate.

Enhanced Holiday % - This is a value entered into a Job Custom Field that is defined with the word ‘Additional’ within it to enter the enhanced holiday percentage.

Timesheet Start

Clock Count

Hours Worked - If the payee has not worked, this will be output as ‘Not Worked’
Expand
titleGender Pay Gap Individuals Right to Data Extract Report
Image Removed

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

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

Expand
titleAWR Report (UK)
Image Removed

The report outputs a clock history for each candidate for each job. This is a report that is available to help manage AWR.

Grouped By

Candidate No

Job No

Filter By

Brand Name

Region Name

Office Name

Client Name

Candidate Number

As At Date - Retrieves jobs that have an active job on or after this date and where timesheet data data exists on or prior to this date. If the job does not last for 12 weeks or more, the job will not be output.

Clock Count From

Clock Count To

Report Fields

This report can be used to extract a candidate’s data if the candidate requests their data under privacy by design/individuals right to data provisions.

The report is designed to be extracted into a Microsoft Excel file and will extract each set of details onto a separate datasheet.

Grouped By

Candidate Details

File Attachment

Comment Details

Custom Field Details

Leave Request Details

Payee Details

Bank Details

Pension Details

Filter By

Candidate ID

Report Fields

 

Candidate Details

Candidate ID

First Name

Middle Name

Surname

Salutation

Previous Name

Gender

Marital Status

DOB

Address Line One

Address Line Two

Address Line Three

City

Suburb

Postcode

Country

Mailing Address Line One

Mailing Address Line Two

Mailing Address Line Three

Mailing City

Mailing Suburb

Mailing Postcode

Mailing Country

Mobile#

After Business Phone#

After Hours Phone#

Email One

Email Two

Preferred Contact Method

Emergency Contact Name

Emergency Contact Phone

Emergency Contact Relationship

Passport Number

Social Security Number

Drivers Licence

Linkedin URL

Facebook URL

Twitter URL

Place of Birth

 Nationality

 Portal Username

 Height

 Weight

File Attachment

File Name

Attachment Type

Comment Details

Created Date

Standard Description

Comment

Custom Field Details

Field Type

Field Label

Field Value

Leave Request Details

Leave Type

Status

Start Date

End Date

Attachments Name

Comments

Payee Details

Payee ID

IRD Number (NZ only)

NI Number (UK only)

Employment Start Date

Employment End Date

Company Name

Company Identifier

UTR Number (UK only)

Partnership UTR Number (UK only)

VAT Registration Number (UK only)

Company Address Line One

Company Address Line Two

Company Address Line Three

Company Suburb

Company City

Company State

Company Postcode

Company Country

Termination Reason

Bank Details

Payee ID

Account Name

Account Number

BSB Number (AU only)

NCC Number (NZ only)

Account Reference

Account Suffix (NZ only)

Sort Code (UK only)

Building Society Number (UK only)

BIC Code (UK only)

Pension Details

Payee ID

Pension Name (UK only)

Superannuation Fund Name (AU only)

USI (AU only)

Policy Number

Opt In Notice Received Date (UK only)

Opt Out Notice Received Date (UK only)

Opt Out Reference (UK only)

Registration Date (UK only)

Withdraw Date (UK only)

Postponement Type (UK only)

Postponement Start Date (UK only)

Postponement End Date (UK only).

Report Status

Updated Report July 2022