How to import Additions from an excel file

How to import Additions from an excel file


The user can import the additions from the excel file to the monthly payroll. (User should have done mapping under Admin Management.) Follow these given steps to import excel file:
Step 01: Go to the “Payroll” module and select the “Addition/Multi Additions” from the drop-down list.



Step 02: From here go to the “Multi Additions” tab.



Step 03: Select the check-box "Import From Excel". Then Select 'Year', 'Month', 'Department', and click the “Choose File” button. 



Step 04: Browse for the location where the file is saved, and select the file and click the 'Open' button.



Step 05: Once the file is chosen click the “GO” button to view the employee's list along with the addition amount as shown in the picture.



Step 06: Select the Checkbox at the rightmost column and click the ”UPDATE” button at the bottom of the list to make the changes effective.




Step 07: Once updated “Successful Alert” appears.



Product Version: SMEPayrollTM Version 11