EXPIRING WITHIN 90 DAYS
FAMILY DEPENDENTS
BACK
BACK
ALERT THRESHOLD
Notify when permit expires within:
BACK
Leave Tracker
Active leaves & return dates
BACK
HR Analytics
Reports & Analytics
BACK
Full & Final Settlement
Solymar Hotel - Bahrain Labor Law
Employee Information
Dates & Salary
Earnings
Days owed from previous month not yet paid
▼ Deductions
days
days × (Basic ÷ prev month days)
days
days × (Basic ÷ last month days)
days × (salary÷30)
× Basic÷365×30
× Basic÷365×30
× Basic÷365×30
BACK
Leave Salary Calculation
Solymar Hotel - Bahrain Labor Law
Employee Information
Salary Details
Leave Entitlement Days
Salary Period Calculation
Formula: (Basic + Transport) ÷ Month Days × Days Worked − GOSI | HRA: add manually in Additional Rows
BACK
Overtime Calculator
Bahrain Labor Law - Private Sector
Salary Details
BD
BD
Overtime Hours by Day Type
Official Holiday
Public holidays issued by Council of Ministers
Rate = 150% extra
Weekly Rest Day
Employee weekly rest day (Friday)
Rate = 150%
☀ Daytime Hours
7 AM to 7 PM
Rate = 125%
🌙 Nighttime Hours
7 PM to 7 AM
Rate = 150%
📚 Calculation Basis
• Hourly Rate = (الأساسي + العلاوات) ÷ 208 ساعة
• Official Holiday = الساعي × عدد الHours × 150% إضافي
• Weekly Rest = الساعي × عدد الHours × 150%
• Daytime (7AM-7PM) = الساعي × عدد الHours × 125%
• Nighttime (7PM-7AM) = الساعي × عدد الHours × 150%
• 208 = عدد Hours العمل الشهرية (8 hours × 30 days)
• Result = overtime pay only (excludes base daily pay)
• Official Holiday = الساعي × عدد الHours × 150% إضافي
• Weekly Rest = الساعي × عدد الHours × 150%
• Daytime (7AM-7PM) = الساعي × عدد الHours × 125%
• Nighttime (7PM-7AM) = الساعي × عدد الHours × 150%
• 208 = عدد Hours العمل الشهرية (8 hours × 30 days)
• Result = overtime pay only (excludes base daily pay)
BACK
BACK
BACK
Payslip Generator
Generate monthly payslips for any employee
Employee & Period
Salary Components
Deductions
BACK
Disciplinary Log
Track offences and disciplinary actions
BACK
Audit Log
Admin only — all system actions recorded
BACK
GitHub Data Viewer
Admin only — view & sync employee data from GitHub
GitHub Raw URL
Paste a raw GitHub URL to a JSON employee data file. Admin access only.
BACK
📊 Import Data
Upload Excel or CSV to update the live Supabase database
Upload Excel or CSV File
Supports .xlsx, .xls and .csv — employees matched by CPR number
📂
Tap to choose file
.xlsx, .xls or .csv
Required Column Names in your file
name — Full name
cpr — CPR (key field)*
emp_code — Employee #
pp — Passport no.
dept — Department
title — Job title
nationality — e.g. IND
gender — M or F
wp_expiry — DD-MM-YYYY
pp_expiry — DD-MM-YYYY
status — RENEWED etc.
basic — Basic salary
housing — Housing allow.
transport — Transport allow.
* CPR matches existing employees. New CPR = new employee added.