Timesheet and Overtime Calculator App (UAE)

Timesheet and Overtime Calculator is an offline app (one HTML file in a zip) for UAE businesses that collect in and out times on paper, WhatsApp or loose spreadsheets and then rebuild regular, overtime, rest-day and public-holiday hours by hand every month. You enter or import the times once; the app classifies every day, shows the hours per person and period, works out weighted pay-hours and overtime pay, and exports a payroll CSV. It also prints blank and filled weekly timesheets for signature.

The problem it removes: month-end overtime counting. Doing it by hand or with fragile formulas costs hours, and one wrong week (an overnight shift, a holiday that fell on a weekend, a break forgotten) becomes a payroll dispute. Here the rules are settings you enter once and every day follows them.

What is inside:

• Weekly sheet: pick a person and a week, type in / out / break for seven days; net hours, day type and the regular / overtime / rest-day / holiday split update as you type
• Rules as settings: regular daily or weekly hours, daily or weekly overtime method, multipliers for overtime, rest days and public holidays, rounding to 5, 10, 15 or 30 minutes, an alert for over-long days, weekend days, week start day
• Public-holiday list you type or import; a holiday beats a rest day beats a working day
• Overnight shifts, leap-day dates and DD/MM/YYYY entry with clear error messages
• Pay-hours summary per person for any period, weighted pay-hours, overtime pay due per person from an hourly rate or monthly basic divided by your monthly-hours divisor, all in exact whole fils
• CSV import of staff and of timesheet entries with a preview and line-numbered errors before anything is applied; payroll CSV and entries CSV export
• Printable A4: blank weekly timesheet forms for all staff, filled timesheet, period summary
• Example data, example CSV files (including one with deliberate errors), JSON backup and restore, Clear everything

Rules are settings, not built in. Fresh installs leave regular hours, overtime method and multipliers blank on purpose, and the app warns wherever a result depends on them. UAE working-hour and overtime rules depend on your emirate, free zone, sector and contracts and change: verify every value with MOHRE / your PRO / your lawyer. The example data uses example values only.

Who it is for: office managers, HR officers, shop, warehouse, clinic and restaurant managers and small payroll teams.

What it is NOT: legal or payroll advice; not a WPS file generator; not a biometric or time clock (people or you type the times, or import a CSV); not connected to any government system. Night-shift premiums, tiered overtime bands and one-person split rows per day are not built in. The existing Staff Attendance, Overtime and Shift Planner is an Excel workbook; this is a separate offline app with import, validation, exact integer maths and printed forms, and does not replace payroll software.

Your data stays on this device in your browser. Back it up with Export; clearing browser data loses it otherwise.

Verified by us: scripted browser tests in Chromium (45 checks through the real screens, including date, leap-year, week-boundary, weekend-setting, rounding, CSV import, export, backup and print flows) and an independent Python (Decimal and datetime) recalculation of 150 random staff-period summaries (hours by category, weighted pay-hours and amounts) with zero mismatches. The test pass also ran in WebKit (43 checks). Firefox could not be launched in our test environment, so it is untested there. Not tested on a real phone or in Microsoft Edge or desktop Safari; layout was checked at 375 px and 1280 px widths.