Salary Details

Month

Select Month Sub Menu under Salary Menu. In the Month window, you have to enter Month Details Such as Month Name, Year and lock condition, which will reflect in salary processing.



 Monthly salary calculation screen of excel payroll software

To create a Month:

  1. Click on Salary Menu and Select Month in the sub-menu.
  2. In the screen that opens, select the month.
  3. Fill details such as Year& Locking condition.


Create month in monthly salary calculation screen of excel payroll

Click on Save button to save details. OR use Create Next Month to create month details.


Monthly Salary

In Monthly salary, you can preview the processed salary for the selected Month.



Preview the processed salary for selected month in Excel payroll

To Process Month Salary:

  1. Click on Salary Menu and Select Monthly Salary in the sub-menu.
  2. In the screen that opens, select the Month.
  3. Click on Import Settings button and define the column numbers of excel template and Save and download the template.
  4. Fill the details in the downloaded template.
  5. Click on Import, then Choose the updated file and Import salary details.


Import salary details in excel payroll software

Click on List to view the processed salary.

To Edit processed salary, click on Edit then modify the required component(s) and Click Save.

You will be able to Export processed salary for the selected Month as well.

Compare with Imported Value


You can compare calculated salary details with excel comparison.



compare calculated salary details with excel comparison in excel
    payroll

To Compare with Imported Value:

  1. Click on Salary Menu and Select Compare with Imported Value in the sub-menu.
  2. In the screen that opens, details will be filtered with the latest Month created in Month Screen.


Fill details with latest Month created in Month Screen.

You can filter the records using the filters provided.

Assign Payment Bank

In Assign Payment Bank, assign the payment bank to employees. Here you can configure bank to Employees in bulk.



Assign payment bank to employee in excel payroll


To Assign Payment Bank:

  1. Click on Salary Menu and Select Assign Payment Bank in the sub-menu.
  2. In the screen that opens, select the Payment Bank.
  3. Move Employees by using arrow buttons to Employees assigned with Selected Bank to Add/Remove employees under the selected bank.


Save Employees assigned with Selected Bank in excel payroll

Click on Save button to save details.