P14 & P35 CSV File Upload Report

User own File Ref. EOY0003 Batch Ref. AAA000001

CSV Data Validation Error Report:

Please fix the errors listed below and upload corrected CSV again.

Error found in Employee P14 CSV file
  1. Employee : Mr Jade Fourteen : Please check the Employee's Name for invalid characters. First character must not be a space.
  2. ECON : ECON (Employers Contracted Out Number) must be in the format of the letter E followed by numbers in the range of 3000000 - 3999999 followed by a letter.
  3. Line 4 Column D11 >> 1969-15-28 : Invalid Date field/format.
  4. Line 5 Column D4 : Invalid mandatory field value.
Error found in Employer P35 CSV file
  1. Line 2 Column D1 : Invalid mandatory field value.

HELP

DEMO