Skip to main content

Available MicrOpay IQ Reports

The Access MicrOpay IQ Reports are used to extract raw data from the software and are used for reports, graphs, and data analysis.
​
Refer to this Knowledgebase article for more information:

Things to note when you are running IQ Reports:

  • When a Parameter is a False/True Type, e.g., Include Terminated, use 0 for false, e.g., to not include Terminated, or 1 for true, e.g., to include Terminated.

  • Period End Date Parameters require actual Period End Dates as specified in the Pay Frequency. You can review Pay Period Ends by going to Payroll, General, Maintenance, Pay Frequencies, and then selecting the Pay Frequency to see Period End Dates for the current financial year. If the date is for a previous Financial Year, you can find the Period End Dates by going to Payroll, Reports, Transactions, Payroll Report, ticking Include Previous Tax Year, and using the Period End Date dropdown to review all available dates.

  • Code fields, e.g. Payroll Tax, Pay Frequency, Payroll Company, need to match the actual code of the component. You can find the code in the maintenance grid.

Standard IQ Reports

These reports can be found in Common, IQ. Below is a list of the common standard queries that extract raw data from the payroll database for use in reports, graphs and data analysis.

Employee Maintenance

Code

Name

Description

Parameters

IQB-AA

Payroll Age Analysis

Number of employees by age

  • Include Terminated

IQB-BL

Payroll Birthday List

List of employees with a birthday in the selected period

  • Include Terminated

  • Month From

  • Month To

IQB-CE001

Payroll Count Employee by Years of Service

Number of Employees by Years of Service

  • Include Terminated

IQB-CE002

Payroll Count Employee by State

Number of Employees by State

  • Include Terminated

IQB-CE003

Payroll Count Employee by Gender

Number of males and females. If the employee doesn't have a gender selected, an Other row will be displayed in the results

  • Include Terminated

IQB-Emp001

Payroll Employee Addition/Deduction List (Report)

List of employee addition and deduction details from the employee record.

  • Include Terminated

IQB-Emp002

Payroll Employee Bank Details (Report)

List of employee bank details from the employee record.

  • Include Terminated

IQB-Emp003

Payroll Employee Costing Details (Report)

List of employee costing details from the employee record.

  • Include Terminated

IQB-Emp004

Payroll Employee Details (Report)

List of employee details from the employee record.

  • Include Terminated

IQB-Emp006

Payroll Employee Significant Dates (Report)

List of employees with Significant Dates within the date range.

  • Include Terminated

  • Significant Date From

  • Significant Date To

IQB-Emp007

Payroll Employee Superannuation Details (Report)

List of superannuation details for all employees.

  • Include Terminated

IQB-Emp008

Payroll Employee Tax Details

Collates information from employee Personal and Tax Details in one place. Review this information prior to end of year processing

  • Include Terminated Employees from

IQB-Emp009

Payroll Employee Salary Changes

Displays changes to the following employee rate details within the specified date range:

  • Yearly Salary

  • Auto Pay Amount

  • Normal Rate

  • Time/Half Rate

  • Double Rate

  • Other Rate

  • Award Rate

  • Date From

  • Date To

  • Include Terminated

IQ-FBFEI

FB & FEI Values

Displays employee Fringe Benefit and Foreign Employment Income, including:

  • Fringe Benefits

    • RFB Taxable

    • RFB Exempt

  • Foreign Income

    • Exempt Foreign Income

    • Foreign Employment Income report via STP1

For Foreign Employment Income report via STP2 see IQ-STP2FEI.

  • Financial Year

IQ-FEISTP1

FEI Values entered using STP1

Displays employee Foreign Employment Income values that were reported through STP1 when the whole year was reported as STP1.

  • Financial Year

IQ-RFB

Display RFB for selected financial year

The report displays:

  • Taxable RFB

  • Exempt RFB

  • Exempt Foreign Income

  • Financial Year

IQB-FTE

Payroll Full Time Equivalent (FTE)

This report:

  • gives an FTE value per Cost Account

  • is based on the Hours entered for a Cost Account in transactions.

  • does not include Additions, Deductions or Terminations

The below columns are included:

  • Amount - Total of Normal, Sick, Annual, LSL, Other Leave and RDO.

  • Hours - the total hours entered.

  • FTE Permanent - The number of Full Time Equivalent employees paid who have Employment Type FP, PP, SA or WG. Based on the number of hours paid in the date range.

  • FTE Casual - The number of Full Time Equivalent employees paid who have Employment Type CA, CS, PT or FT. Based on the number of hours paid in the date range.

  • FTE Other - The number of Full Time Equivalent employees paid who have Employment Type not listed above. Based on the number of hours paid in the date range.

  • FTE Lost Hours - The Full time Equivalient Horus paid using an unpaid Leave Reason.

  • FTE Employees - Equals FTE Permanent + FTE Casual + FTE Other - FTE Lost Hours.

  • Number - Total number of actual employees

  • Include Terminated

  • Pay Frequency

  • Pay Periods

  • Period End Date From

  • Period End Date To

  • Standard Hours

