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 Settings” from the drop down list.
Step 02: From here go to the “Payroll” tab and click the “MultiDeduction Mapping” option.
Step 03: Click the edit icon from the leftmost column of the table.
Step 04: Select the “Deduction Type” from the dropdown list to map with the column variable and click the “UPDATE” button.
Step 05: Once updated ”Successful Alert” appears.
The below image is the sample of the excel file which is ready to import deductions.
Kindly go through the below notes for the first time preparation:
|
01. Not advise changing the name of "Sheet1". 02. Making changes in the first row is prohibited. 03. Second Row is to save the payroll month information. 04. Third Row is to save the headers which are more user_friendly to the person who prepares the excel file. 05. First Column is to key in "Time Card ID". It must be a unique number. |
|
06. Second Column can be used to key in any information which the user finds useful. Can leave it blank also. |
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 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 add payroll deductions to employee monthly salary
To add deductions to employee's monthly payroll follow the given steps: Step 01: Go to the “Payroll” module and select the “Deduction/Multi Deductions” from the drop-down list. Step 02: Click the “Add New Payroll Deduction” button at the bottom of ...Will CPF be calculated based on the CPF gross salary or the net salary after all the deductions and additions ?
What is Gross Salary? It signifies the amount paid out to an individual before any voluntary or mandatory deductions are made from it. Therefore, it is the total pay that an employee receives before taxes and other deductions. CPF is calculated on ...