Smart Excel HR & Payroll System

Job ID: 39668397

Budget: $30 – $250 USD

I'm looking for an experienced Excel and VBA developer to create an HR & Payroll Management System.

Key Features:
- Central employee database with full details (basic info, job history, emergency contacts) auto-linked to all sheets
- Automated salary calculations (considering join date, deductions, overtime, etc.)
- Automated clock-in/out attendance tracking with monthly calendar generation
- Comprehensive tracking of work permits, residency permits, annual leave, and end-of-service as per Saudi labor law
- Integrated system for managing employee advances and loan installments
- Interactive Dashboard displaying KPIs and visual alerts
- Auto-archiving system for exporting monthly reports (PDF format) per employee
- Multi-year data management support (current, past, and upcoming years)
- Customizable access levels for user control

The ideal candidate should have:
- Expertise in automated linking and structured formatting.
- Strong ability to create user-friendly interfaces.
- Advanced skills in VBA scripting.

Please provide samples of previous similar work.