PAYPayroll Systems

WPS SIF file rejected by the bank — 'employee record mismatch' on reconciliation

Monthly WPS SIF upload rejected. Bank says the employee count and total don't match their register. Our payroll register is correct. Diffing the SIF against the bank's expected list, three employees are on the bank side that we terminated last month, and two new joiners are missing from the bank side. So it's a sync gap between our HR system and the bank's MOL register, not the SIF format. How are people keeping that register in sync without doing it by hand every month?

3 replies

Deepa Nairyesterday
We generate a delta file (joiners + leavers + IBAN changes) straight after payroll lock and send it to the bank's portal before the SIF. The SIF then reconciles because the register is already updated. The delta is a small extract — labour card number, action, effective date.
Rana Al-Mutairiyesterday
Same here. The key is that the leaver has to hit the bank register before the SIF that excludes them, or the bank flags the missing record. We run the delta on lock day and the SIF the next morning.
Tomás Ferreirayesterday
Delta-before-SIF it is. I'll build the extract off the payroll action log. Appreciate it.

Members answer here — the people who actually run these systems.

Request to join