Skip to main content

Run an IQ report

Steps to open an IQ report, enter its parameters and view the results in Access Payroll.

Some IQ reports ask you for values before they run, such as date ranges or yes/no options. You can enter those values from the IQ Reports list, then view the results.

📌Note: What you can see and run depends on your permissions and the permissions you have.

Things to note when you run an IQ report

Check these points before you run a report, so the results are right.

  • Yes/no parameters, such as Include Terminated, will display as a checkbox.

  • Period end date parameters need an actual period end date for the pay frequency you're reporting on.

  • Code fields, such as Payroll Tax, Pay Frequency or Payroll Company, must match the code of the component exactly. Check the code in the maintenance grid.


Open the report and enter its parameters

Follow these steps to open an IQ report and enter its parameters.

  1. Click Report & Analytics (Report & Analytics button.), then click the IQ Reports tab.

  2. Find the report you want to run. Use the search box to search by code or description.

  3. In the Actions column, click Run (Run button.).

  4. If a dialog window opens, enter a value for each parameter. A dialog window will only show if there are parameters to enter. Reports with no parameters run straight away and open in IQ View.

  5. Click OK. You can also select

  6. Review the results in the IQ View.

  7. To export the data, use Save Grid and select either Excel (.xlsx) or CSV (.csv). You can sort, group and filter the data in Excel.

  8. When you're finished click Close.

🤓Tip: To change the parameters, Close the IQ View and open the report again. You can't change them from the results page.


Standard IQ reports

The standard IQ reports are listed below by group, with each report's code and parameters. Your list may differ, so check the IQ Reports list in Report Builder.

Employee maintenance

Code

Report name

Parameters

IQB-AA

Payroll Age Analysis

Include Terminated

IQB-BL

Payroll Birthday List

Include Terminated, Month From, Month To

IQB-Emp001

Payroll Employee Addition/Deduction List (Report)

Include Terminated

IQB-Emp002

Payroll Employee Bank Details (Report)

Include Terminated

IQB-Emp003

Payroll Employee Costing Details (Report)

Include Terminated

IQB-Emp004

Payroll Employee Details (Report)

Include Terminated

IQB-Emp006

Payroll Employee Significant Dates (Report)

Include Terminated, Significant Date From, Significant Date To

IQB-Emp007

Payroll Employee Superannuation Details (Report)

Include Terminated

IQB-Emp008

Payroll Employee Tax Details

Include Terminated Employees from

IQB-Emp009

Payroll Employee Salary Changes

Date From, Date To, Include Terminated

IQ-FBFEI

FB & FEI Values

Financial Year

IQ-FEISTP1

FEI Values entered using STP1

Financial Year

IQB-FTE

Payroll Full Time Equivalent (FTE)

Include Terminated, Pay Frequency, Pay Periods, Period End Date From, Period End Date To, Standard Hours

IQB-HC001

Payroll Average Headcount

As of Date From, As of Date To

IQB-HC002

Payroll Headcount

As of Date

IQB-NS

Payroll New Starter

Include Terminated, Start Date From, Start Date To

IQB-PL

Payroll Phone List

Include Terminated

IQB-RET004

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

Pay Frequency Code

IQB-SR

Payroll Salary Review

Include Terminated

IQB-STP

STP Audit Report

Include Terminated

IQB-STP2FEI

STP2 FEI Report by Financial Year

Tax Year, Payroll Company Code, Pay Frequency Code, Include Terminated, ETP Cap for Death Benefits

Employee leave

Code

Report name

Parameters

IQB-Emp005

Payroll Employee Migrated Leave History (Report)

Include Terminated, Leave From Date, Leave To Date

IQB-LLV001

Leave Liability Variance

Include LSL ProRata, Include Sick Leave, B/Fwd Period End Date, C/Fwd Period End Date

IQB-LV001

Payroll Sick Leave

Include Terminated, Leave Date From, Leave Date To

IQB-LV002

Payroll Sick Leave Cost Per Employee

Include Terminated, Leave Date From, Leave Date To

IQB-LV003

Payroll Leave Liability

Include Terminated

IQB-LV004

Payroll Leave Absence Analysis

Include Terminated, Leave Date From, Leave Date To

IQB-LV007

Payroll Employee on leave by Pa Period

Include Terminated, Leave Date From, Leave Date To

IQB-LV008

Payroll Leave Liability (new)

Include Terminated

IQB-SA

Payroll Service Analysis

Include Terminated

IQESS-FALI

ESS Future Approved Leave Import

Include Leave From, Include Leave To, Include Terminated, Include Terminated on or After

IQ-EmpRDO

Employee RDO Balances

Include Terminated

IQ-PFDVL

Paid Family and Domestic Violence Leave Report

Start Date Range, End Date Range, Include Terminated

Transactions

Code

Report name

Parameters

IQ-ADVNOTGEN

Show details for Pay Advices not generated

No parameters

IQB-AC01

Emailed Pay Advice Count

No parameters

IQB-Emp010

Payroll Employee Transaction Variance Report

Previous Date From, Previous Date To, Current Date From, Current Date To, Include Terminated

IQB-RET001

Payroll Employee Transaction Details (Report)

Include Terminated, Period End Date From, Period End Date To

IQB-RET002

Payroll Employee Transaction Costing Details (Report)

Include Terminated, Period End Date From, Period End Date To

IQB-RET003

Payroll Employee Transaction Total Details (Report)

Include Terminated, Period End Date From, Period End Date To

IQB-SH

Payroll Summary of Hours

Include Terminated, Leave Date From, Leave Date To

IQ-EmpTransDt

Employee Transactions between Period End Dates

Leave Date From, Leave Date To

IQ-LSETRANS

Lump sum E transactions

Pay Frequency Code, Payroll Company Code, Tax Year

IQ-YTDVAL

YTD Totals with Reporting and Subgroups

Tax Year, Payroll Company Code, Pay Frequency Code

Terminations

Code

Report name

Parameters

IQB-ST

Payroll Staff Turnover

Date From, Date To

IQB-TM001

Payroll Termination

Termination Date From, Termination Date To

IQB-TM002

Payroll Total Termination

Termination Date From, Termination Date To

General ledger

Code

Report name

Parameters

IQGL-BDM

GL Batch Details Maintenance

Batch Code, Cost Account Code, Detail Description, Ledger Account Code, Pay Component Code

IQGL-CVM

GL Calculations Variables Maintenance

Calculation Code, Cost Account Code, Variable Code

ESS (Employee Self Service)

Code

Report name

Parameters

IQESS-LHI

ESS Leave History

Include Leave From, Include Leave To, Include Terminated, Include Terminated on or After

IQESS-LOOKUPS

Lookups used by ESS

No parameters

Superannuation

Code

Report name

Parameters

IQB-SS1

Super New Employee Details

Date From, Date To

IQB-SS2

Super Employee Details

Include All

IQB-SUPER

Payroll Superable Earnings by Pay Period

Include Terminated, Period End Date From, Period End Date To

IQ-SUPERPC

Super Scheme Pay Components

Super Code

IQ-SUPERPCD

Super Scheme Pay Components Details

Pay Code, Super Code

IQ-SUPERPCSW

Super Scheme Salary & Wages Pay Components

Super Code

IQ-SUPERPCSWD

Super Scheme Salary & Wages Pay Components Details

Pay Code, Super Code

IQ-UnpSuper

Unprocessed Super

Payroll Company Code, Pay Frequency Code

Did this answer your question?