Smart Excel HR & Payroll System
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.
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.
Related categories:
PHP
Visual Basic
Excel
Microsoft Access
Excel VBA
Data Visualization
Data Analysis
Automation
Database Management