Versions Compared

Version Old Version 38 New Version 39
Changes made by

Fiona Sims

Fiona Sims

Saved on

Key

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

...

Timesheet and Interpretation

Report lists all Candidates who have been in a pay batch where the Pay Code Item Date is within date range. The report is grouped by Office and Client and displays Totals of Pay Codes Types based on the type of Ordinary, Overtime, Allowance and LeaveImage RemovedN/A
Expand
titleCandidate Hours by Client Report - Quickly see how many hours your Candidates are working at a Client Site
AWR Clock Reset From Non-Submission of Timesheets (UK)
image-20240802-063204.pngImage Added

This report will output those candidates who have not submitted their timesheets for a set period of time as defined in the report parameters to highlight when they are due to have their clock count reset to zero.  This report will only output those candidates where AWR monitoring is required.

Grouped By

Office

Filter By

CountryCandidate

Brand Name

Region Name

Office Name

Client Name

Date Worked Range

Supplier Name

Job Ends On or After

Job Active for More Than No. of Weeks

No of Weeks Since a T/S Received

Report Date

Include Week of Report Date

Report Fields

Office

Client

Number

No.

Client Name

Candidate

Number
Image Removed

Report assists in identifying Payees whose Leave balance may be insufficient for timesheet-based leave requests.  Where a timesheet has insufficient balance, a row will appear in red.  Where there are multiple timesheets with Leave on them for the same payee a Multiple Timesheet warning will appear in Orange.  Only timesheets that have not been paid will appear in the report.

Grouped By

Office

Filter By

Country

Brand

Region

Office

Timesheet End Date

Report Fields

 

Candidate Name

Payee No

Candidate No

Employment Type

Leave Type

Leave Quantity

Leave Balance

Timesheet Week Ending

Interpreter Status

Multiple Timesheet

Report Status

Updated Report October 2020

Expand
titleOutstanding Timesheet Report - Easily see all timesheets for a period that have not been completed - allowing for easier follow up
Image Removed

Report lists all Timesheet still in the workflow (i.e. have not reached interpreter) for a given user defined period.  Very helpful report to send to Offices to follow up on all their outstanding timesheets meaning less chance of candidates not getting paid.

Grouped By

Office

Filter By

Country

Brand

Region

Office

Timesheet End Date

Timesheet Submitted Status

Client Name

Report Fields

 

Office

Client Name

Cost Centre Name

Candidate Name

Candidate No

Payee No

Job Order No

T/S Start

T/S End

Filled by User Name

Timesheet Location

Report Status

Updated Report October 2020

Expand
titleOverlapping Timesheet Shift Report - Find timesheets for a candidate where they have entered hours on separate timesheets that overlap
Image Removed

Report will list any timesheet entries that overlap with another shift for the same candidate within a user defined period. The report is useful in identifying potential issues at the interpreter stage prior to processing payroll.

Grouped By

Id

Candidate Name

Days Worked

Ordinary Hours (Type of Ordinary and Unit Type of Hours)

Overtime Hours (Type of Overtime and Unit Type of Hours)

Allowance Quantity (Type of Allowance)

Leave Hours (Type of Leave and Unit Type of Hours)

Total Hours (Unit Type of Hours)

Report Status

New Report October 2020

Expand
titleCandidate Hours Report - Quickly see how many hours your Candidates are working
Image Removed

Report lists all Candidates who have been in a pay batch where the Pay Code Item Date is within date range. The report is grouped by Office and displays Totals of Pay Codes Types based on the type of Ordinary, Overtime, Allowance and Leave.

Grouped By

Office

Filter By

Country

Brand

Region

Office

Client Name

Date Worked Range

Report Fields

Office

Candidate Name

Candidate Number

Ordinary Hours (Type of Ordinary and Unit Type of Hours)

Overtime Hours (Type of Overtime and Unit Type of Hours)

Allowance Quantity (Type of Allowance)

Leave Hours (Type of Leave and Unit Type of Hours)

Total Hours (Unit Type of Hours)

Report Status

Updated Report October 2020

Expand
titleFind Timesheet Report - Quickly Find Where to Find a Timesheet in the system
Image Removed

