How to Create a WPS SIF File in Excel (With Sample)
The salary file your bank asks for is a short text file with strict rules. Here is every field in order, a sample you can read, and the reasons a file comes back rejected.
- A SIF, Salary Information File, is the list of salaries you give your bank or exchange house under the Wage Protection System.
- It has one line for each worker (EDR) and one last line for the employer (SCR). Each line has ten values separated by commas.
- The count of workers and the total in the last line must match the lines above exactly, or the whole file is rejected.
- Banks add their own requirements. Always build to the specification of your own bank or exchange house.
What a SIF file is
Under the UAE's Wage Protection System you do not pay your workers one by one. Each month you give your bank or exchange house one list: every worker, where his money goes, and how much. That list is the SIF, the Salary Information File. People also call it the WPS file or the bank salary file.
The path of the file:
- You send the file, and the authority to debit your account, to your bank or exchange house.
- Your bank passes the file to the Wage Protection System at the Central Bank.
- The system accepts or rejects the file as a whole.
- Each worker's money goes to the bank, exchange house or card where he is paid.
- The payment data reaches the Ministry of Human Resources and Emiratisation.
Before you start: what your bank really wants
The layout below comes from the guide for companies that the ministry and the Central Bank wrote for the system in 2010. It is old, and it is still the base of the banks' versions that we have seen. But many banks and exchange houses have added to it, and some do not want a raw SIF from you at all. They give you their own Excel sheet or a web page, and build the file themselves.
So the first step is a question to your bank: "In which layout do you want our salary file?" Everything else on this page helps you understand their answer.
The layout
A SIF is plain text. Each line holds ten values with commas between them. There are one or more lines for workers, each starting with EDR, and exactly one line for the employer, starting with SCR. In the official guide the employer's line is the last one.
One line for each worker: EDR
| No. | Field | What goes in it |
|---|---|---|
| 1 | Record type | EDR |
| 2 | Employee ID | The 14-digit personal number from the worker's labour card, with zeros in front if it is shorter |
| 3 | Agent ID | The 9-digit routing code of the bank or exchange house where the worker is paid |
| 4 | Employee account | The worker's account or card number with that agent. Some banks ask for the IBAN here |
| 5 | Pay start date | First day of the pay period, as YYYY-MM-DD |
| 6 | Pay end date | Last day of the pay period, as YYYY-MM-DD |
| 7 | Days in period | The number of days between those two dates, both included |
| 8 | Fixed income | The fixed part of the salary |
| 9 | Variable income | The part that changes: overtime, extra hours, allowances that move |
| 10 | Days on leave | Days of unpaid leave in the period |
One last line for the employer: SCR
| No. | Field | What goes in it |
|---|---|---|
| 1 | Record type | SCR |
| 2 | Employer ID | Your 13-digit establishment number at the ministry, with zeros in front |
| 3 | Bank code | The 9-digit routing code of your own bank |
| 4 | File creation date | YYYY-MM-DD |
| 5 | File creation time | HHMM |
| 6 | Salary month | MMYYYY |
| 7 | Number of EDR lines | How many workers are in the file |
| 8 | Total salary | The sum of every fixed and every variable amount |
| 9 | Currency | AED |
| 10 | Employer reference | Optional. A note of your own |
A sample
Two workers of a made-up company, paid for November 2026. Every number is invented.
EDR,00012345678901,400123456,AE070331234567890123456,2026-11-01,2026-11-30,30,1200.00,712.50,0
EDR,00012345678902,400123456,AE770331234567890123457,2026-11-01,2026-11-30,30,1000.00,381.50,2
SCR,0000001234567,400987654,2026-12-01,0930,112026,2,3294.00,AED,NOV2026
This sample follows what banks ask for today. It differs from the 2010 guide in two places: the account is an IBAN, longer than the 16 characters the guide allowed, and the salary month is the month before the file was made.
Read the last line against the two above it. It says two workers, and there are two. It says 3,294.00, and 1,200.00 + 712.50 + 1,000.00 + 381.50 is 3,294.00. If either were off by one fils, the file would be rejected.
The file name
The official guide gives the name as the employer's 13-digit number, then the date as YYMMDD, then the time as HHMMSS, with the ending .SIF. The sample above, made on 1 December 2026 at 09:30:00, would be:
0000001234567261201093000.SIF
A name can be used once only. If you send a corrected file, give it a new time.
How to make it in Excel
- Start in row 1, with no row of headings: every line of the file must begin with EDR or SCR. Put the ten values of each worker in columns A to J, one worker to a row.
- Format columns B to F as Text before you type or paste anything. Otherwise Excel removes the zeros in front, turns a long account number into something like
4.00123E+08, and changes the dates. - Type the dates in the form
2026-11-01. If Excel turns them into its own date format, the file will fail. - Give amounts two decimals and no thousands separator:
1200.00, not1,200.00. - Under the last worker write the SCR line. For 30 workers in rows 1 to 30, count them with
=COUNTIF(A1:A30,"EDR")and add the total with=SUM(H1:I30), then copy those two results as values. The time and the month in this line, such as0930and012027, lose their first zero unless the cells are Text. - Save as CSV (Comma delimited), close Excel, and change the file's name to the SIF name.
- Open the file in Notepad and look at it. This is where the missing zeros and the changed dates show up.
Doing this by hand every month works for ten workers. For a hundred it is where a tired person makes the mistake that delays everyone's salary.
Fixed and variable for an hourly worker
A worker with a monthly salary has an obvious fixed part. A worker paid by the hour does not: his whole salary moves with his hours. What offices do:
| Way | Fixed | Variable |
|---|---|---|
| Contract wage as fixed | The basic wage on the labour contract | Everything above it: extra hours, overtime |
| Everything as fixed | The whole salary | 0.00 |
| As your bank says | Follow their rule | Follow their rule |
Never leave a field empty: write 0.00. And never write a negative amount. A deduction makes the salary smaller; it is not a line of its own in this file.
Wages of workers registered with the ministry must go through the Wage Protection System. If part of a salary is still paid in cash, ask your PRO before you do it again.
Why a file is rejected
The system checks the whole file. One wrong line sends all of it back, and nobody is paid until a corrected file goes in.
| What the bank reports | What is usually wrong |
|---|---|
| The count or the total does not match | A worker was added or removed after the last line was written, or an amount was changed by hand |
| The SCR record is not the last | The employer's line is in the wrong place |
| Duplicate file | The same file name was sent before |
| The worker was already paid for this period | A second file for the same month and the same worker |
| Invalid employee, employer, agent or bank ID | A zero in front was lost, a digit is missing, or the worker's number is out of date |
| Negative amount | A deduction was entered as its own figure |
| Wrong date format | Excel changed 2026-11-01 into 01/11/2026 |
| The days do not match the dates | 30 was typed for a month of 31 days |
| Salary month not accepted | The 2010 guide accepted only the current month or the next. Ask your bank which month it expects when you pay on the 1st for the month before |
Before you send a file, check five things: the zeros in front, the dates, the count, the total, and the file name.
Questions people ask
What does SIF stand for?
Salary Information File. It is the file an employer gives its bank or exchange house so that wages can be paid through the UAE's Wage Protection System.
What is the difference between EDR and SCR?
EDR is the Employee Detail Record: one line for each worker, with his number, his account and his pay. SCR is the Salary Control Record: one line for the employer, with the number of workers and the total. The system uses the SCR to check the EDR lines.
Where do I find a worker's 14-digit number?
It is the personal number printed on the worker's labour card, and it is in the ministry's records for your establishment. It is not the Emirates ID number and not the passport number.
Can I make a SIF file without software?
Yes, in Excel, as described above, or on the web page that many banks and exchange houses give their customers. Software saves the work and removes the typing mistakes; it is not a legal requirement.
What goes under variable income?
The part of the salary that changes from month to month. For workers paid by the hour, offices usually put extra hours and overtime there. Banks differ, so ask yours.
Sources
- Ministry of Labour and Central Bank of the UAE, Wages Protection System, "Companies Responsibility Guide", WPS-CRG01, version 3.0.0, 21 January 2010. UAE banks give copies of it to their customers; ask yours.
- The UAE Government portal, Payment of salaries and wages, updated 14 October 2026.
This guide explains the rules as we read them on 19 November 2026. Rules change, and your bank or exchange house may ask for more. It is not legal advice: for a decision that matters, check with the authority concerned, your PRO or your accountant.