{"id":20904,"date":"2024-07-21T09:20:19","date_gmt":"2024-07-21T09:20:19","guid":{"rendered":"https:\/\/docs.daftra.com\/user_manual\/%d8%a7%d8%b3%d8%aa%d9%8a%d8%b1%d8%a7%d8%af-%d8%a7%d9%84%d9%85%d8%b5%d8%b1%d9%88%d9%81%d8%a7%d8%aa-%d8%a8%d8%a7%d9%84%d8%a5%d9%83%d8%b3%d9%8a%d9%84\/"},"modified":"2026-01-18T06:11:10","modified_gmt":"2026-01-18T06:11:10","slug":"import-expenses-via-excel","status":"publish","type":"user_manual","link":"https:\/\/docs.daftra.com\/en\/user_manual\/import-expenses-via-excel\/","title":{"rendered":"Importing Expenses via Excel"},"content":{"rendered":"

[vc_row][vc_column][vc_column_text css=”.vc_custom_1744791155722{margin-left: 200px !important;}”]<\/p>\n

\n
\n

Recording expenses on the system can be done individually for each expense or by uploading all expenses to the system in an Excel file. In this guide, we review how to prepare the Excel file and how to import expenses from it into the system in moments.<\/p>\n<\/div>\n<\/div>\n

[\/vc_column_text][vc_custom_heading text=”Preparing the Excel File for Uploading Expense Data” font_container=”tag:h2|font_size:28|text_align:center|color:%2304306b|line_height:2″ use_theme_fonts=”yes” css=”.vc_custom_1723037027696{margin-left: 200px !important;background-color: #f6f9fc !important;border-radius: 4px !important;}”][vc_column_text css=”.vc_custom_1744791243104{margin-left: 200px !important;}”]<\/p>\n

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

Make sure to prepare an Excel file that includes the expense data you want to upload to the system, such as the date of the expense, amount, currency, taxes, treasury, cost center, and other relevant data.<\/p>\n

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

[\/vc_column_text][vc_message message_box_style=”3d” message_box_color=”alert-warning” css=”.vc_custom_1723364789218{margin-left: 200px !important;}”]<\/p>\n

\n
\n
\n
\n
\n

The Excel file should be in CSV format, as this is the appropriate format for files in English.<\/p>\n<\/div>\n<\/div>\n<\/div>\n<\/div>\n<\/blockquote>\n

[\/vc_message][vc_custom_heading text=”How to Import Expenses From an Excel File” font_container=”tag:h2|font_size:28|text_align:center|color:%2304306b|line_height:2″ use_theme_fonts=”yes” css=”.vc_custom_1723102869887{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_1768716658198{margin-left: 200px !important;}”]<\/p>\n

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

Click on \u201cExpenses<\/strong>\u201d under \u201cFinance<\/strong>\u201d in the main menu. Click on the \u201cImport<\/strong>\u201d button.<\/p>\n

\"\"<\/p>\n

Select the \u201cComma Separated<\/strong>\u201d option and click on \u201cChoose File<\/strong>\u201d to upload the Excel file from your device.<\/p>\n

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

\n
\n
\n
\n
\n
\n
    \n
  • If each column has a header, such as \u201cDate<\/strong>\u201d or \u201cAmount<\/strong>,\u201d do not enable \u201cImport the first row of the file<\/strong>.\u201d However, if there are no headers for each column, enable this option to avoid losing any items during the upload process.<\/li>\n<\/ul>\n<\/blockquote>\n<\/div>\n
    \n
    \n

    Select the Excel file containing the expenses from your device to upload to the system.<\/p>\n

    \"\"Match the data fields in the Excel file containing the expenses with the corresponding fields in the system. For example, if the column header for the date of expenses in the Excel file is \u201cDate<\/strong>,\u201d select this header for the date field in the system so the system can recognize the type of data being uploaded. Then, click the \u201cImport<\/strong>\u201d button.<\/p>\n<\/div>\n<\/div>\n<\/div>\n

    \"\"<\/p>\n

    \n
    \n
    \n

    Note: Fields marked with \u201c*<\/strong>\u201d are default expense fields that must be included in the Excel file. Other fields can be left blank if you do not wish to upload them via the Excel file.<\/p>\n<\/div>\n<\/blockquote>\n

    \n
    \n

    You will receive a message showing the number of expenses successfully imported, as well as those that failed to import, so you can correct the errors that caused the failures.<\/p>\n

    \"\"<\/p>\n

    \n
    \n
    \n
    \n

    After successfully importing the expenses via the Excel file, you can go to \u201cExpenses<\/strong>\u201d under \u201cFinance<\/strong>\u201d in the main menu to find the expenses you have uploaded to the system.<\/p>\n<\/div>\n<\/div>\n<\/div>\n<\/div>\n<\/div>\n<\/div>\n<\/div>\n<\/div>\n<\/div>\n<\/div>\n<\/div>\n<\/div>\n

    \"\"<\/div>\n

    [\/vc_column_text][\/vc_column][\/vc_row]<\/p>\n<\/section>","protected":false},"author":13,"template":"","categories":[2118,2108,2119],"tags":[5895,5817,5897,5818,5896],"class_list":["post-20904","user_manual","type-user_manual","status-publish","hentry","category-finance","category-accounting","category-expenses","tag-add-expenses-automatically","tag-expense","tag-import-excel-sheet","tag-import-expenses","tag-upload-expenses-sheet"],"yoast_head":"\nImporting Expenses 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\/import-expenses-via-excel\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Importing Expenses via Excel - Daftra Knowledge Base\" \/>\n<meta property=\"og:description\" content=\"[vc_row][vc_column][vc_column_text css=”.vc_custom_1744791155722{margin-left: 200px !important;}”] Recording expenses on the system can be done individually for each expense or by uploading all expenses to the system in an Excel file. In this guide, we review how to prepare the Excel file and how to import expenses from it into the system in moments. [\/vc_column_text][vc_custom_heading text=”Preparing the Excel […]\" \/>\n<meta property=\"og:url\" content=\"https:\/\/docs.daftra.com\/en\/user_manual\/import-expenses-via-excel\/\" \/>\n<meta property=\"og:site_name\" content=\"Daftra Knowledge Base\" \/>\n<meta property=\"article:modified_time\" content=\"2026-01-18T06:11:10+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/docs.daftra.com\/wp-content\/uploads\/2024\/07\/rgf.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=\"4 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\/import-expenses-via-excel\/#primaryimage\",\"inLanguage\":\"en-US\",\"url\":\"https:\/\/docs.daftra.com\/wp-content\/uploads\/2024\/07\/rgf.png\",\"contentUrl\":\"https:\/\/docs.daftra.com\/wp-content\/uploads\/2024\/07\/rgf.png\",\"width\":934,\"height\":296},{\"@type\":\"WebPage\",\"@id\":\"https:\/\/docs.daftra.com\/en\/user_manual\/import-expenses-via-excel\/#webpage\",\"url\":\"https:\/\/docs.daftra.com\/en\/user_manual\/import-expenses-via-excel\/\",\"name\":\"Importing Expenses via Excel - Daftra Knowledge Base\",\"isPartOf\":{\"@id\":\"https:\/\/docs.daftra.com\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\/\/docs.daftra.com\/en\/user_manual\/import-expenses-via-excel\/#primaryimage\"},\"datePublished\":\"2024-07-21T09:20:19+00:00\",\"dateModified\":\"2026-01-18T06:11:10+00:00\",\"breadcrumb\":{\"@id\":\"https:\/\/docs.daftra.com\/en\/user_manual\/import-expenses-via-excel\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/docs.daftra.com\/en\/user_manual\/import-expenses-via-excel\/\"]}]},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/docs.daftra.com\/en\/user_manual\/import-expenses-via-excel\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\/\/docs.daftra.com\/en\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Importing Expenses via Excel\"}]}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"Importing Expenses 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\/import-expenses-via-excel\/","og_locale":"en_US","og_type":"article","og_title":"Importing Expenses via Excel - Daftra Knowledge Base","og_description":"[vc_row][vc_column][vc_column_text css=”.vc_custom_1744791155722{margin-left: 200px !important;}”] Recording expenses on the system can be done individually for each expense or by uploading all expenses to the system in an Excel file. In this guide, we review how to prepare the Excel file and how to import expenses from it into the system in moments. [\/vc_column_text][vc_custom_heading text=”Preparing the Excel […]","og_url":"https:\/\/docs.daftra.com\/en\/user_manual\/import-expenses-via-excel\/","og_site_name":"Daftra Knowledge Base","article_modified_time":"2026-01-18T06:11:10+00:00","og_image":[{"url":"https:\/\/docs.daftra.com\/wp-content\/uploads\/2024\/07\/rgf.png"}],"twitter_card":"summary_large_image","twitter_misc":{"Est. reading time":"4 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\/import-expenses-via-excel\/#primaryimage","inLanguage":"en-US","url":"https:\/\/docs.daftra.com\/wp-content\/uploads\/2024\/07\/rgf.png","contentUrl":"https:\/\/docs.daftra.com\/wp-content\/uploads\/2024\/07\/rgf.png","width":934,"height":296},{"@type":"WebPage","@id":"https:\/\/docs.daftra.com\/en\/user_manual\/import-expenses-via-excel\/#webpage","url":"https:\/\/docs.daftra.com\/en\/user_manual\/import-expenses-via-excel\/","name":"Importing Expenses via Excel - Daftra Knowledge Base","isPartOf":{"@id":"https:\/\/docs.daftra.com\/#website"},"primaryImageOfPage":{"@id":"https:\/\/docs.daftra.com\/en\/user_manual\/import-expenses-via-excel\/#primaryimage"},"datePublished":"2024-07-21T09:20:19+00:00","dateModified":"2026-01-18T06:11:10+00:00","breadcrumb":{"@id":"https:\/\/docs.daftra.com\/en\/user_manual\/import-expenses-via-excel\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/docs.daftra.com\/en\/user_manual\/import-expenses-via-excel\/"]}]},{"@type":"BreadcrumbList","@id":"https:\/\/docs.daftra.com\/en\/user_manual\/import-expenses-via-excel\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/docs.daftra.com\/en\/"},{"@type":"ListItem","position":2,"name":"Importing Expenses via Excel"}]}]}},"_links":{"self":[{"href":"https:\/\/docs.daftra.com\/en\/wp-json\/wp\/v2\/user_manual\/20904","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":6,"href":"https:\/\/docs.daftra.com\/en\/wp-json\/wp\/v2\/user_manual\/20904\/revisions"}],"predecessor-version":[{"id":45012,"href":"https:\/\/docs.daftra.com\/en\/wp-json\/wp\/v2\/user_manual\/20904\/revisions\/45012"}],"wp:attachment":[{"href":"https:\/\/docs.daftra.com\/en\/wp-json\/wp\/v2\/media?parent=20904"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/docs.daftra.com\/en\/wp-json\/wp\/v2\/categories?post=20904"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/docs.daftra.com\/en\/wp-json\/wp\/v2\/tags?post=20904"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}