Report assists in locating where a Timesheet is located within the system. Timesheet Location could be one of the following; Not Submitted, Extend Job, Start Job Earlier, Deleted, Available, Bulk Timesheet, Expired, Incomplete, Submitted, Rejected, Incomplete Recalled, Submitted awaiting further approval, Interpreter - Not Reviewed, Interpreter - Reviewed, Timesheet in Open Pay Batch, Timesheet has been Paid, Incomplete - Timesheet Reversed, Timesheet Interpretation in Progress, Interpretation Failed.

Grouped By

N/A

Filter By

Country

Brand

Region

Office

Timesheet End Date

Job Order No

Client Name

Candidate No

Payee No

Candidate First Name

Candidate Surname

Report Fields

 

Client Name

Cost Centre Name

Candidate Name

Candidate No

Payee No

Job Order No

T/S Start

T/S End

Adjustment Timesheet

Timesheet Location

Report Status

Updated Report October 2020

Expand
titleInterpreted Time Check Report - Identify discrepancies between Timesheet Shift Length and Interpreted Results
Image Removed

Report is helpful in identifying timesheets where the hours entered do not match the hours interpreted. Report can be filter to show where there are discrepancies or can show all timesheets that meet the search criteria regardless if the results match or not.

Grouped By

N/A

Filter By

Country

Brand

Region

Office

Interpreter Status

Show Discrepancies Flag

Timesheet End Date

Client Name

Report Fields

 

Client No

Client Name

Cost Centre No

Cost Centre Name

Job Order Number

Candidate No

Candidate Name

Shift Date

Start Time

End Time

Break Length

Shift Length

Manual Item

Manual Quantity

Pay Quantity

Bill Quantity

Report Status

Updated Report October 2020

Expand
titleInterpreter Leave Balance Check Report - Find Timesheets with Insufficient Leave Balances before processing your Payroll

First Name

Surname

Job No.

Client Job Position

Position

Job Start Date

Job End Date

Clock Count

Office Reset Weeks

Last Timesheet

No. of Weeks

No. of Candidate (per office)

Total Candidates

Report Status

Released V12.31

Expand
titleAWR Parity Pay Errors (UK)
image-20240802-054715.pngImage Added

Shows where a payee has reached parity and if the pay/bill rate used in the timesheet is not the same as the parity pay/bill rate.

Grouped By

Office

Candidate No

Job No

Timesheet End Date

Filter By

Brand Name

Region Name

Office Name

Client Name

Supplier Name

Job Ends On or After

Timesheet End Date From

Timesheet End Date To

Report Fields

Office

Client

Client No

Candidate No

First Name

Surname

Supplier Name

Job Order No

Client Job Position

Position

Job Start Date

Job End Date

Date Parity Reached

T/S End Date

Rate Type

Ordinary Hours

Parity Pay Rate

TS Pay Rate

No of Jobs (per office)

Total Jobs

Report Status

Released V12.31

Expand
titleAWR Incomplete Parity Rates (UK)
image-20240802-055547.pngImage Added

The parity rates are defaulted the same as the pre-parity rates.  This report is to highlight those candidates whose jobs have the same parity rates as their pre-parity rates.  This report will only output those candidates where AWR monitoring is required.

Grouped By

Office

Client No

Candidate No

Job No

Filter By

Brand Name

Region Name

Office Name

Client Name

Supplier Name

Job Ends On or After

Job Active for More Than No. of Weeks

Clock Count From

Clock Count To

Report Fields

Office

Client No

Client Name

Candidate No

First Name

Surname

Supplier Name

Job Order No

Job Start Date

Job End Date

Clock Count

Enhanced Holiday

Rate Type

Pay Code Name

Pre-Parity Pay Rate

Parity Pay Rate

No of Jobs (per office)

Total Jobs

Report Status

Released V12.31

Expand
titleAWR Enhanced Holiday Accrual Check (UK)
image-20240802-060444.pngImage Added

As holiday accrual rates can be entered as a percentage or a fixed amount per period, this report is to check that the correct enhanced holiday accrual rate has been entered on the job so as to prevent incorrect accrual.  This is indicated by outputting those candidates where the percentage difference exceeds a parameter value.  

Grouped By

Office

Client No

Candidate No

Job No

Filter By

Brand Name

Region Name

Office Name

Client Name

Supplier Name

Job Ends On or After

Job Active for More Than No. of Weeks

