{"id":148807,"date":"2026-09-28T07:21:55","date_gmt":"2026-09-28T07:21:55","guid":{"rendered":"https:\/\/docs.daftra.com\/tutorial\/%d9%86%d9%82%d9%84-%d9%88%d8%aa%d9%87%d9%8a%d8%a6%d8%a9-%d8%a7%d9%84%d8%a8%d9%8a%d8%a7%d9%86%d8%a7%d8%aa-%d9%85%d9%86-%d9%86%d8%b8%d8%a7%d9%85-%d8%a2%d8%ae%d8%b1-%d8%a7%d9%84%d9%89-%d8%af%d9%81%d8%aa\/"},"modified":"2026-10-05T12:10:07","modified_gmt":"2026-10-05T12:10:07","slug":"migrating-and-setting-up-data-from-another-system-into-your-account","status":"publish","type":"tutorial","link":"https:\/\/docs.daftra.com\/en\/tutorial\/migrating-and-setting-up-data-from-another-system-into-your-account\/","title":{"rendered":"Migrating and Setting Up Data from Another System into your Account"},"content":{"rendered":"
\n
\n

If you are moving to the system from another accounting program or from Excel files, you can migrate your core data by importing Excel (XLS or XLSX) or CSV files instead of entering it manually: clients and suppliers with their opening balances, products with their quantities in the warehouses, the balances of the rest of the accounts with an opening entry, and previous invoices if you want. This guide explains the correct order of migration, the import steps, the columns of each file, and how the system records the balances.<\/p>\n

\n

\ud83d\udec8<\/span><\/p>\n

Note:<\/strong> the order matters: taxes, warehouses, and price lists are written in the import files by name, so they must already be added in the system before you import the files that refer to them.<\/p>\n<\/div>\n

Before You Start<\/h2>\n
    \n
  • Export your data from the old system to Excel: clients, suppliers, products, stock balances, and the trial balance on the migration date.<\/li>\n
  • Choose the migration date (such as the first day of the month or of the financial year), and use it as the date for all opening balances.<\/li>\n
  • Add in the system beforehand: taxes, warehouses, price lists, and unit templates if you use them.<\/li>\n
  • Review the chart of accounts in the system, and add the accounts you need with the same names or codes as your old accounts; there is no import for the chart of accounts, and entries are imported onto existing accounts.<\/li>\n
  • Write the dates in the files in the date format set in your account, or in the year-month-day format.<\/li>\n<\/ul>\n

    Recommended Order<\/h2>\n
      \n
    1. Settings: taxes, warehouses, price lists, apps, chart of accounts.<\/li>\n
    2. Suppliers with their opening balances.<\/li>\n
    3. Clients with their opening balances.<\/li>\n
    4. Products with their quantities in the warehouses.<\/li>\n
    5. The balances of the rest of the accounts (treasuries, banks, assets, capital\u2026) with an opening entry.<\/li>\n
    6. Previous invoices (optional) if you want to keep the old sales record.<\/li>\n<\/ol>\n
      \n

      \u26a0<\/span><\/p>\n

      Warning:<\/strong> don\u2019t import the clients\u2019, suppliers\u2019, or inventory balance a second time inside the opening entry; the system records their entries automatically when they are imported, and repeating them doubles the balances.<\/p>\n<\/div>\n

      Import Steps (Clients, Suppliers, and Products)<\/h2>\n
        \n
      1. Open the import screen: Import Clients, Import Suppliers, or Import Products (from the Import Products button in the products list).<\/li>\n
      2. In the file to be imported, choose a CSV, XLS, or XLSX file.<\/li>\n
      3. If the file is CSV, choose the delimiter (comma, semicolon, or Tab).<\/li>\n
      4. Enable Import the first row of the file only if the first row is data rather than column headers.<\/li>\n
      5. Click Next Step.<\/li>\n
      6. In Map Fields, link each System Field to its Field in the File. The system suggests the mapping based on your column headers; review it. Fields marked with * are mandatory.<\/li>\n
      7. To update existing records instead of creating new ones, enable Update existing \u2026 data with the new data and choose the field the system uses to match the records.<\/li>\n
      8. Click Import.<\/li>\n
      9. Follow the result: clients and products are imported in the background, and a screen appears showing the number of successful and failed records and the reason for each error. The result for suppliers appears directly.<\/li>\n<\/ol>\n

        If a background import stops for more than 3 minutes without completing, a Resume button appears to continue it.<\/p>\n

        Importing Suppliers<\/h2>\n\n\n\n\n\n\n\n\n\n\n
        System Field<\/th>\nMandatory<\/th>\nWhat to Enter<\/th>\n<\/tr>\n
        Business Name<\/td>\nYes<\/td>\nThe supplier\u2019s name.<\/td>\n<\/tr>\n
        Supplier Number<\/td>\nNo<\/td>\nIf left blank, it is created automatically.<\/td>\n<\/tr>\n
        Email, Phone, Mobile<\/td>\nNo<\/td>\nContact details.<\/td>\n<\/tr>\n
        First Name, Last Name<\/td>\nNo<\/td>\nThe contact person\u2019s name.<\/td>\n<\/tr>\n
        Address, City, State, Postal Code, Country<\/td>\nNo<\/td>\nThe country by name or by code.<\/td>\n<\/tr>\n
        Opening Balance<\/td>\nNo<\/td>\nThe amount due to the supplier on the migration date, in your account\u2019s default currency.<\/td>\n<\/tr>\n
        Opening Balance Date<\/td>\nNo<\/td>\nThe migration date.<\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n

        Existing suppliers can be matched by email, supplier number, or business name. If a matching supplier exists and you haven\u2019t enabled updating, the row is rejected as a duplicate row.<\/p>\n

        Importing Clients<\/h2>\n\n\n\n\n\n\n\n\n\n\n\n\n\n
        System Field<\/th>\nMandatory<\/th>\nWhat to Enter<\/th>\n<\/tr>\n
        Business Name<\/td>\nYes<\/td>\nThe client\u2019s name.<\/td>\n<\/tr>\n
        Client Code<\/td>\nNo<\/td>\nIf left blank, it is created automatically.<\/td>\n<\/tr>\n
        Email<\/td>\nNo<\/td>\nMust be valid and not used for another client.<\/td>\n<\/tr>\n
        Phone, Mobile, Address, Country<\/td>\nNo<\/td>\nContact details.<\/td>\n<\/tr>\n
        Type<\/td>\nNo<\/td>\n1 or Individual for an individual, 2 or Business for a company.<\/td>\n<\/tr>\n
        Price Groups<\/td>\nNo<\/td>\nThe name of an existing price group.<\/td>\n<\/tr>\n
        Category<\/td>\nNo<\/td>\nCreated automatically if it doesn\u2019t exist.<\/td>\n<\/tr>\n
        Credit Limit, Credit Period<\/td>\nNo<\/td>\nAppear when credit management is enabled.<\/td>\n<\/tr>\n
        Opening Balance<\/td>\nNo<\/td>\nThe amount due from the client on the migration date.<\/td>\n<\/tr>\n
        Opening Balance Date<\/td>\nNo<\/td>\nThe migration date; if left blank, today\u2019s date is used.<\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n

        Existing clients can be matched by email, client code, phone, or mobile. In Saudi accounts, the national address fields appear (building number, street name, district\u2026).<\/p>\n

        Importing Products<\/h2>\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n
        System Field<\/th>\nMandatory<\/th>\nWhat to Enter<\/th>\n<\/tr>\n
        Name<\/td>\nYes<\/td>\nThe product name.<\/td>\n<\/tr>\n
        Product Code, Barcode<\/td>\nNo<\/td>\nThe barcode is at least 5 digits and not used for another product.<\/td>\n<\/tr>\n
        Type<\/td>\nNo<\/td>\nproduct for a product, service for a service, bundle for a bundle product. The default is product.<\/td>\n<\/tr>\n
        Selling Price, Purchase Price, Minimum Selling Price<\/td>\nNo<\/td>\nNumbers. The purchase price is used as the cost of the imported quantity.<\/td>\n<\/tr>\n
        Tax 1, Tax 2<\/td>\nNo<\/td>\nThe name of an existing tax; if left blank, the products\u2019 default taxes are applied.<\/td>\n<\/tr>\n
        Category, Brand, Supplier<\/td>\nNo<\/td>\nCreated automatically if they don\u2019t exist.<\/td>\n<\/tr>\n
        Track Stock<\/td>\nNo<\/td>\n1 or 0.<\/td>\n<\/tr>\n
        Stock Quantity<\/td>\nNo<\/td>\nThe balance on the migration date.<\/td>\n<\/tr>\n
        Warehouse<\/td>\nNo<\/td>\nThe name of an existing warehouse; if left blank, the quantity is added to the main warehouse.<\/td>\n<\/tr>\n
        Tracking Type<\/td>\nNo<\/td>\nquantity_only, serial, lot, expiry_date, or lot_and_expiry_date.<\/td>\n<\/tr>\n
        Price Lists<\/td>\nNo<\/td>\nA column for each price list, by its name.<\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n

        Click Download Example on the import products screen to get a file with the columns suited to your account\u2019s settings. Existing products can be matched by name, product code, or barcode.<\/p>\n

        How the System Works<\/h2>\n

        Opening Balances for Clients and Suppliers<\/h3>\n
          \n
        • Each client\u2019s or supplier\u2019s balance is recorded as an opening balance in their account, and appears in their account statement.<\/li>\n
        • An automatic entry is created between the client\u2019s or supplier\u2019s account and the Opening Balances account.<\/li>\n
        • The client\u2019s balance is recorded in the client\u2019s default currency if there is one, and the supplier\u2019s balance in your account\u2019s default currency.<\/li>\n
        • If you re-import a client or supplier that has an opening balance in the same currency, the old balance is replaced by the new one and is not added to it.<\/li>\n<\/ul>\n

          Product Quantities<\/h3>\n
            \n
          • The stock quantity value is the required balance, not a quantity to be added: the system calculates the difference between the number and the current balance and adds or deducts it.<\/li>\n
          • The differences are recorded in approved stock requisitions of the type Manual Import Inbound or Manual Import Outbound, one requisition per warehouse (with up to 500 lines in the requisition).<\/li>\n
          • The quantity is recorded at the purchase price in the file, and a new product\u2019s average cost becomes equal to the purchase price.<\/li>\n<\/ul>\n

            Example:<\/strong> a new product, the stock quantity in the file is 50, and the purchase price is 20: a Manual Import Inbound requisition is created for 50 units at a cost of 1,000, and the average cost becomes 20. If you re-import with a quantity of 60, only 10 is added.<\/p>\n

            \n

            \u26a0<\/span><\/p>\n

            Warning:<\/strong> the quantities of products tracked by serial number, lot number, or expiry date cannot be entered through import. Import the products without a quantity, then add their quantities with a stock addition requisition or a stocktaking sheet with the tracking data.<\/p>\n<\/div>\n

            Balances of the Rest of the Accounts (the Opening Entry)<\/h2>\n

            To migrate the balances of treasuries, banks, assets, liabilities, and capital, import an opening entry from Import Entries (from the Import button in the entries list).<\/p>\n

              \n
            1. Download the example file from the import entries screen.<\/li>\n
            2. Write a row for each account: the entry code (the same code for all the entry\u2019s rows), the date, the account name or code, and the debit or credit.<\/li>\n
            3. Choose the entry status: Draft to review it before posting, or Issue.<\/li>\n
            4. Upload the file, map the columns, then click Import.<\/li>\n<\/ol>\n
                \n
              • All the rows that carry the same entry code form a single entry, and the date, currency, and description must be identical in them.<\/li>\n
              • The maximum is 10,000 rows in the file, and 500 rows in a single entry.<\/li>\n
              • Debit and credit are positive numbers. Put the difference between debit and credit on the Opening Balances account or the capital account so that the entry balances.<\/li>\n
              • Don\u2019t put the clients\u2019, suppliers\u2019, and inventory balances in this entry if you have already imported them.<\/li>\n<\/ul>\n

                Previous Invoices (Optional)<\/h2>\n

                You can import old sales invoices from Import Invoices, choosing their status (Draft or Issue) and numbering them automatically. The maximum is 10,000 rows and 500 lines per invoice.<\/p>\n

                \n

                \u26a0<\/span><\/p>\n

                Warning:<\/strong> imported invoices create entries, deduct stock, and increase clients\u2019 balances. If you imported the opening balances of clients and inventory, don\u2019t import the invoices that preceded the migration date with the same effect; otherwise the balances are duplicated.<\/p>\n<\/div>\n

                Validation Rules<\/h2>\n

                The system rejects the entire file in the following cases:<\/p>\n

                  \n
                • A CSV file without a delimiter chosen.<\/li>\n
                • A file with only one column.<\/li>\n
                • A file in which the number of columns differs from one row to another.<\/li>\n
                • A file with no data rows.<\/li>\n
                • A mandatory field that isn\u2019t mapped to a column.<\/li>\n<\/ul>\n

                  And it skips the row alone (stating the reason in the results) in the following cases:<\/p>\n

                    \n
                  • A mandatory field is empty, a date is in an incorrect format, or a number is negative.<\/li>\n
                  • An email that is invalid or used for another client.<\/li>\n
                  • A record that matches an existing record and you haven\u2019t enabled updating.<\/li>\n
                  • A warehouse, tax, or unit template that doesn\u2019t exist.<\/li>\n
                  • A barcode that is already used or is fewer than 5 digits.<\/li>\n
                  • A quantity for a product tracked by serial number, lot number, or expiry date.<\/li>\n
                  • Exceeding the client count limit in your plan.<\/li>\n<\/ul>\n

                    Frequently Asked Questions<\/h2>\n
                      \n
                    • Can I import the chart of accounts?<\/strong> No, add the accounts manually in the chart of accounts before importing entries.<\/li>\n
                    • I imported the products twice and they were duplicated. Why?<\/strong> Because the import creates new records unless you enable updating and choose the matching field (such as the product code).<\/li>\n
                    • I changed a product\u2019s quantity in the file and re-imported. Is the quantity added?<\/strong> No, the balance is adjusted to become the number written.<\/li>\n
                    • Why did the client\u2019s balance appear with today\u2019s date?<\/strong> Because the opening balance date was empty or in an incorrect format.<\/li>\n
                    • Can I import purchase invoices?<\/strong> There is no import for purchase invoices; migrate the amounts due to suppliers as an opening balance.<\/li>\n
                    • How do I migrate the quantities of products that have a serial number?<\/strong> Import the products without a quantity, then add them with a stock addition requisition or a stocktaking sheet with the serial numbers.<\/li>\n
                    • Is there an example file for clients and suppliers?<\/strong> No, use the field names shown in this guide as column headers so the system suggests the mapping automatically.<\/li>\n<\/ul>\n<\/div>\n<\/div>\n","protected":false},"author":17,"featured_media":0,"template":"","categories":[2043,2069],"tags":[18779,19634,19635,18771,6913,7667,18772,19631,19632,4563,19556,19633,19238,19636],"class_list":["post-148807","tutorial","type-tutorial","status-publish","hentry","category-settings","category-about-daftra","tag-can-the-chart-of-accounts-be-imported","tag-how-do-i-import-clients","tag-how-do-i-import-products-with-quantities","tag-import-clients","tag-import-entries-en","tag-import-invoices","tag-import-products","tag-import-suppliers","tag-migrating-from-another-system","tag-opening-balance","tag-opening-balances","tag-opening-entry","tag-stock-quantity-en","tag-why-were-products-duplicated-after-import"],"yoast_head":"\nMigrating and Setting Up Data from Another System into your Account - 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\/tutorial\/migrating-and-setting-up-data-from-another-system-into-your-account\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Migrating and Setting Up Data from Another System into your Account - Daftra Knowledge Base\" \/>\n<meta property=\"og:description\" content=\"If you are moving to the system from another accounting program or from Excel files, you can migrate your core data by importing Excel (XLS or XLSX) or CSV files instead of entering it manually: clients and suppliers with their opening balances, products with their quantities in the warehouses, the balances of the rest of […]\" \/>\n<meta property=\"og:url\" content=\"https:\/\/docs.daftra.com\/en\/tutorial\/migrating-and-setting-up-data-from-another-system-into-your-account\/\" \/>\n<meta property=\"og:site_name\" content=\"Daftra Knowledge Base\" \/>\n<meta property=\"article:modified_time\" content=\"2026-10-05T12:10:07+00:00\" \/>\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=\"9 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\":\"WebPage\",\"@id\":\"https:\/\/docs.daftra.com\/en\/tutorial\/migrating-and-setting-up-data-from-another-system-into-your-account\/#webpage\",\"url\":\"https:\/\/docs.daftra.com\/en\/tutorial\/migrating-and-setting-up-data-from-another-system-into-your-account\/\",\"name\":\"Migrating and Setting Up Data from Another System into your Account - Daftra Knowledge Base\",\"isPartOf\":{\"@id\":\"https:\/\/docs.daftra.com\/#website\"},\"datePublished\":\"2026-09-28T07:21:55+00:00\",\"dateModified\":\"2026-10-05T12:10:07+00:00\",\"breadcrumb\":{\"@id\":\"https:\/\/docs.daftra.com\/en\/tutorial\/migrating-and-setting-up-data-from-another-system-into-your-account\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/docs.daftra.com\/en\/tutorial\/migrating-and-setting-up-data-from-another-system-into-your-account\/\"]}]},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/docs.daftra.com\/en\/tutorial\/migrating-and-setting-up-data-from-another-system-into-your-account\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\/\/docs.daftra.com\/en\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Migrating and Setting Up Data from Another System into your Account\"}]}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"Migrating and Setting Up Data from Another System into your Account - 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\/tutorial\/migrating-and-setting-up-data-from-another-system-into-your-account\/","og_locale":"en_US","og_type":"article","og_title":"Migrating and Setting Up Data from Another System into your Account - Daftra Knowledge Base","og_description":"If you are moving to the system from another accounting program or from Excel files, you can migrate your core data by importing Excel (XLS or XLSX) or CSV files instead of entering it manually: clients and suppliers with their opening balances, products with their quantities in the warehouses, the balances of the rest of […]","og_url":"https:\/\/docs.daftra.com\/en\/tutorial\/migrating-and-setting-up-data-from-another-system-into-your-account\/","og_site_name":"Daftra Knowledge Base","article_modified_time":"2026-10-05T12:10:07+00:00","twitter_card":"summary_large_image","twitter_misc":{"Est. reading time":"9 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":"WebPage","@id":"https:\/\/docs.daftra.com\/en\/tutorial\/migrating-and-setting-up-data-from-another-system-into-your-account\/#webpage","url":"https:\/\/docs.daftra.com\/en\/tutorial\/migrating-and-setting-up-data-from-another-system-into-your-account\/","name":"Migrating and Setting Up Data from Another System into your Account - Daftra Knowledge Base","isPartOf":{"@id":"https:\/\/docs.daftra.com\/#website"},"datePublished":"2026-09-28T07:21:55+00:00","dateModified":"2026-10-05T12:10:07+00:00","breadcrumb":{"@id":"https:\/\/docs.daftra.com\/en\/tutorial\/migrating-and-setting-up-data-from-another-system-into-your-account\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/docs.daftra.com\/en\/tutorial\/migrating-and-setting-up-data-from-another-system-into-your-account\/"]}]},{"@type":"BreadcrumbList","@id":"https:\/\/docs.daftra.com\/en\/tutorial\/migrating-and-setting-up-data-from-another-system-into-your-account\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/docs.daftra.com\/en\/"},{"@type":"ListItem","position":2,"name":"Migrating and Setting Up Data from Another System into your Account"}]}]}},"_links":{"self":[{"href":"https:\/\/docs.daftra.com\/en\/wp-json\/wp\/v2\/tutorial\/148807","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/docs.daftra.com\/en\/wp-json\/wp\/v2\/tutorial"}],"about":[{"href":"https:\/\/docs.daftra.com\/en\/wp-json\/wp\/v2\/types\/tutorial"}],"author":[{"embeddable":true,"href":"https:\/\/docs.daftra.com\/en\/wp-json\/wp\/v2\/users\/17"}],"version-history":[{"count":2,"href":"https:\/\/docs.daftra.com\/en\/wp-json\/wp\/v2\/tutorial\/148807\/revisions"}],"predecessor-version":[{"id":148825,"href":"https:\/\/docs.daftra.com\/en\/wp-json\/wp\/v2\/tutorial\/148807\/revisions\/148825"}],"wp:attachment":[{"href":"https:\/\/docs.daftra.com\/en\/wp-json\/wp\/v2\/media?parent=148807"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/docs.daftra.com\/en\/wp-json\/wp\/v2\/categories?post=148807"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/docs.daftra.com\/en\/wp-json\/wp\/v2\/tags?post=148807"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}