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 Settings” from the dropdown list.
Step 02: From here go to the “Payroll” tab and click the “Multi Addition Mapping” option.
Step 03: Click the edit icon from the leftmost column of the table.
Step 04: Select the “Addition Type” from the drop down list to map with the column 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 additions.
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 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 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 add payroll additions to employee’s monthly salary
To add new payroll addition to the employee’s monthly salary follow the given steps: Step 01: Go to the “Payroll” module and select the “Addition/Multi Additions” from the drop-down list. Step 02: Click the “Add New Payroll Addition” button at the ...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 ...