Clock Count From

Clock Count To

Base Leave Accrual Percentage

Percentage Difference

Report Fields

Office

Client No

Client Name

Candidate No

First Name

Surname

Supplier Name

Job Order No

Job Start Date

Job End Date

Clock Count

Enhanced Holiday Override

Percentage Change

No of Candidates (per office)

Total Candidates

Report Status

Released V12.31

Expand
titleCandidate AWR Summary (UK)
image-20240802-060832.pngImage Added

A report that outputs candidates’ job clock count, parity rates and enhanced holiday rate for all candidates that are monitored for AWR.  Users can decide if they want to see all candidates or those who are at a certain clock count.  If all candidates that are monitored for AWR are required, the clock count From would be set as 0.

Grouped By

Office

Client No

Candidate No

Job No

Filter By

Brand Name

Region Name

Office Name

Client Name

Supplier Name

Job Ends On or After

Job Active for More Than No. of Weeks

Clock Count From

Clock Count To

Report Fields

Office

Client No

Client Name

Candidate No

First Name

Surname

Supplier Name

Job Order No

Client Job Position

Position

Job Start Date

Job End Date

Clock Count

Enhanced Holiday Override

Rate Type

Pay Code Name

Pre-Parity Pay Rate

Parity Pay Rate

No of Jobs (per office)

Total Jobs

Report Status

Released V12.31

Expand
titleCandidate AWR Clock Count History (UK)
image-20240802-061421.pngImage Added

A report that outputs candidates’ job clock count history.  Users can decide if they want to see all candidates or those who are at a certain clock count.  If all candidates that are monitored for AWR are required, the clock count From would be set as 0. 

Grouped By

Candidate No

Job No

Client No

Client Name

Candidate Name

Client Job Position

Position

Job Start Date

Job End Date

Filter By

Brand Name

Region Name

Office Name

Client Name

Supplier Name

Job Ends On or After

Job Active for More Than No. of Weeks

Clock Count From

Clock Count To

Candidate Id

Report Fields

T/S Week End Date

T/S Type

T/S Status

Clock Source

AWR Status

Clock Count

Report Status

Released V12.31

Expand
titleCandidate Hours by Client Report - Quickly see how many hours your Candidates are working at a Client Site
Image Added

Report lists all Candidates who have been in a pay batch where the Pay Code Item Date is within date range. The report is grouped by Office and Client and displays Totals of Pay Codes Types based on the type of Ordinary, Overtime, Allowance and Leave.

Grouped By

Office

Filter By

Country

Brand

Region

Office

Client Name

Timesheet End

Date Worked Range

Candidate

Report Fields

 

Office

Candidate No

Client Number

Candidate

Client Name

Shift Date

Candidate Number

Client

Candidate Name

Job Order No

Shift Start

Shift End

Report Status

Updated Report October 2020

Expand
titleShift Break (Fatigue) Report - Find Timesheets where break between shifts is an issue
Image Removed

Report assists in identifying shift that are worked with less than a user defined shift break.  This is useful in identifying and potential fatigue issues and ensuring legislative compliance. Report also identifies any overlapping shifts.

Grouped By

N/A

Filter By

Country

Brand

Region

Office

Client Name

Shift Date

Minimum Shift Break

Report Fields

 

Candidate No

Candidate

Client No

Client Name

Job Order No

Shift Date

Start Date

End Date

Shift Break

Report Status

New Report October 2020

Expand
titleShift Min / Max Hours Report - Find Timesheets where Shift hours are below of above User Define Thresholds
Image Removed

Report lists all timesheets that contain shifts that fall outside a user defined Maximum and Minimum Time Period. Very Helpful for identifying incorrect Timesheet Entry, Fatigues Management and Short Shifts

Grouped By

N/A

Filter By

Country

Brand

Region

Office

Interpreter Status

Show Min / Max Filter

Client Name

Minimum Shift Hours

Maximum Shift Hours

Timesheet End Date

Report Fields

 

Client Id

Client Name

Candidate No

Candidate

Job Order No

Timesheet End Date

Shift Date

Start Date

End Date

Shift Length

Break Length

Interpreter Status

Report Status

Updated Report October 2020

Expand
titleTimesheet Audit Report - Get a whole client audit view of Timesheet Approval in a single report
Image Removed

