Skip to main content

Error: 'The value specified for an item does not match the item type (value = "-nn.nn", item type = Decimal, uniqueID = ...) Hint: MinInclusive constraint failed' in STP Reporting

Employee has a negative Qualifying Earnings (QE) in STP

You can receive this message when an employee has a negative QE (Qualifying Earnings) value in STP Reporting.

​This error can happen when:

  • Components are incorrectly marked as QE.

  • When a component that is marked as QE and paid in a previous Financial Year is being reversed in the current financial year. For example, Leave or Normal (flagged as QE) has been reversed and paid as Worker's Compensation (not flagged as QE).

  • When you pay a component that isn't marked as QE and include a Salary Sacrifice that is marked as QE. For example, pay Company Paid Parental Leave or Worker's Compensation (not flagged as QE) and include a salary sacrifice, e.g. salary packaging (marked as QE).

Find the cause

To find the cause, run the Employee Previous Earnings for the whole financial year and check which components are marked as QE or not.

  1. Go to Payroll, Reports, End of Pay, Employee Previous Earnings.

  2. Select the Payroll Company and Location or leave as <All>.

  3. Enter the employee in From Employee and To Employee.

  4. As STP is for the whole financial year, select the first period in the financial year as the From Date and the most recent period as the To Date. This can be the same date.

  5. Leave Transaction Type, Pay Components, Additions and Deductions, Leave Reasons and User Defined Leave as <All>.

  6. Click Preview.

  7. Note the components and values from the Employee Total section.

  8. Find the QE setting for the below by adding STP2 QE to the grids to find what has been included.

    • Payroll, Maintenance, General, Pay Components

    • Payroll, Maintenance, General, Additions and Deductions

    • Payroll, Maintenance, Leave, Leave Reasons

Correct the negative Qualifying Earnings

The steps to correct the QE will depend on the cause.

Component incorrectly marked

If the cause is due to QE being incorrectly ticked or unticked, you can correct the components and then review the QE value in STP Update. To do this:

  1. Go to

    • Payroll, Maintenance, General, Pay Components

    • Payroll, Maintenance, General, Additions and Deductions

    • Payroll, Maintenance, Leave, Leave Reasons

  2. Edit the component.

  3. For Additions and Deductions or Leave Reasons, click the STP Reporting tab.

  4. Tick or untick Qualifying Earnings (QE).

  5. Click OK.

Reverse a QE component

If the cause is because Sick Leave, Annual Leave or Normal has been reversed and Worker's Compensation paid, use the steps below to correct the negative QE:

  1. Go to Payroll, Maintenance, Leave, Leave Reason.

  2. Right-click and Copy the existing Worker's Compensation reason.

  3. Enter a new Code and Description. The description should indicate that this one is marked for QE.

  4. Select the STP Reporting tab and tick Qualifying Earnings (QE).

  5. Click OK to Save.

  6. Next, go to Payroll, Transactions, Processing, Manual Calculation.

  7. Select the Employee and click Subtract.

  8. From Pay Calculation, tick Value.

  9. Select Other Leave in the Pay Summary and click Add.

  10. Enter the Leave Reason used in the original adjustment and the number of hours. Check that the value is correct.

  11. Click Process.

  12. Continuing with the same employee, create Pay Advice 2 and select the Add radio button.

  13. From Pay Calculation, tick Value.

  14. Untick Generate Payment to exclude the transaction from the EFT file.

  15. Select Other Leave in the Pay Summary and click Add.

  16. Enter the new Leave Reason created above and the number of hours. Check that the value is correct.

  17. Click Process.

Salary Sacrifice when there is no QE component

If the cause is because you paid a component that isn't marked as QE and included a Salary Sacrifice (e.g. Novated Leave or Salary Packaging) that is marked as QE, use the steps below to correct the negative QE:

  1. Go to Payroll, Maintenance, General, Additions and Deductions.

  2. Right-click and Copy the existing Deduction Before Tax (e.g. Novated Leave).

  3. Enter a new Code, Shortcut Key and Description. The description should indicate that this one is not marked for QE and is for correcting the error.

  4. Select the STP Reporting tab and untick Qualifying Earnings (QE).

  5. Click OK to Save.

  6. Next, go to Payroll, Transactions, Processing, Manual Calculation.

  7. Select the Employee and click Add.

  8. Untick Generate Payment.

  9. Select Deds Before Tax in the Pay Summary and click Add.

  10. Enter the Salary Sacrifice used in the original adjustment and enter the Value as a negative. In the Pay Summary, this will create a negative Deds Before Tax total, and a positive Gross Taxable Total and Net Pay.

  11. Click Add to create a second line.

  12. Enter the new Salary Sacrifice created above and the Value as a positive. In the Pay Summary, the Deds Before Tax total, Gross Taxable Total and Net Pay should all be 0.

  13. Click Process.

  14. After processing, verify the adjustments in the STP Update to confirm that the QE value is zero.

If the reversal entered is due to another reason, e.g., reversing an overpayment of Normal Hours for a terminated employee, contact support via MyAccess.

Did this answer your question?