How to Calculate Payroll in UAE: Complete Guide & Formula

How to Calculate Payroll in UAE

Calculating payroll in the UAE requires more than simply adding an employee’s basic salary and allowances. A proper payroll calculation may include basic salary, fixed allowances, variable allowances, overtime, leave, absences, deductions, loans or advances, end-of-service provisions and WPS salary processing.

For companies managing payroll manually in Excel, calculating salaries for every employee can become time-consuming and prone to errors, especially when employee salaries, attendance, overtime, leave and deductions change every month.

This guide explains how to calculate payroll in the UAE step by step, and how payroll software can automate the process.

Important: This article is intended as a general payroll calculation guide for UAE private-sector employers. Payroll treatment can vary depending on the employee’s contract, employment category, company policy and applicable UAE legislation. Always verify specific legal cases with the relevant UAE authority or qualified adviser.

What Is Payroll Calculation?

Payroll calculation is the process of determining the amount an employee should receive for a particular salary period after considering all applicable earnings and deductions.

A simplified payroll formula is:

Net Salary = Gross Earnings – Total Deductions

Where:

Gross Earnings = Basic Salary + Fixed Allowances + Variable Allowances + Overtime + Other Payable Earnings

Depending on the employee and company, deductions may include approved salary deductions, unpaid absence, loan or advance repayments and other legally permitted deductions.

The UAE Labour Law regulates employment relationships in the private sector, including matters such as wages, working hours, overtime, leave and end-of-service benefits.

How to Calculate Payroll in UAE Step by Step

A practical UAE payroll process can be divided into the following steps:

1. Maintain employee master data
2. Confirm the salary structure
3. Calculate basic salary and fixed allowances
4. Calculate variable earnings
5. Calculate overtime
6. Calculate leave and absence adjustments
7. Calculate approved deductions
8. Calculate gross salary
9. Calculate net salary
10. Generate payslips and payroll reports
11. Prepare WPS salary processing
12. Maintain payroll records

Let’s look at each step in detail.

1. Maintain Employee Master Data

Before calculating payroll, maintain accurate employee information.

Important employee payroll information may include:

• Employee name
• Employee ID
• Designation
• Department
• Date of joining
• Employment contract details
• Basic salary
• Housing allowance
• Transportation allowance
• Other fixed allowances
• Bank details
• WPS-related information
• Working schedule
• Leave balance
• Attendance information
• Overtime records
• Loans and salary advances
• Employee documents and expiry dates

Whenever an employee receives a salary increment, allowance change, promotion or other payroll-related change, the employee master record should be updated.

Keeping these details in Excel can work for a very small company, but maintaining multiple spreadsheets becomes increasingly difficult as the number of employees grows.

A UAE payroll system can maintain employee information centrally and use the updated data automatically during monthly payroll processing.

2. Understand Basic Salary and Allowances

The next step is to identify the employee’s salary components.

A typical salary structure may contain:

Basic Salary + Housing Allowance + Transportation Allowance + Other Allowances = Contractual Monthly Wage

For example:

The exact salary structure depends on the employment contract and company arrangement.

It is important not to treat every allowance as basic salary. Certain UAE employment calculations, including overtime and end-of-service gratuity, use the basic salary as a specific calculation component.

For example, the official UAE Government guidance states that private-sector overtime is calculated based on the basic salary, while end-of-service gratuity for eligible foreign workers is also based on the basic salary rather than allowances.

3. Calculate Gross Salary

Gross salary represents the employee’s earnings before applicable deductions.

A basic payroll calculation can be represented as:

Gross Salary = Basic Salary + Fixed Allowances + Variable Allowances + Overtime + Other Earnings

For example, suppose an employee has:

• Basic salary = AED 5,000
• Housing allowance = AED 2,000
• Transportation allowance = AED 500
• Monthly commission = AED 1,000
• Overtime = AED 400

Then:

Gross Earnings = 5,000 + 2,000 + 500 + 1,000 + 400

Gross Earnings = AED 8,900

The actual payroll calculation should then apply the relevant deductions and adjustments.

4. Calculate Overtime in UAE

Overtime is an important part of UAE payroll calculation.

Under the UAE private-sector Labour Law, overtime is generally calculated using the employee’s basic salary, not the total salary including allowances. The official UAE Government guidance states that overtime during normal circumstances is paid at the normal working-hours remuneration based on basic salary plus an increase of at least 25%. Overtime between 10 PM and 4 AM generally carries an increase of at least 50%, subject to the applicable rules and shift-worker exception.