Report lists all Timesheets within a selectable date range and shows who initiated and approved a timesheet (if actioned).

Grouped By

Client

Filter By

Country

Brand

Region

Office

Client Name

Timesheet End Date

Report Fields

 

Client Name

Job Order No

Candidate Name

Timesheet End Date

Adjustment Timesheet Flag

Initiator User Name

Initiator User Type

Submitted Date

Approver User Name

Approver User Type

Approved Date

Report Status

Updated Report October 2020

Expand
titleTimesheet Break Report - Find Timesheets where Shift hours are below of above User Define Thresholds
Image RemovedReport lists all timesheets that contain Shifts that are greater than a user defined Time Period and do not contain the Minimum user defined Break length. Report is handy to identify keying errors and possible legislation infringements

Days Worked

Ordinary Hours (Type of Ordinary and Unit Type of Hours)

Overtime Hours (Type of Overtime and Unit Type of Hours)

Allowance Quantity (Type of Allowance)

Leave Hours (Type of Leave and Unit Type of Hours)

Total Hours (Unit Type of Hours)

Report Status

Updated V12.31

Expand
titleCandidate Hours Report - Quickly see how many hours your Candidates are working
Image Added

Report lists all Candidates who have been in a pay batch where the Pay Code Item Date is within date range. The report is grouped by Office and displays Totals of Pay Codes Types based on the type of Ordinary, Overtime, Allowance and Leave.

Grouped By

Office

Filter By

Country

Brand

Region

Office

Client Name

Date Worked Range

Report Fields

Office

Candidate Name

Candidate Number

Ordinary Hours (Type of Ordinary and Unit Type of Hours)

Overtime Hours (Type of Overtime and Unit Type of Hours)

Allowance Quantity (Type of Allowance)

Leave Hours (Type of Leave and Unit Type of Hours)

Total Hours (Unit Type of Hours)

Report Status

Updated V12.31

Expand
titleFind Timesheet Report - Quickly Find Where to Find a Timesheet in the system
Image Added

Report assists in locating where a Timesheet is located within the system. Timesheet Location could be one of the following; Not Submitted, Extend Job, Start Job Earlier, Deleted, Available, Bulk Timesheet, Expired, Incomplete, Submitted, Rejected, Incomplete Recalled, Submitted awaiting further approval, Interpreter - Not Reviewed, Interpreter - Reviewed, Timesheet in Open Pay Batch, Timesheet has been Paid, Incomplete - Timesheet Reversed, Timesheet Interpretation in Progress, Interpretation Failed.

Grouped By

N/A

Filter By

Country

Brand

Region

Office

Timesheet End Date

Job Order No

Client Name

Candidate No

Payee No

Candidate First Name

Candidate Surname

Report Fields

 

Client Name

Cost Centre Name

Candidate Name

Candidate No

Payee No

Job Order No

T/S Start

T/S End

Adjustment Timesheet

Timesheet Location

Report Status

Updated Report October 2020

Expand
titleInterpreted Time Check Report - Identify discrepancies between Timesheet Shift Length and Interpreted Results
Report Fields
Image Added

Report is helpful in identifying timesheets where the hours entered do not match the hours interpreted. Report can be filter to show where there are discrepancies or can show all timesheets that meet the search criteria regardless if the results match or not.

Grouped By

N/A

Filter By

Country

Brand

Region

Office

Interpreter Status

Show Discrepancies Flag

Timesheet End Date

Client Name

Minimum Break Length

Maximum Shift Length

Timesheet End Date

Report Fields

 

Client

Id

No

Client Name

Candidate

Cost Centre No

Candidate

Cost Centre Name

Job Order Number

Candidate No

Timesheet End Date

Candidate Name

Shift Date

Start

Date

Time

End

Date

Time

Break Length

Shift Length

Break Length

Interpreter Status

Manual Item

Manual Quantity

Pay Quantity

Bill Quantity

Report Status

Updated Report October 2020

Pay Company
Expand
titleTimesheet Detail Export Report - Find Timesheet details for a defined period by Hierarchy, Job, Client, Payee, Candidate
image-20240801-042940.pngImage Removed

Report lists all Timesheet lines for a given user defined period. Report can be filtered by Country, Brand, Region, Office, Job Order Number, Client Name, Client No, Candidate number, Payee Number and Candidate Name

