Summary
Description
You have generated the IRP5 file from your payroll for either the Annual or Interim SARS submission and imported the file into SARS e@syFile.
The import pass the validation of the file with Warnings and allows you to select to import the file:
The import fails with the onscreen message "Payroll File import failed." but no information is provided on the Import Payroll File Log as to why it is failing.
Cause
The error is related to commas in address field which is not validated as per the SARS Business Requirement Specification. Due to this, the Sage nor SARS e@syFile validation does not report an issue.
Resolution
- The payroll application and SARS software does not validate commas in alfa-numeric fields
- The IRP5 file is a comma delimited file and any commas in alpha-numeric fields impacts on the file layout when exported from the payroll system
How do I find the impacted record(s) resulting in the error message?
- The Employee Address fields (for residential, postal and work address) must be checked for any commas, which should be removed
- This can be done manually per employee, or by using reports
- The Flexi Fixed export cannot be used to export the information to check as it will not show the commas within alfa-numeric fields
- The only option to check will be to create a report in Report Writer, for all the address fields (where we find the errors usually), and to print the report to PDF. This will allow you to search the PDF report file for any "," (comma) in the file
NOTE: The Sage Customer Support team can provide guidance, however will not be able to assist in locating the commas in the data. Should you require assistance to locate the commas using the solution provided here, you can click here to book a consultation with a consultant.