{"id":105048,"date":"2024-01-16T07:16:10","date_gmt":"2024-01-16T07:16:10","guid":{"rendered":"https:\/\/www.askforaccounting.com\/?p=105048"},"modified":"2025-11-20T09:38:57","modified_gmt":"2025-11-20T09:38:57","slug":"import-data-into-sage-50","status":"publish","type":"post","link":"https:\/\/www.askforaccounting.com\/sage\/import-data-into-sage-50\/","title":{"rendered":"Import Data into Sage 50"},"content":{"rendered":"\n<p>There are many ways through which a user can get their import data into Sage 50. Data importing processes require manual work to be done by the user and are more time and effort-consuming, making them not the first option anyone would want to choose. Data can simply be imported into Sage 50 from another accounting software automatically, which will be discussed in-depth in this article.<\/p>\n\n\n\n<div id=\"ez-toc-container\" class=\"ez-toc-v2_0_81 counter-hierarchy ez-toc-counter ez-toc-grey ez-toc-container-direction\">\n<div class=\"ez-toc-title-container\">\n<p class=\"ez-toc-title\" style=\"cursor:inherit\">Table of Contents<\/p>\n<span class=\"ez-toc-title-toggle\"><a href=\"#\" class=\"ez-toc-pull-right ez-toc-btn ez-toc-btn-xs ez-toc-btn-default ez-toc-toggle\" aria-label=\"Toggle Table of Content\"><span class=\"ez-toc-js-icon-con\"><span class=\"\"><span class=\"eztoc-hide\" style=\"display:none;\">Toggle<\/span><span class=\"ez-toc-icon-toggle-span\"><svg style=\"fill: #999;color:#999\" xmlns=\"http:\/\/www.w3.org\/2000\/svg\" class=\"list-377408\" width=\"20px\" height=\"20px\" viewBox=\"0 0 24 24\" fill=\"none\"><path d=\"M6 6H4v2h2V6zm14 0H8v2h12V6zM4 11h2v2H4v-2zm16 0H8v2h12v-2zM4 16h2v2H4v-2zm16 0H8v2h12v-2z\" fill=\"currentColor\"><\/path><\/svg><svg style=\"fill: #999;color:#999\" class=\"arrow-unsorted-368013\" xmlns=\"http:\/\/www.w3.org\/2000\/svg\" width=\"10px\" height=\"10px\" viewBox=\"0 0 24 24\" version=\"1.2\" baseProfile=\"tiny\"><path d=\"M18.2 9.3l-6.2-6.3-6.2 6.3c-.2.2-.3.4-.3.7s.1.5.3.7c.2.2.4.3.7.3h11c.3 0 .5-.1.7-.3.2-.2.3-.5.3-.7s-.1-.5-.3-.7zM5.8 14.7l6.2 6.3 6.2-6.3c.2-.2.3-.5.3-.7s-.1-.5-.3-.7c-.2-.2-.4-.3-.7-.3h-11c-.3 0-.5.1-.7.3-.2.2-.3.5-.3.7s.1.5.3.7z\"\/><\/svg><\/span><\/span><\/span><\/a><\/span><\/div>\n<nav><ul class='ez-toc-list ez-toc-list-level-1 ' ><li class='ez-toc-page-1 ez-toc-heading-level-2'><a class=\"ez-toc-link ez-toc-heading-1\" href=\"https:\/\/www.askforaccounting.com\/sage\/import-data-into-sage-50\/#Prepare_your_Data_Before_Importing_into_Sage_50\" >Prepare your Data Before Importing into Sage 50<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-2'><a class=\"ez-toc-link ez-toc-heading-2\" href=\"https:\/\/www.askforaccounting.com\/sage\/import-data-into-sage-50\/#Guide_to_Information_or_Import_Data_into_Sage_50_Accounts\" >Guide to Information or Import Data into Sage 50 Accounts<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-2'><a class=\"ez-toc-link ez-toc-heading-3\" href=\"https:\/\/www.askforaccounting.com\/sage\/import-data-into-sage-50\/#What_Type_of_Data_or_Information_You_Can_Import_or_Cant_Import_into_Sage_50_Accounts\" >What Type of Data or Information You Can Import or Can&#8217;t Import into Sage 50 Accounts?<\/a><ul class='ez-toc-list-level-3' ><li class='ez-toc-heading-level-3'><a class=\"ez-toc-link ez-toc-heading-4\" href=\"https:\/\/www.askforaccounting.com\/sage\/import-data-into-sage-50\/#Type_of_data_you_can_import\" >Type of data you can import<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-3'><a class=\"ez-toc-link ez-toc-heading-5\" href=\"https:\/\/www.askforaccounting.com\/sage\/import-data-into-sage-50\/#Type_of_data_or_Information_you_cant_import\" >Type of data or Information you can&#8217;t import<\/a><\/li><\/ul><\/li><\/ul><\/nav><\/div>\n<h2 class=\"wp-block-heading\" id=\"1-prepare-your-data-before-importing-into-sage-50\"><span class=\"ez-toc-section\" id=\"Prepare_your_Data_Before_Importing_into_Sage_50\"><\/span>Prepare your Data Before Importing into Sage 50<span class=\"ez-toc-section-end\"><\/span><\/h2>\n\n\n\n<p>There are a few things that the user needs to take care of before they can start importing data into Sage 50. Failure to adhere to the following things may result in a loss of data or information.<\/p>\n\n\n\n<p>The first thing that needs to be kept in mind before the user can start the import process is to take a <a href=\"https:\/\/askforaccounting.com\/sage\/backup-data-sage-50\/\">backup of their Sage 50 database<\/a>. If there is a mistake during the import process, the Sage 50 accounting system can easily be restored from a backup.<\/p>\n\n\n\n<p>In addition to this, there are a few additional pointers that need to be kept in mind for smooth data import into Sage 50. Some of these extremely helpful tips\/pointers are mentioned below.<\/p>\n\n\n\n<ul class=\"wp-block-list\">\n<li>Sage 50 requires the \u2018<strong>Due Date<\/strong>\u2019 field of an imported sales\/purchase transaction to be imported as well. It is not capable of calculating the due date for the transaction.<\/li>\n\n\n\n<li>Some other data does not get imported:\n<ul class=\"wp-block-list\">\n<li>G\/L account links, custom field labels, shipping methods, payroll fields, etc.<\/li>\n\n\n\n<li>Inventory beginning balances.<\/li>\n\n\n\n<li>Job beginning balances.<\/li>\n\n\n\n<li>Sales Tax information.<\/li>\n\n\n\n<li>Payroll Tax Formulas.<\/li>\n\n\n\n<li>Task Window Templates.<\/li>\n<\/ul>\n<\/li>\n\n\n\n<li>Some fields also have specific values and information about whether they can be imported or not. Users should look at the field definition list for more information.<\/li>\n\n\n\n<li>The order in which the user imports the data is also extremely important. For example, the user cannot import the vendor list before the employee list, and so on. There is a certain order that needs to be followed, which is: <a href=\"https:\/\/askforaccounting.com\/sage\/import-chart-of-accounts-in-sage-50\/\">Chart of accounts<\/a> -> Employee List -> Vendor List -> Customer List -> Inventory Item List -> Phase List -> Cost Code List -> Job List.<\/li>\n\n\n\n<li>In some situations, Sage 50 does not allow duplicate reference numbers to be imported. For instance, there cannot be a duplicate invoice number for the same customer ID. In such a scenario, the user must enter those duplicate records manually.<\/li>\n\n\n\n<li>In some situations, Sage 50 does allow duplicate reference numbers to be imported. For instance, payroll checks can have duplicate check numbers.<\/li>\n<\/ul>\n\n\n\n<h2 class=\"wp-block-heading\" id=\"2-how-to-import-your-data-into-sage-50\"><span class=\"ez-toc-section\" id=\"Guide_to_Information_or_Import_Data_into_Sage_50_Accounts\"><\/span>Guide to Information or Import Data into Sage 50 Accounts<span class=\"ez-toc-section-end\"><\/span><\/h2>\n\n\n\n<p>Now that the user has taken care of all the things that need to be kept in mind while preparing their data for import into Sage 50, we can begin the process to start the import smoothly. To import data into Sage 50, the user needs to just follow these steps, and their data will be imported hassle-free.<\/p>\n\n\n\n<ul class=\"wp-block-list\">\n<li>First, the user needs to navigate to the \u2018<strong>File<\/strong>\u2019 option, which can be found in the menu bar.<\/li>\n\n\n\n<li>In the \u2018File\u2019 menu, the user then needs to choose \u2018<strong>Select Import\/Export<\/strong>.<\/li>\n\n\n\n<li><span style=\"font-size: inherit; background-color: initial;\">The user then needs to select the <strong>program area<\/strong> and the <strong>template<\/strong> that they want to use.<\/span><\/li>\n\n\n\n<li>After that has been done, the user needs to then press the \u2018<strong>Import<\/strong>\u2019 button.<\/li>\n\n\n\n<li>Sage 50 will then display the window for the template that the user selected. It will also be showing the \u2018<strong>Fields<\/strong>\u2019 tab.<\/li>\n\n\n\n<li>Now, the user will need to select the \u2018<strong>Show<\/strong>\u2019 checkbox for every field that is included in the import file.<\/li>\n\n\n\n<li>If the order of the fields listed in front of the user is not correct, the user must select the first field they wish to relocate, and then press the \u2018<strong>Move<\/strong>\u2019 button. They then need to select the row beneath the row to which they want to move the selected field.<\/li>\n\n\n\n<li>Next, the user needs to go to the \u2018<strong>Options<\/strong>\u2019 tab. They need to then select the \u2018<strong>Warn if Duplicate Reference<\/strong>\u2019 check box, provided that they want Sage 50 to tell them every time a duplicate check number or receipt reference appears during the import process.<\/li>\n\n\n\n<li>Next, the user needs to specify the <strong>path<\/strong> of the import file. What this means is that they need to tell Sage 50 where the import file is stored on their computer. If it is stored on an external storage device, the user needs to open that device\u2019s folder and give the import file to Sage 50.<\/li>\n\n\n\n<li>If the import file contains headings, the user needs to select \u2018<strong>First Row Contains Headings<\/strong>\u2019. This will help Sage 50 ignore the first row and not confuse it with the rest of the data that is present in the file.<\/li>\n\n\n\n<li>The user can then save these changes to the template to use them later simply by pressing \u2018<strong>Save<\/strong>\u2019 and providing a name for the template. It must be kept in mind that the name of the template should be unique, the Sage 50 default name cannot be used.<\/li>\n\n\n\n<li>When all of the aforementioned steps have been completed, the user can simply select \u2019<strong>OK<\/strong>\u2019, and the import process will commence at this point.<\/li>\n<\/ul>\n\n\n\n<p>If your data import wizard validation getting any issues with your data, need to edit the data in your import file to correct the issue.<\/p>\n\n\n\n<ul class=\"wp-block-list\">\n<li>First, <strong>close<\/strong> the file.<\/li>\n\n\n\n<li>After that again <strong>run the Data Import wizard<\/strong>.<\/li>\n<\/ul>\n\n\n\n<h2 class=\"wp-block-heading\" id=\"0-what-type-of-information-can-i-import-into-sage-50\"><span class=\"ez-toc-section\" id=\"What_Type_of_Data_or_Information_You_Can_Import_or_Cant_Import_into_Sage_50_Accounts\"><\/span>What Type of Data or Information You Can Import or Can&#8217;t Import into Sage 50 Accounts?<span class=\"ez-toc-section-end\"><\/span><\/h2>\n\n\n\n<p>There are so many things that a user can import data or can&#8217;t import data into Sage 50.<\/p>\n\n\n\n<h3 class=\"wp-block-heading\"><span class=\"ez-toc-section\" id=\"Type_of_data_you_can_import\"><\/span> Type of data you can import<span class=\"ez-toc-section-end\"><\/span><\/h3>\n\n\n\n<p>There are so many things that a user can import data into Sage 50, which makes things a lot easier for any user who is trying to import data in Sage 50 from another accounting software. Following are the types of information that a user can import data into Sage 50, with exceptions of items that cannot be imported mentioned as well.<\/p>\n\n\n\n<ul class=\"wp-block-list\">\n<li>You can import Audit trail transactions but can&#8217;t import foreign <a href=\"https:\/\/askforaccounting.com\/sage\/import-a-bank-statement-in-sage-50\/\">bank transactions<\/a>, sales receipts, purchase payments, sales discounts, purchase discounts, CIS, etc.<\/li>\n\n\n\n<li>You can import Bank accounts as nominal records.<\/li>\n\n\n\n<li>You can <a href=\"https:\/\/askforaccounting.com\/sage\/import-customer-vendor-contacts-sage-50\/\">import Customer records<\/a> but can&#8217;t import customer delivery addresses.<\/li>\n\n\n\n<li>You can import fixed asset records.<\/li>\n\n\n\n<li>You can import Nominal accounts and standard budgets but can&#8217;t import advanced budget information.<\/li>\n\n\n\n<li>You can import Price lists from within the price list record.<\/li>\n\n\n\n<li>You can import Product records but can&#8217;t import Bills of materials and Quantity in stock.<\/li>\n\n\n\n<li>You can import Project records.<\/li>\n\n\n\n<li>You can import Project-only transactions.<\/li>\n\n\n\n<li>You can import Stock take.<\/li>\n\n\n\n<li>You can import Stock transactions but can&#8217;t import Movement out and Movement in.<\/li>\n\n\n\n<li>You can import Supplier records but can&#8217;t import supplier delivery addresses.<\/li>\n<\/ul>\n\n\n\n<h3 class=\"wp-block-heading\"><span class=\"ez-toc-section\" id=\"Type_of_data_or_Information_you_cant_import\"><\/span>Type of data or Information you can&#8217;t import<span class=\"ez-toc-section-end\"><\/span><\/h3>\n\n\n\n<p>There are so many things that a user can&#8217;t import data or information into Sage 50. Following are the types of information that a user can not <a href=\"https:\/\/gb-kb.sage.com\/portal\/app\/portlets\/results\/viewsolution.jsp?solutionid=200427112602351&amp;hypermediatext=null\" target=\"_blank\" rel=\"noopener\">import data<\/a> into Sage 50 accounts software.<\/p>\n\n\n\n<ul class=\"wp-block-list\">\n<li>You can&#8217;t <a href=\"https:\/\/askforaccounting.com\/sage\/import-invoices-into-sage-50\/\">import the Invoice<\/a> and credits module.<\/li>\n\n\n\n<li>You can&#8217;t import the Purchase orders module.<\/li>\n\n\n\n<li>You can&#8217;t import Sales orders.<\/li>\n\n\n\n<li>You can&#8217;t import Quotations.<\/li>\n\n\n\n<li>You can&#8217;t import Subcontractors&#8217; records.<\/li>\n\n\n\n<li>You can&#8217;t import CIS subcontractor transactions.<\/li>\n<\/ul>\n\n\n","protected":false},"excerpt":{"rendered":"<p>There are many ways through which a user can get their import data into Sage 50. Data importing processes require manual work to be done by the user and are more time and effort-consuming, making them not the first option anyone would want to choose. Data can simply be imported into Sage 50 from another &#8230; <a title=\"Import Data into Sage 50\" class=\"read-more\" href=\"https:\/\/www.askforaccounting.com\/sage\/import-data-into-sage-50\/\" aria-label=\"Read more about Import Data into Sage 50\">Read more<\/a><\/p>\n","protected":false},"author":3,"featured_media":114794,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"_acf_changed":false,"footnotes":""},"categories":[3],"tags":[],"class_list":["post-105048","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-sage-accounting"],"acf":[],"featured_image_src":"https:\/\/www.askforaccounting.com\/sage\/wp-content\/uploads\/2024\/01\/Import-Data-into-Sage-50.jpg","author_info":{"display_name":"Lawrence Flanagan","author_link":"https:\/\/www.askforaccounting.com\/sage\/author\/openfolderbin\/"},"_links":{"self":[{"href":"https:\/\/www.askforaccounting.com\/sage\/wp-json\/wp\/v2\/posts\/105048","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.askforaccounting.com\/sage\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.askforaccounting.com\/sage\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.askforaccounting.com\/sage\/wp-json\/wp\/v2\/users\/3"}],"replies":[{"embeddable":true,"href":"https:\/\/www.askforaccounting.com\/sage\/wp-json\/wp\/v2\/comments?post=105048"}],"version-history":[{"count":1,"href":"https:\/\/www.askforaccounting.com\/sage\/wp-json\/wp\/v2\/posts\/105048\/revisions"}],"predecessor-version":[{"id":114795,"href":"https:\/\/www.askforaccounting.com\/sage\/wp-json\/wp\/v2\/posts\/105048\/revisions\/114795"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/www.askforaccounting.com\/sage\/wp-json\/wp\/v2\/media\/114794"}],"wp:attachment":[{"href":"https:\/\/www.askforaccounting.com\/sage\/wp-json\/wp\/v2\/media?parent=105048"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.askforaccounting.com\/sage\/wp-json\/wp\/v2\/categories?post=105048"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.askforaccounting.com\/sage\/wp-json\/wp\/v2\/tags?post=105048"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}