Grouped By

Country

Brand

Region

Office

Job Order

Client Name

Client No

Candidate Name

Candidate No

Interpreter Leave Balance Check Report - Find Timesheets with Insufficient Leave Balances before processing your Payroll
Image Added

Report assists in identifying Payees whose Leave balance may be insufficient for timesheet-based leave requests.  Where a timesheet has insufficient balance, a row will appear in red.  Where there are multiple timesheets with Leave on them for the same payee a Multiple Timesheet warning will appear in Orange.  Only timesheets that have not been paid will appear in the report.

Grouped By

Office

Filter By

Country

Brand

Region

Office

Timesheet

Start DateTimesheet

End Date

Client Name

Client No

Payee Name

Report Fields

 

Candidate Name

Candidate

Payee No

Job Order

Candidate No

Report Fields

Country

Brand

Region

Office

Job Id

Timesheet Id

Timesheet End Date

Timesheet Code

Purchase Order No

Payee First Name

Payee Surname

Parent

Client

Cost Centre Name

Cost Centre Code

Type

Date

Start Time

End Time

Attendance / Absence Type

Break Start

Break End

Break Hours

Total Hours

Project Code

Total Project Hours

Item

Quantity

Rate

Net

Sales Tax

Total Reimbursement

Report Status

Updated December 2022

Expand
titleTimesheets Processed by Pay Company Report - Are you getting the most out of the system? Easily identify how timesheets are being entered into you system
Image Removed

Report lists all timesheets processed within a user defined payment period.  Results are then displayed by Pay Company, Brand, Region, Office, User and Client and display on separate pages.  The report breaks down the origin of the timesheet entry to Online, Imports, Keyed Original, Keyed Adjustments, Keyed Total and Total.

Grouped By

Employment Type

Leave Type

Leave Quantity

Leave Balance

Timesheet Week Ending

Interpreter Status

Multiple Timesheet

Report Status

Updated Report October 2020

Payment Date From

Payment Date ToTotal
Expand
titleOutstanding Timesheet Report - Easily see all timesheets for a period that have not been completed - allowing for easier follow up
Image Added

Report lists all Timesheet still in the workflow (i.e. have not reached interpreter) for a given user defined period.  Very helpful report to send to Offices to follow up on all their outstanding timesheets meaning less chance of candidates not getting paid.

Grouped By

Office

Filter By

Country

Brand

Region

Office

Keyed by User

Client

Filter By

Timesheet End Date

Timesheet Submitted Status

Client Name

Report Fields

 

Pay Company / Brand / Region / Office/ User/ Client

Online Total

Timesheet Import Total

Keyed Original Total

Keyed Adjustment Total

Office

Client Name

Cost Centre Name

Candidate Name

Candidate No

Payee No

Job Order No

T/S Start

T/S End

Filled by User Name

Timesheet Location

Report Status

Updated Report October 2020

Office

Job Owner
Expand
titleWeekly Overlapping Timesheet Forecast Report - Forecast Weekly Revenue using Job Schedule and Estimated Rates
Image Removed

Report lists all Timesheets within a selectable date range and shows who initiated and approved a timesheet (if actioned).

Grouped By

Shift Report - Find timesheets for a candidate where they have entered hours on separate timesheets that overlap
Image Added

Report will list any timesheet entries that overlap with another shift for the same candidate within a user defined period. The report is useful in identifying potential issues at the interpreter stage prior to processing payroll.

Grouped By

N/A

Filter By

Country

Brand

Region

Office

Job Owner

Client Name

Timesheet End Date

Report Fields

 

Office

Job Owner

Candidate No

Client

Candidate Name

Cost Centre

Shift Date

Client Name

Job Order No

Timesheet

Shift Start

Date

Timesheet

Shift End

Date

Job Order Status

Rate Frequency

Scheduled Hours

Scheduled Days

Estimated Pay Rate

Estimated Bill Rate

Estimated Bill OnCost

Dollar Margin

Job Weekly Profit

GP%

Report Status

Updated Report October 2020

Payroll

Payee

Pay Company

Payee Number

Candidate Number

Employment Start Date

Last Worked Date

Tax Type

Hours Worked

Days Worked

Weeks Worked

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

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

 

