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
Related Articles
How to map Deductions with Excel Columns
SME Payroll Software has a function that allows users to import allowances and deductions from the excel file which was prepared in a specific format. To do the mapping, follow the given steps: Step 01: Go to the "Admin” module and select the "Manage ...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 ...How to map Additions with Excel Columns
SME Payroll Software has a function that allows users to import allowances and deductions from the excel file which was prepared in a specific format. To do the mapping, follow the given steps: Step 01: Go to the "Admin” module and select the "Manage ...How to Create AMCS File
To create the AMCS follow the given steps: Step 01: Go to the “Reports” module and select the “AMCS” from the drop-down list. Step 02: From here go to the “Manage AMCS” tab. Select the “Year”, “Month”, “CSN”, and click the “Go” button. Step 03: Now ...How to Generate Bank Giro File
To generate a bank GIRO file and submit to the company's bank, follow the given steps: Step 01: Go to the “Reports” module and select the "Bank/Online Mid-Month Giro" from the drop-down list. Step 02: In this “Bank Giro” tab, select "Year", "Month", ...