Click on the “Number” tabs and select Custom format.Go to cell and right-click and select “Format cells”.To do this follow the following instructions: Sometimes, due to excel settings, this particular format might not display. Enter the first date of the month and it displays it like this “Jan-21”. Insert the month for which you want to prepare the salary slip.
Salary Slip Format UAE consists of 6 sections:Įnter your Company name and Company Address at the top. 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 the version is same and both have same formulas. One is in the English language and another in the Arabic language. This template can be useful to WPS service providers, HR heads, and office admins working in the UAE. The template calculates all the totals and subtotals automatically as all these cell consists of predefined formulas. Lastly, insert the bonus amount if applicable to the employee. Overtime pay changes every month based on hours worked by employees.įurthermore, insert the salary advance and other applicable deductions to each employee. These formulas can be changes according to the company policy.Īdditionally, insert the overtime pay if any for the employee or insert 0. Usually, these amounts are fixed in nature. Insert conveyance allowance and medical allowance. The sheet auto-calculates Basic salary and House Rent allowance. Hence, all you need to do is to enter the company details, employee details, and CTC of the employee. This sheet consists of predefined formulas. Both templates consist of the same salary heads. Salary Slip Format UAE consists of 2 templates: Salary Slip UAE in English and Salary Slip UAE in Arabic. 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.Īdditionally, You can also download other HR templates such as Simple Salary Sheet or Employee Salary Sheet depending on the company requirement. Microsoft Excel OpenOffice Calc Google Sheet Microsoft Excel OpenOffice Calc Google Sheet Download Free Salary Slip Format UAE Template in Arabic (Excel, OpenOffice Calc, and Google Sheet) Difference between a Salary Certificate and Salary Slip?ĭownload Free Salary Slip Format UAE Template in English (Excel, OpenOffice Calc, and Google Sheet).What is a Wage Protection System (WPS) in the UAE?.Download Free Salary Slip Format UAE Template in Arabic (Excel, OpenOffice Calc, and Google Sheet).Download Free Salary Slip Format UAE Template in English (Excel, OpenOffice Calc, and Google Sheet).
0 kommentar(er)