Shift Break (Fatigue) Report - Find Timesheets where break between shifts is an issue
Image Added

Report assists in identifying shift that are worked with less than a user defined shift break.  This is useful in identifying and potential fatigue issues and ensuring legislative compliance. Report also identifies any overlapping shifts.

Grouped By

N/A

Filter By

Country

Brand

Region

Office

Client Name

Shift Date

Minimum Shift Break

Report Fields

 

Candidate No

Candidate

Client No

Client Name

Job Order No

Shift Date

Start Date

End Date

Shift Break

Report Status

New Report October 2020

Expand
titleShift Min / Max Hours Report - Find Timesheets where Shift hours are below of above User Define Thresholds
Image Added

Report lists all timesheets that contain shifts that fall outside a user defined Maximum and Minimum Time Period. Very Helpful for identifying incorrect Timesheet Entry, Fatigues Management and Short Shifts

Grouped By

N/A

Filter By

Country

Brand

Region

Office

Interpreter Status

Show Min / Max Filter

Client Name

Minimum Shift Hours

Maximum Shift Hours

Timesheet End Date

Report Fields

 

Client Id

Client Name

Candidate No

Candidate

Job Order No

Timesheet End Date

Shift Date

Start Date

End Date

Shift Length

Break Length

Interpreter Status

Report Status

Updated Report October 2020

Expand
titleTimesheet Audit Report - Get a whole client audit view of Timesheet Approval in a single report
Image Added

Report lists all Timesheets within a selectable date range and shows who initiated and approved a timesheet (if actioned).

Grouped By

Client

Filter By

Country

Brand

Region

Office

Client Name

Timesheet End Date

Report Fields

 

Client Name

Job Order No

Candidate Name

Timesheet End Date

Adjustment Timesheet Flag

Initiator User Name

Initiator User Type

Submitted Date

Approver User Name

Approver User Type

Approved Date

Report Status

Updated Report October 2020

Expand
titleTimesheet Break Report - Find Timesheets where Shift hours are below of above User Define Thresholds
Image Added

Report lists all timesheets that contain Shifts that are greater than a user defined Time Period and do not contain the Minimum user defined Break length. Report is handy to identify keying errors and possible legislation infringements

Grouped By

N/A

Filter By

Country

Brand

Region

Office

Interpreter Status

Client Name

Minimum Break Length

Maximum Shift Length

Timesheet End Date

Report Fields

 

Client Id

Client Name

Candidate No

Candidate

Job Order No

Timesheet End Date

Shift Date

Start Date

End Date

Shift Length

Break Length

Interpreter Status

Report Status

Updated Report October 2020

Expand
titleTimesheet Detail Export Report - Find Timesheet details for a defined period by Hierarchy, Job, Client, Payee, Candidate
image-20240801-042940.pngImage Added

Report lists all Timesheet lines for a given user defined period. Report can be filtered by Country, Brand, Region, Office, Job Order Number, Client Name, Client No, Candidate number, Payee Number and Candidate Name

Grouped By

Country

Brand

Region

Office

Job Order

Client Name

Client No

Candidate Name

Candidate No

Filter By

Country

Brand

Region

Office

Timesheet Start Date

Timesheet End Date

Client Name

Client No

Payee Name

Candidate Name

Candidate No

Job Order No

Report Fields

Country

Brand

Region

Office

Job Id

Timesheet Id

Timesheet End Date

Timesheet Code

Purchase Order No

Payee First Name

Payee Surname

Parent

Client

Cost Centre Name

Cost Centre Code

Type

Date

Start Time

End Time

Attendance / Absence Type

Break Start

Break End

Break Hours

Total Hours

Project Code

Total Project Hours

Item

Quantity

Rate

Net

Sales Tax

Total Reimbursement

Report Status

Updated December 2022

Expand
titleTimesheet Processed - Are you getting the most out of the system? Easily identify how timesheets are being entered into you system
Image Added

Report lists all timesheets processed within a user defined payment period.  Results are then displayed by Pay Company, Brand, Region, Office, User and Client and display on separate pages.  The report breaks down the origin of the timesheet entry to Online, Imports, Keyed Original, Keyed Adjustments, Keyed Total and Total.

Grouped By

Pay Company

Brand

Region

Office

Keyed by User

