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.
Click Report & Analytics (
), then click the IQ Reports tab.Find the report you want to run. Use the search box to search by code or description.
In the Actions column, click Run (
).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.
Click OK. You can also select
Review the results in the IQ View.
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.
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 |
