{"id":22218,"date":"2026-07-31T06:51:10","date_gmt":"2026-07-31T06:51:10","guid":{"rendered":"https:\/\/tenthplanet.in\/idempiere\/?p=22218"},"modified":"2026-08-20T09:04:40","modified_gmt":"2026-08-20T09:04:40","slug":"how-to-import-account-window-in-idempiere","status":"publish","type":"post","link":"https:\/\/tenthplanet.in\/idempiere\/how-to-import-account-window-in-idempiere\/","title":{"rendered":"How to Import Account Window in iDempiere"},"content":{"rendered":"\n<p class=\"wp-block-paragraph\">The Import Account window lets iDempiere users bulk load Chart of Accounts values from a staging table into live account records, instead of creating each account manually.<\/p>\n\n\n\n<p class=\"wp-block-paragraph\">A correctly run import directly affects GL posting accuracy, default account mapping, and the reliability of financial and store-level reporting.<\/p>\n\n\n\n<h2 class=\"wp-block-heading\"><strong>Process Flow<\/strong><\/h2>\n\n\n\n<figure class=\"wp-block-image size-large\"><img loading=\"lazy\" decoding=\"async\" width=\"1024\" height=\"341\" src=\"https:\/\/tenthplanet.in\/idempiere\/wp-content\/uploads\/sites\/13\/2026\/07\/TenthPlanet-iDempiere-ImportAccount-1-1024x341.png\" alt=\"\" class=\"wp-image-22226\" title=\"\" srcset=\"https:\/\/tenthplanet.in\/idempiere\/wp-content\/uploads\/sites\/13\/2026\/07\/TenthPlanet-iDempiere-ImportAccount-1-1024x341.png 1024w, https:\/\/tenthplanet.in\/idempiere\/wp-content\/uploads\/sites\/13\/2026\/07\/TenthPlanet-iDempiere-ImportAccount-1-300x100.png 300w, https:\/\/tenthplanet.in\/idempiere\/wp-content\/uploads\/sites\/13\/2026\/07\/TenthPlanet-iDempiere-ImportAccount-1-768x256.png 768w, https:\/\/tenthplanet.in\/idempiere\/wp-content\/uploads\/sites\/13\/2026\/07\/TenthPlanet-iDempiere-ImportAccount-1-1536x511.png 1536w, https:\/\/tenthplanet.in\/idempiere\/wp-content\/uploads\/sites\/13\/2026\/07\/TenthPlanet-iDempiere-ImportAccount-1.png 1662w\" sizes=\"auto, (max-width: 1024px) 100vw, 1024px\" \/><\/figure>\n\n\n\n<h2 class=\"wp-block-heading\"><strong>Business Rules<\/strong><\/h2>\n\n\n\n<ul class=\"wp-block-list\">\n<li>Only active accounts are available for GL posting and transaction entry.<\/li>\n\n\n\n<li>Existing accounts with a matching Value are updated, not duplicated on re-import.<\/li>\n\n\n\n<li>Missing Account Type defaults to Expense during import processing.<\/li>\n\n\n\n<li>Missing Account Sign defaults to Natural during import processing.<\/li>\n\n\n\n<li>A child account requires its parent Value to already exist in the Chart of Accounts.<\/li>\n\n\n\n<li>Enabling Update Default Accounts changes accounts used across future postings.<\/li>\n\n\n\n<li>Records that fail validation are flagged with an error message and are skipped.<\/li>\n\n\n\n<li>Previously imported staging rows can be auto-deleted before a new import run.<\/li>\n<\/ul>\n\n\n\n<h2 class=\"wp-block-heading\"><strong>Prerequisites<\/strong><\/h2>\n\n\n\n<ul class=\"wp-block-list\">\n<li>Accounting Element (C_Element) configured, for example &#8220;POTS Account&#8221;.<\/li>\n\n\n\n<li>Accounting Schema configured for the retail organization.<\/li>\n\n\n\n<li>Import file prepared in the Import Account CSV format.<\/li>\n\n\n\n<li>Tenant and Organization already configured in iDempiere.<\/li>\n\n\n\n<li>Parent account Values imported first when loading child-level accounts.<\/li>\n<\/ul>\n\n\n\n<h2 class=\"wp-block-heading\"><strong>Navigation<\/strong><\/h2>\n\n\n\n<p class=\"wp-block-paragraph\">Menu \u2192 Data \u2192 Data Import \u2192 Import File Loader \/ Import Account<\/p>\n\n\n\n<h2 class=\"wp-block-heading\"><strong>Configuration Steps<\/strong><\/h2>\n\n\n\n<h3 class=\"wp-block-heading\"><strong>Step 1: Prepare the Import File<\/strong><\/h3>\n\n\n\n<p class=\"wp-block-paragraph\">Create a CSV with Organization, Value, Search Key, Name, Description, Account Type, Account Sign, and Is Summary columns, one row per account.<\/p>\n\n\n\n<figure class=\"wp-block-table\"><table><thead><tr><td><strong>Field<\/strong><\/td><td><strong>Sample Value<\/strong><\/td><td><strong>Description<\/strong><\/td><\/tr><\/thead><tbody><tr><td>Organization<\/td><td>0<\/td><td>Organization the account belongs to.<\/td><\/tr><tr><td>Element ID \/ Value<\/td><td>1000000<\/td><td>Account key\/code used to match or create records.<\/td><\/tr><tr><td>Search Key<\/td><td>AP<\/td><td>Short code identifying the account.<\/td><\/tr><tr><td>Name<\/td><td>Accounts Payable<\/td><td>Display name of the account.<\/td><\/tr><tr><td>Description<\/td><td>Account for Account Payables<\/td><td>Descriptive text for the account.<\/td><\/tr><tr><td>Account Type<\/td><td>R<\/td><td>Asset, Expense, Liability, Memo, Owner Equity, or Revenue.<\/td><\/tr><tr><td>AccountSign<\/td><td>N<\/td><td>Natural, Credit, or Debit balance sign.<\/td><\/tr><\/tbody><\/table><\/figure>\n\n\n\n<figure class=\"wp-block-image size-large\"><img loading=\"lazy\" decoding=\"async\" width=\"1024\" height=\"490\" src=\"https:\/\/tenthplanet.in\/idempiere\/wp-content\/uploads\/sites\/13\/2026\/07\/TenthPlanet-iDempeire-DataManagement-ImportAccount-1-1024x490.png\" alt=\"\" class=\"wp-image-22220\" title=\"\" srcset=\"https:\/\/tenthplanet.in\/idempiere\/wp-content\/uploads\/sites\/13\/2026\/07\/TenthPlanet-iDempeire-DataManagement-ImportAccount-1-1024x490.png 1024w, https:\/\/tenthplanet.in\/idempiere\/wp-content\/uploads\/sites\/13\/2026\/07\/TenthPlanet-iDempeire-DataManagement-ImportAccount-1-300x143.png 300w, https:\/\/tenthplanet.in\/idempiere\/wp-content\/uploads\/sites\/13\/2026\/07\/TenthPlanet-iDempeire-DataManagement-ImportAccount-1-768x367.png 768w, https:\/\/tenthplanet.in\/idempiere\/wp-content\/uploads\/sites\/13\/2026\/07\/TenthPlanet-iDempeire-DataManagement-ImportAccount-1-1536x735.png 1536w, https:\/\/tenthplanet.in\/idempiere\/wp-content\/uploads\/sites\/13\/2026\/07\/TenthPlanet-iDempeire-DataManagement-ImportAccount-1-2048x979.png 2048w\" sizes=\"auto, (max-width: 1024px) 100vw, 1024px\" \/><\/figure>\n\n\n\n<h3 class=\"wp-block-heading\"><strong>Step 2: Load the File Using Import File Loader<\/strong><\/h3>\n\n\n\n<p class=\"wp-block-paragraph\">Open Import File Loader, select the CSV file, choose UTF-8 encoding, set Import Format to Import Account, then click the file name button to load.<\/p>\n\n\n\n<figure class=\"wp-block-image size-large\"><img loading=\"lazy\" decoding=\"async\" width=\"1024\" height=\"490\" src=\"https:\/\/tenthplanet.in\/idempiere\/wp-content\/uploads\/sites\/13\/2026\/07\/TenthPlanet-iDempeire-DataManagement-ImportAccount-2-1024x490.png\" alt=\"\" class=\"wp-image-22221\" title=\"\" srcset=\"https:\/\/tenthplanet.in\/idempiere\/wp-content\/uploads\/sites\/13\/2026\/07\/TenthPlanet-iDempeire-DataManagement-ImportAccount-2-1024x490.png 1024w, https:\/\/tenthplanet.in\/idempiere\/wp-content\/uploads\/sites\/13\/2026\/07\/TenthPlanet-iDempeire-DataManagement-ImportAccount-2-300x143.png 300w, https:\/\/tenthplanet.in\/idempiere\/wp-content\/uploads\/sites\/13\/2026\/07\/TenthPlanet-iDempeire-DataManagement-ImportAccount-2-768x367.png 768w, https:\/\/tenthplanet.in\/idempiere\/wp-content\/uploads\/sites\/13\/2026\/07\/TenthPlanet-iDempeire-DataManagement-ImportAccount-2-1536x735.png 1536w, https:\/\/tenthplanet.in\/idempiere\/wp-content\/uploads\/sites\/13\/2026\/07\/TenthPlanet-iDempeire-DataManagement-ImportAccount-2-2048x979.png 2048w\" sizes=\"auto, (max-width: 1024px) 100vw, 1024px\" \/><\/figure>\n\n\n\n<h3 class=\"wp-block-heading\"><strong>Step 3: Review the Import Account Staging Record<\/strong><\/h3>\n\n\n\n<p class=\"wp-block-paragraph\">Open the Import Account window, check Element, Name, Account Type, Account Sign, Parent Key, and posting flags for each staged row.<\/p>\n\n\n\n<figure class=\"wp-block-table\"><table><thead><tr><td><strong>Field<\/strong><\/td><td><strong>Sample<\/strong><\/td><td><strong>Purpose<\/strong><\/td><\/tr><\/thead><tbody><tr><td>Element<\/td><td>POTS Account<\/td><td>Accounting element the row belongs to.<\/td><\/tr><tr><td>Account Type<\/td><td>Revenue<\/td><td>Classifies the account for financial statements.<\/td><\/tr><tr><td>Account Sign<\/td><td>Natural<\/td><td>Defines the normal balance behavior.<\/td><\/tr><tr><td>Parent Key<\/td><td>(blank)<\/td><td>Links this account under a summary parent account.<\/td><\/tr><tr><td>Post Actual<\/td><td>Checked<\/td><td>Allows actual transactions to post to this account.<\/td><\/tr><tr><td>Post Statistical<\/td><td>Checked<\/td><td>Allows statistical postings to this account.<\/td><\/tr><tr><td>Document Controlled<\/td><td>Unchecked<\/td><td>Marks whether the account is tied to a default-account column.<\/td><\/tr><\/tbody><\/table><\/figure>\n\n\n\n<figure class=\"wp-block-image size-large\"><img loading=\"lazy\" decoding=\"async\" width=\"1024\" height=\"605\" src=\"https:\/\/tenthplanet.in\/idempiere\/wp-content\/uploads\/sites\/13\/2026\/07\/TenthPlanet-iDempeire-DataManagement-ImportAccount-3-1024x605.png\" alt=\"\" class=\"wp-image-22222\" title=\"\" srcset=\"https:\/\/tenthplanet.in\/idempiere\/wp-content\/uploads\/sites\/13\/2026\/07\/TenthPlanet-iDempeire-DataManagement-ImportAccount-3-1024x605.png 1024w, https:\/\/tenthplanet.in\/idempiere\/wp-content\/uploads\/sites\/13\/2026\/07\/TenthPlanet-iDempeire-DataManagement-ImportAccount-3-300x177.png 300w, https:\/\/tenthplanet.in\/idempiere\/wp-content\/uploads\/sites\/13\/2026\/07\/TenthPlanet-iDempeire-DataManagement-ImportAccount-3-768x454.png 768w, https:\/\/tenthplanet.in\/idempiere\/wp-content\/uploads\/sites\/13\/2026\/07\/TenthPlanet-iDempeire-DataManagement-ImportAccount-3-1536x908.png 1536w, https:\/\/tenthplanet.in\/idempiere\/wp-content\/uploads\/sites\/13\/2026\/07\/TenthPlanet-iDempeire-DataManagement-ImportAccount-3-2048x1210.png 2048w\" sizes=\"auto, (max-width: 1024px) 100vw, 1024px\" \/><\/figure>\n\n\n\n<h3 class=\"wp-block-heading\"><strong>Step 4: Run the Import Accounts Process<\/strong><\/h3>\n\n\n\n<p class=\"wp-block-paragraph\">Click the process button, set Tenant and Element, then choose Update Default Accounts, Create New Combination, and Delete Old Imported Records as needed.<\/p>\n\n\n\n<figure class=\"wp-block-image size-large\"><img loading=\"lazy\" decoding=\"async\" width=\"1024\" height=\"605\" src=\"https:\/\/tenthplanet.in\/idempiere\/wp-content\/uploads\/sites\/13\/2026\/07\/TenthPlanet-iDempeire-DataManagement-ImportAccount-4-1024x605.png\" alt=\"\" class=\"wp-image-22223\" title=\"\" srcset=\"https:\/\/tenthplanet.in\/idempiere\/wp-content\/uploads\/sites\/13\/2026\/07\/TenthPlanet-iDempeire-DataManagement-ImportAccount-4-1024x605.png 1024w, https:\/\/tenthplanet.in\/idempiere\/wp-content\/uploads\/sites\/13\/2026\/07\/TenthPlanet-iDempeire-DataManagement-ImportAccount-4-300x177.png 300w, https:\/\/tenthplanet.in\/idempiere\/wp-content\/uploads\/sites\/13\/2026\/07\/TenthPlanet-iDempeire-DataManagement-ImportAccount-4-768x454.png 768w, https:\/\/tenthplanet.in\/idempiere\/wp-content\/uploads\/sites\/13\/2026\/07\/TenthPlanet-iDempeire-DataManagement-ImportAccount-4-1536x908.png 1536w, https:\/\/tenthplanet.in\/idempiere\/wp-content\/uploads\/sites\/13\/2026\/07\/TenthPlanet-iDempeire-DataManagement-ImportAccount-4-2048x1210.png 2048w\" sizes=\"auto, (max-width: 1024px) 100vw, 1024px\" \/><\/figure>\n\n\n\n<h3 class=\"wp-block-heading\"><strong>Step 5: Review Import Results<\/strong><\/h3>\n\n\n\n<p class=\"wp-block-paragraph\">After the process completes, review the Errors, Inserted, and Updated counts shown in the confirmation dialog.<\/p>\n\n\n\n<figure class=\"wp-block-table\"><table><thead><tr><td><strong>Field<\/strong><\/td><td><strong>Sample<\/strong><\/td><td><strong>Description<\/strong><\/td><\/tr><\/thead><tbody><tr><td>Errors<\/td><td>0<\/td><td>Count of rows that failed validation.<\/td><\/tr><tr><td>Account Element: Inserted<\/td><td>1<\/td><td>Count of new accounts created.<\/td><\/tr><tr><td>Account Element: Updated<\/td><td>0<\/td><td>Count of existing accounts updated.<\/td><\/tr><tr><td>Parent Account: Updated<\/td><td>1<\/td><td>Count of accounts linked to a parent.<\/td><\/tr><\/tbody><\/table><\/figure>\n\n\n\n<figure class=\"wp-block-image size-large\"><img loading=\"lazy\" decoding=\"async\" width=\"1024\" height=\"605\" src=\"https:\/\/tenthplanet.in\/idempiere\/wp-content\/uploads\/sites\/13\/2026\/07\/TenthPlanet-iDempeire-DataManagement-ImportAccount-5-1024x605.png\" alt=\"\" class=\"wp-image-22224\" title=\"\" srcset=\"https:\/\/tenthplanet.in\/idempiere\/wp-content\/uploads\/sites\/13\/2026\/07\/TenthPlanet-iDempeire-DataManagement-ImportAccount-5-1024x605.png 1024w, https:\/\/tenthplanet.in\/idempiere\/wp-content\/uploads\/sites\/13\/2026\/07\/TenthPlanet-iDempeire-DataManagement-ImportAccount-5-300x177.png 300w, https:\/\/tenthplanet.in\/idempiere\/wp-content\/uploads\/sites\/13\/2026\/07\/TenthPlanet-iDempeire-DataManagement-ImportAccount-5-768x454.png 768w, https:\/\/tenthplanet.in\/idempiere\/wp-content\/uploads\/sites\/13\/2026\/07\/TenthPlanet-iDempeire-DataManagement-ImportAccount-5-1536x908.png 1536w, https:\/\/tenthplanet.in\/idempiere\/wp-content\/uploads\/sites\/13\/2026\/07\/TenthPlanet-iDempeire-DataManagement-ImportAccount-5-2048x1210.png 2048w\" sizes=\"auto, (max-width: 1024px) 100vw, 1024px\" \/><\/figure>\n\n\n\n<h3 class=\"wp-block-heading\"><strong>Step 6: Verify the Account in the Chart of Accounts<\/strong><\/h3>\n\n\n\n<p class=\"wp-block-paragraph\">Open Account Element (Chart of Accounts), locate the new account in the tree, and confirm its type, sign, and posting flags.<\/p>\n\n\n\n<figure class=\"wp-block-image size-large\"><img loading=\"lazy\" decoding=\"async\" width=\"1024\" height=\"533\" src=\"https:\/\/tenthplanet.in\/idempiere\/wp-content\/uploads\/sites\/13\/2026\/07\/TenthPlanet-iDempeire-DataManagement-ImportAccount-6-1024x533.png\" alt=\"\" class=\"wp-image-22225\" title=\"\" srcset=\"https:\/\/tenthplanet.in\/idempiere\/wp-content\/uploads\/sites\/13\/2026\/07\/TenthPlanet-iDempeire-DataManagement-ImportAccount-6-1024x533.png 1024w, https:\/\/tenthplanet.in\/idempiere\/wp-content\/uploads\/sites\/13\/2026\/07\/TenthPlanet-iDempeire-DataManagement-ImportAccount-6-300x156.png 300w, https:\/\/tenthplanet.in\/idempiere\/wp-content\/uploads\/sites\/13\/2026\/07\/TenthPlanet-iDempeire-DataManagement-ImportAccount-6-768x400.png 768w, https:\/\/tenthplanet.in\/idempiere\/wp-content\/uploads\/sites\/13\/2026\/07\/TenthPlanet-iDempeire-DataManagement-ImportAccount-6-1536x800.png 1536w, https:\/\/tenthplanet.in\/idempiere\/wp-content\/uploads\/sites\/13\/2026\/07\/TenthPlanet-iDempeire-DataManagement-ImportAccount-6-2048x1067.png 2048w\" sizes=\"auto, (max-width: 1024px) 100vw, 1024px\" \/><\/figure>\n\n\n\n<h2 class=\"wp-block-heading\"><strong>Common Issues and Resolutions<\/strong><\/h2>\n\n\n\n<figure class=\"wp-block-table\"><table><thead><tr><td><strong>Issue<\/strong><\/td><td><strong>Cause<\/strong><\/td><td><strong>Resolution<\/strong><\/td><\/tr><\/thead><tbody><tr><td>Row shows &#8220;ERR=No Name&#8221;<\/td><td>Value or Name column is empty in the CSV.<\/td><td>Fill in Value and Name for every row before re-loading the file.<\/td><\/tr><tr><td>Row shows &#8220;ERR=Invalid Element&#8221;<\/td><td>Element Name in the file does not match any C_Element.<\/td><td>Set the Element parameter or correct the ElementName column.<\/td><\/tr><tr><td>Default accounts did not change<\/td><td>Update Default Accounts checkbox left unchecked.<\/td><td>Enable Update Default Accounts when running the Import Accounts process.<\/td><\/tr><tr><td>Import shows 0 Inserted and 0 Updated<\/td><td>Rows already marked Processed=Y from an earlier run.<\/td><td>Reload the CSV file so new unprocessed rows are created before running the process.<\/td><\/tr><tr><td>Existing account combinations affected unexpectedly<\/td><td>Create New Combination disabled while changing a default account.<\/td><td>Enable Create New Combination, or confirm the replace behavior first and keep a backup.<\/td><\/tr><\/tbody><\/table><\/figure>\n\n\n\n<h2 class=\"wp-block-heading\"><strong>Next Steps<\/strong><\/h2>\n\n\n\n<ul class=\"wp-block-list\">\n<li>Configure the Accounting Schema and confirm its default accounts.<\/li>\n\n\n\n<li>Review Element Value Security if certain organizations should not see all accounts.<\/li>\n\n\n\n<li>Set up Bank Account and GL Category records linked to the new accounts.<\/li>\n\n\n\n<li>Continue with Business Partner and Product setup to begin posting retail transactions.<\/li>\n<\/ul>\n","protected":false},"excerpt":{"rendered":"<p>The Import Account window lets iDempiere users bulk load Chart of Accounts values from a staging table into live account [&hellip;]<\/p>\n","protected":false},"author":3,"featured_media":0,"comment_status":"closed","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[10,92],"tags":[],"class_list":["post-22218","post","type-post","status-publish","format-standard","hentry","category-idempiere-product","category-idempiere-data"],"_links":{"self":[{"href":"https:\/\/tenthplanet.in\/idempiere\/wp-json\/wp\/v2\/posts\/22218","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/tenthplanet.in\/idempiere\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/tenthplanet.in\/idempiere\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/tenthplanet.in\/idempiere\/wp-json\/wp\/v2\/users\/3"}],"replies":[{"embeddable":true,"href":"https:\/\/tenthplanet.in\/idempiere\/wp-json\/wp\/v2\/comments?post=22218"}],"version-history":[{"count":0,"href":"https:\/\/tenthplanet.in\/idempiere\/wp-json\/wp\/v2\/posts\/22218\/revisions"}],"wp:attachment":[{"href":"https:\/\/tenthplanet.in\/idempiere\/wp-json\/wp\/v2\/media?parent=22218"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/tenthplanet.in\/idempiere\/wp-json\/wp\/v2\/categories?post=22218"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/tenthplanet.in\/idempiere\/wp-json\/wp\/v2\/tags?post=22218"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}