Client

Filter By

Payment Date From

Payment Date To

Report Fields

 

Pay Company / Brand / Region / Office/ User/ Client

Online Total

Timesheet Import Total

Keyed Original Total

Keyed Adjustment Total

Total

Report Status

Updated Report V12.31

Expand
titleWeekly Timesheet Forecast Report - Forecast Weekly Revenue using Job Schedule and Estimated Rates
Image Added

Report lists all Timesheets within a selectable date range and shows who initiated and approved a timesheet (if actioned).

Grouped By

Office

Job Owner

Filter By

Country

Brand

Region

Office

Job Owner

Client Name

Timesheet End Date

Report Fields

 

Office

Job Owner

Client Name

Cost Centre Name

Job Order No

Timesheet Start Date

Timesheet End Date

Job Order Status

Rate Frequency

Scheduled Hours

Scheduled Days

Estimated Pay Rate

Estimated Bill Rate

Estimated Bill OnCost

Dollar Margin

Job Weekly Profit

GP%

Report Status

Updated Report October 2020

Payroll

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

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

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, Payee First Name then Payee Surname.

Grouped By

Pay Company

Payee

Filter By

Country

Brand

Region

Office

Pay Company

Pay Group

Employment Type

Payment Date From

Payment 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

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 CompanyImage Removed
Expand
titleContractor Payments - View payments to Payees
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,

Payee First Name then Payee Surname

Brand, Region, Office then Item Type.

Grouped By

Country

Pay Company

Payee

Brand

Region

Office

Item Type

Filter By

Country

Brand

Region

Office

Pay Company

Pay Group

Employment Type

Payment Date

From

Payment 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

Range

Report Fields

 

Country

Pay Company

Brand Name

Region Name

Office Name

Item

Amount Paid

GST Paid

Total Paid

Report Status

Updated Report October 2020

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 Typeimage-20240731-232902.pngImage Removed

Country

Brand

Region

Office
Expand
titleGST/VAT Paid Report - High Level grouped view of GST/VAT paid by Type
Pay Code by Pay Batch Report - 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

Company

Code

Filter By

Country

Brand

Region

Office

Item

Pay Code Type

Filter By

Pay Code Name

Pay Batch From

Pay Batch To

Payment Date From

Payment Date

Range

To

Report Fields

 

Country

Pay

Company

Code Name

Brand

Payee First Name

Region Name

Office Name

Item

Amount Paid

GST Paid

Total Paid

Payee Surname

Payee Number

Candidate Number

Pay Quantity

Pay Rate

Pay Total

Report Status

Updated

Report October 2020

V12.31

Expand
titlePay Code by Pay Batch Report Export - See all Deductions set up on a Payee at a given time
Image RemovedThis 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
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

New Report October 2020

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

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

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
titleTimesheet Gross Profit (UK)
image-20240502-125325.png

The report will output data once the timesheets for the period selected has been processed in an invoice.

The margin is based on the bill value minus (total pay plus the holiday pay accrual cost, plus the employer national insurance contribution, plus employer pension plus apprenticeship levy).

The holiday pay accrual cost is based on the average of the prior 52 weeks. Please note if the candidate has multiple jobs, the holiday cost will also only be allocated to the first job. This will be enhanced in a future release of software.

Where pay items are added manually in a pay batch and not processed via a timesheet, these values will not be output onto the report.

Grouped By

None

Filter By

Country

Brand

Region

Office

Pay Company

Job Owner

Pay Period Date From

Pay Period Date To

Parent Client

Client Name

Payee Id

Report Fields

Payee ID

Candidate ID

Payee First Name

Payee Surname

Timesheet ID

Timesheet Type

Timesheet Date

Pay Batch No

Units

Pay

Holiday Pay

Employer NI

Employer Pension

App Levy

Total Cost

Bill Margin

Margin %

Margin/Hour

Country

Pay Company

Region

Office

Brand

Client

Job Order ID

Job Owner

Job Position

Report Status

Report added May 2024Updated V12.31

Billing

Expand
titleClient Single Line Margin Report - A simple Single Line Margin Report by Client

