Skip to main content

Transaction variances report

A report to compare transactions from a previous pay period to the current

The IQB-Emp010 - Payroll Employee Transaction Variance Report compares employee pay values between pay periods. You can compare a single pay period or a range of pay periods, e.g, compare April to May.

The IQ Transaction Variance report is a standard report.

Use Current Taxable Income and Previous Taxable Income to compare the Taxable Income (pay components + additions before tax - deductions before tax). The Gross values in the report include additions after tax (pay components + additions before tax - deductions before tax + additions after tax).

Run the Variance Report

  1. Go to Common, IQ.

  2. Double click on IQB-Emp010 - Payroll Employee Transaction Variance Report.

  3. Enter the date ranges to compare in the Value fields. To compare individual periods, include the same period end date in both the From and To date fields

  4. Click OK to run the IQ Query. The results will show in a grid window.

Errors

If you receive the error 'There was a problem running the IQ. Please restart MicrOpay and try again' the parameters are incorrectly entered. Review the below:

  • Include Terminated must be entered as either 1 or 0. That is the numerical value, entering the word false or true will result in the error.

  • Dates (Date From and Date To) need to be entered in the correct format, dd/mm/yyyy.

Did this answer your question?