Versions Compared

Version Old Version 39 New Version Current
Changes made by

Fiona Sims

Fiona Sims

Saved on

Key

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

...

Info

All FT Standard Reports have apply a user’s Data Group Permissions.  This means that you will only see results for the Data Groups you have permissions for. Click here for more information on applying Data Groups to Custom Reports.

The FT Standard Reports include Hot Links where applicable.  Hot Links allow you to click on a field and have that record opened in a new tab.  If you hover over a field you will see a pop up to indicate where a Hot Link is configured.  Click here for more information on adding Hot Links to Custom Reports.

Report Updates (

...

November 2024)

New Reports

...

Bulk Anonymise Batch Candidate Report (12.23 Release AU/NZ)

This report has been created to assist reconciling the deduction amounts that are required to be paid forward to the IRD for each filing period. See the Payroll section below Stimulsoft report will allow you to review information relating Bulk Action - Anonymise Candidate batches. The report provides details on the items that were updated, by whom and when. Click here for more details.

FT Standard Report Library

...

Expand
title12 Month Tenure Report - Easily Identify A Payee's Tenure over the previous 12 months
image-20240731-230433.png

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 Employed Before date defaults to 1 year prior to the Tenure As At and excludes Payees who's Employment Start Date is after this date. Data is sorted by Payee Name (Surname, First name).

 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 V12.31

Pay Company

Payee
Expand
titleContractor Payments - View payments to Payees
Image Removed

Report provides payments to Payees with Tax Type ‘Company’ or ‘Contractor’, splitting earnings and GST/VAT. It separates non-reimbursement and reimbursement payments. Report is grouped by Country then Pay Company. Data is sorted by Country, Pay Company, Payee First Name then Payee Surname.

Grouped By

Invoiced VAT/GST Report
image-20240813-070148.pngImage Added

Report lists VAT that has been calculated as part of the proforma remittance generation process for VAT registered contractors. The Invoice Date from and Invoice Date To options refer to the earliest and latest proforma remittance creation dates respectively. The report only includes data linked to payees who are VAT registered contractors, where VAT has been calculated as part of the proforma remittance generation process prior to the contractor being paid in a pay batch.

Grouped By

N/A

Filter By

Country

Brand

Region

Office

Pay Company

Pay Group

Employment Type

Payment

Invoice Date From

Payment

Invoice Date To

Pay Period End Date From

Pay Period End Date To

Pay Batch From

Pay Batch To

Report Fields

 

Payee First Name

Payee Surname

Payee No

Employment Type

No of Payments

Total Amount Paid

Wages Amount

Reimbursement Amount

Total GST/VAT Paid

Wages GST/VAT

Adjustment GST/VAT

Report Status

Updated Report October 2020

Expand
titleGST/VAT Paid Report - High Level grouped view of GST/VAT paid by Type
image-20240731-232902.pngImage RemovedReport provides all GST/VAT paid by each Pay Company, split by Office and item type ‘Wages’ or ‘Reimbursement’

Payroll country

Pay company

Brand

Region

Office

Invoiced Date (i.e. date on which proforma remittance was created)

Pay Period End Date

Item (Wages or Reimbursement)

Amount

VAT/GST

Total

Report Status

Added Report V12.21P2

Expand
titleContractor Payments - View payments to Payees
Image Added

Report provides payments to Payees with Tax Type ‘Company’ or ‘Contractor’, splitting earnings and GST/VAT. It separates non-reimbursement and reimbursement payments. Report is grouped by Country then Pay Company. Data is sorted by Country, Pay Company,

Brand, Region, Office then Item Type

Payee First Name then Payee Surname.

Grouped By

CountryItem Type

Pay Company

Brand

Region

Office

Payee

Filter By

Country

Brand

Region

Office

Pay Company

Pay Group

Employment Type

Payment Date From

Payment

Date Range

Date To

Pay Period End Date From

Pay Period End Date To

Pay Batch From

Pay Batch To

Report Fields

 

Country

Pay Company

Brand Name

Region Name

Office Name

Item

Amount Paid

GST Paid

Total Paid

Payee First Name

Payee Surname

Payee No

Employment Type

No of Payments

Total Amount Paid

Wages Amount

Reimbursement Amount

Total GST/VAT Paid

Wages GST/VAT

Adjustment GST/VAT

Report Status

Updated Report October 2020

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 CodeImage RemovedCountry
Expand
titlePay Code by Pay Batch Report - See all Deductions set up on a Payee at a given time
GST/VAT Paid Report - High Level grouped view of GST/VAT paid by Type
image-20240731-232902.pngImage Added

Report provides all GST/VAT paid by each Pay Company, split by Office and item type ‘Wages’ or ‘Reimbursement’. Data is sorted by Country, Pay Company, Brand, Region, Office then Item Type.

