Download the Salary Slip Format – UAE, a ready-to-use template in Excel, Google Sheets, and OpenOffice Calc that helps you prepare the salary slip in English and Arabic.
This template consists of 2 types of salary slips: Salary Slip UAE English version and Salary Slip UAE Arabic version. These salary slips are designed based on the UAE Salary structure. Simple and easy to use. Just enter the credentials, and your payslip is ready.
Table of Contents
Key Takeaways
- Salary Slip Format UAE is a ready-to-use bilingual template in English & Arabic.
- It follows the UAE payroll structure, including CTC breakdown, HRA, allowances, overtime, and deductions.
- It supports WPS-based salary processing and includes IBAN bank details for UAE compliance.
- Generates print-ready salary slips with automatic calculations and language-specific formatting (LTR & RTL layouts).
Download the Free Salary Slip Format UAE Template in English (Excel, OpenOffice Calc, and Google Sheets)
Buy 33+ HR & Payroll Templates for Rs.249/- Only
Download Free Salary Slip Format UAE Template in Arabic (Excel, OpenOffice Calc, and Google Sheets)
If you want to automate your payroll process, you can download a fully automated Payroll Excel Template With Attendance to easily perform all your payroll tasks.
Additionally, you can also download other HR templates such as Simple Salary Sheet or Employee Salary Sheet depending on the company requirement.
How To Use Salary Slip Template UAE?
Salary Slip Format UAE consists of 2 templates: Salary Slip UAE in English and Salary Slip UAE in Arabic. Both templates consist of the same salary heads. The only difference is the language.
This sheet consists of predefined formulas. Hence, all you need to do is enter the company details, employee details, and CTC of the employee.
The sheet auto-calculates Basic salary and House Rent allowance. Insert conveyance allowance and medical allowance. Usually, these amounts are fixed in nature. Thus, need to be entered only once. These formulas can be changed according to the company policy.
Additionally, insert the overtime pay, if any, for the employee, or insert 0. Overtime pay changes every month based on hours worked by employees.
Furthermore, insert the salary advance and other applicable deductions for each employee. Lastly, insert the bonus amount if applicable to the employee. Or else, insert 0.
The template calculates all the totals and subtotals automatically, as all these cells consist of predefined formulas. This template can be useful to WPS service providers, HR heads, and office admins working in the UAE.
Your Salary Sheet is ready to print. Click the “Print” button.
Components of Salary Slip Format UAE
There are two versions of this template. One is in the English language and another in the Arabic language.
The Salary Slip format UAE English version starts from left to right, whereas the Salary Slip format UAE Arabic version starts from right to left. Moreover, the functioning of both versions is the same, and both have the same formulas.
Salary Slip Format UAE consists of 6 sections:
- Company Credentials
- Employee Information
- Attendance Details
- Employee Bank Details
- Salary Calculation Section
- Approval Section.
Company Credentials
Enter your Company name and Company Address at the top. Insert the month for which you want to prepare the salary slip. Enter the first date of the month, and it displays it like this: “Jan-21”.
Sometimes, due to Excel settings, this particular format might not display. To do this, follow the following instructions:
- Go to the cell and right-click and select “Format Cells”.
- Click on the “Number” tab and select Custom format. Select “mmm-yy” or manually type mmm-yy.
Employee Information
The employee information section consists of the following:
- Employee ID
- Employee Name
- Designation
- Department
Employee ID is a unique number. You can configure it according to your choice. This template uses the first two letters for the company’s initials. The middle two digits are for the year, and the last two digits are for the employee number.
Moreover, to automate the process, you can use the Data Validation function for employee name, employee ID, designation, and department by creating a drop-down list.
Attendance Details
This section consists of the following heads:
- Working Days
- Leaves Allowed
- Leaves Taken
- Payable Days
The template auto-calculates the Payable Days. If the employee hasn’t taken any leave, it will display the full working days. Or else, it will deduct the leaves taken from working days and add leaves allowed. The formula applied here is =IF(C12=0,C10,(C10-C12+C11)).
Bank Details
The Bank Details section consists of the following heads:
- Bank Name
- Account Number
- IBAN Number
As per the instructions from the Labor Ministry of the UAE, the employer needs to transfer the salary through the WPS process. Thus, every bank account is given an IBAN, which the employer uses to transfer the salaries of its employees.
Salary Calculations
In the Salary Calculation section, you need to insert salary details. Most of the cells consist of predefined formulas. This section consists of the following heads:
CTC – Cost to Company
Basic
HRA
Conveyance Allowance
Medical Allowance
Overtime Pay
Gross Salary
Salary Advance
Other Deductions
Bonus
Net Payable Salary
CTC
“Cost to Company” means the costs borne by an employer to employ an individual.
Basic Salary
Usually, the basic salary ranges from 40%-60% of the CTC amount. This template uses 50% of the basic salary. You can change the formula depending on company policy.
HRA
House Rent Allowance depends on company policy. Most corporates give their employees HRA. Leave it blank if the employment contract doesn’t include this clause.
Conveyance Allowance
Conveyance Allowance is for compensating the employees travel to work and back. This allowance is given only if no transportation is provided by the employer. If the employer provides company transportation, then insert 0.
Medical Allowance
An employer pays a medical allowance to their employees to cover their medical expenses. This amount depends on company policy. Most companies provide their employees with a fixed amount, and others provide on a reimbursement basis.
Overtime Pay
An employer pays overtime to its employees for hours worked more than the normal hours. It is calculated based on the gross salary (basic salary + the agreed allowances).
Depending on company policy, the employee gets overtime pay with an increase of not less than 25% of that wage as per the Labor Laws.
Gross Salary
The template adds all the allowances to basic to form Gross Salary. Hence, Basic Salary + Total Allowance = Gross Salary.
Salary Advance
In the deduction sections, insert the amount of salary advance the employee has received. If not, then enter 0.
Other Deductions
If there are any other deductions applicable to the employee, insert them here; otherwise, leave blank.
Additional Perks
This section is usually blank unless there are any agreed-upon additional perks given to an employee. Usually, companies pay a bonus once a year during Ramadan or any other festival. It differs from company to company.
Net Salary
Net Salary consists of a predefined formula and is auto-calculated.
Approval Section
Amount in words displays the salary amount in text format. It uses the SpellNumber Indian Rupees Excel function, which is manually inserted into the Excel file. In OpenOffice Calc uses NUMBERTEXT Function add-in.
Whereas Google Sheets also uses the Spell Number Indian Rupees script manually inserted through App Script.
Your Salary Slip is ready. Now click on the “Print” button at the top right and print the salary slip.
Get it signed and approved by the authorities.
Frequently Asked Questions
The Wage Protection System is an electronic payroll system launched by the UAE government to protect the non-payment of salary by employers in the country. With the help of this system, the Ministry of Labour monitors the correct and timely wage payments to employees. Payslip consists of details of the salary disbursed that an employer provides to its employees. It is the right of the employee to demand a payslip. It displays a complete break-up of salary like basic pay, allowances, deductions, etc. It can be an electronic slip or a physically printed document. Salary Certificate, as the name suggests is a certificate that an employer issues upon request to his/her employee. Usually, an employee demands this certificate for obtaining loans, opening a bank account, or other purposes where the employee needs to prove his monthly source as well as the amount of income. Whereas, a Salary Slip is a document that an employer sends to his/her employees as proof of salary payment to his or her bank account. Gratuity is an end-of-service benefit by UAE Labor Law that entitles an employee to receive an extra amount while leaving the company. This law doesn't cover employees that leave the employer before completing a year of service. Moreover, from 1-5 years of service, this law entitles an employee to receive full gratuity based on 21 days of salary. Whereas, for employees having 5 years and above years of service, this law entitles the employee to receive gratuity based on 30 days of salary.What is a Wage Protection System (WPS) in the UAE?
What is a payslip?
Difference between a Salary Certificate and Salary Slip?
What is Gratuity?
If you like this article, kindly share it on different social media platforms so that your friends and colleagues can also benefit from it. Sharing is Caring.
We also design customized templates according to your needs. You can hire us for our services on Fiverr or directly contact us at info@msofficegeek.com.
Please send us your queries or suggestions in the comment section below. We will be more than happy to assist you.
Pingback: School Report Card And Mark Sheet Excel Template - MSOfficeGeek