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
Related Articles
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 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 ...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 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", ...