New Employee Entry
ESI Number
UAN Number
Employee Directory
| Employee Code | Name | Designation | Department | Work Location | Type | Joining Date | Mobile | Gross Salary | Leave Balance | Status | Actions |
|---|
Bulk Employee Upload
Instructions for Bulk Upload
- Download the Excel template using the button below
- Fill in employee details in the template (do not modify column headers)
- Save the file and upload it using the file input below
- Review the preview and click "Import Employees" to complete
Upload Employee File
Required Excel Format
Column Headers (Required - do not change):
| Employee Code | Full Name | Date of Birth | Date of Joining | Designation | Department | Employment Type | Mobile Number | Aadhar Number | PAN Number | Basic Amount | Allowance | Opening Leave Balance | Work Location | Bank Account | IFSC Code | Bank Branch | ESI Eligible | PF Eligible | Bonus Eligible | ESI Number | UAN Number |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| EMP001 | John Doe | 15-01-1990 | 01-01-2023 | Software Engineer | IT | Permanent | 9876543210 | 123456789012 | ABCDE1234F | 25000 | 15000 | 10 | Bangalore | 1234567890123456 | ICIC0001234 | Main Branch | Yes | Yes | Yes | 12345678901 | 123456789012 |
Important Notes:
- Date Format: DD-MM-YYYY (e.g., 15-01-1990, 01-01-2023)
- Employment Type: Permanent or Contract
- ESI/PF/Bonus Eligible: Yes or No
- Mobile: 10-digit number starting with 6-9 (Optional - can be left empty)
- Email: Valid email format (e.g., user@company.com)
- Aadhar: 12-digit number
- PAN: Format: ABCDE1234F (Optional - can be left empty)
- IFSC: Format: ABCD0123456
- Allowance: Can be zero or left empty (will default to 0)
- Opening Leave Balance: Number of days (0-365, can be decimal or zero)
- ESI Number: 10-digit number (if ESI eligible)
- UAN Number: 12-digit number (if PF eligible)