Offer: Launch offer: your first 30 days free. Sign up by 31 December 2026. Get started
salarypaypackEvery rupee. Every rule. Book a demo

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.

Anyone who runs the payrollChecked against the software on 14 October 2026

Employees are under Establishments and people, Employees. Operators, Managers and Owners can add and change them.

One at a time

  1. Choose Add on the Employees list.
  2. Fill in Identity (name, father's or spouse's name, gender, date of birth) and Employment (date of joining, designation, department).
  3. 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.
  4. Under Banking enter the account number and IFSC — without them nobody can be paid by bank file.
  5. Add Nominees at the bottom; the shares should total 100.
  6. 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

  1. On the Employees list choose Import from Excel.
  2. 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.
  3. 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.
Still stuck?Write to us or message us on WhatsApp with the screen you are on and what you expected to see. A person answers.
Chat on WhatsApp