Work performed on the employee’s contractual or regulated rest day can involve a substitute rest day or payment based on normal working-day remuneration plus an increase of at least 50% of the basic wage for that day.

Basic overtime calculation formula

A commonly used calculation approach is:

Hourly Basic Rate = Basic Salary ÷ 30 ÷ 8

Then:

Normal Overtime Rate = Hourly Basic Rate × 1.25

For example, if the basic salary is AED 5,000:

Hourly Basic Rate = 5,000 ÷ 30 ÷ 8

Hourly Basic Rate = AED 20.83

For eligible normal overtime:

Overtime Rate = AED 20.83 × 1.25

Overtime Rate = AED 26.04 per hour

If the employee worked 10 hours of eligible overtime:

Overtime Pay = AED 26.04 × 10

Overtime Pay = AED 260.40

However, payroll administrators should not blindly apply one formula to every employee. Applicable legislation, employment arrangements, working patterns and exceptions should be considered.

This is one of the areas where payroll software can significantly reduce manual calculation errors.

5. Calculate Variable Allowances and Earnings

Some salary components change every month.

Examples include:

• Sales commission
• Monthly bonus
• Incentive
• Performance payment
• Reimbursement
• Special allowance
• Approved overtime
• Other variable earnings

For example:

The payroll administrator should ensure that variable payments are supported by the company’s approved payroll records.

6. Calculate Absence and Unpaid Leave Adjustments

If an employee has an unpaid absence or other unpaid period, the payroll calculation may need an adjustment.

A commonly used monthly calculation approach is:

Daily Salary Rate = Applicable Monthly Salary ÷ 30

Then:

Absence Deduction = Daily Salary Rate × Unpaid Days

For example, if the applicable monthly salary is AED 9,000 and the employee has 2 unpaid days:

Daily Rate = AED 9,000 ÷ 30 = AED 300

Absence Deduction = AED 300 × 2 = AED 600

The exact basis for the calculation should follow the applicable employment terms and UAE regulations.

Payroll software can automatically calculate these adjustments when attendance and leave information is integrated with payroll.

7. Calculate Leave-Related Salary Adjustments

Employee leave is another important part of payroll processing.

Depending on the type of leave, an employee may receive:

• Full salary
• Partial salary
• No salary
• Leave salary
• Other applicable entitlements

The payroll administrator should identify the type of leave before calculating the employee’s salary.

For example, sick leave has specific UAE Labour Law rules concerning eligibility and the amount of salary payable during different stages of sick leave.

Therefore, payroll should not simply deduct every day marked as “leave”.

The payroll system should distinguish between different leave types and apply the relevant payroll rules.

8. Calculate Payroll Deductions

After calculating earnings, the payroll administrator needs to calculate applicable deductions.

Depending on the circumstances, deductions can include:

• Approved salary advance repayment
• Employee loan instalment
• Unpaid absence
• Approved deductions
• Employee contributions where applicable
• Other legally permitted deductions

Employers should not make arbitrary deductions from an employee’s salary. UAE Labour Law specifies circumstances in which deductions or withholding from wages are permitted and includes limitations for certain deductions.

For this reason, payroll software should maintain a clear record of the reason and amount for each deduction.

9. Calculate Net Salary

Once all earnings and deductions have been calculated, determine the employee’s net salary.

The simplified formula is:

Net Salary = Gross Earnings – Total Deductions

For example:

Therefore:

AED 8,800 – AED 700 = AED 8,100

The actual payroll calculation for an employee may contain many more components.

10. Prepare Employee Payslips

After calculating payroll, generate a payslip for each employee.

A useful payslip should clearly show:

• Employee name
• Employee ID
• Pay period
• Basic salary
• Allowances
• Overtime
• Variable earnings
• Deductions
• Net salary
• Other relevant payroll information

Payslips help employees understand how their salary was calculated and provide a useful payroll record for the employer.

Creating individual payslips manually in Excel or Word every month can be time-consuming.

Payroll software can generate payslips automatically after payroll processing.

11. Prepare WPS Salary Processing

For many UAE private-sector employers registered with MoHRE, salary payment through the Wages Protection System (WPS) is an important part of payroll processing.

