Skip to content
logo Knowledgebase

e@syFile error: "Monthly Calculated ETI (7004): If Year of Assessment (3025) is 2021 and ETI Month (7006) is 04, 05, 06 or 07 and ETI qualifying 12 month cycle indicator (7005) is 1 or 2, then value MUST be greater than zero (0.00), (YoA3025=2021..."

Created on  | Last modified on  Highlight Matches

Summary

This article will provide guidance on resolving the SARS e@syFile error, when importing your IRP5/IT3a payroll file generated on Sage Classic, Sage Premier or Sage 200c VIP.

Description

Example of the error message:

Monthly Calculated ETI (7004): If Year of Assessment (3025) is 2021 and ETI Month (7006) is 04, 05, 06 or 07 and ETI qualifying 12 month cycle indicator (7005) is 1 or 2, then value MUST be greater than zero (0.00), (YoA3025=2021, 7004=750.00, ETI Month 7006=07, Age=40, 7009=NOT COMPLETED


  • 3025 - Year of Assessment, which would be 2021.
  • 7004 - ETI amount calculated on the payroll
  • 7005 - ETI qualifying cycle (1 = 1st 12 months qualified, 2, for 2nd 12 months, and 3 for additional relief periods April to July 2020)
  • 7006 - ETI month (1 = January, 2 = February, 3 = March, 4 = April, 5 = May, 6 = June, 7 = July, 8 = August)
  • 7009 - Special Economic Zone (SEZ) code

Cause

The issue is related to records where the ETI set should have been 3, but was changed to 1. The cause of the issue is still under investigation.

The issue had been found mainly on records where employees previously qualified 24 periods for ETI, prior to the additional leave months.

Resolution

The solution to resolve the error, is to correct the ETI periods using the ETI Take-on function. Follow the steps below to correct the Set values.

 

Step 1: Identify the employee from the Import Payroll File Log on SARS e@syFile
  • When a payroll IRP5 file is imported but rejected, the errors are logged on the Import Payroll File Log.
  • The log will indicate the employee tax certificate records affected 
  • The error message will indicate which calendar month is causing the error (in this example, the month is July):  
Monthly Calculated ETI (7004): If Year of Assessment (3025) is 2021 and ETI Month (7006) is 04, 05, 06 or 07 and ETI qualifying 12 month cycle indicator (7005) is 1 or 2, then value MUST be greater than zero (0.00), (YoA3025=2021, 7004=750.00, ETI Month 7006=07, Age=40, 7009=NOT COMPLETED
Step 2: Export the ETI History from the payroll
  • To review the ETI information for the past 6 months of your employees, export the ETI History report for 2020.
  • Click here for a guide how to export the report to Microsoft Excel.
Step 4: Save and import ETI Take-on file
  • Once the changed have been made the file should by saved in Excel format.
  • After you have saved it in Excel format, delete column AE to AL, for the End of Record marker moves to column AE.
  • Save the file in CSV comma delimited format.
  • Import the CSV file into your payroll, which will overwrite the existing ETI history data.
  • Click here for more details to create an ETI take-on file.
Step 5: Import EMP501 to confirm if ETI values changed
  • Generate the EMP501 report from your History Reports, and review your values. 
  • Click here for a guide to export the EMP501 report.
Step 6: Export the Test Run file again, and import into SARS e@syFile
  • Click here for a guide to export the Test run with the IRP5/IT3a Report.
  • When your Test file imports successfully, you can continue to generate your Live Run to import into SARS e@syFile.

 

To further assist you with this error we have created an extraction tool.

For information on the ETI Validation Export: New ETI Take-on option for Sage Classic and Sage Premier is now available please click here