Employee Document Expiry and Renewal Cost Tracker App

A passport that expires in a client's busy season, a visa found expired on the day of a site visit, a renewal bill nobody budgeted. This app keeps every employee document in one place, shows what is expiring, and tells you what the renewals will cost and when to start them.

You list your employees, then add each document with its type, number, expiry date and where the paper or file is kept. The app colours each one by days left, with a word on every badge as well as a colour (for example Critical in 5d, Expired 20d ago). You enter the default renewal cost and the lead time per document type once, and the app builds a 12 month cost forecast, in exact fils, split by month and by document type.

What is inside:

• Dashboard: counts by status (expired, critical, warning, coming up, OK), the list that needs attention now, and the AED you should be spending now on renewals already due
• Status windows you set (they start at 30, 60 and 90 days, inclusive at the edges), filter and sort by status, type and department, search by name, code, document number or file location
• Editable document types: passport, residence visa or permit, Emirates ID, labour card or work permit, medical insurance, driving licence, professional licence, other, and any you add. Default cost and start-renewal lead per type, optional cost per document
• Renewal cost forecast for 12 months from any month: cost lands in the month of expiry minus lead days (or the expiry month, your choice), with an overdue row, a later row, totals, and a Needs renewal now box
• Renewed button: enter the new expiry and the old number and dates stay in the document history. Mark renewals in progress
• Printable A4: a per-employee file index that lists missing standard documents as MISSING, an expiring soon list for any window you choose grouped by department, and the forecast
• CSV import of employees and documents with line-numbered errors and unknown document types created for you, CSV export of documents and the forecast, JSON backup and restore, example data, and an Instructions page inside the app

Who it is for: owners, HR officers and PROs of small and mid-size UAE companies who look after anything from a handful to a few hundred staff.

What it is NOT: it does not know which documents UAE law requires for a person, what the fees are, or how long a renewal takes. A fresh install has no costs or lead times filled in on purpose and shows a warning until you enter them from your own quotes and your PRO. Example data uses illustrative figures only. It does not read scans, store the document files themselves (only where you keep them), connect to any government or insurer system, or send reminders, so open it weekly. Data stays in your browser on this device, so export backups.

Neighbours: the Employee Visa and Document Expiry Tracker is an Excel workbook for the same job in cells, and the Licence and Document Expiry Tracker covers company licences. This app adds the cost forecast, document history, per-employee file index and print lists.

Verified by scripted Chromium tests (93 assertions: window boundaries, leap-day and month-end cost dates, DD/MM/YYYY parsing, filters, renewal history, inactive staff, CSV imports with bad rows, printing with PDF page counts, backup and restore) and an independent Python model that matched statuses, cost dates, the 12 month forecast, the needs-now bucket and the expiring soon lists on 50 random cases (1,349 documents, 234 of them exactly on a window edge). Firefox could not be launched in the test environment, so it was not tested. Not tested on a physical phone.