Home/SIF errors/Duplicate Employee ID in the SIF file
SIF errors

Duplicate Employee ID in the SIF file

Two or more rows in the SIF file share the same Employee ID (field 4). Each Civil ID or Passport number may appear only once per file one row = one salary for one month for one employee.

Rule: F06

Why the bank rejects this

The bank cannot tell which of the duplicate rows is the "real" payment, so the entire SIF is rejected to protect against double-payment fraud. If you have a genuine second payment (bonus, end of service), it must go in a separate file with the correct file type not as a duplicate row in the salary file.

How to fix it

  1. Open the SIF and sort rows by field 4 (Employee ID) to group duplicates together watch for leading-zero variants that look different but are the same ID.
  2. Decide which row is correct: usually the one with the final salary figure after all adjustments. Delete the other rows for that employee.
  3. If you genuinely need to pay the same employee twice (regular salary plus a bonus), export the bonus into a separate SIF marked as a Bonus file type do not combine it here.
  4. Check your payroll export settings duplicates often happen when an employee is listed under two cost centres and exported twice.
  5. Confirm no Civil ID was mistyped so it now collides with another employee's ID.
  6. Re-run Ujoor to confirm no rows still trigger rule F06 before resubmitting to the bank.

How Ujoor catches this

Ujoor scans all rows at once and lists every duplicate pair row number, Employee ID, and both conflicting rows highlighted so you can delete the wrong one in place. Rule F06 catches duplicates that a simple Excel filter misses when leading zeros or whitespace hide them.

Validate your SIF file now

Drop your file. See every issue inline. Fix it and download a clean file all in your browser.