The UAE Government states that MoHRE-registered establishments must pay employee wages through WPS, subject to applicable rules and exemptions. WPS enables salary payments through authorised banks, exchange houses or financial institutions.

MOHRE describes WPS as an electronic wage-transfer system designed to monitor timely and accurate payment of workers’ registered wages.

Therefore, payroll processing should not end after calculating net salary.

A typical process is:

Employee Data → Payroll Calculation → Salary Approval → WPS File/Payment Processing → Salary Transfer → Payroll Records

This is another reason UAE companies often prefer dedicated WPS payroll software rather than maintaining payroll entirely in spreadsheets.

12. Maintain Payroll Reports and Records

After completing payroll, maintain appropriate payroll reports.

Useful payroll reports include:

• Monthly salary statement
• Employee salary report
• Payroll summary
• Overtime report
• Leave report
• Absence report
• Deduction report
• Loan and advance report
• Payslip report
• WPS-related payroll information
• Payroll comparison report

These reports can help HR and finance teams review payroll before salary payment.

Example of Complete UAE Payroll Calculation

Let’s take a simple example.

An employee has:

• Basic Salary: AED 6,000
• Housing Allowance: AED 2,000
• Transportation Allowance: AED 500
• Commission: AED 1,000
• Eligible Overtime: AED 400
• Loan Deduction: AED 500
• Unpaid Absence Deduction: AED 200

Step 1: Calculate Gross Earnings

AED 6,000 + AED 2,000 + AED 500 + AED 1,000 + AED 400 = AED 9,900

Step 2: Calculate Total Deductions

AED 500 + AED 200 = AED 700

Step 3: Calculate Net Salary

AED 9,900 – AED 700 = AED 9,200

Therefore, the employee’s calculated net salary in this example is:

AED 9,200

This is a simplified example. Actual payroll calculations should consider the employee’s contract, attendance, leave, overtime eligibility, applicable deductions and relevant UAE regulations.

What Is the Difference Between Basic Salary, Gross Salary and Net Salary?

Understanding these three terms is essential when calculating payroll in the UAE.

Basic Salary

Basic salary is the employee’s basic wage specified in the employment arrangement, excluding separate allowances.

It is particularly important for certain statutory calculations, including overtime and end-of-service gratuity.

Gross Salary

Gross salary generally refers to total earnings before applicable deductions.

Gross Salary = Basic Salary + Allowances + Variable Earnings + Overtime

Net Salary

Net salary is the amount remaining after applicable deductions.

Net Salary = Gross Salary – Applicable Deductions

Is Payroll in the UAE Calculated on Basic Salary or Gross Salary?

The answer depends on the specific payroll component.

For example, UAE private-sector overtime calculations are based on the basic salary under the applicable Labour Law provisions, while end-of-service gratuity for eligible foreign workers is also calculated using the basic salary.

However, the employee’s contractual wage may include basic salary plus allowances.

Therefore, payroll administrators should maintain separate fields for:

• Basic salary
• Allowances
• Gross earnings
• Deductions
• Net salary

This separation makes payroll calculations easier to audit and manage.

How to Calculate Monthly Payroll in UAE

A practical monthly payroll workflow can be summarised as:

1. Update employee master data

↓

2. Import or verify attendance

↓

3. Calculate leave and absences

↓

4. Calculate basic salary and allowances

↓

5. Calculate overtime

↓

6. Add commissions, bonuses and other variable earnings

↓

7. Calculate loans, advances and other permitted deductions

↓

8. Calculate gross earnings

↓

9. Calculate net salary

↓

10. Generate payslips and salary reports

↓

11. Prepare WPS salary processing

↓

12. Review and approve payroll

↓

13. Process salary payment

This process can be completed manually for a small workforce, but automation becomes increasingly valuable as the number of employees grows.

Why Is Manual Payroll Calculation Difficult?

Many companies initially calculate payroll using Excel spreadsheets.

This may work when there are only a few employees, but payroll becomes more complicated when the company has:

• 20+ employees
• Different salary structures
• Multiple allowances
• Overtime
• Monthly commissions
• Employee loans
• Salary advances
• Different leave types
• Frequent employee changes
• Attendance integration
• WPS requirements
• Multiple departments
• Monthly payroll reporting requirements

A small error in one formula can affect an employee’s salary.

Manual payroll also requires HR or finance staff to repeatedly enter the same information every month.

