Adding employees, one at a time or from Excel
How to put your people in: typing one in, or reading a whole list from a spreadsheet you already have.
Employees are under Establishments and people, Employees. Operators, Managers and Owners can add and change them.
One at a time
- Choose Add on the Employees list.
- Fill in Identity (name, father's or spouse's name, gender, date of birth) and Employment (date of joining, designation, department).
- Under Statutory numbers enter PAN (needed for income tax and Form 16), UAN (needed for the PF return) and the ESI number where they are covered.
- Under Banking enter the account number and IFSC — without them nobody can be paid by bank file.
- Add Nominees at the bottom; the shares should total 100.
- Choose Save. Each person is given a serial in the employee register, never reused.
PAN, UAN, PF and ESI numbers and bank accounts are stored encrypted. Typing a full PAN or UAN in the list's search box still finds the person.
From an Excel file
- On the Employees list choose Import from Excel.
- Choose the establishment under Import into, then the file (.xlsx). Leave Update employees already on file ticked to refresh people already there, matched on employee code.
- Choose Read the file.
The file needs a column headed Name of the Employee, Employee name or Name of employee in its first 30 rows. Other columns are found by what they say — emp code, father, gender, designation, date of joining, date of birth, gross salary, mobile, account no, bank name, IFSC, PF no, ESI no, PAN, UAN, department, email — in any order. Dates can be 31-12-2024, 31/12/2024, 2024-12-31, 31.12.2024 or 31-Dec-2024.
Check it worked
- The result page says how many were added and updated.
- Rows listed under read, with something left out had a PAN, UAN, IFSC or email in the wrong shape: that one value was left out. Correct it on the person's record.
- Rows listed under could not be read were skipped.
- A row with no employee code is given AUTO0001, AUTO0002 and so on. Change these to your own codes.