Report lists all Clients that have been invoiced within a selectable date range and displays a single line total for Hours Billed (Based of Bill Code Unit Type of Hours), Gross Wage, Invoiced Ex Gst, Invoice Inc GST, Bill Oncost, Gross Margin (Total Invoiced ex GST – Gross Wage), Net Margin (Total Invoiced ex GST – Gross Wage and Bill Oncost) and a Percentage GP (Net Margin / Total Invoiced ex GST * 100). 

Grouped By

Office

Filter By

Country

Brand Name

Region Name

Office Name

Client Owner

Client Name

Invoice Date Range

Report Fields

Office Name

Client Name

Client Owner

Hours

Gross Wage

Invoice Value Excluding GST

Invoice Value Including GST

Bill Oncost Total

Gross Margin

Net Margin

Gross Profit Percentage

Report Status

Updated Report October 2020

Expand
titleClient Timesheet Sales Report - A Summary Margin report for all Paid Timesheets

Report lists all Timesheets that have been paid (pay batch completed) within a specified payment date range.  The report is grouped by Office and displays Client Name, Cost Centre, Number of unique Candidates on paid Jobs, total Gross Wages, Gross Revenue and UnInvoiced Revenue.

Grouped By

Office

Client

Filter By

Country

Brand Name

Region Name

Office Name

Client Owner

Client Name

Payment Date Range

Report Fields

Office Name

Client Name

Cost Centre Name

Number of Candidates Paid

Hours Worked

Gross Wages

Gross Revenue

Uninvoiced Revenue

Report Status

Updated Report October 2020V12.31

Expand
titleDetailed Client Margin Report - A Detailed Margin report at a Pay Code per invoice Level

Report lists all Clients that have been invoiced within a selectable date range and displays Cost Centre Name, Invoice Date, Invoice Number, Bill Item Hours, Pay Code, Pay Quantity, Pay Rate, Pay Total, Bill Code, Bill Quantity, Bill Rate, Bill Total, Invoice Amount (Inc Gst), $ Margin (Net) and Percentage GP. 

Grouped By

Office

Client

Filter By

Country

Brand Name

Region Name

Office Name

Client Owner

Client Name

Invoice Date Range

Report Fields

Office Name

Client Name

Cost Centre Name

Invoice Date

Invoice Number

Hours

Pay Code

Pay Quantity

Pay Rate

Pay Total

Bill Code

Bill Quantity

Bill Rate

Bill Total

Invoice Amount Including GST

Dollar Margin

Gross Profit Percentage

Report Status

Updated Report October 2020

...

Expand
titleUninvoiced Sales Report - Identify all Uninvoiced sales

Report lists all Timesheets that have been paid (pay batch completed) and have not been invoiced at time of running the report. 

Grouped By

Office

Filter By

Country

Brand Name

Region Name

Office Name

Report Fields

Office Name

Client Name

Debtor Number

Debtor Name

Time Group

Job Order No

Payee No

Payee Name

Timesheet End Date

Pay Batch No

Payment Date

Total

Report Status

Updated Report October 2020V12.31

Expand
titleUser Job Order Performance Report - A Summary of each Users Performance
image-20240801-022415.png

Report lists all Agency/Connect/Integration users (defaulted to Active status) and provides the total number of jobs created, filled and cancelled for both Temporary/Contract and Permanent jobs. It includes total hours (based on Bill Code Unit Type ‘Hours’), unique jobs, timesheet gross revenue, non timesheet gross revenue and total gross revenue invoiced. It also provides the number of unique Candidates on jobs submitted to timesheet and the number of Temporary/Contract jobs filled and unfilled at the time of running the report. Created is based on Created By. Filled is based on Filled By. All other details are based on Job Owner. Report is grouped by Office. Data is sorted by Office then User Name.

Grouped By

Office

Filter By

Country

Brand Name

Region Name

Office

User Manager

Date Range

Current Date

User Status

User Type

Report Fields

Office Name

User Name

Position

Timesheet Jobs Created

Timesheet Jobs Filled

Timesheet Jobs Cancelled

Non Timesheet Jobs Created

Non Timesheet Jobs Filled

Non Timesheet Jobs Cancelled

Invoiced Hours

Invoiced Jobs

Invoiced Timesheet Revenue

Invoiced Non Timesheet Revenue

Total Revenue

Current Timesheet Jobs

Candidates

Filled Jobs

Unfilled Jobs

Report Status

Updated Report V12.22

...