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 16:11] 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:hrmsexceltemplatefillinandsave.png|}} | {{:spay:hrmsprocguide:hrmsexceltemplatefillinandsave.png|}} | ||
Line 36: | Line 39: | ||
{{:spay:hrmsprocguide:hrmsselecttoimport.png|}} | {{:spay:hrmsprocguide:hrmsselecttoimport.png|}} | ||
- | ** * Step 9:** You are prompted to Select the respective excel sheet | + | ** * Step 9:** You are prompted to Select the excel sheet |
** * Step 10:** Click OK | ** * Step 10:** Click OK | ||
+ | {{:spay:hrmsprocguide:hrmsimportsuccessfulcloseimport.png|}} | ||
+ | ** * Step 11:** Close the window after the successful import | ||
- | ** * Step 10:** verify the number of records and the total amount imported through Payments/Deductions | + | {{: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===== |