Salary Settings

In this help topic, you will learn how to add a new employee detail, import existing and ex-employee details, bulk Employee delete, Marking Bulk Left Employee, Generate UAN number for employees and Import UAN numbers of employees who already have UAN.



Employee Master & Details in Excel Payroll

To create Employee details:

  1. Click on Employee menu and Select Employee in the sub-menu.
  2. In the screen that opens, click on New.
  3. Fill details such as Employee Number, Employee name, Join Date, Gender, Designation, Department, Branch & Mobile No.
  4. Fill in all the further information in the tabs such as Personal Info, Bank details, Statutory details & Other details.


Employee Personal Details entry screen in Payroll Software

Click on Save button to save details.

Import

You can import Employee details in bulk.



Import Employee Personal Details in Excel Payroll Software

To import Employee details:

  1. Click on Import button, select the Download template option.
  2. Fill details in the downloaded Excel sheet.
  3. In the import screen, click on the Choose File. In the popup select updated excel file.
  4. By Clicking on the Import button, all the details can be imported. If there are missing information system will prompt you indicating the same.


Choose Ecel Sheet for Employee Detais in Excel Payroll Software

Change Department/Designation/Branch



Change Department , Branch of Eployee in Excel Payroll

To update the details of Department, Designation & Branch details.

  1. Click on Change Designation/Department/Branch icon under Action.
  2. In the window that opens, Fill in the details such as From month, Year, Designation, Department & Branch.


Save Employee Personal Details in Employee Master

Click on Save button to save details.


Employee Contacts

Additional contacts of Employees can be stored.



Employee Personal Details in Employee Master of Excel Payroll
    Software

To create Employee Contacts:

  1. Click on Employee menu and Select Contacts sub-menu.
  2. In the screen that opens, select Employee Name, Relationship & enter Phone Number.


Create employee contact in Employee Master

Click on Save button to save details.

Relationship



Relationship Screen in Employee Master & Details

You can add Items to Relationship Dropdown

  1. To add more Relationships, Click on Relationship button.
  2. In the window that opens, enter Relationship.


Add relationship in Employee Master & Details of Excel Payroll
    Software

Click on Save Button to save details.


Bulk Employee Delete

You can delete Employee details in bulk.



Bulk employee Details in Excel Payroll

To delete Employees in bulk:

  1. Click on Employee menu, and Select Bulk Employee Delete sub-menu.
  2. In the screen that opens, select Employee Name.


Add Bulk employee details in Employee Master of excel payroll
    software

Click on Bulk Delete.


UAN Generation

You can generate UAN Numbers for the PF applicable employees. A text file is required to submit to the Govt. portal to generate UAN numbers.



UAN generation in Employee Master of excel payroll software

To create a file for UAN Generation:

  1. Click on Employee menu and Select UAN Generation sub-menu.
  2. In the screen that opens, select Employee Name.


Generate UAN for Employee in Employee Master

Click on Generate UAN No. Download text file from EPFO Portal.

Import UAN

When UAN is generated in bulk, it can be imported to the application from the template.



Import UAN to for Excel Payroll Application

To Import UAN:

  1. Click on Employee menu and Select Import UAN sub-menu.
  2. In the screen that opens, Click on Download Template.
  3. Fill in the details in the downloaded excel template.


Download UAN template Employee Master & Details screen

In the import UAN screen, click on Choose File and select the updated file.



Upload UAN file in Employee Master & Details screen

Click on Import button to import the details.