IQB-HC001

Payroll Average Headcount

The average number of employees within the date range.

  • As of Date From

  • As of Date To

IQB-HC002

Payroll Headcount

The number of employees as at the date specified.

  • As of Date

IQB-NS

Payroll New Starter

List of employees who started within the date range.

  • Include Terminated

  • Start Date From

  • Start Date to

IQB-PL

Payroll Phone List

List of employees and their contact phone numbers

  • Include Terminated

IQB-RET004

Payroll Employee Additions/Deductions Member Number in the Current Pay Run

List of employees who have an addition or deduction activated in a current timesheet and include the member number.

  • Pay Frequency Code

IQB-SR

Payroll Salary Review

List of employees and their annual salary.

  • Include Terminated

IQB-STP

STP Audit Report

Displays a list of employees with any STP errors.

  • Include Terminated

IQB-STP2FEI

STP2 FEI Report by Financial Year

Displays a breakdown of values making up employee Foreign Employment Income (FEI), for a select financial year. Values in the IQ can be compared to FEI values in STP Update when run for the same financial year.

  • Tax Year

  • Payroll Company Code

  • Pay Frequency Code

  • Include Terminated

  • ETP Cap for Death Benefits

Employee Leave

Code

Name

Description

Parameters

IQB-Emp005

Payroll Employee Migrated Leave History (Report)

List of migration leave history from Payroll Manager with the date range

  • Include Terminated

  • Leave From Date

  • Leave To Date

IQB-LLV001

Leave Liability Variance