How Payroll Software Simplifies UAE Payroll

A UAE payroll software system can automate many repetitive payroll tasks.

For example, EasyHR UAE payroll software can help companies manage:

• Employee records
• Basic salary and allowances
• Attendance
• Leave management
• Overtime
• Employee loans
• Salary advances
• Payroll calculations
• Payslips
• Payroll reports
• WPS SIF file generation
• End-of-service calculations
• Employee document records

Instead of manually calculating every employee’s salary in Excel, the payroll team can maintain employee information once and process payroll using the stored salary and payroll data.

Benefits of Using Payroll Software in UAE

1. Faster Payroll Processing

Payroll software can automatically calculate salary components for multiple employees instead of requiring HR staff to calculate each employee separately.

2. Fewer Manual Errors

Automated formulas reduce the risk of common Excel calculation and data-entry mistakes.

3. Automatic Overtime Calculation

Different overtime categories and approved overtime hours can be processed according to the configured payroll rules.

4. Automatic Leave and Absence Calculations

Approved leave and unpaid absence can be incorporated into payroll without manually recalculating every employee.

5. Employee Loans and Advances

Loan or advance instalments can be automatically included as payroll deductions.

6. Payslip Generation

The system can generate employee payslips after payroll is processed.

7. Payroll Reports

HR and finance teams can generate salary statements and other payroll reports quickly.

8. WPS Processing

A UAE-focused payroll system can help prepare the required WPS salary file based on the processed payroll data.

9. Better Payroll Records

Employee salary history and payroll transactions can be maintained systematically.

How EasyHR Can Help Calculate Payroll in UAE

EasyHR is a UAE-focused HR and payroll software solution designed to simplify employee management and monthly payroll processing.

With EasyHR, businesses can manage employee records, salary structures, attendance, leave, overtime, deductions, loans, payslips and WPS-related payroll processing from one system.

Instead of maintaining separate Excel sheets for employees, attendance, leave, overtime and salary calculations, HR and finance teams can manage these payroll-related processes within one system.

EasyHR Payroll Features Include:

• Employee master records
• Salary and allowance management
• Monthly payroll calculation
• Overtime calculation
• Attendance integration
• Leave management
• Employee self-service
• Loan and salary advance management
• Automatic deductions
• Payslip generation
• Salary reports
• End-of-service/gratuity calculations
• WPS SIF file generation
• Employee document management

If your company is still calculating payroll manually in Excel, payroll software can save significant administrative time and provide a more structured payroll process.

Final Checklist for UAE Payroll Processing

Before finalising monthly payroll, HR or finance teams should check:

• Employee master data is updated
• Salary changes are updated
• Basic salary is correct
• Allowances are correct
• Attendance is verified
• Leave records are updated
• Unpaid absences are checked
• Overtime is approved and calculated correctly
• Commissions and bonuses are added
• Loans and advances are deducted correctly
• Other applicable deductions are reviewed
• Gross salary is verified
• Net salary is verified
• Payslips are generated
• Payroll reports are reviewed
• WPS processing requirements are checked
• Payroll is approved before salary payment

Conclusion: Automate Your UAE Payroll Calculation

Calculating payroll in the UAE manually can become complicated when a company has multiple employees, different salary structures, overtime, leave, attendance, commissions, loans and other payroll components.

The basic calculation can be summarised as:

Gross Earnings = Basic Salary + Allowances + Overtime + Variable Earnings

Net Salary = Gross Earnings – Applicable Deductions

However, accurate UAE payroll processing involves much more than these two formulas. Employers also need to manage attendance, leave, overtime, employee deductions, payslips, payroll reports and WPS salary processing.

For businesses that want to reduce manual Excel work, UAE payroll software can automate much of the monthly payroll process.

Looking for UAE Payroll Software?

EasyHR helps UAE businesses manage employee records, attendance, leave, overtime, payroll calculations, payslips, reports and WPS processing from one HR and payroll system.

Explore EasyHR:
https://delicatesoft.com/hr-and-payroll-software/

Need help with UAE payroll software?

WhatsApp/Call: +971-52-9957352
Website: DelicateSoft.com

Important Note

The payroll examples and formulas in this article are simplified for educational purposes. UAE employment regulations can change, and different employee categories or circumstances may be subject to different rules. Employers should verify specific payroll and employment-law matters against current UAE legislation and official guidance before applying them to employees.