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:52] 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:hrmsexceltemplate1.png|}} | ||
| - | ** * Step 5:** Fill in the excel template - sheet PD_Format2 as shown above above | + | {{:spay:hrmsprocguide:hrmsexceltemplatefillinandsave.png|}} |
| + | |||
| + | ** * Step 5:** Fill in the excel template - sheet PD_Format2 as shown above | ||
| ** * Step 6:** Save the file | ** * Step 6:** Save the file | ||
| - | {{:spay:hrmsprocguide:hrms_salary_increase_import_sheet1_2020.png|}} | + | {{:spay:hrmsprocguide:hrmsexceltemplateclickuploadpng.png|}} |
| + | |||
| + | ** * Step 7:** To import the excel file, click upload as shown above | ||
| + | |||
| + | {{:spay:hrmsprocguide:hrmsexceltemplatebrowse.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===== | ||