List of employees showing any changes in leave balances between two period end dates in hours and dollars

  • Include LSL ProRata

  • Include Sick Leave

  • B/Fwd Period End Date (previous period end date

  • C/Fwd Period End Date (current or more recent period end date)

IQB-LV001

Payroll Sick Leave

Lists employees who have taken sick leave within the date range

  • Include Terminated

  • Leave Date From

  • Leave Date To

IQB-LV002

Payroll Sick Leave Cost Per Employee

Lists employees who have taken sick leave and the cost within the date range

  • Include Terminated

  • Leave Date From

  • Leave Date To

IQB-LV003

Payroll Leave Liability

Lists employees and their current leave balances and liability.

This IQ:

  • doesn't include User Defined Leave.

  • doesn't include LSL contingency calculations.

  • Include Terminated

IQB-LV004

Payroll Leave Absence Analysis

Lists employees who have taken leave within the date range.

  • Include Terminated

  • Leave Date From

  • Leave Date To

IQB-LV005

Payroll Graphical Leave/Absence - Amount

The value of Leave Taken with the date range.

  • Include Terminated

  • Leave Date From

  • Leave Date To

IQB-LV006

Payroll Graphical Leave/Absence - Hour

The number of hours of Leave Taken with the date range.

  • Include Terminated

  • Leave Date From

  • Leave Date To

IQB-LV007

Payroll Employee on leave by Pa Period

List of employees who have taken leave within the date range.

  • Include Terminated

  • Leave Date From

  • Leave Date To

IQB-LV008

Payroll Leave Liability (new)

List of employees leave balances up to the last entitlement update date.

This IQ includes User Defined Leave and LSL contingency.

  • Include Terminated

IQB-SA

Payroll Service Analysis

List of employees and the Service Years to Date

  • Include Terminated

IQESS-FALI

ESS Future Approved Leave Import

List any leave entries that are in the Implement Leave Planning window.

This doesn't include Leave from ESS.

  • Include Leave From

  • Include Leave To

  • Include Terminated

  • Include Terminated on or After

IQ-EmpRDO

Employee RDO Balances

List of employees and their RDO hours and amounts

  • Include Terminated

IQ-PFDVL

Paid Family and Domestic Violence Leave Report

List of Paid Family and Domestic Violence Leave entered in the Paid FCV Leave screen for the date range

  • Start Date Range

  • End Date Range

  • Include Terminated

IQ-PORTABLELSL

Portable Long Service Leave

List of employees attached to Long Service Leave classes with Portable Long Service Leave definitions applied.

Report is to assist employers in meeting their Portable Long Service Leave reporting obligations required by the relevant state or territory authority.

  • Start Date Range

  • End Date Range

  • Include Terminated

Transactions

Code

Name

Description

Parameters

IQ-ADVNOTGEN

Show details for Pay Advices not generated

Display the number of transactions for current period end date where the pay advice hasn't been generated

No parameters

IQB-AC01

Emailed Pay Advice Count

Shows the number of employees who have had their pay advice emailed per database in the current month.

No parameters

IQB-Emp010

Payroll Employee Transaction Variance Report

This IQ report enable you to compare employee pay values over two different date ranges and review variance between them.

To compare two periods, use the same period end date in the current and previous date fields.

  • Previous Date from

  • Previous Date to

  • Current Date from

  • Current Date to

  • Include Terminated

IQB-RET001

Payroll Employee Transaction Details (Report)

List of pays for all employees per transaction within the date range. This will balance back to the Payroll Report.

  • Include Terminated

  • Period End Date From

  • Period End Date To

IQB-RET002

Payroll Employee Transaction Costing Details (Report)

List of employee transactions with costing redirections and costing splits. This will balance back to the Costing Report.

  • Include Terminated

  • Period End Date From

  • Period End Date To

IQB-RET003

Payroll Employee Transaction Total Details (Report)

Summary list of all employees per pay period within the date range. This will balance back to the payroll Report.

  • Include Terminated

  • Period End Date From

  • Period End Date To

IQB-SH

Payroll Summary of Hours

List of hours paid per employee within the date range.

  • Include Terminated

  • Leave Date From

  • Leave Date To

IQB-THCA

Payroll Total Hours per Cost Account

The year-to-date hours per cost account.

This does not include Additions and Deduction hours.

  • Include Terminated

IQ-EmpTransDt

Employee Transactions between Period End Dates

Extracts employee transaction information generated between two pay periods.

  • Leave Date From

  • Leave Date To

IQ-LSETRANS

Lump sum E transactions

Lists the employees transactions that resulted in a Lump Sum E value.

  • Pay Frequency Code

  • Payroll Company Code

  • Tax Year

IQ-YTDVAL

YTD Totals with Reporting and Subgroups

Collates the year-to-date total of STP2 reporting amounts per processed pay component, and includes the Reporting Group and Reporting Subgroup information for each processed component

  • Tax Year

  • Payroll Company Code

  • Pay Frequency Code

Terminations

Code

Name

Description

Parameters

IQB-ST

Payroll Staff Turnover

Number of employees hired and terminated within the date range.

  • Date From

  • Date To

IQB-TM001

Payroll Termination

List of employees who were terminated with the date range.

  • Termination Date From

  • Termination Date To

IQB-TM002

Payroll Total Termination

Total number of employees terminated per Location with the date range.

  • Termination Date From

  • Termination Date To

General Ledger

Code

Name

Description

Parameters

IQGL-BDM

GL Batch Details Maintenance

Lists the Batch Details setup found in General Ledger Integration, Maintenance, Batches, Batches, if you have GL.

Use % wildcard in the Value fields to include all information or enter the required fields.

  • Batch Code

  • Cost Account Code

  • Detail Description

  • Ledger Account Code

  • Pay Component Code

IQGL-CVM

GL Calculations Variables Maintenance

Shows the setup of any General Ledger Integration, Maintenance, Calculations, that you have setup in GL.

Use % wildcard in the Value fields to include all information or enter the required fields.

  • Calculation Code

  • Cost Account Code

  • Variable Code

ESS (Employee Self Service)

Code

Name

Description

Parameters

IQESS-LHI

ESS Leave History

Leave that has been imported via MicrOpay ESS within the date range.

  • Include Leave From

  • Include Leave To

  • Include Terminated

  • Include Terminated on or After

IQESS-LOOKUPS

Lookups used by ESS

Displays a list of lookups that are used by ESS where there is either blank or null codes.

No parameters

IQ-MCSERR

MCS Log Errors

Displays a list of MCS errors within the date range.

  • Date From

  • Date To

Superannuation

Code

Name

Description

Parameters

IQB-SS1

Super New Employee Details

Employee Superannuation Details with a date range

  • Date From

  • Date To

IQB-SS2

Super Employee Details

Employee Superannuation Details

  • Include All

IQB-SUPER

Payroll Superable Earnings by Pay Period

List per employee of the superannuation calculation within the date range.

  • Include Terminated

  • Period End Date From

  • Period End Date To

IQ-SUPERPC

Super Scheme Pay Components

Columns in the IQ reflect the selection in the Details tab and Pay Components on the Calculation Parameters tab of the employer contribution.

Y/N indicators show that a component is included in the calculation, e.g. Annual Leave is selected in Pay Components if the Annual Leave column is Y.

  • Super Code

IQ-SUPERPCD

Super Scheme Pay Components Details

Use this IQ to see a breakdown of Leave Reasons, Additions and Deductions and User Defined Leave types selected in Calculation Parameters of the employer contribution.

You can group and sort by Super Code or Super Contribution.

  • Pay Code

  • Super Code

IQ-SUPERPCSW

Super Scheme Salary & Wages Pay Components

This IQ displays a breakdown of Pay Components defined on the Salary and Wages tab of the employer contribution. Y/N indicator shows whether they are selected or not.

  • Super Code

IQ-SUPERPCSWD

Super Scheme Salary & Wages Pay Components Details

Run this IQ to see a list of Leave Reasons, Additions and Deductions and User Defined Leave types selected in Salary and Wages tab of the employer contribution.

You can group and sort by Super Code or Super Contribution.

There must be at least one contribution configured for Salary and Wages, otherwise no results will be returned for the IQ

  • Pay Code

  • Super Code

IQ-UnpSuper

Unprocessed Super

Shows a list of super that is yet to be processed either through Super Clearing or Super Processing.

  • Payroll Company Code

  • Pay Frequency Code

Download the document below for a list of standard payroll queries available:

Related Articles
Did this answer your question?