Versions Compared

Version Old Version 13 New Version 14
Changes made by

Fiona Sims

Fiona Sims

Saved on

Key

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

...

Expand
titleTime to Fill Report - A Great Report to Easily to See How long Job Orders are Taking to Fill

Report lists all Jobs Created within a specified date range that have been filled. The report is grouped by Office and Client Name and displays time to fill in Days, Hours and Minutes.

Grouped By

Office

Client

Filter By

Country

Brand

Region

Office

Client

Position Type

Job Owner

Creation Date

Report Fields

Office

Client Name

Cost Centre

Job Order No

Job Owner

Position Type

Position

Job Order Status

Job Order Start Date

Job Order End Date

Filled Date

Days To Fill

Hours To Fill

Minutes to Fill

Report Status

Updated Report October 2020

Timesheet and Interpretation

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

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

Date Worked Range

Report Fields

Office

Client Number

Client Name

Candidate Number

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
titleWeekly Timesheet Forecast Report - Forecast Weekly Revenue using Job Schedule and Estimated Rates

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

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

...

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 Modified

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
titleSuper Fund USI Search Report - Use the USI to search for Super Funds

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

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

...