Wednesday, March 11, 2015

Leave salary calculation in uae in excel

How to calculate annual leave in Excel ? In general, when staff have been working in a company for a year, they will deserve their annual leaves. And maybe the days of annual leave will be added with the working years. But if there are hundreds or thousands of staff in your company, how could you quickly calculate their own annual leaves. A reader asks: I’m working in a company in Dubai.


Two years ago, I was recruited in this company as an engineer with a basic salary of Dh0only.

Three months ago my basic salary was. For more help visit my website. Full-time employees working in the UAE are entitled to leave and holidays as per laws in the country, which broadly include annual or recreation leave , sick leave and maternity leave.


The division does not apply on leaves pertaining to working youth. The employer must pay the worker’s salary for annual leave before it is taken. What are you eligible for? UAE Labour Law: things to know about your annual leave.


The employee shall receive his basic pay in addition to housing allowance, if any for the annual leave days.

As the annual leave is for working days this figure must be multiplied by = KD 18. Monthly Salary - enter the gross monthly remuneration of each employee in column F. This amount forms part of the leave provision calculation. Leave Entitlement - enter the annual leave entitlement of each employee in column G. This is the number of days of annual leave that each employee is entitled to for the particular financial year. You will be paid your leave which you have not availed (In lieu of leave ) as : Some companies pay full salary and will be calculated 2. Employee on superannuation. This utility automatically prepare Bill Inner Sheet, Bill Outer Sheet, Bill Extract, Input Statement, Annexure etc.


Most employers have their own rules. Usually the basic salary and dearness allowance is taken in consideration for calculation of the amount. Days where the Salary has been decuted for the same. You are entitled to get salary for unused leaves. Can I get leave salary and air ticket (as was mentioned in my job contract) now for the current year?


In this video i have shown you how to calculate the Amt. Encashment leave salary seperate shows in basic,da,hra in record. If you’ve been employed by the company for more than years, you calculate days’ salary for each year of employment. Basic salary : Dh10Step 1.

No comments:

Post a Comment

Note: Only a member of this blog may post a comment.

Popular Posts