{"id":21601,"date":"2022-04-11T13:59:46","date_gmt":"2022-04-11T11:59:46","guid":{"rendered":"https:\/\/help.openbee.com\/open-bee-smart-capture\/administrator-guide\/accounting\/import-profile\/"},"modified":"2026-05-13T09:37:21","modified_gmt":"2026-05-13T07:37:21","slug":"import-profile","status":"publish","type":"page","link":"https:\/\/help.openbee.com\/en\/open-bee-smart-capture\/administrator-guide\/accounting\/import-profile\/","title":{"rendered":"Import Profile"},"content":{"rendered":"\n<ul class=\"wp-block-list\"><li><a href=\"#Profild%E2%80%99import-Profild'import\">Import Profile<\/a><ul><li><a href=\"#Profild%E2%80%99import-Cr%C3%A9erunnouveauprofild'import\">Create a new import profile<\/a><\/li><li><a href=\"#Profild%E2%80%99import-Typed'import\">Import Type<\/a><ul><li><a href=\"#Profild%E2%80%99import-ImportcomptableTexte,CSV\">Accounting Import Text, CSV<\/a><ul><li><a href=\"#Profild%E2%80%99import-Configurationg%C3%A9n%C3%A9rale\">General Setup<\/a><\/li><li><a href=\"#Profild%E2%80%99import-Typed'import.1\">Import Type<\/a><\/li><li><a href=\"#Profild%E2%80%99import-Structured'importdecompte\">Account Import Structure  <\/a><\/li><li><a href=\"#Profild%E2%80%99import-Structured'importanalytique\">Analytical import structure  <\/a><\/li><li><a href=\"#Profild%E2%80%99import-Actions\">Actions<\/a><\/li><\/ul><\/li><li><a href=\"#Profild%E2%80%99import-ImportcomptableXML\">XML Accounting Import<\/a><ul><li><a href=\"#Profild%E2%80%99import-Configurationdescomptes\">Setting up accounts<\/a><\/li><li><a href=\"#Profild%E2%80%99import-Configurationdesexercicescomptables\">Setting Up Fiscal Years<\/a><\/li><\/ul><\/li><\/ul><\/li><\/ul><\/li><\/ul>\n\n<h1 class=\"wp-block-heading\" id=\"Profild&#x2019;import-Profild'import\">Import Profile<\/h1>\n\n<p>To access this interface:<\/p>\n\n<p>Click on the &#8220;Accounting&#8221; \/ &#8220;Import Profile&#8221; menu<\/p>\n\n<figure class=\"wp-block-image\"><img decoding=\"async\" src=\"https:\/\/help.openbee.com\/wp-content\/uploads\/2022\/04\/276922414.png\" alt=\"\"\/><\/figure>\n\n<h2 class=\"wp-block-heading\" id=\"Profild&#x2019;import-Cr&#xE9;erunnouveauprofild'import\">Create a new import profile<\/h2>\n\n<p>To create a new import profile<\/p>\n\n<p>Click the  <\/p>\n\n<figure class=\"wp-block-image\"><img decoding=\"async\" src=\"https:\/\/help.openbee.com\/wp-content\/uploads\/2022\/04\/276922416.png\" alt=\"\"\/><\/figure>\n\n<p>A profile, in the Smart Capture sense, is a specification of your import type.<\/p>\n\n<figure class=\"wp-block-image\"><img decoding=\"async\" src=\"https:\/\/help.openbee.com\/wp-content\/uploads\/2022\/04\/276922417.png\" alt=\"\"\/><\/figure>\n\n<h2 class=\"wp-block-heading\" id=\"Profild&#x2019;import-Typed'import\">Import Type<\/h2>\n\n<h3 class=\"wp-block-heading\" id=\"Profild&#x2019;import-ImportcomptableTexte,CSV\">Accounting Import Text, CSV<\/h3>\n\n<p>The text, CSV accounting import allows you to import the <strong>chart of accounts<\/strong> or the <strong>analytical plan<\/strong> of a file from a file.<\/p>\n\n<h4 class=\"wp-block-heading\" id=\"Profild&#x2019;import-Configurationg&#xE9;n&#xE9;rale\">General Setup<\/h4>\n\n<figure class=\"wp-block-image\"><img decoding=\"async\" src=\"https:\/\/help.openbee.com\/wp-content\/uploads\/2022\/04\/276922433.png\" alt=\"\"\/><\/figure>\n\n<ul class=\"wp-block-list\"><li>Start by choosing the type of import e.g. Text File, CSV<\/li><li>Choose <strong>Name<\/strong><\/li><li>Start at Line: Allows you to start at a specific line in the file and avoid header lines. By default the value is 1, no rows are skipped.<\/li><li>Separator: The TAB value will represent the &#8220;Tab&#8221; separator.<\/li><\/ul>\n\n<h4 class=\"wp-block-heading\" id=\"Profild&#x2019;import-Typed'import.1\">Import Type<\/h4>\n\n<p>The Chart of Accounts import offers to filter the accounts to be imported to retrieve only those used when generating accounting entries. Each type of account (customer, supplier, VAT, charges), can be filtered by the<strong> first characters<\/strong> of the account number as in the following example:<\/p>\n\n<figure class=\"wp-block-image\"><img decoding=\"async\" src=\"https:\/\/help.openbee.com\/wp-content\/uploads\/2022\/04\/276922434.png\" alt=\"\"\/><\/figure>\n\n<p>It is possible to define multiple account starts<\/p>\n\n<p>Special case: the filters applied on customer\/supplier accounts apply on the master account, except in the case where the customer\/supplier account number is filled in in the same column as the general accounts.<\/p>\n\n<p>Often in this position, the centralizing accounts are not present in the source file. It is then possible to fill them in by default:<\/p>\n\n<figure class=\"wp-block-image\"><img decoding=\"async\" src=\"https:\/\/help.openbee.com\/wp-content\/uploads\/2022\/04\/276922435.png\" alt=\"\"\/><\/figure>\n\n<p>The import type allows you to choose between the Chart of Accounts import and the cost plan import. Depending on the type of plan to be imported, specific options are available.<\/p>\n\n<h4 class=\"wp-block-heading\" id=\"Profild&#x2019;import-Structured'importdecompte\">Account Import Structure  <\/h4>\n\n<p>Allows you to configure the columns added according to the structure of the file to be imported<\/p>\n\n<ul class=\"wp-block-list\"><li>Third-party account<\/li><li>General account<\/li><li>Business party and general account number: When the business party number and account number are located in the same column.<\/li><li>Entitled<\/li><li>VAT Rate: Populates the decimal value associated with the VAT accounts (optional)<\/li><\/ul>\n\n<p>It is also possible to add an &#8220;Additional Information&#8221;, which will be used to:<\/p>\n\n<ul class=\"wp-block-list\"><li>Fill in additional info in the account<\/li><li>Fill in an index of the third-party record if the label of the additional information corresponds to the ID of an index of the third-party record, and of course the account being imported is a third-party account<\/li><\/ul>\n\n<figure class=\"wp-block-image\"><img decoding=\"async\" src=\"https:\/\/help.openbee.com\/wp-content\/uploads\/2022\/04\/276922436.png\" alt=\"\"\/><\/figure>\n\n<h4 class=\"wp-block-heading\" id=\"Profild&#x2019;import-Structured'importanalytique\">Analytical import structure  <\/h4>\n\n<p>Allows you to make analytical breakdowns on a customer&#8217;s accounting<\/p>\n\n<ul class=\"wp-block-list\"><li>Title of the plan (if broken down by plan)<\/li><li>Plan code (if broken down by plan)<\/li><li>Section Title<\/li><li>Section Code<\/li><\/ul>\n\n<figure class=\"wp-block-image\"><img decoding=\"async\" src=\"https:\/\/help.openbee.com\/wp-content\/uploads\/2022\/04\/276922437.png\" alt=\"\"\/><\/figure>\n\n<p>In the case of a breakdown by section, it is also possible to put the &#8220;Group&#8221; column, which allows you to group the different imported sections into several different groups. This will display multiple columns (one per group) when entering the cost breakdown<\/p>\n\n<h4 class=\"wp-block-heading\" id=\"Profild&#x2019;import-Actions\">Actions<\/h4>\n\n<p>To delete a profile, simply click on the button <img decoding=\"async\" src=\"https:\/\/help.openbee.com\/wp-content\/uploads\/2022\/04\/276922439.png\"\/> and then click on &#8221; <strong>Submit<\/strong> &#8220;<\/p>\n\n<figure class=\"wp-block-image\"><img decoding=\"async\" src=\"https:\/\/help.openbee.com\/wp-content\/uploads\/2022\/04\/276922438.png\" alt=\"\"\/><\/figure>\n\n<p>To save the default import profile for all new folders to be created, simply click , <img decoding=\"async\" src=\"https:\/\/help.openbee.com\/wp-content\/uploads\/2022\/04\/276922440.png\"\/>you can also specify a default Template for a specific folder by clicking  <img decoding=\"async\" src=\"https:\/\/help.openbee.com\/wp-content\/uploads\/2022\/04\/276922441.png\"\/><\/p>\n\n<p>Choose the default profile for the folder, then click &#8221; <strong>Submit<\/strong> &#8220;.<\/p>\n\n<figure class=\"wp-block-image\"><img decoding=\"async\" src=\"https:\/\/help.openbee.com\/wp-content\/uploads\/2022\/04\/276922442.png\" alt=\"\"\/><\/figure>\n\n<h3 class=\"wp-block-heading\" id=\"Profild&#x2019;import-ImportcomptableXML\">XML Accounting Import<\/h3>\n\n<p>The XML import configuration is done in the &#8220;Accounting \/ <strong>Import Profile<\/strong>&#8221; tab.<\/p>\n\n<p>To create an XML import profile, simply choose the type and name in the appropriate fields<\/p>\n\n<figure class=\"wp-block-image\"><img decoding=\"async\" src=\"https:\/\/help.openbee.com\/wp-content\/uploads\/2022\/04\/276922443.png\" alt=\"\"\/><\/figure>\n\n<h4 class=\"wp-block-heading\" id=\"Profild&#x2019;import-Configurationdescomptes\">Setting up accounts<\/h4>\n\n<p>Each type of account has its own section that allows you to identify them  <\/p>\n\n<ul class=\"wp-block-list\"><li>Root: This is the tag that encompasses the account information.<\/li><li>General account: The tag or attribute containing the account number<\/li><li>Account label: The tag or attribute containing the account label<\/li><li>Third-party account: (Accounts receivable\/vendors only) the tag or attribute containing the third-party account number<\/li><li>VAT Rate: (VAT account only) the decimal value associated with VAT accounts (optional).<\/li><li>Accounts starting with: The filter that allows you to import only accounts that start with these characters. It is possible to define several of them by separating them with &#8220;;&#8221;.<\/li><\/ul>\n\n<figure class=\"wp-block-image\"><img decoding=\"async\" src=\"https:\/\/help.openbee.com\/wp-content\/uploads\/2022\/04\/276922444.png\" alt=\"\"\/><\/figure>\n\n<h4 class=\"wp-block-heading\" id=\"Profild&#x2019;import-Configurationdesexercicescomptables\">Setting Up Fiscal Years<\/h4>\n\n<p>In the same way, it is possible to import accounting years if they are available:<\/p>\n\n<ul class=\"wp-block-list\"><li>Root: This is the tag that encompasses the account information.<\/li><li>Start date: The tag or attribute that contains the start date of the fiscal year<\/li><li>End Date: The tag or attribute that contains the end date of the fiscal year<\/li><\/ul>\n\n<figure class=\"wp-block-image\"><img decoding=\"async\" src=\"https:\/\/help.openbee.com\/wp-content\/uploads\/2022\/04\/276922445.png\" alt=\"\"\/><\/figure>\n","protected":false},"excerpt":{"rendered":"<p>Import Profile Create a new import profile Import Type Accounting Import Text, CSV General Setup Import Type Account Import Structure Analytical import structure Actions XML Accounting Import Setting up accounts Setting Up Fiscal Years Import Profile To access this interface: Click on the &#8220;Accounting&#8221; \/ &#8220;Import Profile&#8221; menu Create a new import profile To create [&hellip;]<\/p>\n","protected":false},"author":2,"featured_media":0,"parent":21580,"menu_order":1,"comment_status":"closed","ping_status":"closed","template":"templates\/ob-help-products.php","meta":{"footnotes":""},"class_list":["post-21601","page","type-page","status-publish","hentry"],"_links":{"self":[{"href":"https:\/\/help.openbee.com\/en\/wp-json\/wp\/v2\/pages\/21601","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/help.openbee.com\/en\/wp-json\/wp\/v2\/pages"}],"about":[{"href":"https:\/\/help.openbee.com\/en\/wp-json\/wp\/v2\/types\/page"}],"author":[{"embeddable":true,"href":"https:\/\/help.openbee.com\/en\/wp-json\/wp\/v2\/users\/2"}],"replies":[{"embeddable":true,"href":"https:\/\/help.openbee.com\/en\/wp-json\/wp\/v2\/comments?post=21601"}],"version-history":[{"count":1,"href":"https:\/\/help.openbee.com\/en\/wp-json\/wp\/v2\/pages\/21601\/revisions"}],"predecessor-version":[{"id":21605,"href":"https:\/\/help.openbee.com\/en\/wp-json\/wp\/v2\/pages\/21601\/revisions\/21605"}],"up":[{"embeddable":true,"href":"https:\/\/help.openbee.com\/en\/wp-json\/wp\/v2\/pages\/21580"}],"wp:attachment":[{"href":"https:\/\/help.openbee.com\/en\/wp-json\/wp\/v2\/media?parent=21601"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}