{"id":21072,"date":"2024-07-21T10:10:25","date_gmt":"2024-07-21T10:10:25","guid":{"rendered":"https:\/\/docs.daftra.com\/user_manual\/%d8%a7%d8%b3%d8%aa%d9%8a%d8%b1%d8%a7%d8%af-%d8%b3%d9%86%d8%af%d8%a7%d8%aa-%d8%a7%d9%84%d9%82%d8%a8%d8%b6-%d8%a8%d8%a7%d9%84%d8%a5%d9%83%d8%b3%d9%8a%d9%84\/"},"modified":"2026-01-18T08:10:04","modified_gmt":"2026-01-18T08:10:04","slug":"importing-income-via-excel","status":"publish","type":"user_manual","link":"https:\/\/docs.daftra.com\/en\/user_manual\/importing-income-via-excel\/","title":{"rendered":"Importing Income via Excel"},"content":{"rendered":"

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

\n
\n
\n
\n

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

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

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

Prepare an Excel file that includes the income data you want to upload to the system, such as the income date, 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<\/div>\n<\/div>\n

\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<\/div>\n

[\/vc_column_text][vc_custom_heading text=”How to Import Income Using 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_1723366522924{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_1744797765972{margin-left: 200px !important;}”]<\/p>\n

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

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

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

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

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

\n
\n
\n
\n
\n
\n
    \n
  • Note:<\/strong> If each column has a header, such as “Date<\/strong>” or “Amount<\/strong>,” do not enable “Import the first row of the file<\/strong>.” However, if there are no headers for each column, enable this option to avoid losing any items during the upload process. Select the Excel file containing the receipts from your device to upload it to the system.<\/li>\n<\/ul>\n<\/blockquote>\n<\/div>\n
    \n
    \n

    \"\"<\/p>\n

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

    \"\"<\/p>\n

    \n
    \n
    \n

    Note:<\/strong> Fields marked with \u201c*<\/strong>\u201d are default fields for incomes 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

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

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

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

    After successfully importing receipts via the Excel file, you can go to “Incomes<\/strong>” under “Finance<\/strong>” in the main menu to find the receipts you have uploaded to the system.<\/p>\n

    \"\"<\/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<\/section>\n<\/article>\n<\/div>\n

    [\/vc_column_text][\/vc_column][\/vc_row]<\/p>\n<\/section>","protected":false},"author":13,"template":"","categories":[2118,2108,2121],"tags":[5977,5978,5317,5979],"class_list":["post-21072","user_manual","type-user_manual","status-publish","hentry","category-finance","category-accounting","category-incomes","tag-automatically-add-income","tag-import-income","tag-income","tag-upload-income-sheets"],"yoast_head":"\nImporting Income 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-income-via-excel\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Importing Income via Excel - Daftra Knowledge Base\" \/>\n<meta property=\"og:description\" content=\"[vc_row][vc_column][vc_column_text css=”.vc_custom_1744797135709{margin-left: 200px !important;}”] Recording income on the system can be done individually for each income or by uploading all incomes to the system in an Excel file. In this guide, we will review how to prepare the Excel file and how to import incomes from it into the system in moments. [\/vc_column_text][vc_custom_heading text=”Preparing the […]\" \/>\n<meta property=\"og:url\" content=\"https:\/\/docs.daftra.com\/en\/user_manual\/importing-income-via-excel\/\" \/>\n<meta property=\"og:site_name\" content=\"Daftra Knowledge Base\" \/>\n<meta property=\"article:modified_time\" content=\"2026-01-18T08:10:04+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/docs.daftra.com\/wp-content\/uploads\/2024\/07\/kjdgvv.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\/importing-income-via-excel\/#primaryimage\",\"inLanguage\":\"en-US\",\"url\":\"https:\/\/docs.daftra.com\/wp-content\/uploads\/2024\/07\/kjdgvv.png\",\"contentUrl\":\"https:\/\/docs.daftra.com\/wp-content\/uploads\/2024\/07\/kjdgvv.png\",\"width\":768,\"height\":243},{\"@type\":\"WebPage\",\"@id\":\"https:\/\/docs.daftra.com\/en\/user_manual\/importing-income-via-excel\/#webpage\",\"url\":\"https:\/\/docs.daftra.com\/en\/user_manual\/importing-income-via-excel\/\",\"name\":\"Importing Income via Excel - Daftra Knowledge Base\",\"isPartOf\":{\"@id\":\"https:\/\/docs.daftra.com\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\/\/docs.daftra.com\/en\/user_manual\/importing-income-via-excel\/#primaryimage\"},\"datePublished\":\"2024-07-21T10:10:25+00:00\",\"dateModified\":\"2026-01-18T08:10:04+00:00\",\"breadcrumb\":{\"@id\":\"https:\/\/docs.daftra.com\/en\/user_manual\/importing-income-via-excel\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/docs.daftra.com\/en\/user_manual\/importing-income-via-excel\/\"]}]},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/docs.daftra.com\/en\/user_manual\/importing-income-via-excel\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\/\/docs.daftra.com\/en\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Importing Income via Excel\"}]}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"Importing Income 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-income-via-excel\/","og_locale":"en_US","og_type":"article","og_title":"Importing Income via Excel - Daftra Knowledge Base","og_description":"[vc_row][vc_column][vc_column_text css=”.vc_custom_1744797135709{margin-left: 200px !important;}”] Recording income on the system can be done individually for each income or by uploading all incomes to the system in an Excel file. In this guide, we will review how to prepare the Excel file and how to import incomes from it into the system in moments. [\/vc_column_text][vc_custom_heading text=”Preparing the […]","og_url":"https:\/\/docs.daftra.com\/en\/user_manual\/importing-income-via-excel\/","og_site_name":"Daftra Knowledge Base","article_modified_time":"2026-01-18T08:10:04+00:00","og_image":[{"url":"https:\/\/docs.daftra.com\/wp-content\/uploads\/2024\/07\/kjdgvv.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\/importing-income-via-excel\/#primaryimage","inLanguage":"en-US","url":"https:\/\/docs.daftra.com\/wp-content\/uploads\/2024\/07\/kjdgvv.png","contentUrl":"https:\/\/docs.daftra.com\/wp-content\/uploads\/2024\/07\/kjdgvv.png","width":768,"height":243},{"@type":"WebPage","@id":"https:\/\/docs.daftra.com\/en\/user_manual\/importing-income-via-excel\/#webpage","url":"https:\/\/docs.daftra.com\/en\/user_manual\/importing-income-via-excel\/","name":"Importing Income via Excel - Daftra Knowledge Base","isPartOf":{"@id":"https:\/\/docs.daftra.com\/#website"},"primaryImageOfPage":{"@id":"https:\/\/docs.daftra.com\/en\/user_manual\/importing-income-via-excel\/#primaryimage"},"datePublished":"2024-07-21T10:10:25+00:00","dateModified":"2026-01-18T08:10:04+00:00","breadcrumb":{"@id":"https:\/\/docs.daftra.com\/en\/user_manual\/importing-income-via-excel\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/docs.daftra.com\/en\/user_manual\/importing-income-via-excel\/"]}]},{"@type":"BreadcrumbList","@id":"https:\/\/docs.daftra.com\/en\/user_manual\/importing-income-via-excel\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/docs.daftra.com\/en\/"},{"@type":"ListItem","position":2,"name":"Importing Income via Excel"}]}]}},"_links":{"self":[{"href":"https:\/\/docs.daftra.com\/en\/wp-json\/wp\/v2\/user_manual\/21072","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\/21072\/revisions"}],"predecessor-version":[{"id":33483,"href":"https:\/\/docs.daftra.com\/en\/wp-json\/wp\/v2\/user_manual\/21072\/revisions\/33483"}],"wp:attachment":[{"href":"https:\/\/docs.daftra.com\/en\/wp-json\/wp\/v2\/media?parent=21072"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/docs.daftra.com\/en\/wp-json\/wp\/v2\/categories?post=21072"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/docs.daftra.com\/en\/wp-json\/wp\/v2\/tags?post=21072"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}