WPS SIF file maker
Paste your workers and their amounts out of Excel. The count, the total, the zeros in front and the file's name are worked out for you. Your list stays on your computer.
Your company and the month
Your workers
Nothing you type here is sent to us or to anyone. The file is made inside your own browser.
Your file
- Workers
- 0
- Total (AED)
- 0.00
the name appears here
How to use it
- In Excel, keep one row for each worker with the six columns named above. Format the ID, routing code and account columns as Text, so that Excel does not remove zeros or shorten long numbers.
- Select the rows, without the heading, copy them, and paste them into the box.
- Type your employer ID and your bank's routing code, and choose the salary month.
- Read the file on the right. If something is wrong, it is listed there and the download stays off.
- Download the file and send it to your bank or exchange house in the way they ask for.
What it works out for you
- zeros in front of an employee ID, an employer ID and a routing code;
- the pay period, from the first to the last day of the month, and its number of days;
- amounts with two decimals and no thousands separator;
- the number of workers and the total in the employer's line;
- the file's name: the employer ID, today's date and the time, ending in .SIF;
- the line endings the official guide asks for.
Before you rely on it
The file follows the layout in the guide that the Ministry of Labour and the Central Bank wrote for the Wage Protection System. Your bank or exchange house may ask for more, or may want its own Excel sheet instead of a SIF. Send one small file as a test before you trust any tool, this one included, with a full salary month. The layout is explained in how to create a WPS SIF file in Excel, and an existing file can be tested in the SIF file checker.
Questions people ask
What goes under fixed and what under variable?
Fixed is the part of the salary that is the same every month, usually the basic wage in the labour contract. Variable is the part that changes, such as extra hours and overtime. For workers paid by the hour the split is not obvious, and banks differ, so ask yours.
Can the pay period be something other than the calendar month?
This tool writes the whole calendar month. If your pay period runs differently, for example from the 26th to the 25th, ask your bank which dates it expects, and change the two dates in the downloaded file with Notepad.
Is the file ready to send?
It is correct by the official layout: ten values on each line, the right count and total, the right name. Whether your bank accepts it also depends on things no tool can see, such as whether each worker's number and account are right.
The file is the last step. We do the ones before it.
Manpower Ledger reads the timesheets, works out the salaries, and makes the salary file when the owner approves.
Book a demo