How to import Deductions from an excel file
The user can import the deductions 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 “Deduction/Multi Deductions” from the drop-down list.
Step 02: From here go o the “Multi Deductions” tab. And select the check-box "Import From Excel". Then Select 'Year', 'Month', 'Department', and click the “Choose File” button.
Step 03: Browse for the location where the file is saved, and select the file and click the “Open” button.
Step 04: Once the file is chosen click the “GO” button to view the employee's list along with the deduction amount as shown in the picture.
Step 05: Select the Checkboxes at the rightmost column and click the “UPDATE” button at the bottom of the list to save the changes effective.
Step 06: Once updated “Successful Alert” appears.
Product Version: SMEPayrollTM Version 11