Excel workbookOfficial Zeyto
Employee Leave and Absence Tracker for UAE Companies
An Excel workbook for owners, HR officers and office managers who need leave answers in seconds.
Answer who is off and how many days remain.
At a glance
- FormatExcel workbook
- DeliveryInstant download
- In the box3 files, 279 KB
- Works withMicrosoft Excel 2016 or later, or Google Sheets
- Made forUAE businesses
How it works
- 1BuyPay on Stripe’s secure page.
- 2DownloadYour order page opens at once with a secure link.
- 3Open and useOpen the workbook in Excel and start from the example.
What you get
- 7 sheets, 50 employees and 500 leave entries
- Working days skip your weekend pattern and holiday list
- Balance to date, year-end balance and overlap check
- Month calendar of who is off each day
- Filled example for six fictional employees
Files and sizes (3)
- employee-leave-absence-tracker.xlsx138 KB
- employee-leave-absence-tracker-example.xlsx138 KB
- README.txt3.3 KB
3 files, 279 KB in total. You download them from your order page after payment.
What it does not do
- You type the holiday dates and confirm entitlements with MOHRE or a lawyer.
- It does not link to payroll.
- The holiday list is empty by design because dates are announced each year, so you type the official dates.
After you buy
- Instant downloadYour order page opens right after payment with a secure link for each file. The link is emailed to you too.
- A fresh link any timeLinks last 48 hours. Enter your order reference and the email you paid with and we will send a new one.
- Help is one email awayWrite to support@zeyto.app with your order reference. The team answers every enquiry.
- Fix, replace or refundIf a file is damaged, will not open, or is materially different from its listing, tell us within 7 days of the sale and we will fix it, replace it or refund you.
Find my purchasesContact the Zeyto teamMarketplace terms
Full refund wording
Digital downloads (files, templates, skill packs, guides) are delivered straight away, so they are not refunded once downloaded. If a file is damaged, will not open, or is materially different from its listing, tell us within 7 days of the sale and we will fix it, replace it or refund you.
Applies to products sold by Zeyto itself. None of this takes away rights you have under UAE law.
About this product
Read the full description
Employee Leave and Absence Tracker is an Excel workbook for small and mid-size UAE companies that still track leave on paper, in WhatsApp or in several sheets. You list your employees once, log each leave or absence, and the workbook counts the working days and shows every balance.
What is inside:
- Seven sheets: Instructions, Settings, Holidays, Balances (up to 50 employees), Leave Log (up to 500 entries), Month View and Worked Example
- Working days counted with your weekend pattern (Saturday and Sunday, Friday and Saturday, or one day) and your own list of public holidays, so a holiday inside a leave period is not charged
- Balance to date (pro rata of the year elapsed), balance at year end if everything booked is taken, carried-forward days and days paid out
- Half days through a days override, and an overlap check that catches two entries for the same person on the same dates
- Counts of sick, unpaid, other paid and absent days, and an absence-pattern score (spells x spells x days) as a prompt for a conversation, with a clear warning not to use it alone
- A Month View calendar: a grid by employee and day with letters for each type of leave and a count of staff off each day
- A filled example with six fictional employees for 2026, and a worked-example sheet that says where to look
Who it is for: owners, HR officers and office managers who need to answer "how many days does she have left?" and "who is off next week?" in seconds.
What it does not do: the holiday list is empty by design because dates are announced each year, so you type the official dates. Entitlements, accrual, carry-over, sick leave pay and the effect of unpaid leave are set by the law and your contract: the 30 days in the file is only an example value, and you replace it after checking MOHRE or a lawyer. It does not send reminders or approvals and does not connect to payroll; copy unpaid and absent days across yourself. For rotating shifts use the Attendance, Overtime and Shift Planner.
Verified by recalculating the filled example with an independent engine and comparing balances with a separate calculation. Not opened in Microsoft Excel itself.
Requirements: Microsoft Excel 2016 or later, or Google Sheets.
Questions
Who is it for?
What do I need to use it?
How do I get it?
What if the file is wrong?
Employee Leave and Absence Tracker for UAE Companies: AED 29
Pay once, download at once.
Damaged, will not open or not as listed? Tell us within 7 days and we fix it, replace it or refund you.
Questions before you buy? Contact the Zeyto team. This is sold by Zeyto (Emeron Infospace FZE) itself, not by an independent seller. See the marketplace terms.
Not sure it is the right one?
Works well with
Other official products that cover the same ground or finish the job.
- Download
Leave Manager App: Balances, Approvals and Team Calendar (UAE)
Offline app that counts leave days (weekends, holidays, half days), keeps a balance per employee from rules you set, runs approvals and shows a team calendar. Prints a leave record per person. Works by double-click, data stays on your device.
Also about leave, hr, attendanceAED 79Instant download - Download
UAE HR Offline Apps Bundle: 10 Working Tools for Leave, Payslips, Rota and More
Ten offline HR apps in one zip: leave, timesheets and overtime, payslips, onboarding, probation, document expiry, shift rota, org chart, recruitment and training. Open by double-click, data stays on your device. AED 491 less than buying separately.
Also about hr, leave, uaeAED 349Instant download - Download
End-of-Service Gratuity Calculator
An Excel estimator for UAE private-sector end-of-service gratuity, for one employee or a whole team, with two daily-rate methods side by side. An estimate for planning and accruals, not a final settlement.
Also about hr, excel, uaeAED 30Instant download - Download
Class Attendance Register with Absence Notices and Missing Note Chase
Offline class register. Start the day's register for every pupil in one tap, change the few who are late or absent, print an absence notice with a slip for the parent to sign, and keep a list of absences with no note yet, plus attendance percent per pupil and per class.
Also about attendance, uaeAED 39Instant download