{"id":25136,"date":"2024-12-11T14:12:59","date_gmt":"2024-12-11T14:12:59","guid":{"rendered":"https:\/\/docs.daftra.com\/user_manual\/%d8%a7%d8%b3%d8%aa%d9%8a%d8%b1%d8%a7%d8%af-%d9%82%d8%b3%d8%a7%d8%a6%d9%85-%d8%a7%d9%84%d8%b1%d8%a7%d8%aa%d8%a8-%d8%a8%d8%a7%d9%84%d8%a5%d9%83%d8%b3%d9%8a%d9%84\/"},"modified":"2025-05-14T11:15:10","modified_gmt":"2025-05-14T11:15:10","slug":"importing-pay-slips-via-excel","status":"publish","type":"user_manual","link":"https:\/\/docs.daftra.com\/en\/user_manual\/importing-pay-slips-via-excel\/","title":{"rendered":"Importing Pay Slips via Excel"},"content":{"rendered":"

[vc_row][vc_column][vc_column_text css=”.vc_custom_1734002783643{margin-left: 200px !important;}”]The process of issuing pay slips in the system can be done individually for each pay slip or by uploading all pay slips to the system via an Excel file. In this guide, we will review how to prepare the Excel file and how to import pay slips into the system in just a few moments.[\/vc_column_text][vc_custom_heading text=”Reviewing the Excel File for Uploading Pay Slip Data” font_container=”tag:h2|font_size:28|text_align:center|color:%2304306b|line_height:2″ use_theme_fonts=”yes” css=”.vc_custom_1734002812187{margin-left: 200px !important;background-color: #f6f9fc !important;border-radius: 4px !important;}”][vc_column_text css=”.vc_custom_1747218256605{margin-left: 200px !important;}”]<\/p>\n

\n
\n
\n
\n
\n
\n
\n
\n

Make sure that the Excel file contains all the necessary pay slip data to be uploaded to the system, such as employee code, basic salary, variable salary, currency, and other relevant data.<\/p>\n<\/div>\n

\"\"<\/p>\n<\/div>\n<\/div>\n<\/div>\n<\/div>\n<\/div>\n<\/div>\n<\/div>\n

\n

The Excel File Should Be in CSV Format<\/p><\/blockquote>\n<\/div>\n

[\/vc_column_text][vc_custom_heading text=”How to Import Pay slips via Excel File” font_container=”tag:h2|font_size:28|text_align:center|color:%2304306b|line_height:2″ use_theme_fonts=”yes” css=”.vc_custom_1734003334789{margin-left: 200px !important;background-color: #f6f9fc !important;border-radius: 4px !important;}”][\/vc_column][\/vc_row][vc_row][vc_column][vc_column_text css=”.vc_custom_1747221264589{margin-left: 200px !important;}”]<\/p>\n

\n
\n
\n
\n
\n
\n
\n
\n
\n
\n
\n
\n
\n
\n
\n
\n
\n

Click on “Payslips<\/strong>” under “Payroll<\/strong>” in the main menu, then click on the “Import<\/strong>” button.<\/p>\n<\/div>\n<\/div>\n<\/div>\n

\n
\n
\n

\"\"<\/p>\n

Select the “Comma Separated<\/strong>” option and click on “Choose File<\/strong>” to upload the desired Excel file from your device.<\/p>\n<\/div>\n<\/div>\n

\n
\n

\"\"<\/p>\n<\/div>\n<\/div>\n<\/div>\n<\/div>\n<\/div>\n<\/div>\n<\/div>\n<\/div>\n<\/div>\n

 <\/p>\n

\n
    \n
  • Note: If each column has a header like “Date<\/strong>” or “Amount<\/strong>“, do not activate the “Import first row<\/strong>” option. However, if there are no headers for each column, activate this option to prevent losing any data during the upload process.<\/li>\n<\/ul>\n<\/div>\n
    \n
    \n

     <\/p>\n<\/div>\n<\/div>\n<\/div>\n

    \n
    \n

    Match the data in the Excel file containing the payslips with the corresponding fields in the system. For example, if the column header for employees in the Excel file is “Employee Name\/Code<\/strong>,” select this header corresponding to the “Employee<\/strong>” field in the system so that the system recognizes the type of each entry being uploaded. Then, click the “Import<\/strong>” button.<\/p>\n

    \"\"<\/p>\n<\/div>\n<\/div>\n<\/div>\n

     <\/p>\n

    \n

    Note: The fields marked with the \u201c*\u201d symbol are mandatory fields for salary slips that must be included in the Excel file. Other fields can be left empty if you do not wish to upload them via the Excel file.<\/p>\n<\/div>\n

    \n
    \n

    A message will appear indicating the number of salary slips that were successfully imported, as well as those that failed to import, with an explanation of the error so that you can fix the issues that caused the failure.<\/p>\n

    After successfully importing the salary slips via the Excel file, you can go to “PaySlips” under the “Payroll” dropdown in the main menu to find the payslips you have uploaded to the system.<\/p>\n<\/div>\n<\/div>\n<\/div>\n<\/div>\n<\/div>\n<\/section>\n<\/article>\n<\/div>\n

    [\/vc_column_text][\/vc_column][\/vc_row]<\/p>\n<\/section>","protected":false},"author":13,"template":"","categories":[2197,2200],"tags":[7631,7673,7672],"class_list":["post-25136","user_manual","type-user_manual","status-publish","hentry","category-hr","category-manage-payrolls","tag-import-from-excel","tag-import-from-excel-sheel","tag-import-payslips"],"yoast_head":"\nImporting Pay Slips via Excel - Daftra Knowledge Base<\/title>\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<link rel=\"canonical\" href=\"https:\/\/docs.daftra.com\/en\/user_manual\/importing-pay-slips-via-excel\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Importing Pay Slips via Excel - Daftra Knowledge Base\" \/>\n<meta property=\"og:description\" content=\"[vc_row][vc_column][vc_column_text css=”.vc_custom_1734002783643{margin-left: 200px !important;}”]The process of issuing pay slips in the system can be done individually for each pay slip or by uploading all pay slips to the system via an Excel file. In this guide, we will review how to prepare the Excel file and how to import pay slips into the system in […]\" \/>\n<meta property=\"og:url\" content=\"https:\/\/docs.daftra.com\/en\/user_manual\/importing-pay-slips-via-excel\/\" \/>\n<meta property=\"og:site_name\" content=\"Daftra Knowledge Base\" \/>\n<meta property=\"article:modified_time\" content=\"2025-05-14T11:15:10+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/docs.daftra.com\/wp-content\/uploads\/2024\/12\/jfuye.png\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:label1\" content=\"Est. reading time\" \/>\n\t<meta name=\"twitter:data1\" content=\"3 minutes\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":\"WebSite\",\"@id\":\"https:\/\/docs.daftra.com\/#website\",\"url\":\"https:\/\/docs.daftra.com\/\",\"name\":\"Daftra Knowledge Base\",\"description\":\"Daftra\",\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\/\/docs.daftra.com\/?s={search_term_string}\"},\"query-input\":\"required name=search_term_string\"}],\"inLanguage\":\"en-US\"},{\"@type\":\"ImageObject\",\"@id\":\"https:\/\/docs.daftra.com\/en\/user_manual\/importing-pay-slips-via-excel\/#primaryimage\",\"inLanguage\":\"en-US\",\"url\":\"https:\/\/docs.daftra.com\/wp-content\/uploads\/2024\/12\/jfuye.png\",\"contentUrl\":\"https:\/\/docs.daftra.com\/wp-content\/uploads\/2024\/12\/jfuye.png\",\"width\":1366,\"height\":288},{\"@type\":\"WebPage\",\"@id\":\"https:\/\/docs.daftra.com\/en\/user_manual\/importing-pay-slips-via-excel\/#webpage\",\"url\":\"https:\/\/docs.daftra.com\/en\/user_manual\/importing-pay-slips-via-excel\/\",\"name\":\"Importing Pay Slips via Excel - Daftra Knowledge Base\",\"isPartOf\":{\"@id\":\"https:\/\/docs.daftra.com\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\/\/docs.daftra.com\/en\/user_manual\/importing-pay-slips-via-excel\/#primaryimage\"},\"datePublished\":\"2024-12-11T14:12:59+00:00\",\"dateModified\":\"2025-05-14T11:15:10+00:00\",\"breadcrumb\":{\"@id\":\"https:\/\/docs.daftra.com\/en\/user_manual\/importing-pay-slips-via-excel\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/docs.daftra.com\/en\/user_manual\/importing-pay-slips-via-excel\/\"]}]},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/docs.daftra.com\/en\/user_manual\/importing-pay-slips-via-excel\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\/\/docs.daftra.com\/en\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Importing Pay Slips via Excel\"}]}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"Importing Pay Slips via Excel - Daftra Knowledge Base","robots":{"index":"index","follow":"follow","max-snippet":"max-snippet:-1","max-image-preview":"max-image-preview:large","max-video-preview":"max-video-preview:-1"},"canonical":"https:\/\/docs.daftra.com\/en\/user_manual\/importing-pay-slips-via-excel\/","og_locale":"en_US","og_type":"article","og_title":"Importing Pay Slips via Excel - Daftra Knowledge Base","og_description":"[vc_row][vc_column][vc_column_text css=”.vc_custom_1734002783643{margin-left: 200px !important;}”]The process of issuing pay slips in the system can be done individually for each pay slip or by uploading all pay slips to the system via an Excel file. In this guide, we will review how to prepare the Excel file and how to import pay slips into the system in […]","og_url":"https:\/\/docs.daftra.com\/en\/user_manual\/importing-pay-slips-via-excel\/","og_site_name":"Daftra Knowledge Base","article_modified_time":"2025-05-14T11:15:10+00:00","og_image":[{"url":"https:\/\/docs.daftra.com\/wp-content\/uploads\/2024\/12\/jfuye.png"}],"twitter_card":"summary_large_image","twitter_misc":{"Est. reading time":"3 minutes"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"WebSite","@id":"https:\/\/docs.daftra.com\/#website","url":"https:\/\/docs.daftra.com\/","name":"Daftra Knowledge Base","description":"Daftra","potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/docs.daftra.com\/?s={search_term_string}"},"query-input":"required name=search_term_string"}],"inLanguage":"en-US"},{"@type":"ImageObject","@id":"https:\/\/docs.daftra.com\/en\/user_manual\/importing-pay-slips-via-excel\/#primaryimage","inLanguage":"en-US","url":"https:\/\/docs.daftra.com\/wp-content\/uploads\/2024\/12\/jfuye.png","contentUrl":"https:\/\/docs.daftra.com\/wp-content\/uploads\/2024\/12\/jfuye.png","width":1366,"height":288},{"@type":"WebPage","@id":"https:\/\/docs.daftra.com\/en\/user_manual\/importing-pay-slips-via-excel\/#webpage","url":"https:\/\/docs.daftra.com\/en\/user_manual\/importing-pay-slips-via-excel\/","name":"Importing Pay Slips via Excel - Daftra Knowledge Base","isPartOf":{"@id":"https:\/\/docs.daftra.com\/#website"},"primaryImageOfPage":{"@id":"https:\/\/docs.daftra.com\/en\/user_manual\/importing-pay-slips-via-excel\/#primaryimage"},"datePublished":"2024-12-11T14:12:59+00:00","dateModified":"2025-05-14T11:15:10+00:00","breadcrumb":{"@id":"https:\/\/docs.daftra.com\/en\/user_manual\/importing-pay-slips-via-excel\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/docs.daftra.com\/en\/user_manual\/importing-pay-slips-via-excel\/"]}]},{"@type":"BreadcrumbList","@id":"https:\/\/docs.daftra.com\/en\/user_manual\/importing-pay-slips-via-excel\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/docs.daftra.com\/en\/"},{"@type":"ListItem","position":2,"name":"Importing Pay Slips via Excel"}]}]}},"_links":{"self":[{"href":"https:\/\/docs.daftra.com\/en\/wp-json\/wp\/v2\/user_manual\/25136","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/docs.daftra.com\/en\/wp-json\/wp\/v2\/user_manual"}],"about":[{"href":"https:\/\/docs.daftra.com\/en\/wp-json\/wp\/v2\/types\/user_manual"}],"author":[{"embeddable":true,"href":"https:\/\/docs.daftra.com\/en\/wp-json\/wp\/v2\/users\/13"}],"version-history":[{"count":3,"href":"https:\/\/docs.daftra.com\/en\/wp-json\/wp\/v2\/user_manual\/25136\/revisions"}],"predecessor-version":[{"id":34400,"href":"https:\/\/docs.daftra.com\/en\/wp-json\/wp\/v2\/user_manual\/25136\/revisions\/34400"}],"wp:attachment":[{"href":"https:\/\/docs.daftra.com\/en\/wp-json\/wp\/v2\/media?parent=25136"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/docs.daftra.com\/en\/wp-json\/wp\/v2\/categories?post=25136"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/docs.daftra.com\/en\/wp-json\/wp\/v2\/tags?post=25136"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}