Grouped By

Country

Pay

Code

Filter By

Company

Brand

Region

Office

Pay Code

Item Type

Pay Code Name

Pay Batch From

Pay Batch To

Payment Date From

Filter By

Country

Brand

Region

Office

Payment Date

To

Range

Report Fields

 

Country

Pay

Code

Company

Brand Name

Payee First Pay Total

Region Name

Payee Surname

Payee Number

Candidate Number

Pay Quantity

Pay Rate

Office Name

Item

Amount Paid

GST Paid

Total Paid

Report Status

Updated

V12.31

Report October 2020

Expand
titlePay Code by Pay Batch Report Export - See all Deductions set up on a Payee at a given time
image-20240805-012732.pngImage RemovedReport provides amount paid by Pay Code broken down by Payee and is designed to be exported. Data is sorted by Country, Pay Code Sort Order, Pay Code Name, Payee Surname then First Name
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 Company

Pay Code Type

Pay Code Name

Payee No

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

Updated V12.31

Expand
titlePay Code Group Linked Pay Codes - Easily see all Pay Codes linked to a Pay Code Group - Great for updating
image-20240801-012403.pngImage 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

Country

Pay Code Group Name

Pay Code Group Type

Pay Code Name

Report Status

Updated Report V11.22

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

by Pay Batch Report Export - See all Deductions set up on a Payee at a given time
image-20240805-012732.pngImage Added

Report provides amount paid by Pay Code broken down by Payee and is designed to be exported. Data is sorted by Country, Pay Code Sort Order, Pay Code Name, Payee Surname then First Name.

Grouped By

Country

Pay Code

Filter By

Country

Brand

Region

Office

Pay Company

Pay Code Type

Pay Code Name

Payee No

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

Updated V12.31

Expand
titlePay Code Group Linked Pay Codes - Easily see all Pay Codes linked to a Pay Code Group - Great for updating
image-20240801-012403.pngImage 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

Country

Pay Code Group Name

Pay Code Group Type

Pay Code Name

Report Status

Updated Report V11.22

Expand
titlePayee Deductions Report - See all Deductions set up on a Payee at a given time
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

 

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
titleWorkplace Profile (AU)

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

...

Expand
titleGender Pay Gap (UK)

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
titleNOW: Pension Data File (UK)

The report is the file format defined by NOW: Pension for the pension data required each pay period. The report parameters include the pension provider, pay group and period range to select. NOW: Pensions import validation requires 1 report per pay period per pay group. You can select data over a range of periods and pay groups to be included in the report which can be used for reconciliation purposes.

Grouped By

N/A

Filter By

Pay Group

Pay Period Start Date From

Pay Period Start Date To

Pension Provider

Report Fields

Forename 1

Forename 2

Surname

NINO

Start Date

Title

DOB

Sex

Payroll No

Pay Start

Pay Period

Pay Frequency

Enrol Date

Posponement Date

Assessment

Address 1

Address 2

Address 3

Address 4

Address 5

Post Code

Email

Salary Sacrifice

EE Conts

ER Conts

AVC’s

Opt In

Opt Out

Gross Pay

Exit Date

EE Cont %

ER Cont %

Pay Code

ER Code

Scheme Code

Pensionable Earnings

Report Status

Version 12.3132

Expand
titleStatutory Parameters - Attachment of Earnings Orders Rate Table (UK)

Displays the earning thresholds and rates for rate based AEOs.

Grouped By

AEO Rate Name

Calculation Type

Filter By

Pay Frequency

AEO Rate Name

Report Fields

AEO Rate Name

Calculation Type

Pay Frequency

Effective From

Earnings From

Earnings To

Rate %

Excess Rate %

...

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

Expand
titleBulk Anonymise Candidate Batch Report (12.23 AU/NZ)

This report can be used to find details about Candidate Records that have been updated via the Bulk Action - Anonymise Candidate feature. It provides details on whether the record’s Personal Identity Information was anonymised, the user that has instigated the feature, and any other elements of the record that have been updated/deleted via the process.

Grouped By

Batch Id (most recent first)

Filter/Search Criterion

Country

Brand

Region

Office

Candidate No

Batch Id

Records Updated From (Date)

Records Updated To (Date)

Report Fields

Office

Candidate No

Candidate Name (Firstname Surname)

Batch Date

Batch Id

Action By Name (Firstname Surname)

Action By Username

Anonymised PII (display Y / N)

Deleted Custom Fields (display Y / N)

Deleted Candidate Activities (display Y / N)

Deleted Candidate Attachments (display Y / N)

Deleted Candidate Comms. History (display Y / N)

Deleted Candidate Audit Data (display Y / N)

Updated Status to (display name of new Status)

Updated Type to (display name of new Type)

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

 

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