You are here: SKB Home » HRMS Payroll » hrmsprocguide » Salary Increase Excel Import
Differences
This shows you the differences between two versions of the page.
spay:hrmsprocguide:salary_increase_import [2022/01/15 15:45] mclement |
spay:hrmsprocguide:salary_increase_import [2022/01/15 16:19] (current) mclement |
||
---|---|---|---|
Line 3: | Line 3: | ||
Salary increase amount can also be imported using an Excel file as shown below. | Salary increase amount can also be imported using an Excel file as shown below. | ||
- | ===== Government Salary Increase Excel Import===== | + | ===== Salary Increase Excel Import===== |
- | To import the Government Salary Increase Excel file, follow the steps below: | + | To import the Salary Increase Excel file, follow the steps below: |
{{:spay:hrmsprocguide:hrmssalincexceltemplate.png|}} | {{:spay:hrmsprocguide:hrmssalincexceltemplate.png|}} | ||
Line 18: | Line 18: | ||
{{:spay:hrmsprocguide:hrmsimportexcelopenwith.png|}} | {{:spay:hrmsprocguide:hrmsimportexcelopenwith.png|}} | ||
+ | |||
** * Step 4:** Click OK | ** * Step 4:** Click OK | ||
- | {{:spay:hrmsprocguide:hrmsexceltemplate.png|}} | ||
- | ** * Step 5:** Fill in and Save the excel template as shown above | + | {{:spay:hrmsprocguide:hrmsexceltemplatefillinandsave.png|}} |
+ | |||
+ | ** * Step 5:** Fill in the excel template - sheet PD_Format2 as shown above | ||
+ | |||
+ | ** * Step 6:** Save the file | ||
+ | |||
+ | {{:spay:hrmsprocguide:hrmsexceltemplateclickuploadpng.png|}} | ||
+ | |||
+ | ** * Step 7:** To import the excel file, click upload as shown above | ||
+ | |||
+ | {{:spay:hrmsprocguide:hrmsexceltemplatebrowse.png|}} | ||
- | {{:spay:hrmsprocguide:hrms_salary_increase_import_sheet1_2020.png|}} | + | ** * Step 8:** Browse the Excel file, Click Open |
- | ** * Step 7:** To import the excel file, browse the Government Salary Increase file | + | {{:spay:hrmsprocguide:hrmsselecttoimport.png|}} |
- | ** * Step 8:** You are prompted to Select the respective excel sheet | + | ** * Step 9:** You are prompted to Select the excel sheet |
- | ** * Step 9:** Click OK | + | ** * Step 10:** Click OK |
- | {{:spay:hrmsprocguide:hrmssalincreaseimportedamount.png|}} | + | {{:spay:hrmsprocguide:hrmsimportsuccessfulcloseimport.png|}} |
- | ** * Step 10:** verify the number of records and the total amount imported through Payments/Deductions | + | ** * Step 11:** Close the window after the successful import |
+ | {{:spay:hrmsprocguide:hrmssalincreaseimportedamount1.png|}} | ||
+ | ** * Step 12:** Go to Payments/Deductions to verify the imported salary increase figures | ||
===== Company Salary Increase Excel Import===== | ===== Company Salary Increase Excel Import===== |